Connect DBT to Database | DBT & Snowflake | Data Build Tool Tutorials

Показать описание

-------------------------------
DBT Tutorials
-------------------------------

Snowflake [Creating DBT User]:

-- 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 test_user
PASSWORD='dbtPassword123'
LOGIN_NAME='test_user'
MUST_CHANGE_PASSWORD=FALSE
DEFAULT_WAREHOUSE='COMPUTE_WH'
DEFAULT_ROLE='transform'
DEFAULT_NAMESPACE='TEST.STAGING'
COMMENT='DBT user used for data transformation';
GRANT ROLE transform to USER test_user;

-- Create our database and schemas
CREATE DATABASE IF NOT EXISTS TEST;
CREATE SCHEMA IF NOT EXISTS TEST.STAGING;
CREATE SCHEMA IF NOT EXISTS TEST.CORE;

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

-- Set up the defaults
USE WAREHOUSE COMPUTE_WH;
USE DATABASE TEST;
USE SCHEMA STAGING;