Can I Cluster or Partition an Existing BigQuery Table Created by Fivetran?

Question

Can I add clustering or partitioning to an existing BigQuery table created by Fivetran?

Environment

Destination: BigQuery

Answer

BigQuery doesn't support adding clustering or partitioning to an existing table after it has been created. However, you can replace the existing table with a new one that includes clustering or partitioning. To do this:

1. Create a new table using the same data and define clustering or partitioning during creation. To learn how, see our Convert to clustering tables documentation.
2. Delete the original table.
3. Rename the new table to match the original table name.

For help deciding when and how to use clustering or partitioning, see When Should I Cluster and Partition My Data?.