Define analyses for performing ad-hoc activities.

Navigating to the analyses/ folder in a dbt project.Navigating to the analyses/ folder in a dbt project.


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.Utilizing analyses to preview data.