dbt-labs / dbt-external-tables

dbt macros to stage external sources
https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/
Apache License 2.0
299 stars 120 forks source link

BigQuery build plan requires CREATE SCHEMA permissions to create external tables #221

Closed thomas-vl closed 5 months ago

thomas-vl commented 1 year ago

Describe the bug

Before trying to create a new dataset we should check if it already exists without using the CREATE statement. It could be that the DBT SA or DBT user that runs the command does not has the permission to create a dataset.

thomas-vl commented 1 year ago

PR: https://github.com/dbt-labs/dbt-external-tables/pull/220

MaselEOBHH commented 11 months ago

Fixed in Version 0.8.7.

Hopefully you do not have digits in your google-project-name :-) See https://github.com/dbt-labs/dbt-external-tables/issues/235

github-actions[bot] commented 5 months ago

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

github-actions[bot] commented 5 months ago

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.