Index: discovery/googleapis/bigquery__v2.json |
diff --git a/discovery/googleapis/bigquery__v2.json b/discovery/googleapis/bigquery__v2.json |
index 45c8d858e2137183e2e5b888e094d88817c3c213..62e3bcee9f408513743833856fe141bd54d7eae1 100644 |
--- a/discovery/googleapis/bigquery__v2.json |
+++ b/discovery/googleapis/bigquery__v2.json |
@@ -29,7 +29,7 @@ |
"description": "A data platform for customers to create, manage, share and query data.", |
"discoveryVersion": "v1", |
"documentationLink": "https://developers.google.com/bigquery/docs/overview", |
- "etag": "\"ye6orv2F-1npMW3u9suM3a7C5Bo/oDdLsdibHBJaKlk0IjPRWSI7TBM\"", |
+ "etag": "\"ye6orv2F-1npMW3u9suM3a7C5Bo/KlquM6UqjmIyuGctKF7ppu43Avk\"", |
"icons": { |
"x16": "https://www.google.com/images/icons/product/search-16.gif", |
"x32": "https://www.google.com/images/icons/product/search-32.gif" |
@@ -889,9 +889,40 @@ |
} |
} |
}, |
- "revision": "20150226", |
+ "revision": "20150326", |
"rootUrl": "https://www.googleapis.com/", |
"schemas": { |
+ "CsvOptions": { |
+ "id": "CsvOptions", |
+ "properties": { |
+ "allowJaggedRows": { |
+ "description": "[Optional] Indicates if BigQuery should accept rows that are missing trailing optional columns. If true, BigQuery treats missing trailing columns as null values. If false, records with missing trailing columns are treated as bad records, and if there are too many bad records, an invalid error is returned in the job result. The default value is false.", |
+ "type": "boolean" |
+ }, |
+ "allowQuotedNewlines": { |
+ "description": "[Optional] Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.", |
+ "type": "boolean" |
+ }, |
+ "encoding": { |
+ "description": "[Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.", |
+ "type": "string" |
+ }, |
+ "fieldDelimiter": { |
+ "description": "[Optional] The separator for fields in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence \"\\t\" to specify a tab separator. The default value is a comma (',').", |
+ "type": "string" |
+ }, |
+ "quote": { |
+ "description": "[Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('\"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.", |
+ "type": "string" |
+ }, |
+ "skipLeadingRows": { |
+ "description": "[Optional] The number of rows at the top of a CSV file that BigQuery will skip when reading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.", |
+ "format": "int32", |
+ "type": "integer" |
+ } |
+ }, |
+ "type": "object" |
+ }, |
"Dataset": { |
"id": "Dataset", |
"properties": { |
@@ -937,6 +968,11 @@ |
"$ref": "DatasetReference", |
"description": "[Required] A reference that identifies the dataset." |
}, |
+ "defaultTableExpirationMs": { |
+ "description": "[Experimental] The default lifetime of all tables in the dataset, in milliseconds. The minimum value is 3600000 milliseconds (one hour). Once this property is set, all newly-created tables in the dataset will have an expirationTime property set to the creation time plus the value in this property, and changing the value will only affect new tables, not existing ones. When the expirationTime for a given table is reached, that table will be deleted automatically. If a table's expirationTime is modified or removed before the table expires, or if you provide an explicit expirationTime when creating a table, that value takes precedence over the default expiration time indicated by this property.", |
+ "format": "int64", |
+ "type": "string" |
+ }, |
"description": { |
"description": "[Optional] A user-friendly description of the dataset.", |
"type": "string" |
@@ -1061,6 +1097,44 @@ |
}, |
"type": "object" |
}, |
+ "ExternalDataConfiguration": { |
+ "id": "ExternalDataConfiguration", |
+ "properties": { |
+ "compression": { |
+ "description": "[Optional] The compression type of the data source. Possible values include GZIP and NONE. The default value is NONE.", |
+ "type": "string" |
+ }, |
+ "csvOptions": { |
+ "$ref": "CsvOptions", |
+ "description": "Additional properties to set if sourceFormat is set to CSV." |
+ }, |
+ "ignoreUnknownValues": { |
+ "description": "[Optional] Indicates if BigQuery should allow extra values that are not represented in the table schema. If true, the extra values are ignored. If false, records with extra columns are treated as bad records, and if there are too many bad records, an invalid error is returned in the job result. The default value is false. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns", |
+ "type": "boolean" |
+ }, |
+ "maxBadRecords": { |
+ "description": "[Optional] The maximum number of bad records that BigQuery can ignore when reading data. If the number of bad records exceeds this value, an invalid error is returned in the job result. The default value is 0, which requires that all records are valid.", |
+ "format": "int32", |
+ "type": "integer" |
+ }, |
+ "schema": { |
+ "$ref": "TableSchema", |
+ "description": "[Required] The schema for the data." |
+ }, |
+ "sourceFormat": { |
+ "description": "[Optional] The data format. External data sources must be in CSV format. The default value is CSV.", |
+ "type": "string" |
+ }, |
+ "sourceUris": { |
+ "description": "[Required] The fully-qualified URIs that point to your data in Google Cloud Storage. Each URI can contain one '*' wildcard character and it must come after the 'bucket' name. CSV limits related to load jobs apply to external data sources, plus an additional limit of 10 GB maximum size across all URIs.", |
+ "items": { |
+ "type": "string" |
+ }, |
+ "type": "array" |
+ } |
+ }, |
+ "type": "object" |
+ }, |
"GetQueryResultsResponse": { |
"id": "GetQueryResultsResponse", |
"properties": { |
@@ -1252,7 +1326,7 @@ |
"id": "JobConfigurationLoad", |
"properties": { |
"allowJaggedRows": { |
- "description": "[Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. Default is false which treats short rows as errors. Only applicable to CSV, ignored for other formats.", |
+ "description": "[Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing columns are treated as bad records, and if there are too many bad records, an invalid error is returned in the job result. The default value is false. Only applicable to CSV, ignored for other formats.", |
"type": "boolean" |
}, |
"allowQuotedNewlines": { |
@@ -1276,11 +1350,11 @@ |
"type": "string" |
}, |
"ignoreUnknownValues": { |
- "description": "[Optional] Accept rows that contain values that do not match the schema. The unknown values are ignored. Default is false which treats unknown values as errors. For CSV this ignores extra values at the end of a line. For JSON this ignores named values that do not match any column name.", |
+ "description": "[Optional] Indicates if BigQuery should allow extra values that are not represented in the table schema. If true, the extra values are ignored. If false, records with extra columns are treated as bad records, and if there are too many bad records, an invalid error is returned in the job result. The default value is false. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names", |
"type": "boolean" |
}, |
"maxBadRecords": { |
- "description": "[Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an 'invalid' error is returned in the job result and the job fails. The default value is 0, which requires that all records are valid.", |
+ "description": "[Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. The default value is 0, which requires that all records are valid.", |
"format": "int32", |
"type": "integer" |
}, |
@@ -1317,7 +1391,7 @@ |
"type": "string" |
}, |
"sourceUris": { |
- "description": "[Required] The fully-qualified URIs that point to your data in Google Cloud Storage. Wildcard names are only supported when they appear at the end of the URI.", |
+ "description": "[Required] The fully-qualified URIs that point to your data in Google Cloud Storage. Each URI can contain one '*' wildcard character and it must come after the 'bucket' name.", |
"items": { |
"type": "string" |
}, |
@@ -1365,6 +1439,13 @@ |
"description": "[Required] BigQuery SQL query to execute.", |
"type": "string" |
}, |
+ "tableDefinitions": { |
+ "additionalProperties": { |
+ "$ref": "ExternalDataConfiguration" |
+ }, |
+ "description": "[Experimental] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.", |
+ "type": "object" |
+ }, |
"useQueryCache": { |
"description": "[Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified.", |
"type": "boolean" |
@@ -1869,6 +1950,10 @@ |
"TableDataInsertAllRequest": { |
"id": "TableDataInsertAllRequest", |
"properties": { |
+ "ignoreUnknownValues": { |
+ "description": "[Optional] Accept rows that contain values that do not match the schema. The unknown values are ignored. Default is false, which treats unknown values as errors.", |
+ "type": "boolean" |
+ }, |
"kind": { |
"default": "bigquery#tableDataInsertAllRequest", |
"description": "The resource type of the response.", |
@@ -1890,6 +1975,10 @@ |
"type": "object" |
}, |
"type": "array" |
+ }, |
+ "skipInvalidRows": { |
+ "description": "[Optional] Insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist.", |
+ "type": "boolean" |
} |
}, |
"type": "object" |