Welcome to your new dbt project!

Using the starter project

Try running the following commands:

• dbt run
• dbt test

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

INIT EXECUTION:

-- Use an admin role USE ROLE ACCOUNTADMIN;

-- Create the transform role CREATE ROLE IF NOT EXISTS transform; GRANT ROLE TRANSFORM TO ROLE ACCOUNTADMIN;

-- Create the default warehouse if necessary CREATE WAREHOUSE IF NOT EXISTS COMPUTE_WH; GRANT OPERATE ON WAREHOUSE COMPUTE_WH TO ROLE TRANSFORM;

-- Create the dbt user and assign to role CREATE USER IF NOT EXISTS dbt PASSWORD='dbtPassword123' LOGIN_NAME='dbt' MUST_CHANGE_PASSWORD=FALSE DEFAULT_WAREHOUSE='COMPUTE_WH' DEFAULT_ROLE='transform' DEFAULT_NAMESPACE='AIRBNB.RAW' COMMENT='DBT user used for data transformation'; GRANT ROLE transform to USER dbt;

-- Create our database and schemas CREATE DATABASE IF NOT EXISTS AIRBNB; CREATE SCHEMA IF NOT EXISTS AIRBNB.RAW;

-- Set up permissions to role transform GRANT ALL ON WAREHOUSE COMPUTE_WH TO ROLE transform; GRANT ALL ON DATABASE AIRBNB to ROLE transform; GRANT ALL ON ALL SCHEMAS IN DATABASE AIRBNB to ROLE transform; GRANT ALL ON FUTURE SCHEMAS IN DATABASE AIRBNB to ROLE transform; GRANT ALL ON ALL TABLES IN SCHEMA AIRBNB.RAW to ROLE transform; GRANT ALL ON FUTURE TABLES IN SCHEMA AIRBNB.RAW to ROLE transform;