Trying the new dbt extension in vs code after dbt power user working seemlessly for months. Getting this failed to download source schema error on all of my source schemas, such as the error below. It says it is a big query access issue but I am a big query admin in the dbt environment and the development environment where the data sources are stored, as below.
I have also been made owner of both environments to ensure this is not a GCP permissions issue. Has anyone encountered this issue and been able to fix it? It’s driving me crazy!
The problem I’m having
Many errors in cursor/VS code with the new dbt extension.
Errors:
error: dbt1014: Failed to download model schema for ‘model.dbt_zapp.forms’. Setting ‘static_analysis’ to off. Skipping analysis for ‘model.dbt_zapp.user_demographic_info_s’: ADBC error: Unknown: [BigQuery] googleapi: Error 403: Access Denied: Table zapp-data-warehouse:prod_bronze.forms: Permission bigquery.tables.get denied on table zapp-data-warehouse:prod_bronze.forms (or it may not exist)., accessDenied (sqlstate: [0, 0, 0, 0, 0], vendor_code: -2147483648)