browse
dbt/

dbt CLI

dbt Labs

Data transformation tool that enables analytics engineers to transform data using SQL select statements.

Databases & DataJSON
01Install
pip install dbt-core

02Global Flags
FlagTypeDescription
--outputenum [text, json]Output format
--profiles-dirstringPath to profiles directory
--target/-tstringTarget profile to use
--no-use-colorsbooleanDisable color output
--select/-sstringSelect specific models to run

03Authentication
Methods
config-fileenvironment-variables
Env vars
DBT_PROFILES_DIRDBT_TARGETDBT_DATABASE
Config files
~/.dbt/profiles.yml

04Capabilities
Reference
binarydbt
checkdbt --version
authconfig-file, environment-variables
formatstext
json flag--output json