Create a dbt™ model

This guide builds your first dbt™ model in the Code IDE, from a fresh branch to a table materialized in your warehouse.

Prerequisites

Developer or Admin permissions in Paradime.
A dbt™ project set up in the IDE.
Basic SQL, dbt™, and git knowledge.

Estimated time: 10 minutes.

Steps

Create a branch

Keep main clean. Open source control (the left panel icon), and from the branch dropdown select + New branch, naming it something like my_first_dbt_model.

Create the model file

Open your project files (folder icon), right-click the target folder (for example models/staging), select New file, and name it descriptively (for example nba_player_info.sql).

Write the model

Write SQL that transforms your data, using dbt™ ref() and source() to reference other nodes:

WITH source AS (
    SELECT
        person_id AS player_id,
        first_name,
        last_name,
        team_name,
        position
    FROM {{ source('PUBLIC', 'COMMON_PLAYER_INFO') }}
)

SELECT * FROM source

Materialize it

In the Terminal, run:

dbt run

Resolve any errors or warnings. You can also run models from the commands panel.

Commit and open a pull request

Commit and push with Git Lite, then open a pull request for review.

dbt run completes without errors and the model exists as a table or view in your development schema. Preview it in the Data Explorer to confirm the output.

Foundations

Automate with AI agents

Set up & configure

Orchestrate data pipelines

Migrate to Paradime

Develop in Paradime

Learn dbt™

Create a dbt™ model

Steps

Next steps

Explore data in the Code IDE

Build with DinoAI

​Steps

​Next steps

Explore data in the Code IDE

Build with DinoAI

Steps

Next steps