Category: Medallion Architecture
-
How to Create Metabase Dashboards Using dbt Gold-Layer Tables and the dbt analyses Folder
This is the final step of our dbt project: displaying our data in a dashboard so that managers and directors can use it to make informed decisions. This dashboard contains four reports, and we will show how to create each one in Metabase: First, we need to connect Metabase to the database used in our…
-
Gold layer
Now we finally are in the final stage of our ELT process, in this layer we will see the fables that our dashboards will consume, this layer have tables group fields, dimension tables fact tables. We consume the data from the silver layer that is clean, we have one dashboard and one tab for each…
-
How to create DBT Models
In this post we will explain how to create DBT models, we will continue the hospital example and we will transform the data from bronze schema and load to silver schema, first we will analyze the data, make some queries filter and transform the raw data from Bronze schema. After filter the silver schema, we…