Analysis
Explore how to use the analysis feature in dbt to write and compile ad hoc business queries that are not part of the data pipeline. Learn to set up analyses in the dedicated folder, utilize dbt templating functions like ref and project variables, and understand how to compile queries for execution outside dbt models.
We'll cover the following...
We'll cover the following...
Why use analysis?
Sometimes, we need to write ad hoc queries for business purposes. These queries might not be intended for inclusion in our data pipeline, but we might still want to leverage dbt’s capabilities to compile these queries and store them in the same repository. In such cases, we can use the analysis feature in dbt.