bruno-szdl / dbt-ci-cd

68 stars 16 forks source link

fix: delete the schema when it still has data #22

Closed benedikt-buchert closed 4 days ago

benedikt-buchert commented 5 days ago

https://cloud.google.com/bigquery/docs/managing-datasets?hl=en#delete-datasets

By default, this only works to delete an empty dataset. To delete a dataset and all of its contents, use the CASCADE keyword:

DROP SCHEMA IF EXISTS mydataset CASCADE;