Analytics Engineering project with Great Outdoors dataset.
dbt Project docs url - https://cloud.getdbt.com/accounts/68052/develop/1204134/docs/index.html
- MySQL- as transaction database(OLTP)
- Airbyte- as Extract-Load(EL) tool between MySQL database and Snowflake data warehouse
- Snowflake - as Data Warehouse for loading raw data and performing transformations using dbt
- dbt - as Transformation tool
- Metabase - as data visualization tool
select products.product_category,sum(sales.sale_total)
from fct_sales sales
join dim_products as products
on sales.product_key=products.product_key
group by 1 order by 2 desc;