Api-roll 33: 2016-03-14

discovery/googleapis/bigquery__v2.json

Index: discovery/googleapis/bigquery__v2.json
diff --git a/discovery/googleapis/bigquery__v2.json b/discovery/googleapis/bigquery__v2.json
index fec4b2569283e8c2252d1bc95279aa3a0e5d5d07..8668f17a2b94b851a0336f070ea5f06e0bedd7c7 100644
--- a/discovery/googleapis/bigquery__v2.json
+++ b/discovery/googleapis/bigquery__v2.json
@@ -32,7 +32,7 @@
     "description": "A data platform for customers to create, manage, share and query data.",
     "discoveryVersion": "v1",
     "documentationLink": "https://cloud.google.com/bigquery/",
-    "etag": "\"bRFOOrZKfO9LweMbPqu0kcu6De8/KhBY9BAZ9f1xpe68E42latOsq24\"",
+    "etag": "\"bRFOOrZKfO9LweMbPqu0kcu6De8/eSPju3c2Pyt6CcnQAdTDIxZaY3k\"",
     "icons": {
         "x16": "https://www.google.com/images/icons/product/search-16.gif",
         "x32": "https://www.google.com/images/icons/product/search-32.gif"
@@ -933,9 +933,85 @@
             }
         }
     },
