BigQuery - Converting from non-partitioned to partitioned table - Legacy SQL

Question

I've looked at previous questions, but the links given to GCP were outdated so I would like to learn what is the best way to do the conversion while inserting the correct partition (meaning not the day i inserted the records, but according to the "date" column.

Could someone point me in the right direction, specifically for Legacy SQL.

Did you read this? https://stackoverflow.com/questions/38993877/migrating-from-non-partitioned-to-partitioned-tables — Graham Polley, Jul 02 '18 at 13:45
Why legacy? For querying afterwards, or for running the process? — Felipe Hoffa, Jul 02 '18 at 23:25
@GrahamPolley - thank you!, I have - but this method is for Standard SQL, Isn't it? — ShiraP, Jul 03 '18 at 08:52
@FelipeHoffa - I prefer legacy, I know it's not the common approach but that's what I use currently for my queries. so I assume for your questions - both yes :) — ShiraP, Jul 03 '18 at 08:52
I strongly recommend you stop using legacySQL unless you're absolutely tied to it for some reason. — Graham Polley, Jul 03 '18 at 13:18

score 0 · Answer 1 · answered Nov 06 '18 at 18:17

From the docs: "Currently, legacy SQL is not supported for querying partitioned tables or for writing query results to partitioned tables".

So, in this case, because Legacy can't write to partitioned tables, which seems to be a major blocking with no workarounds, you would have to use Standard SQL or Dataflow, as detailed in the answers of the question provided by Graham.

BigQuery - Converting from non-partitioned to partitioned table - Legacy SQL

1 Answers1