Analysis
Store and compile ad hoc queries with dbt analyses.
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.
How to create an analysis
We need to create all of our analyses in the analyses folder within our dbt project. An analysis is similar to a model and can utilize dbt’s templating features. For example:
Get hands-on with 1400+ tech skills courses.