Question: Anyone here know if GCP BQ table schemas...
# general
b
Question: Anyone here know if GCP BQ table schemas are capable of being updated in Pulumi (example to add a new column) ?
s
On the bridged provider (pulumi-gcp), per the docs (https://www.pulumi.com/registry/packages/gcp/api-docs/bigquery/table/#schema_nodejs), it looks like no: "Furthermore drift for this field cannot not be detected because BigQuery only uses this schema to compute the effective schema for the table, therefore any changes on the configured value will force the table to be recreated." You might have better luck with the Native provider, which seems to have a nicer interface to the table schema, but I can't say for sure. Note that the Google Native provider is in preview: https://www.pulumi.com/registry/packages/google-native/api-docs/bigquery/v2/table/#tablefieldschema