# How to Build a Production Grade Workflow with SQL Modelling

DevFeed: [How to Build a Production Grade Workflow with SQL Modelling](<https://devfeed.tech/articles/how-to-build-a-production-grade-workflow-with-sql-modelling-1314.md>)

Original publisher: [Read original article](<https://shopify.engineering/build-production-grade-workflow-sql-modelling>)

Author: Michelle Ark

Published: 2020-11-19T19:37:29Z

Content type: tutorial

Language: en

Sources: [Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering.md>), [Shopify Engineering - Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering-shopify-engineering.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Data Science](<https://devfeed.tech/topics/data-science.md>), [Apache Spark](<https://devfeed.tech/topics/spark.md>), [Shopify](<https://devfeed.tech/topics/shopify.md>), [Documentation](<https://devfeed.tech/topics/documentation.md>), [Testing](<https://devfeed.tech/topics/testing.md>), [Tooling](<https://devfeed.tech/topics/tooling.md>)

Tags: [data-science](<https://devfeed.tech/tags/data-science.md>), [development](<https://devfeed.tech/tags/development.md>), [documentation](<https://devfeed.tech/tags/documentation.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [shopify](<https://devfeed.tech/tags/shopify.md>), [sql](<https://devfeed.tech/tags/sql.md>), [testing](<https://devfeed.tech/tags/testing.md>), [tooling](<https://devfeed.tech/tags/tooling.md>)

## AI overview

The article describes Shopify's move from a PySpark-based data pipeline workflow toward production-grade SQL modelling using dbt. It introduces Seamster, a system built for straightforward reporting pipelines, with additional tooling for testing and documentation.

## Source excerpt

I'll show you how we moved to a SQL modelling workflow by leveraging dbt (data build tool) and created tooling for testing and documentation on top of it.