Topic 2 Question 3
Which of these statements about exporting data from BigQuery is false?
To export more than 1 GB of data, you need to put a wildcard in the destination filename.
The only supported export destination is Google Cloud Storage.
Data can only be exported in JSON or Avro format.
The only compression option available is GZIP.
解説
Data can be exported in CSV, JSON, or Avro format. If you are exporting nested or repeated data, then CSV format is not supported. Reference: https://cloud.google.com/bigquery/docs/exporting-data
コメント(9)
Correct: C
When you export data from BigQuery, note the following:
You cannot export table data to a local file, to Google Sheets, or to Google Drive. The only supported export location is Cloud Storage. For information on saving query results, see Downloading and saving query results. You can export up to 1 GB of table data to a single file. If you are exporting more than 1 GB of data, use a wildcard to export the data into multiple files. When you export data to multiple files, the size of the files will vary. You cannot export nested and repeated data in CSV format. Nested and repeated data is supported for Avro and JSON exports. When you export data in JSON format, INT64 (integer) data types are encoded as JSON strings to preserve 64-bit precision when the data is read by other systems. You cannot export data from multiple tables in a single export job. You cannot choose a compression type other than GZIP when you export data using the Cloud Console or the classic BigQuery web UI.
👍 23[Removed]2020/03/25- 👍 14[Removed]2020/03/21
Correct Answer is A,B,D
You cannot export table data to a local file, to Sheets, or to Drive. The only supported export location is Cloud Storage. For information on saving query results, see Downloading and saving query results. You can export up to 1 GB of table data to a single file. If you are exporting more than 1 GB of data, use a wildcard to export the data into multiple files. When you export data to multiple files, the size of the files will vary. You cannot export nested and repeated data in CSV format. Nested and repeated data is supported for Avro and JSON exports. When you export data in JSON format, INT64 (integer) data types are encoded as JSON strings to preserve 64-bit precision when the data is read by other systems. You cannot export data from multiple tables in a single export job.
https://cloud.google.com/bigquery/docs/exporting-data#export_limitations
👍 7saurabh18052020/08/18
シャッフルモード