Analyses

Define analyses for performing ad-hoc activities.

Navigating to the analyses/ folder in a dbt project.

Overview

Analyses provide a mechanism for incorporating SQL statements that you don't intend to materialize within your data warehouse. This feature facilitates version control of more analytical SQL files within your dbt project.

SQL files located in the analyses/ directory of a dbt project are compiled but not executed, permitting the use of dbt functionalities like {{ ref(...) }} to select from models.

Utilizing analyses to preview data.