DBT POC using Snowflake Trial Acccess

• Simple demo using dbt with snowflake warehouse

Snowflake Setup

user	DBT_CLOUD
role	transformer
schema	analytics
database	dev
warehouse	transformer

---

Applying Grants

Dropping user & role if they already exists.

use role accountadmin;

drop user if exists dbt_cloud;
drop user if exists dbt_cloud_dev;
drop role if exists transformer;
drop role if exists transformer_dev;

Creating a database.

create database DEV comment = 'Development database';

Create schemas.

create schema "DEV"."ANALYTICS" comment = 'Data layer for end user';

Create an access role.

create role transformer comment = 'Role for dbt';

Create a warehouse.

create warehouse transforming with 
 warehouse_size = 'XSMALL' 
 warehouse_type = 'STANDARD' 
 auto_suspend = 300 
 auto_resume = TRUE 
 comment = 'Warehouse to transform data';

Granting role permissions

grant usage,operate on warehouse transforming to role transformer;
grant usage,create schema on database DEV to role transformer;
grant all on schema "DEV"."ANALYTICS" to role transformer;

---

DBT Installation

Sequence of commands:

pip install dbt
pip install dbt-snowflake

dbt --version
dbt debug
dbt init
dbt deps
dbt seed
dbt run
dbt docs generate
dbt docs serve --port 8001

• You can also install dbt using these instructions

Profile template:

# For more information on how to configure this file, please see:
# https://docs.getdbt.com/docs/profile
dbt_demo:
  target: dev
  outputs:
    dev:
      type: snowflake
      account: your-snowflake-account-id-here
      user: your-user-name-here
      password: your-password-here
      role: TRANSFORMER
      database: DEV
      warehouse: TRANSFORMING
      schema: STG
      threads: 4
      client_session_keep_alive: False

DAGs

---

DIM & FACT

---

Resources

• 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