A list of example projects for Snowflake, BigQuery, and Redshift.

Example projects

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

Stackoverflow data on BigQuery

## Summary

This project transforms four raw datasets (`posts_answers`, `posts_questions`, `badges` and `users`) into two summary reporting tables.

- `posts_combined` brings stackoverflow posts and answers into a single table, with a “type” field for differentiating between the two.
- `user_stats` provides an overview of each users engagement: when they signed up, how many badges they have, and how many posts and answers they’ve made.

## Dependency tree of the project

<img src="https://assets.dataform.co/docs/sample_projects/bigquery_sample_project_dag.png"  width="1100"  alt="Sample bigquery Dataform project DAG" />
<figcaption>Dependency tree of the BigQuery sample project</figcaption>

## View the project

<a href="https://github.com/dataform-co/dataform-example-project-bigquery" target="_blank"><button>See the example on GitHub</button></a>

<a href="https://app.dataform.co/#/6470156092964864/overview"><button intent="primary">See the example on Dataform web</button></a> (Viewing the example project on Dataform web requires sign up)


stackoverflow-bigquery

A fictional ecommerce store project on a Snowflake data warehouse.

Ecommerce store on Snowflake

## 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

<img src="https://assets.dataform.co/docs/sample_projects/snowflake_sample_project_dag.png"  width="1100"  alt="Sample Snowflae Dataform project DAG" />
<figcaption>Dependency tree of the Snowflake sample project</figcaption>

## View the project

<a href="https://github.com/dataform-co/dataform-example-project-snowflake" target="_blank"><button>See the example on GitHub</button></a>

<a href="https://app.dataform.co/#/6478728478588928/overview" target="_blank"><button intent="primary">See the example on Dataform web</button></a> (Viewing the example project on Dataform web requires sign up)


ecommerce-snowflake

A fictional ecommerce store project on a Redshift data warehouse.

Ecommerce store on Redshift

## Summary

This project transforms four raw data tables (`orders` from Shopify, `charges` from Stripe, and `customer` from a CRM) into three summary reporting tables.

- `order_stats` brings all orders information into a single table
- `customer_stats` brings all customer information into a single table
- `daily_country_stats` provides an overview of stats aggregated by country

## Dependency tree of the project

<img src="https://assets.dataform.co/docs/sample_projects/redshift_sample_project_dag.png"  width="1100"  alt="Sample bigquery Dataform project DAG" />
<figcaption>Dependency tree of the Redshift sample project</figcaption>

## View the project

<a href="https://github.com/dataform-co/dataform-example-project" target="_blank"><button>See the example on GitHub</button></a>

<a href="https://app.dataform.co/#/5702806545629184/overview"><button intent="primary">See the example on Dataform web</button></a> (Viewing the example project on Dataform web requires sign up)


ecommerce-redshift

projects

Home

Learn the basics of Dataform, how it works, and where it fits in your data stack.

Introduction

An introduction to ELT and where Dataform fits in.

ELT and the modern data stack

modern-data-stack

Learn how Dataform and SQLX can help your team manage data in your warehouse.

SQLX and Dataform in 5 minutes

dataform-in-5-minutes

Learn how Dataform compiles your project and runs it in your warehouse.

How Dataform works

how-dataform-works

introduction

Learn about which data warehouses Dataform can work with and how to configure them.

Supported warehouses

Authentification, configuration options, and content for Snowflake.

Snowflake

snowflake

Authentification, configuration options, and content for BigQuery.

Google BigQuery

bigquery

Authentification, configuration options, and content for Redshift.

Amazon Redshift

redshift

Authentification and configuration options for Azure SQL Data Warehouse.

Azure SQL Data Warehouse

sqldatawarehouse

Authentification and configuration options for Postgres.

Postgres

postgres

warehouses

Learn how Dataform works with examples projects and scripts.