rough-oyster-7745804/05/2022, 7:11 PM
, I see this error message:
I changes some resource options:
error: deleting urn:pulumi:dev::data::gcp:bigquery/dataset:Dataset$gcp:bigquery/table:Table::my_dataset.my_table: 1 error occurred: * cannot destroy instance without setting deletion_protection=false and running `terraform apply`
But the error has not been dissapeared. What did I do wrong? How to fix that?
opts=pl.ResourceOptions( parent=dataset_raw, delete_before_replace=True, protect=False, )
shy-arm-3239104/05/2022, 7:42 PM
rough-oyster-7745804/05/2022, 8:16 PM
shy-arm-3239104/05/2022, 8:25 PM
rough-oyster-7745804/05/2022, 9:15 PM
. Thanks so much!
breezy-glass-772106/23/2022, 4:22 PM
rough-oyster-7745806/23/2022, 6:26 PM
object to create and update tables. It consumes
parameter to control the schema, where we should put a JSON string with a schema. When I just add a new column schema to the JSON, it creates a new column in the existing table without recreating the table. And it works pretty fine for me. But if you want to change a column (for example, when you decide you want to change
field type from STRING to INT), I'm afraid Pulumi will recreate the whole table. And this is a limitation of Bigquery, as well as most other column oriented data bases. It's not a limitation of Pulumi.
breezy-glass-772106/23/2022, 7:03 PM
rough-oyster-7745809/05/2022, 7:37 AM