Solution: Querying a Public Dataset
Explore how to reference and query public datasets in dbt by configuring sources and using the source macro. Understand how to set up source files and write SQL queries applying aggregation functions like GROUP BY and COUNT to analyze data effectively.
We'll cover the following...
We'll cover the following...
Solution
Let’s review the solution to the problem presented in the previous lesson.
Solution code: Querying a public dataset
In the public_data.yml ...