Reference https://medium.com/@abderahmane.hamim/building-an-elt-pipeline-with-snowflake-and-dbt-a-step-by-step-guide-93ea90e24db7

Step 1: Setup Snowflake CREATE WAREHOUSE DBT_WH WITH WAREHOUSE_SIZE = 'small';

    CREATE DATABASE DBT_DB;

    CREATE ROLE DBT_ROLE;

    GRANT USAGE ON WAREHOUSE DBT_WH TO ROLE DBT_ROLE;

    GRANT ROLE DBT_ROLE TO USER DBT_USER;

    GRANT USAGE ON DATABASE DBT_DB TO ROLE DBT_ROLE;

    CREATE SCHEMA TPCH;

    CREATE OR REPLACE TABLE DBT_DB.TPCH.CUSTOMER AS
    SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.CUSTOMER;

    CREATE OR REPLACE TABLE DBT_DB.TPCH.LINEITEM AS
    SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.LINEITEM;

    CREATE OR REPLACE TABLE DBT_DB.TPCH.NATION AS
    SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.NATION;

    CREATE OR REPLACE TABLE DBT_DB.TPCH.ORDERS AS
    SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.ORDERS;

    CREATE OR REPLACE TABLE DBT_DB.TPCH.PART AS
    SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.PART;

    CREATE OR REPLACE TABLE DBT_DB.TPCH.PARTSUPP AS
    SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.PARTSUPP;

    CREATE OR REPLACE TABLE DBT_DB.TPCH.REGION AS
    SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.REGION;

    CREATE OR REPLACE TABLE DBT_DB.TPCH.SUPPLIER AS
    SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.SUPPLIER;

Step 2: Install Required Softwares pip install dbt-core pip install dbt-snowflake pip install astronomer-cosmos pip install apache-airflow-providers-snowflake pip3 install dbt-metric-utils winget install Astronomer.Astro

Step 3: Add DBT package dependencies packages: - package: dbt-labs/dbt_utils version: 1.1.1

Run to Resolve Dependencies
    dbt deps