dbt models: Part I

Dbt models are such that they constitute a given SQL query. There are two types of dbt models. They are SQL models and python models.

Dbt models is not a reference to relational or dimensional data models. Dbt models are code.

The SQL model is basically a SQL file with exactly one SQL statement. It is a file with an extension of .sql. Here is a sample SQL model:

WITH
QueryA AS
(
SELECT * FROM Table1
),
QueryB AS
(
SELECT * FROM Table2
)
SELECT *
FROM
QueryA
JOIN
QueryB
ON
QueryA.Id = QueryB.Id