Good video thanks. Only thing i would do differently is give less permission to the service account. Probably Big Query User & Big Query Data editor roles are enough.
Hi Saad, Thanks for your video. I have a question for dbt-core and bigquery. I have two project gcp, the first is the default project, for all processing data (staging, transformation) and the second project the dataset from the first project. But in the dbt-core, profil.yml the project and dataset are set on the first project. when i want into the second project in existing table. dbt use always the dataset in profile.yml, i don't knwo to configure this case. I need help pleae.
hi Saad, Nice video. I am getting this error while making connection with bigquery. 21:35:32 1 check failed: 21:35:32 dbt was unable to connect to the specified database. The database returned the following error: >Runtime Error Unable to generate access token, if you're using impersonate_service_account, make sure your initial account has the "roles/iam.serviceAccountTokenCreator" role on the account you are trying to impersonate. ('invalid_grant: Invalid JWT: Token must be a short-lived token (60 minutes) and in a reasonable timeframe. Check your iat and exp values in the JWT claim.', {'error': 'invalid_grant', 'error_description': 'Invalid JWT: Token must be a short-lived token (60 minutes) and in a reasonable timeframe. Check your iat and exp values in the JWT claim.'}) Check your database credentials and try again. For more information, visit: docs.getdbt.com/docs/configure-your-profile