Shopify Data Warehouse Setup: A Practical Guide
How to set up a Shopify data warehouse: when you need one, BigQuery vs Snowflake, choosing a connector, full order history, data modeling and costs.
On this page
Last updated November 13, 2026.
Most guides to Shopify data warehouses are written by the companies selling connectors. This one is vendor-neutral. It covers when you actually need a warehouse, how to choose a connector, how to get your full order history, and the setup mistakes that make numbers disagree.
Do you need a Shopify data warehouse?
You need one when your questions span several systems or outgrow Shopify's built-in reports. A warehouse brings Shopify orders together with ad spend, payments, email and ERP data in one place. If Shopify's reports answer your questions today, a warehouse adds cost without adding much value.
Signs you're ready:
- Data lives in several systems, such as Shopify, ads, email and an ERP.
- You run several stores and want one view across them.
- You need custom metrics, such as customer lifetime value by acquisition channel.
- Reports take manual exports every week.
Which warehouse should you use for Shopify data?
BigQuery and Snowflake are the most common choices for Shopify brands, with Redshift, Databricks and Postgres also supported by most connectors. BigQuery suits teams already using Google tools. Snowflake now offers its own Shopify connector, which loads data directly into a Snowflake account.
| Warehouse | Best for | Note |
|---|---|---|
| BigQuery | Teams using Google Analytics and Google Ads | Supported by most Shopify connectors |
| Snowflake | Larger data teams | Has its own Shopify connector, Openflow |
| Redshift | Teams on Amazon Web Services | Supported by major connectors |
| Postgres | Smaller setups and custom builds | A simpler, lower-cost option |
How do you choose a Shopify connector?
Choose between a managed connector, an open-source connector or a custom build, based on your team, budget and data volume. Managed tools need little upkeep but charge by usage. Open-source tools cost less but need someone to run them. Custom builds suit unusual needs.
| Option | Examples | Trade-off |
|---|---|---|
| Managed connector | Fivetran | Little upkeep; billed on monthly active rows |
| Open-source connector | Airbyte | Lower cost; you run or host it |
| Warehouse-native connector | Snowflake Openflow | Simple if you use Snowflake |
| Custom pipeline | Your own code on Shopify's GraphQL API | Full control; you maintain it |
Source: Airbyte's 2026 comparison of Shopify ETL tools. Check each vendor's current pricing.
Our integration scorecard helps compare connectors on reliability, rate limits and cost.
How do you get your full Shopify order history?
Grant the connector access to all orders, not just recent ones. By default, apps see only recent orders. Connectors need the read_all_orders permission to pull a store's full history into the warehouse.
- Request read_all_orders when setting up the connector.
- Run a full historical sync first, then switch to incremental updates.
- Check row counts against Shopify for a sample month.
How do bulk operations speed up Shopify exports?
Bulk operations let a connector request a whole dataset at once and receive it as a file, instead of paging through it request by request. That makes large historical exports practical. Shopify's Admin API version 2026-01 raised the limit from one to five bulk operations running at once per store, according to a connector maintainer citing Shopify's documentation.
- Prefer connectors that use GraphQL bulk operations for large stores.
- Check which API version your connector uses.
- Schedule large syncs outside peak trading hours.
Shopify's GraphQL rate limits also apply to each connector. See Shopify's rate limit documentation.
How do you model Shopify data in a warehouse?
Turn raw tables into clean, tested models before building reports. Raw connector tables are hard to report on directly. Tools like dbt, with ready-made Shopify packages, clean the data, add freshness tests and document every field.
| Model | What it holds | Common use |
|---|---|---|
| Orders | One row per order, with totals and status | Revenue and order trends |
| Order lines | One row per product in an order | Product performance |
| Refunds | Returned items and amounts | Net revenue |
| Customers | Customer profiles and first order date | Retention and lifetime value |
| Products | Products, variants and costs | Margin analysis |
Why don't warehouse numbers match Shopify's reports?
Small differences are normal, because each source defines and times data differently. Shopify's reports can include canceled, pending and unpaid orders, while a warehouse model may exclude them. Time zones differ too: warehouse data often arrives in UTC by default, while Shopify reports use your store's time zone.
- Agree on definitions, such as whether revenue includes refunds.
- Convert time zones to your store's local time.
- Reconcile one month against Shopify before trusting reports.
For more on why reports differ, see Shopify marketing attribution explained.
How do you handle customer data responsibly?
Only sync the customer data you need, restrict who can see it, and follow your privacy obligations in the warehouse as well as in Shopify. Names, emails and addresses copied into a warehouse are still personal data. Deleting a customer in Shopify doesn't automatically delete their copy in the warehouse.
- Exclude fields you don't need, where your connector allows.
- Restrict access to personal data in the warehouse.
- Plan for deletion requests across every copy of the data.
What does a Shopify data warehouse cost?
Costs come from three places: the connector, the warehouse and the people who maintain it. Managed connectors bill by usage, warehouses bill by storage and queries, and someone needs to keep models and dashboards working. Small stores can start for little; large, multi-store setups cost more.
How we connect Shopify to other systems
Solo Media Group builds the integrations that feed and use Shopify data. For Time4Learning, we built a checkout extension that syncs order details to its learning platform, and for HUK Gear, inventory synced to its ERP across 59 POS locations. See our ERP, PIM, CRM and WMS integrations service.
Shopify data warehouse FAQs
What is a Shopify data warehouse?
A central database where Shopify data is stored alongside data from other systems, such as ads, payments and an ERP, for reporting and analysis.
Can I connect Shopify to BigQuery?
Yes, through connectors such as Fivetran or Airbyte, or a custom pipeline using Shopify's GraphQL API.
Does Snowflake have a Shopify connector?
Yes. Snowflake's Openflow Connector for Shopify loads data directly into a Snowflake account.
Why can't my connector see older orders?
It probably lacks the read_all_orders permission. Grant it, then run a full historical sync.
How often does Shopify data sync to a warehouse?
It depends on the connector and plan. Many sync hourly or daily; some offer near-real-time updates.
Do I need dbt for Shopify data?
Not always, but it helps. Ready-made Shopify dbt packages clean the data, test it and document every field.
