DBT (Data Build Tool) is a popular open-source command-line tool for managing and orchestrating SQL transformations in data warehousing. It helps data engineers and analysts write, test, and deploy SQL code easily and supports data modeling, version control, and documentation. In this tutorial, we will guide you through the process of installing the DBT CLI on your local computer.
Before we start, make sure that you have the following prerequisites:
- Python 3.6 or higher installed
- Pip package manager installed
- Snowflake trial account
- Git installed (optional)
- Visual Studio or similar Ide (optional)
Now, let’s get started!
Step 2: Set up a Snowflake account.
open a trial account with Snowflake and create a database and schema in it.
CREATE OR REPLACE DATABASE AYUSH_DWH_DEV;
USE DATABASE AYUSH_DWH_DEV;
CREATE OR REPLACE SCHEMA RAW;Step 2: Install DBT CLI
To install DBT, we first need to install the DBT CLI using pip. Open a terminal or command prompt and run the following command:
pip install dbt-snowflake
