Skip to main content


If you're using the dbt CLI, you'll need to set up a profiles.yml file.

You can learn more about this in the article on Connecting to your warehouse.

This article lists the parts of your profiles.yml which are not database specific. Check out the article for your database for exact connection details.

send_anonymous_usage_stats: <true | false>
use_colors: <true | false>
partial_parse: <true | false>
printer_width: <integer>
write_json: <true | false>
warn_error: <true | false>
log_format: <true | false>
debug: <true | false>
version_check: <true | false>
fail_fast: <true | false>
use_experimental_parser: <true | false>
static_parser: <true | false>

target: <target-name> # this is the default target
type: <bigquery | postgres | redshift | snowflake | other>
schema: <schema_identifier>
threads: <natural_number>

### database-specific connection details

<target-name>: # additional targets

<profile-name>: # additional profiles

User config

You can set default values of global configs for all projects that you run using your local machine. See the docs on global configs for details.