-    "revision": "20160127",
+    "revision": "20160304",
     "rootUrl": "https://www.googleapis.com/",
     "schemas": {
+        "BigtableColumn": {
+            "id": "BigtableColumn",
+            "properties": {
+                "encoding": {
+                    "description": "[Optional] The encoding of the values when the type is not STRING. Acceptable encoding values are: TEXT - indicates values are alphanumeric text strings. BINARY - indicates values are encoded using HBase Bytes.toBytes family of functions. 'encoding' can also be set at the column family level. However, the setting at this level takes precedence if 'encoding' is set at both levels.",
+                    "type": "string"
+                },
+                "fieldName": {
+                    "description": "[Optional] If the qualifier is not a valid BigQuery field identifier i.e. does not match [a-zA-Z][a-zA-Z0-9_]*, a valid identifier must be provided as the column field name and is used as field name in queries.",
+                    "type": "string"
+                },
+                "onlyReadLatest": {
+                    "description": "[Optional] If this is set, only the latest version of value in this column are exposed. 'onlyReadLatest' can also be set at the column family level. However, the setting at this level takes precedence if 'onlyReadLatest' is set at both levels.",
+                    "type": "boolean"
+                },
+                "qualifierEncoded": {
+                    "description": "[Required] Qualifier of the column. Columns in the parent column family that has this exact qualifier are exposed as . field. If the qualifier is valid UTF-8 string, it can be specified in the qualifier_string field. Otherwise, a base-64 encoded value must be set to qualifier_encoded. The column field name is the same as the column qualifier. However, if the qualifier is not a valid BigQuery field identifier i.e. does not match [a-zA-Z][a-zA-Z0-9_]*, a valid identifier must be provided as field_name.",
+                    "format": "byte",
+                    "type": "string"
+                },
+                "qualifierString": {
+                    "type": "string"
+                },
+                "type": {
+                    "description": "[Optional] The type to convert the value in cells of this column. The values are expected to be encoded using HBase Bytes.toBytes function when using the BINARY encoding value. Following BigQuery types are allowed (case-sensitive) - BYTES STRING INTEGER FLOAT BOOLEAN Defaut type is BYTES. 'type' can also be set at the column family level. However, the setting at this level takes precedence if 'type' is set at both levels.",
+                    "type": "string"
+                }
+            },
+            "type": "object"
+        },
+        "BigtableColumnFamily": {
+            "id": "BigtableColumnFamily",
+            "properties": {
+                "columns": {
+                    "description": "[Optional] Lists of columns that should be exposed as individual fields as opposed to a list of (column name, value) pairs. All columns whose qualifier matches a qualifier in this list can be accessed as .. Other columns can be accessed as a list through .Column field.",
+                    "items": {
+                        "$ref": "BigtableColumn"
+                    },
+                    "type": "array"
+                },
+                "encoding": {
+                    "description": "[Optional] The encoding of the values when the type is not STRING. Acceptable encoding values are: TEXT - indicates values are alphanumeric text strings. BINARY - indicates values are encoded using HBase Bytes.toBytes family of functions. This can be overridden for a specific column by listing that column in 'columns' and specifying an encoding for it.",
+                    "type": "string"
+                },
+                "familyId": {
+                    "description": "Identifier of the column family.",
+                    "type": "string"
+                },
+                "onlyReadLatest": {
+                    "description": "[Optional] If this is set only the latest version of value are exposed for all columns in this column family. This can be overridden for a specific column by listing that column in 'columns' and specifying a different setting for that column.",
+                    "type": "boolean"
+                },
+                "type": {
+                    "description": "[Optional] The type to convert the value in cells of this column family. The values are expected to be encoded using HBase Bytes.toBytes function when using the BINARY encoding value. Following BigQuery types are allowed (case-sensitive) - BYTES STRING INTEGER FLOAT BOOLEAN Defaut type is BYTES. This can be overridden for a specific column by listing that column in 'columns' and specifying a type for it.",
+                    "type": "string"
+                }
+            },
+            "type": "object"
+        },
+        "BigtableOptions": {
+            "id": "BigtableOptions",
+            "properties": {
+                "columnFamilies": {
+                    "description": "[Optional] List of column families to expose in the table schema along with their types. This list restricts the column families that can be referenced in queries and specifies their value types. You can use this list to do type conversions - see the 'type' field for more details. If you leave this list empty, all column families are present in the table schema and their values are read as BYTES. During a query only the column families referenced in that query are read from Bigtable.",
+                    "items": {
+                        "$ref": "BigtableColumnFamily"
+                    },
+                    "type": "array"
+                },
+                "ignoreUnspecifiedColumnFamilies": {
+                    "description": "[Optional] If field is true, then the column families that are not specified in columnFamilies list are not exposed in the table schema. Otherwise, they are read with BYTES type values. The default value is false.",
+                    "type": "boolean"
+                }
+            },
+            "type": "object"
+        },
         "CsvOptions": {
             "id": "CsvOptions",
             "properties": {
@@ -1239,8 +1315,16 @@
         "ExternalDataConfiguration": {
             "id": "ExternalDataConfiguration",
             "properties": {
+                "autodetect": {
+                    "description": "[Experimental] Try to detect schema and format options automatically. Any option specified explicitly will be honored.",
+                    "type": "boolean"
+                },
+                "bigtableOptions": {
+                    "$ref": "BigtableOptions",
+                    "description": "[Optional] Additional options if sourceFormat is set to BIGTABLE."
+                },
                 "compression": {
-                    "description": "[Optional] The compression type of the data source. Possible values include GZIP and NONE. The default value is NONE. This setting is ignored for Google Cloud Datastore backups.",
+                    "description": "[Optional] The compression type of the data source. Possible values include GZIP and NONE. The default value is NONE. This setting is ignored for Google Cloud Bigtable, Google Cloud Datastore backups and Avro formats.",
                     "type": "string"
                 },
                 "csvOptions": {
@@ -1248,24 +1332,24 @@
                     "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 JSON: Named values that don't match any column names Google Cloud Datastore backups: This setting is ignored.",
+                    "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 Google Cloud Bigtable: This setting is ignored. Google Cloud Datastore backups: This setting is ignored. Avro: This setting is ignored.",
                     "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. This setting is ignored for Google Cloud Datastore backups.",
+                    "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. This setting is ignored for Google Cloud Bigtable, Google Cloud Datastore backups and Avro formats.",
                     "format": "int32",
                     "type": "integer"
                 },
                 "schema": {
                     "$ref": "TableSchema",
-                    "description": "[Optional] The schema for the data. Schema is required for CSV and JSON formats. Schema is disallowed for Google Cloud Datastore backups."
+                    "description": "[Optional] The schema for the data. Schema is required for CSV and JSON formats. Schema is disallowed for Google Cloud Bigtable, Cloud Datastore backups, and Avro formats."
                 },
                 "sourceFormat": {
-                    "description": "[Required] The data format. For CSV files, specify \"CSV\". For newline-delimited JSON, specify \"NEWLINE_DELIMITED_JSON\". For Google Cloud Datastore backups, specify \"DATASTORE_BACKUP\".",
+                    "description": "[Required] The data format. For CSV files, specify \"CSV\". For newline-delimited JSON, specify \"NEWLINE_DELIMITED_JSON\". For Avro files, specify \"AVRO\". For Google Cloud Datastore backups, specify \"DATASTORE_BACKUP\". [Experimental] For Google Cloud Bigtable, specify \"BIGTABLE\". Please note that reading from Google Cloud Bigtable is experimental and has to be enabled for your project. Please contact Google Cloud Support to enable this for your project.",
                     "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. Size limits related to load jobs apply to external data sources, plus an additional limit of 10 GB maximum size across all URIs. For Google Cloud Datastore backups, exactly one URI can be specified, and it must end with '.backup_info'. Also, the '*' wildcard character is not allowed.",
+                    "description": "[Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '*' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources, plus an additional limit of 10 GB maximum size across all URIs. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups, exactly one URI can be specified, and it must end with '.backup_info'. Also, the '*' wildcard character is not allowed.",
                     "items": {
                         "type": "string"
                     },
@@ -1588,6 +1672,10 @@
                     "description": "[Optional] 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"
                 },
+                "useLegacySql": {
+                    "description": "[Experimental] Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's updated SQL dialect with improved standards compliance. When using BigQuery's updated SQL, the values of allowLargeResults and flattenResults are ignored. Queries with useLegacySql set to false will be run as if allowLargeResults is true and flattenResults is false.",
+                    "type": "boolean"
+                },
                 "useQueryCache": {
                     "default": "true",
                     "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. The default value is true.",
@@ -1782,6 +1870,13 @@
                     },
                     "type": "array"
                 },
+                "referencedTables": {
+                    "description": "[Output-only, Experimental] Referenced tables for the job. Queries that reference more than 50 tables will not have a complete list.",
+                    "items": {
+                        "$ref": "TableReference"
+                    },
+                    "type": "array"
+                },
                 "totalBytesBilled": {
                     "description": "[Output-only] Total bytes billed for the job.",
                     "format": "int64",
@@ -1972,6 +2067,10 @@
                     "format": "uint32",
                     "type": "integer"
                 },
+                "useLegacySql": {
+                    "description": "[Experimental] Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's updated SQL dialect with improved standards compliance. When using BigQuery's updated SQL, the values of allowLargeResults and flattenResults are ignored. Queries with useLegacySql set to false will be run as if allowLargeResults is true and flattenResults is false.",
+                    "type": "boolean"
+                },
                 "useQueryCache": {
                     "default": "true",
                     "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. The default value is true.",
@@ -2183,7 +2282,7 @@
                     "type": "boolean"
                 },
                 "templateSuffix": {
-                    "description": "[Optional] If specified, treats the destination table as a base template, and inserts the rows into an instance table named \"{destination}{templateSuffix}\". BigQuery will manage creation of the instance table, using the schema of the base template table. See https://cloud.google.com/bigquery/streaming-data-into-bigquery#template-tables for considerations when working with templates tables.",
+                    "description": "[Experimental] If specified, treats the destination table as a base template, and inserts the rows into an instance table named \"{destination}{templateSuffix}\". BigQuery will manage creation of the instance table, using the schema of the base template table. See https://cloud.google.com/bigquery/streaming-data-into-bigquery#template-tables for considerations when working with templates tables.",
                     "type": "string"
                 }
             },