https://dagster.io/ logo
#integration-bigquery
Title
# integration-bigquery
d

Danilo Oliveira

08/18/2023, 9:44 PM
Hi, I'm new to Dagster but already loving the tool! I'm trying to build a dbt + bigquery pipeline, how can I pass the credentials (service account) on the dbt config
profiles.yml
in a safe way? I'm already using the GCP_CREDENTIALS env variable to use bigquery with the BigQueryPandasIOManager
🤖 1
t

Tim Castillo

08/18/2023, 10:06 PM
Hi! The safest way would be to have your
profiles.yml
configured to read your
GCP_CREDENTIALS
using dbt's
env_var
macro. Here's an example of how dbt recommends it: https://docs.getdbt.com/reference/dbt-jinja-functions/env_var
d

Danilo Oliveira

08/18/2023, 11:32 PM
Great, thanks!!
3 Views