Skip to content

Latest commit

 

History

History
52 lines (40 loc) · 1.7 KB

README.md

File metadata and controls

52 lines (40 loc) · 1.7 KB

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;