Welcome to your new dbt project!
- clone and pull repo
- Install dbt normally (make sure to install with dbt-postgres) in virtual env
dbt --version
to check dbt-core and postgres adapter are installed and working- add profiles.yml in ~/.dbt/ and complete the login creds for dev
stir:
outputs:
dev:
type: postgres
threads: 4
host: [host]
port: [port]
user: [dev_username]
pass: [dev_password]
dbname: [dbname]
schema: [dev_schema]
prod:
type: postgres
threads: [1 or more]
host: [host]
port: [port]
user: [prod_username]
pass: [prod_password]
dbname: [dbname]
schema: [prod_schema]
target: dev
-
enter repo folder
-
dbt deps
- installs dbt_utils package -
dbt run
- should run as long as schema and table specified in input model - extract_forms_params model exists -
dbt test
- run tests -
Model viewer dbt docs - browser based viewer to see details of models and compiled column list of each table/view
dbt docs generate
dbt docs serve
- Learn more about dbt in the docs
- Check out Discourse for commonly asked questions and answers
- Join the chat on Slack for live discussions and support
- Find dbt events near you
- Check out the blog for the latest news on dbt's development and best practices