CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquery
walking_the_cow
walking_the_cow

Reputation: 491

BigQuery Cannot Modify Partitioned Table Schema

Per the BigQuery documentation I am attempting to modify a table's schema by adding a field. The table in question is a partition slice (partitioned by day). I am planning on performing the action on every slice.

Per the documentation (https://cloud.google.com/bigquery/docs/managing-partitioned-tables), I should be able to add field to a partitioned table like any other table. However whenever I attempt to add a field to a partitioned table, I am met with this error:

Could not edit table schema.: Cannot change partitioned/clustered table to non partitioned/clustered table.

I am not able to find any good information on what this error means, or what I'm doing wrong. I have successfully added a field to a non-partitioned table. Does the community have any good ideas to help me troubleshoot?

Upvotes: 1

Views: 1082

Answers (1)

Nathan Nasser
Nathan Nasser

Reputation: 1004

I understand that you are using the update_table method to update the schema in python, correct me if I'm wrong. You have to do it with the patch API you can try this API to have a better view on how to do it.

Upvotes: 0

Related Questions