In part two of this series using Microsoft’s Wide World Importers sample database, we design a dimensional model for sales and build it using dbt and Snowflake
In part two of this series using Microsoft’s Wide World Importers sample database, we design a dimensional model for sales and build it using dbt and Snowflake
In part one of this series using Microsoft’s Wide World Importers sample database, we focus on loading the data into a Snowflake environment to enable future model creation and analysis. We also use dbt to establish the loaded tables as data sources, we document them, add testing and create a code base in GitHub to store transformation scripts and implement version control.
In part one of this series using Microsoft’s Wide World Importers sample database, we focus on loading the data into a Snowflake environment to enable future model creation and analysis. We also use dbt to establish the loaded tables as data sources, we document them, add testing and create a code base in GitHub to store transformation scripts and implement version control.