pip install dbt-vault
# profiles.yml
my_bigquery_profile:
target: dev
outputs:
dev:
type: bigquery
method: service-account
project: my_project
dataset: my_dataset
location: us
keyfile: /path/to/keyfile.json
threads: 4
timeout_seconds: 300
priority: interactive
vault:
addr: https://my-vault.example.com
token: VAULT_TOKEN_HERE
kv_mount_point: kv
-- models/my_model.sql
select *
from vault.kv.my_secret