OLD | NEW |
1 // This is a generated file (see the discoveryapis_generator project). | 1 // This is a generated file (see the discoveryapis_generator project). |
2 | 2 |
3 library googleapis.bigquery.v2; | 3 library googleapis.bigquery.v2; |
4 | 4 |
5 import 'dart:core' as core; | 5 import 'dart:core' as core; |
6 import 'dart:collection' as collection; | 6 import 'dart:collection' as collection; |
7 import 'dart:async' as async; | 7 import 'dart:async' as async; |
8 import 'dart:convert' as convert; | 8 import 'dart:convert' as convert; |
9 | 9 |
10 import 'package:_discoveryapis_commons/_discoveryapis_commons.dart' as commons; | 10 import 'package:_discoveryapis_commons/_discoveryapis_commons.dart' as commons; |
(...skipping 830 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
841 * | 841 * |
842 * [datasetId] - Dataset ID of the table to read | 842 * [datasetId] - Dataset ID of the table to read |
843 * | 843 * |
844 * [tableId] - Table ID of the table to read | 844 * [tableId] - Table ID of the table to read |
845 * | 845 * |
846 * [maxResults] - Maximum number of results to return | 846 * [maxResults] - Maximum number of results to return |
847 * | 847 * |
848 * [pageToken] - Page token, returned by a previous call, identifying the | 848 * [pageToken] - Page token, returned by a previous call, identifying the |
849 * result set | 849 * result set |
850 * | 850 * |
| 851 * [selectedFields] - List of fields to return (comma-separated). If |
| 852 * unspecified, all fields are returned |
| 853 * |
851 * [startIndex] - Zero-based index of the starting row to read | 854 * [startIndex] - Zero-based index of the starting row to read |
852 * | 855 * |
853 * Completes with a [TableDataList]. | 856 * Completes with a [TableDataList]. |
854 * | 857 * |
855 * Completes with a [commons.ApiRequestError] if the API endpoint returned an | 858 * Completes with a [commons.ApiRequestError] if the API endpoint returned an |
856 * error. | 859 * error. |
857 * | 860 * |
858 * If the used [http.Client] completes with an error when making a REST call, | 861 * If the used [http.Client] completes with an error when making a REST call, |
859 * this method will complete with the same error. | 862 * this method will complete with the same error. |
860 */ | 863 */ |
861 async.Future<TableDataList> list(core.String projectId, core.String datasetId,
core.String tableId, {core.int maxResults, core.String pageToken, core.String s
tartIndex}) { | 864 async.Future<TableDataList> list(core.String projectId, core.String datasetId,
core.String tableId, {core.int maxResults, core.String pageToken, core.String s
electedFields, core.String startIndex}) { |
862 var _url = null; | 865 var _url = null; |
863 var _queryParams = new core.Map(); | 866 var _queryParams = new core.Map(); |
864 var _uploadMedia = null; | 867 var _uploadMedia = null; |
865 var _uploadOptions = null; | 868 var _uploadOptions = null; |
866 var _downloadOptions = commons.DownloadOptions.Metadata; | 869 var _downloadOptions = commons.DownloadOptions.Metadata; |
867 var _body = null; | 870 var _body = null; |
868 | 871 |
869 if (projectId == null) { | 872 if (projectId == null) { |
870 throw new core.ArgumentError("Parameter projectId is required."); | 873 throw new core.ArgumentError("Parameter projectId is required."); |
871 } | 874 } |
872 if (datasetId == null) { | 875 if (datasetId == null) { |
873 throw new core.ArgumentError("Parameter datasetId is required."); | 876 throw new core.ArgumentError("Parameter datasetId is required."); |
874 } | 877 } |
875 if (tableId == null) { | 878 if (tableId == null) { |
876 throw new core.ArgumentError("Parameter tableId is required."); | 879 throw new core.ArgumentError("Parameter tableId is required."); |
877 } | 880 } |
878 if (maxResults != null) { | 881 if (maxResults != null) { |
879 _queryParams["maxResults"] = ["${maxResults}"]; | 882 _queryParams["maxResults"] = ["${maxResults}"]; |
880 } | 883 } |
881 if (pageToken != null) { | 884 if (pageToken != null) { |
882 _queryParams["pageToken"] = [pageToken]; | 885 _queryParams["pageToken"] = [pageToken]; |
883 } | 886 } |
| 887 if (selectedFields != null) { |
| 888 _queryParams["selectedFields"] = [selectedFields]; |
| 889 } |
884 if (startIndex != null) { | 890 if (startIndex != null) { |
885 _queryParams["startIndex"] = [startIndex]; | 891 _queryParams["startIndex"] = [startIndex]; |
886 } | 892 } |
887 | 893 |
888 _url = 'projects/' + commons.Escaper.ecapeVariable('$projectId') + '/dataset
s/' + commons.Escaper.ecapeVariable('$datasetId') + '/tables/' + commons.Escaper
.ecapeVariable('$tableId') + '/data'; | 894 _url = 'projects/' + commons.Escaper.ecapeVariable('$projectId') + '/dataset
s/' + commons.Escaper.ecapeVariable('$datasetId') + '/tables/' + commons.Escaper
.ecapeVariable('$tableId') + '/data'; |
889 | 895 |
890 var _response = _requester.request(_url, | 896 var _response = _requester.request(_url, |
891 "GET", | 897 "GET", |
892 body: _body, | 898 body: _body, |
893 queryParams: _queryParams, | 899 queryParams: _queryParams, |
(...skipping 68 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
962 * the structure of this table. | 968 * the structure of this table. |
963 * | 969 * |
964 * Request parameters: | 970 * Request parameters: |
965 * | 971 * |
966 * [projectId] - Project ID of the requested table | 972 * [projectId] - Project ID of the requested table |
967 * | 973 * |
968 * [datasetId] - Dataset ID of the requested table | 974 * [datasetId] - Dataset ID of the requested table |
969 * | 975 * |
970 * [tableId] - Table ID of the requested table | 976 * [tableId] - Table ID of the requested table |
971 * | 977 * |
| 978 * [selectedFields] - List of fields to return (comma-separated). If |
| 979 * unspecified, all fields are returned |
| 980 * |
972 * Completes with a [Table]. | 981 * Completes with a [Table]. |
973 * | 982 * |
974 * Completes with a [commons.ApiRequestError] if the API endpoint returned an | 983 * Completes with a [commons.ApiRequestError] if the API endpoint returned an |
975 * error. | 984 * error. |
976 * | 985 * |
977 * If the used [http.Client] completes with an error when making a REST call, | 986 * If the used [http.Client] completes with an error when making a REST call, |
978 * this method will complete with the same error. | 987 * this method will complete with the same error. |
979 */ | 988 */ |
980 async.Future<Table> get(core.String projectId, core.String datasetId, core.Str
ing tableId) { | 989 async.Future<Table> get(core.String projectId, core.String datasetId, core.Str
ing tableId, {core.String selectedFields}) { |
981 var _url = null; | 990 var _url = null; |
982 var _queryParams = new core.Map(); | 991 var _queryParams = new core.Map(); |
983 var _uploadMedia = null; | 992 var _uploadMedia = null; |
984 var _uploadOptions = null; | 993 var _uploadOptions = null; |
985 var _downloadOptions = commons.DownloadOptions.Metadata; | 994 var _downloadOptions = commons.DownloadOptions.Metadata; |
986 var _body = null; | 995 var _body = null; |
987 | 996 |
988 if (projectId == null) { | 997 if (projectId == null) { |
989 throw new core.ArgumentError("Parameter projectId is required."); | 998 throw new core.ArgumentError("Parameter projectId is required."); |
990 } | 999 } |
991 if (datasetId == null) { | 1000 if (datasetId == null) { |
992 throw new core.ArgumentError("Parameter datasetId is required."); | 1001 throw new core.ArgumentError("Parameter datasetId is required."); |
993 } | 1002 } |
994 if (tableId == null) { | 1003 if (tableId == null) { |
995 throw new core.ArgumentError("Parameter tableId is required."); | 1004 throw new core.ArgumentError("Parameter tableId is required."); |
996 } | 1005 } |
| 1006 if (selectedFields != null) { |
| 1007 _queryParams["selectedFields"] = [selectedFields]; |
| 1008 } |
997 | 1009 |
998 _url = 'projects/' + commons.Escaper.ecapeVariable('$projectId') + '/dataset
s/' + commons.Escaper.ecapeVariable('$datasetId') + '/tables/' + commons.Escaper
.ecapeVariable('$tableId'); | 1010 _url = 'projects/' + commons.Escaper.ecapeVariable('$projectId') + '/dataset
s/' + commons.Escaper.ecapeVariable('$datasetId') + '/tables/' + commons.Escaper
.ecapeVariable('$tableId'); |
999 | 1011 |
1000 var _response = _requester.request(_url, | 1012 var _response = _requester.request(_url, |
1001 "GET", | 1013 "GET", |
1002 body: _body, | 1014 body: _body, |
1003 queryParams: _queryParams, | 1015 queryParams: _queryParams, |
1004 uploadOptions: _uploadOptions, | 1016 uploadOptions: _uploadOptions, |
1005 uploadMedia: _uploadMedia, | 1017 uploadMedia: _uploadMedia, |
1006 downloadOptions: _downloadOptions); | 1018 downloadOptions: _downloadOptions); |
(...skipping 668 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
1675 /** | 1687 /** |
1676 * [Output-only] The fully-qualified unique name of the dataset in the format | 1688 * [Output-only] The fully-qualified unique name of the dataset in the format |
1677 * projectId:datasetId. The dataset name without the project name is given in | 1689 * projectId:datasetId. The dataset name without the project name is given in |
1678 * the datasetId field. When creating a new dataset, leave this field blank, | 1690 * the datasetId field. When creating a new dataset, leave this field blank, |
1679 * and instead specify the datasetId field. | 1691 * and instead specify the datasetId field. |
1680 */ | 1692 */ |
1681 core.String id; | 1693 core.String id; |
1682 /** [Output-only] The resource type. */ | 1694 /** [Output-only] The resource type. */ |
1683 core.String kind; | 1695 core.String kind; |
1684 /** | 1696 /** |
1685 * [Experimental] The labels associated with this dataset. You can use these | 1697 * The labels associated with this dataset. You can use these to organize and |
1686 * to organize and group your datasets. You can set this property when | 1698 * group your datasets. You can set this property when inserting or updating a |
1687 * inserting or updating a dataset. See Labeling Datasets for more | 1699 * dataset. See Labeling Datasets for more information. |
1688 * information. | |
1689 */ | 1700 */ |
1690 core.Map<core.String, core.String> labels; | 1701 core.Map<core.String, core.String> labels; |
1691 /** | 1702 /** |
1692 * [Output-only] The date when this dataset or any of its tables was last | 1703 * [Output-only] The date when this dataset or any of its tables was last |
1693 * modified, in milliseconds since the epoch. | 1704 * modified, in milliseconds since the epoch. |
1694 */ | 1705 */ |
1695 core.String lastModifiedTime; | 1706 core.String lastModifiedTime; |
1696 /** | 1707 /** |
1697 * [Experimental] The geographic location where the dataset should reside. | 1708 * The geographic location where the dataset should reside. Possible values |
1698 * Possible values include EU and US. The default value is US. | 1709 * include EU and US. The default value is US. |
1699 */ | 1710 */ |
1700 core.String location; | 1711 core.String location; |
1701 /** | 1712 /** |
1702 * [Output-only] A URL that can be used to access the resource again. You can | 1713 * [Output-only] A URL that can be used to access the resource again. You can |
1703 * use this URL in Get or Update requests to the resource. | 1714 * use this URL in Get or Update requests to the resource. |
1704 */ | 1715 */ |
1705 core.String selfLink; | 1716 core.String selfLink; |
1706 | 1717 |
1707 Dataset(); | 1718 Dataset(); |
1708 | 1719 |
(...skipping 93 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
1802 /** A descriptive name for the dataset, if one exists. */ | 1813 /** A descriptive name for the dataset, if one exists. */ |
1803 core.String friendlyName; | 1814 core.String friendlyName; |
1804 /** The fully-qualified, unique, opaque ID of the dataset. */ | 1815 /** The fully-qualified, unique, opaque ID of the dataset. */ |
1805 core.String id; | 1816 core.String id; |
1806 /** | 1817 /** |
1807 * The resource type. This property always returns the value | 1818 * The resource type. This property always returns the value |
1808 * "bigquery#dataset". | 1819 * "bigquery#dataset". |
1809 */ | 1820 */ |
1810 core.String kind; | 1821 core.String kind; |
1811 /** | 1822 /** |
1812 * [Experimental] The labels associated with this dataset. You can use these | 1823 * The labels associated with this dataset. You can use these to organize and |
1813 * to organize and group your datasets. | 1824 * group your datasets. |
1814 */ | 1825 */ |
1815 core.Map<core.String, core.String> labels; | 1826 core.Map<core.String, core.String> labels; |
1816 | 1827 |
1817 DatasetListDatasets(); | 1828 DatasetListDatasets(); |
1818 | 1829 |
1819 DatasetListDatasets.fromJson(core.Map _json) { | 1830 DatasetListDatasets.fromJson(core.Map _json) { |
1820 if (_json.containsKey("datasetReference")) { | 1831 if (_json.containsKey("datasetReference")) { |
1821 datasetReference = new DatasetReference.fromJson(_json["datasetReference"]
); | 1832 datasetReference = new DatasetReference.fromJson(_json["datasetReference"]
); |
1822 } | 1833 } |
1823 if (_json.containsKey("friendlyName")) { | 1834 if (_json.containsKey("friendlyName")) { |
(...skipping 327 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
2151 } | 2162 } |
2152 if (substeps != null) { | 2163 if (substeps != null) { |
2153 _json["substeps"] = substeps; | 2164 _json["substeps"] = substeps; |
2154 } | 2165 } |
2155 return _json; | 2166 return _json; |
2156 } | 2167 } |
2157 } | 2168 } |
2158 | 2169 |
2159 class ExternalDataConfiguration { | 2170 class ExternalDataConfiguration { |
2160 /** | 2171 /** |
2161 * [Experimental] Try to detect schema and format options automatically. Any | 2172 * Try to detect schema and format options automatically. Any option specified |
2162 * option specified explicitly will be honored. | 2173 * explicitly will be honored. |
2163 */ | 2174 */ |
2164 core.bool autodetect; | 2175 core.bool autodetect; |
2165 /** [Optional] Additional options if sourceFormat is set to BIGTABLE. */ | 2176 /** [Optional] Additional options if sourceFormat is set to BIGTABLE. */ |
2166 BigtableOptions bigtableOptions; | 2177 BigtableOptions bigtableOptions; |
2167 /** | 2178 /** |
2168 * [Optional] The compression type of the data source. Possible values include | 2179 * [Optional] The compression type of the data source. Possible values include |
2169 * GZIP and NONE. The default value is NONE. This setting is ignored for | 2180 * GZIP and NONE. The default value is NONE. This setting is ignored for |
2170 * Google Cloud Bigtable, Google Cloud Datastore backups and Avro formats. | 2181 * Google Cloud Bigtable, Google Cloud Datastore backups and Avro formats. |
2171 */ | 2182 */ |
2172 core.String compression; | 2183 core.String compression; |
(...skipping 24 matching lines...) Expand all Loading... |
2197 /** | 2208 /** |
2198 * [Optional] The schema for the data. Schema is required for CSV and JSON | 2209 * [Optional] The schema for the data. Schema is required for CSV and JSON |
2199 * formats. Schema is disallowed for Google Cloud Bigtable, Cloud Datastore | 2210 * formats. Schema is disallowed for Google Cloud Bigtable, Cloud Datastore |
2200 * backups, and Avro formats. | 2211 * backups, and Avro formats. |
2201 */ | 2212 */ |
2202 TableSchema schema; | 2213 TableSchema schema; |
2203 /** | 2214 /** |
2204 * [Required] The data format. For CSV files, specify "CSV". For Google | 2215 * [Required] The data format. For CSV files, specify "CSV". For Google |
2205 * sheets, specify "GOOGLE_SHEETS". For newline-delimited JSON, specify | 2216 * sheets, specify "GOOGLE_SHEETS". For newline-delimited JSON, specify |
2206 * "NEWLINE_DELIMITED_JSON". For Avro files, specify "AVRO". For Google Cloud | 2217 * "NEWLINE_DELIMITED_JSON". For Avro files, specify "AVRO". For Google Cloud |
2207 * Datastore backups, specify "DATASTORE_BACKUP". [Experimental] For Google | 2218 * Datastore backups, specify "DATASTORE_BACKUP". [Beta] For Google Cloud |
2208 * Cloud Bigtable, specify "BIGTABLE". Please note that reading from Google | 2219 * Bigtable, specify "BIGTABLE". |
2209 * Cloud Bigtable is experimental and has to be enabled for your project. | |
2210 * Please contact Google Cloud Support to enable this for your project. | |
2211 */ | 2220 */ |
2212 core.String sourceFormat; | 2221 core.String sourceFormat; |
2213 /** | 2222 /** |
2214 * [Required] The fully-qualified URIs that point to your data in Google | 2223 * [Required] The fully-qualified URIs that point to your data in Google |
2215 * Cloud. For Google Cloud Storage URIs: Each URI can contain one '*' wildcard | 2224 * Cloud. For Google Cloud Storage URIs: Each URI can contain one '*' wildcard |
2216 * character and it must come after the 'bucket' name. Size limits related to | 2225 * character and it must come after the 'bucket' name. Size limits related to |
2217 * load jobs apply to external data sources. For Google Cloud Bigtable URIs: | 2226 * load jobs apply to external data sources. For Google Cloud Bigtable URIs: |
2218 * Exactly one URI can be specified and it has be a fully specified and valid | 2227 * Exactly one URI can be specified and it has be a fully specified and valid |
2219 * HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore | 2228 * HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore |
2220 * backups, exactly one URI can be specified, and it must end with | 2229 * backups, exactly one URI can be specified, and it must end with |
(...skipping 93 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
2314 * Reference to the BigQuery Job that was created to run the query. This field | 2323 * Reference to the BigQuery Job that was created to run the query. This field |
2315 * will be present even if the original request timed out, in which case | 2324 * will be present even if the original request timed out, in which case |
2316 * GetQueryResults can be used to read the results once the query has | 2325 * GetQueryResults can be used to read the results once the query has |
2317 * completed. Since this API only returns the first page of results, | 2326 * completed. Since this API only returns the first page of results, |
2318 * subsequent pages can be fetched via the same mechanism (GetQueryResults). | 2327 * subsequent pages can be fetched via the same mechanism (GetQueryResults). |
2319 */ | 2328 */ |
2320 JobReference jobReference; | 2329 JobReference jobReference; |
2321 /** The resource type of the response. */ | 2330 /** The resource type of the response. */ |
2322 core.String kind; | 2331 core.String kind; |
2323 /** | 2332 /** |
2324 * [Output-only, Experimental] The number of rows affected by a DML statement. | 2333 * [Output-only] The number of rows affected by a DML statement. Present only |
2325 * Present only for DML statements INSERT, UPDATE or DELETE. | 2334 * for DML statements INSERT, UPDATE or DELETE. |
2326 */ | 2335 */ |
2327 core.String numDmlAffectedRows; | 2336 core.String numDmlAffectedRows; |
2328 /** A token used for paging results. */ | 2337 /** A token used for paging results. */ |
2329 core.String pageToken; | 2338 core.String pageToken; |
2330 /** | 2339 /** |
2331 * An object with as many results as can be contained within the maximum | 2340 * An object with as many results as can be contained within the maximum |
2332 * permitted reply size. To get any additional rows, you can call | 2341 * permitted reply size. To get any additional rows, you can call |
2333 * GetQueryResults and specify the jobReference returned above. Present only | 2342 * GetQueryResults and specify the jobReference returned above. Present only |
2334 * when the query completes successfully. | 2343 * when the query completes successfully. |
2335 */ | 2344 */ |
(...skipping 418 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
2754 * records, an invalid error is returned in the job result. The default value | 2763 * records, an invalid error is returned in the job result. The default value |
2755 * is false. Only applicable to CSV, ignored for other formats. | 2764 * is false. Only applicable to CSV, ignored for other formats. |
2756 */ | 2765 */ |
2757 core.bool allowJaggedRows; | 2766 core.bool allowJaggedRows; |
2758 /** | 2767 /** |
2759 * Indicates if BigQuery should allow quoted data sections that contain | 2768 * Indicates if BigQuery should allow quoted data sections that contain |
2760 * newline characters in a CSV file. The default value is false. | 2769 * newline characters in a CSV file. The default value is false. |
2761 */ | 2770 */ |
2762 core.bool allowQuotedNewlines; | 2771 core.bool allowQuotedNewlines; |
2763 /** | 2772 /** |
2764 * [Experimental] Indicates if we should automatically infer the options and | 2773 * Indicates if we should automatically infer the options and schema for CSV |
2765 * schema for CSV and JSON sources. | 2774 * and JSON sources. |
2766 */ | 2775 */ |
2767 core.bool autodetect; | 2776 core.bool autodetect; |
2768 /** | 2777 /** |
2769 * [Optional] Specifies whether the job is allowed to create new tables. The | 2778 * [Optional] Specifies whether the job is allowed to create new tables. The |
2770 * following values are supported: CREATE_IF_NEEDED: If the table does not | 2779 * following values are supported: CREATE_IF_NEEDED: If the table does not |
2771 * exist, BigQuery creates the table. CREATE_NEVER: The table must already | 2780 * exist, BigQuery creates the table. CREATE_NEVER: The table must already |
2772 * exist. If it does not, a 'notFound' error is returned in the job result. | 2781 * exist. If it does not, a 'notFound' error is returned in the job result. |
2773 * The default value is CREATE_IF_NEEDED. Creation, truncation and append | 2782 * The default value is CREATE_IF_NEEDED. Creation, truncation and append |
2774 * actions occur as one atomic update upon job completion. | 2783 * actions occur as one atomic update upon job completion. |
2775 */ | 2784 */ |
(...skipping 37 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
2813 /** | 2822 /** |
2814 * [Optional] Specifies a string that represents a null value in a CSV file. | 2823 * [Optional] Specifies a string that represents a null value in a CSV file. |
2815 * For example, if you specify "\N", BigQuery interprets "\N" as a null value | 2824 * For example, if you specify "\N", BigQuery interprets "\N" as a null value |
2816 * when loading a CSV file. The default value is the empty string. If you set | 2825 * when loading a CSV file. The default value is the empty string. If you set |
2817 * this property to a custom value, BigQuery still interprets the empty string | 2826 * this property to a custom value, BigQuery still interprets the empty string |
2818 * as a null value for all data types except for STRING and BYTE. For STRING | 2827 * as a null value for all data types except for STRING and BYTE. For STRING |
2819 * and BYTE columns, BigQuery interprets the empty string as an empty value. | 2828 * and BYTE columns, BigQuery interprets the empty string as an empty value. |
2820 */ | 2829 */ |
2821 core.String nullMarker; | 2830 core.String nullMarker; |
2822 /** | 2831 /** |
2823 * [Experimental] If sourceFormat is set to "DATASTORE_BACKUP", indicates | 2832 * If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity |
2824 * which entity properties to load into BigQuery from a Cloud Datastore | 2833 * properties to load into BigQuery from a Cloud Datastore backup. Property |
2825 * backup. Property names are case sensitive and must be top-level properties. | 2834 * names are case sensitive and must be top-level properties. If no properties |
2826 * If no properties are specified, BigQuery loads all properties. If any named | 2835 * are specified, BigQuery loads all properties. If any named property isn't |
2827 * property isn't found in the Cloud Datastore backup, an invalid error is | 2836 * found in the Cloud Datastore backup, an invalid error is returned in the |
2828 * returned in the job result. | 2837 * job result. |
2829 */ | 2838 */ |
2830 core.List<core.String> projectionFields; | 2839 core.List<core.String> projectionFields; |
2831 /** | 2840 /** |
2832 * [Optional] The value that is used to quote data sections in a CSV file. | 2841 * [Optional] The value that is used to quote data sections in a CSV file. |
2833 * BigQuery converts the string to ISO-8859-1 encoding, and then uses the | 2842 * BigQuery converts the string to ISO-8859-1 encoding, and then uses the |
2834 * first byte of the encoded string to split the data in its raw, binary | 2843 * first byte of the encoded string to split the data in its raw, binary |
2835 * state. The default value is a double-quote ('"'). If your data does not | 2844 * state. The default value is a double-quote ('"'). If your data does not |
2836 * contain quoted sections, set the property value to an empty string. If your | 2845 * contain quoted sections, set the property value to an empty string. If your |
2837 * data contains quoted newline characters, you must also set the | 2846 * data contains quoted newline characters, you must also set the |
2838 * allowQuotedNewlines property to true. | 2847 * allowQuotedNewlines property to true. |
(...skipping 225 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
3064 * unspecified, this will be set to your project default. | 3073 * unspecified, this will be set to your project default. |
3065 */ | 3074 */ |
3066 core.int maximumBillingTier; | 3075 core.int maximumBillingTier; |
3067 /** | 3076 /** |
3068 * [Optional] Limits the bytes billed for this job. Queries that will have | 3077 * [Optional] Limits the bytes billed for this job. Queries that will have |
3069 * bytes billed beyond this limit will fail (without incurring a charge). If | 3078 * bytes billed beyond this limit will fail (without incurring a charge). If |
3070 * unspecified, this will be set to your project default. | 3079 * unspecified, this will be set to your project default. |
3071 */ | 3080 */ |
3072 core.String maximumBytesBilled; | 3081 core.String maximumBytesBilled; |
3073 /** | 3082 /** |
3074 * [Experimental] Standard SQL only. Set to POSITIONAL to use positional (?) | 3083 * Standard SQL only. Set to POSITIONAL to use positional (?) query parameters |
3075 * query parameters or to NAMED to use named (@myparam) query parameters in | 3084 * or to NAMED to use named (@myparam) query parameters in this query. |
3076 * this query. | |
3077 */ | 3085 */ |
3078 core.String parameterMode; | 3086 core.String parameterMode; |
3079 /** [Deprecated] This property is deprecated. */ | 3087 /** [Deprecated] This property is deprecated. */ |
3080 core.bool preserveNulls; | 3088 core.bool preserveNulls; |
3081 /** | 3089 /** |
3082 * [Optional] Specifies a priority for the query. Possible values include | 3090 * [Optional] Specifies a priority for the query. Possible values include |
3083 * INTERACTIVE and BATCH. The default value is INTERACTIVE. | 3091 * INTERACTIVE and BATCH. The default value is INTERACTIVE. |
3084 */ | 3092 */ |
3085 core.String priority; | 3093 core.String priority; |
3086 /** [Required] BigQuery SQL query to execute. */ | 3094 /** [Required] BigQuery SQL query to execute. */ |
(...skipping 29 matching lines...) Expand all Loading... |
3116 */ | 3124 */ |
3117 core.bool useLegacySql; | 3125 core.bool useLegacySql; |
3118 /** | 3126 /** |
3119 * [Optional] Whether to look for the result in the query cache. The query | 3127 * [Optional] Whether to look for the result in the query cache. The query |
3120 * cache is a best-effort cache that will be flushed whenever tables in the | 3128 * cache is a best-effort cache that will be flushed whenever tables in the |
3121 * query are modified. Moreover, the query cache is only available when a | 3129 * query are modified. Moreover, the query cache is only available when a |
3122 * query does not have a destination table specified. The default value is | 3130 * query does not have a destination table specified. The default value is |
3123 * true. | 3131 * true. |
3124 */ | 3132 */ |
3125 core.bool useQueryCache; | 3133 core.bool useQueryCache; |
3126 /** | 3134 /** Describes user-defined function resources used in the query. */ |
3127 * [Experimental] Describes user-defined function resources used in the query. | |
3128 */ | |
3129 core.List<UserDefinedFunctionResource> userDefinedFunctionResources; | 3135 core.List<UserDefinedFunctionResource> userDefinedFunctionResources; |
3130 /** | 3136 /** |
3131 * [Optional] Specifies the action that occurs if the destination table | 3137 * [Optional] Specifies the action that occurs if the destination table |
3132 * already exists. The following values are supported: WRITE_TRUNCATE: If the | 3138 * already exists. The following values are supported: WRITE_TRUNCATE: If the |
3133 * table already exists, BigQuery overwrites the table data. WRITE_APPEND: If | 3139 * table already exists, BigQuery overwrites the table data. WRITE_APPEND: If |
3134 * the table already exists, BigQuery appends the data to the table. | 3140 * the table already exists, BigQuery appends the data to the table. |
3135 * WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' | 3141 * WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' |
3136 * error is returned in the job result. The default value is WRITE_EMPTY. Each | 3142 * error is returned in the job result. The default value is WRITE_EMPTY. Each |
3137 * action is atomic and only occurs if BigQuery is able to complete the job | 3143 * action is atomic and only occurs if BigQuery is able to complete the job |
3138 * successfully. Creation, truncation and append actions occur as one atomic | 3144 * successfully. Creation, truncation and append actions occur as one atomic |
(...skipping 442 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
3581 } | 3587 } |
3582 | 3588 |
3583 class JobStatistics2 { | 3589 class JobStatistics2 { |
3584 /** [Output-only] Billing tier for the job. */ | 3590 /** [Output-only] Billing tier for the job. */ |
3585 core.int billingTier; | 3591 core.int billingTier; |
3586 /** | 3592 /** |
3587 * [Output-only] Whether the query result was fetched from the query cache. | 3593 * [Output-only] Whether the query result was fetched from the query cache. |
3588 */ | 3594 */ |
3589 core.bool cacheHit; | 3595 core.bool cacheHit; |
3590 /** | 3596 /** |
3591 * [Output-only, Experimental] The number of rows affected by a DML statement. | 3597 * [Output-only] The number of rows affected by a DML statement. Present only |
3592 * Present only for DML statements INSERT, UPDATE or DELETE. | 3598 * for DML statements INSERT, UPDATE or DELETE. |
3593 */ | 3599 */ |
3594 core.String numDmlAffectedRows; | 3600 core.String numDmlAffectedRows; |
3595 /** [Output-only, Experimental] Describes execution plan for the query. */ | 3601 /** [Output-only] Describes execution plan for the query. */ |
3596 core.List<ExplainQueryStage> queryPlan; | 3602 core.List<ExplainQueryStage> queryPlan; |
3597 /** | 3603 /** |
3598 * [Output-only, Experimental] Referenced tables for the job. Queries that | 3604 * [Output-only, Experimental] Referenced tables for the job. Queries that |
3599 * reference more than 50 tables will not have a complete list. | 3605 * reference more than 50 tables will not have a complete list. |
3600 */ | 3606 */ |
3601 core.List<TableReference> referencedTables; | 3607 core.List<TableReference> referencedTables; |
3602 /** | 3608 /** |
3603 * [Output-only, Experimental] The schema of the results. Present only for | 3609 * [Output-only, Experimental] The schema of the results. Present only for |
3604 * successful dry run of non-legacy SQL queries. | 3610 * successful dry run of non-legacy SQL queries. |
3605 */ | 3611 */ |
(...skipping 543 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
4149 core.String kind; | 4155 core.String kind; |
4150 /** | 4156 /** |
4151 * [Optional] The maximum number of rows of data to return per page of | 4157 * [Optional] The maximum number of rows of data to return per page of |
4152 * results. Setting this flag to a small value such as 1000 and then paging | 4158 * results. Setting this flag to a small value such as 1000 and then paging |
4153 * through results might improve reliability when the query result set is | 4159 * through results might improve reliability when the query result set is |
4154 * large. In addition to this limit, responses are also limited to 10 MB. By | 4160 * large. In addition to this limit, responses are also limited to 10 MB. By |
4155 * default, there is no maximum row count, and only the byte limit applies. | 4161 * default, there is no maximum row count, and only the byte limit applies. |
4156 */ | 4162 */ |
4157 core.int maxResults; | 4163 core.int maxResults; |
4158 /** | 4164 /** |
4159 * [Experimental] Standard SQL only. Set to POSITIONAL to use positional (?) | 4165 * Standard SQL only. Set to POSITIONAL to use positional (?) query parameters |
4160 * query parameters or to NAMED to use named (@myparam) query parameters in | 4166 * or to NAMED to use named (@myparam) query parameters in this query. |
4161 * this query. | |
4162 */ | 4167 */ |
4163 core.String parameterMode; | 4168 core.String parameterMode; |
4164 /** [Deprecated] This property is deprecated. */ | 4169 /** [Deprecated] This property is deprecated. */ |
4165 core.bool preserveNulls; | 4170 core.bool preserveNulls; |
4166 /** | 4171 /** |
4167 * [Required] A query string, following the BigQuery query syntax, of the | 4172 * [Required] A query string, following the BigQuery query syntax, of the |
4168 * query to execute. Example: "SELECT count(f1) FROM | 4173 * query to execute. Example: "SELECT count(f1) FROM |
4169 * [myProjectId:myDatasetId.myTableId]". | 4174 * [myProjectId:myDatasetId.myTableId]". |
4170 */ | 4175 */ |
4171 core.String query; | 4176 core.String query; |
4172 /** [Experimental] Query parameters for Standard SQL queries. */ | 4177 /** Query parameters for Standard SQL queries. */ |
4173 core.List<QueryParameter> queryParameters; | 4178 core.List<QueryParameter> queryParameters; |
4174 /** | 4179 /** |
4175 * [Optional] How long to wait for the query to complete, in milliseconds, | 4180 * [Optional] How long to wait for the query to complete, in milliseconds, |
4176 * before the request times out and returns. Note that this is only a timeout | 4181 * before the request times out and returns. Note that this is only a timeout |
4177 * for the request, not the query. If the query takes longer to run than the | 4182 * for the request, not the query. If the query takes longer to run than the |
4178 * timeout value, the call returns without any results and with the | 4183 * timeout value, the call returns without any results and with the |
4179 * 'jobComplete' flag set to false. You can call GetQueryResults() to wait for | 4184 * 'jobComplete' flag set to false. You can call GetQueryResults() to wait for |
4180 * the query to complete and read the results. The default value is 10000 | 4185 * the query to complete and read the results. The default value is 10000 |
4181 * milliseconds (10 seconds). | 4186 * milliseconds (10 seconds). |
4182 */ | 4187 */ |
(...skipping 110 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
4293 * Reference to the Job that was created to run the query. This field will be | 4298 * Reference to the Job that was created to run the query. This field will be |
4294 * present even if the original request timed out, in which case | 4299 * present even if the original request timed out, in which case |
4295 * GetQueryResults can be used to read the results once the query has | 4300 * GetQueryResults can be used to read the results once the query has |
4296 * completed. Since this API only returns the first page of results, | 4301 * completed. Since this API only returns the first page of results, |
4297 * subsequent pages can be fetched via the same mechanism (GetQueryResults). | 4302 * subsequent pages can be fetched via the same mechanism (GetQueryResults). |
4298 */ | 4303 */ |
4299 JobReference jobReference; | 4304 JobReference jobReference; |
4300 /** The resource type. */ | 4305 /** The resource type. */ |
4301 core.String kind; | 4306 core.String kind; |
4302 /** | 4307 /** |
4303 * [Output-only, Experimental] The number of rows affected by a DML statement. | 4308 * [Output-only] The number of rows affected by a DML statement. Present only |
4304 * Present only for DML statements INSERT, UPDATE or DELETE. | 4309 * for DML statements INSERT, UPDATE or DELETE. |
4305 */ | 4310 */ |
4306 core.String numDmlAffectedRows; | 4311 core.String numDmlAffectedRows; |
4307 /** A token used for paging results. */ | 4312 /** A token used for paging results. */ |
4308 core.String pageToken; | 4313 core.String pageToken; |
4309 /** | 4314 /** |
4310 * An object with as many results as can be contained within the maximum | 4315 * An object with as many results as can be contained within the maximum |
4311 * permitted reply size. To get any additional rows, you can call | 4316 * permitted reply size. To get any additional rows, you can call |
4312 * GetQueryResults and specify the jobReference returned above. | 4317 * GetQueryResults and specify the jobReference returned above. |
4313 */ | 4318 */ |
4314 core.List<TableRow> rows; | 4319 core.List<TableRow> rows; |
(...skipping 988 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
5303 class ViewDefinition { | 5308 class ViewDefinition { |
5304 /** [Required] A query that BigQuery executes when the view is referenced. */ | 5309 /** [Required] A query that BigQuery executes when the view is referenced. */ |
5305 core.String query; | 5310 core.String query; |
5306 /** | 5311 /** |
5307 * Specifies whether to use BigQuery's legacy SQL for this view. The default | 5312 * Specifies whether to use BigQuery's legacy SQL for this view. The default |
5308 * value is true. If set to false, the view will use BigQuery's standard SQL: | 5313 * value is true. If set to false, the view will use BigQuery's standard SQL: |
5309 * https://cloud.google.com/bigquery/sql-reference/ Queries and views that | 5314 * https://cloud.google.com/bigquery/sql-reference/ Queries and views that |
5310 * reference this view must use the same flag value. | 5315 * reference this view must use the same flag value. |
5311 */ | 5316 */ |
5312 core.bool useLegacySql; | 5317 core.bool useLegacySql; |
5313 /** | 5318 /** Describes user-defined function resources used in the query. */ |
5314 * [Experimental] Describes user-defined function resources used in the query. | |
5315 */ | |
5316 core.List<UserDefinedFunctionResource> userDefinedFunctionResources; | 5319 core.List<UserDefinedFunctionResource> userDefinedFunctionResources; |
5317 | 5320 |
5318 ViewDefinition(); | 5321 ViewDefinition(); |
5319 | 5322 |
5320 ViewDefinition.fromJson(core.Map _json) { | 5323 ViewDefinition.fromJson(core.Map _json) { |
5321 if (_json.containsKey("query")) { | 5324 if (_json.containsKey("query")) { |
5322 query = _json["query"]; | 5325 query = _json["query"]; |
5323 } | 5326 } |
5324 if (_json.containsKey("useLegacySql")) { | 5327 if (_json.containsKey("useLegacySql")) { |
5325 useLegacySql = _json["useLegacySql"]; | 5328 useLegacySql = _json["useLegacySql"]; |
(...skipping 10 matching lines...) Expand all Loading... |
5336 } | 5339 } |
5337 if (useLegacySql != null) { | 5340 if (useLegacySql != null) { |
5338 _json["useLegacySql"] = useLegacySql; | 5341 _json["useLegacySql"] = useLegacySql; |
5339 } | 5342 } |
5340 if (userDefinedFunctionResources != null) { | 5343 if (userDefinedFunctionResources != null) { |
5341 _json["userDefinedFunctionResources"] = userDefinedFunctionResources.map((
value) => (value).toJson()).toList(); | 5344 _json["userDefinedFunctionResources"] = userDefinedFunctionResources.map((
value) => (value).toJson()).toList(); |
5342 } | 5345 } |
5343 return _json; | 5346 return _json; |
5344 } | 5347 } |
5345 } | 5348 } |
OLD | NEW |