Which of these is not a supported method of putting data into a partitioned table?

Which of these is not a supported method of putting data into a partitioned table?
A . If you have existing data in a separate file for each day, then create a partitioned table and upload each file into the appropriate partition.
B . Run a query to get the records for a specific day from an existing table and for the destination table, specify a partitioned table ending with the day in the format "$YYYYMMDD".
C . Create a partitioned table and stream new records to it every day.
D . Use ORDER BY to put a table’s rows into chronological order and then change the table’s type to "Partitioned".

Answer: D

Explanation:

You cannot change an existing table into a partitioned table. You must create a partitioned table from scratch. Then you can either stream data into it every day and the data will automatically be put in the right partition, or you can load data into a specific partition by using "$YYYYMMDD" at the end of the table name.

Reference: https://cloud.google.com/bigquery/docs/partitioned-tables

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments