Data Build Project: dbt setup with Snowflake without installation

 

## Setting Up dbt Directly in Snowflake (No Installation Required)

Snowflake has introduced a native feature that allows you to set up and run dbt projects directly within its platform.

 

Traditionally, developing with dbt required installing Visual Studio Code, configuring local environments, and running CLI commands to initialize a project. This manual setup often led to configuration errors and consumed valuable development time.

 

With this new feature, Snowflake eliminates the need for any local software installation. You can now build and manage your dbt projects entirely within the Snowflake user interface.

 

## Prerequisites

Before you begin, you only need to have the following ready in your Snowflake account:

 

* A dedicated Database

* A target Schema

* An active Virtual Warehouse

 

## Step-by-Step Setup Guide

 

   1. Log In: Sign into your Snowflake account console.

   2. Locate dbt: On the welcome or navigation page, click on the dbt Projects option.

   3. Configure Project: Fill in the required project details:

   * Project Name: Enter a unique name for your project.

      * Role and Warehouse: Select your security role and compute warehouse.

      * Storage: Select your target Database and Schema.

   4. Initialize: Click Create.

 

Let's process the CSV file to verify that the setup is working correctly.

 

1. Navigate to the seed folder within your dbt project.

2. Click on the three dots (...) next to the file, select "Rename," and name it `test.csv`.

3. Add your data to the CSV file.

Next, proceed to the command prompt:

- Choose the appropriate profile, either `dev` or `prod`.

- On the next tab, set the "Select Operation" to **seed**.

- In the "Additional Flags" field, enter `--select test`.

- Click **Execute**.

If successful, the data will be loaded into the `test` table.