Ecommerce store on Snowflake

A fictional ecommerce store project on a Snowflake data warehouse.

Summary

This project transforms four raw datasets (CUSTOMER , NATION , LINEITEM and ORDERS ) into three summary reporting tables.

  • CUSTOMER_STATS provides a single view of all customers: how many orders they’ve made, how much they’ve spent, where they’re from.
  • ORDER_STATS provides a single view of every order, adding the number of line-items it included.
  • DAILY_COUNTRY_STATS provides an aggregate view of total daily order volumes by country.

Dependency tree of the project

Sample Snowflae Dataform project DAG
Dependency tree of the Snowflake sample project

View the project

(Viewing the example project on Dataform web requires sign up)

What's next

Stackoverflow data on BigQuery

A simple project turning Stackoverflow public raw data into reporting tables in a BigQuery data warehouse.

Ecommerce store on Redshift

A fictional ecommerce store project on a Redshift data warehouse.

Sitemap