# The Complex Data Models Behind Shopify's Tax Insights Feature

DevFeed: [The Complex Data Models Behind Shopify's Tax Insights Feature](<https://devfeed.tech/articles/the-complex-data-models-behind-shopify-s-tax-insights-feature-1350.md>)

Original publisher: [Read original article](<https://shopify.engineering/complex-data-models-behind-shopify-tax-insights>)

Author: Siraj Ali

Published: 2023-02-08T15:00:04Z

Content type: article

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: [Shopify](<https://devfeed.tech/topics/shopify.md>), [data-architecture](<https://devfeed.tech/topics/data-architecture.md>), [data-modeling](<https://devfeed.tech/topics/data-modeling.md>), [Apache Spark](<https://devfeed.tech/topics/spark.md>), [Google Cloud Platform (GCP)](<https://devfeed.tech/topics/google-cloud.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Back end](<https://devfeed.tech/topics/backend.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>)

Tags: [backend](<https://devfeed.tech/tags/backend.md>), [cloud-storage](<https://devfeed.tech/tags/cloud-storage.md>), [data](<https://devfeed.tech/tags/data.md>), [data-architecture](<https://devfeed.tech/tags/data-architecture.md>), [data-modeling](<https://devfeed.tech/tags/data-modeling.md>), [databases](<https://devfeed.tech/tags/databases.md>), [google-cloud](<https://devfeed.tech/tags/google-cloud.md>), [shopify](<https://devfeed.tech/tags/shopify.md>), [spark](<https://devfeed.tech/tags/spark.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article explains the data architecture behind Shopify Tax's Tax Insights feature. It covers requirements gathering, SQL-based data-model prototyping, dynamically changing data, Spark processing jobs, data warehousing in Google Cloud Storage, and publishing insights for display in the merchant application.

## Source excerpt

The intensive data work behind Shopify's Tax Insights feature required building functionality to handle dynamically changing information