--- title: "Shopify to Snowflake Connector | OWOX" canonical: "https://www.owox.com/connectors/free-shopify-connector-to-snowflake" updated: "2026-09-21" --- # Collect Shopify Data into Snowflake Own your Shopify data in Snowflake with OWOX Data Marts. Collect orders, customers, products, and transaction data directly into Snowflake, control schema and refresh logic, and reuse it across BI tools and AI Insights. [Get Started Free](https://www.owox.com/app-signup) ## Endpoints ## Shopify Endpoints [Documentation](https://docs.owox.com/packages/connectors/src/sources/shopify/readme/) 25 Shopify endpoints you can import. Each lands in its own table in your warehouse. * [Abandoned Checkouts Checkout sessions that did not complete — customer info, items, and pricing for recovery campaigns. 20 fields · Time series](/data-sources/shopify#schema-abandoned-checkouts) * [Article Metafields Custom metadata attached to articles — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-article-metafields) * [Articles Blog articles — title, author, publication status, and timestamps. 15 fields](/data-sources/shopify#schema-articles) * [Blog Metafields Custom metadata attached to blogs — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-blog-metafields) * [Blogs Blogs in the store — title, handle, and template settings. 6 fields](/data-sources/shopify#schema-blogs) * [Collection Metafields Custom metadata attached to collections — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-collection-metafields) * [Collections Product collections — title, sort order, product count, and last updated. 10 fields](/data-sources/shopify#schema-collections) * [Customer Metafields Custom metadata attached to customers — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-customer-metafields) * [Customers Customer accounts — contact info, marketing consent, order history, and lifetime spend. 22 fields · Time series](/data-sources/shopify#schema-customers) * [Discount Codes Discount codes — type, status, usage limits, and validity window. 12 fields](/data-sources/shopify#schema-discount-codes) * [Fulfillment Orders Fulfillment orders — items to ship, assigned location, delivery method, and status. 11 fields](/data-sources/shopify#schema-fulfillment-orders) * [Inventory Items Inventory items (SKUs) — tracking status, shipping requirements, and country of origin. 9 fields](/data-sources/shopify#schema-inventory-items) * [Location Metafields Custom metadata attached to locations — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-location-metafields) * [Locations Physical and virtual store locations — activity status, fulfillment capabilities, and address. 19 fields](/data-sources/shopify#schema-locations) * [Order Metafields Custom metadata attached to orders — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-order-metafields) * [Orders Orders placed in the store — financial and fulfillment status, customer info, totals, and timestamps. 47 fields · Time series](/data-sources/shopify#schema-orders) * [Page Metafields Custom metadata attached to pages — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-page-metafields) * [Pages Static store pages — title, handle, publication status, and timestamps. 10 fields](/data-sources/shopify#schema-pages) * [Product Metafields Custom metadata attached to products — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-product-metafields) * [Product Variant Metafields Custom metadata attached to product variants — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-product-variant-metafields) * [Product Variants Product variants — SKU, price, inventory quantity, and availability. 18 fields](/data-sources/shopify#schema-product-variants) * [Products Products in the store catalog — vendor, type, status, inventory, and price range. 21 fields · Time series](/data-sources/shopify#schema-products) * [Shop Store settings — domain, currency, timezone, and plan details. 20 fields](/data-sources/shopify#schema-shop) * [Shop Metafields Custom metadata attached to the shop — namespace, key, value, and type. 9 fields](/data-sources/shopify#schema-shop-metafields) * [Tender Transactions Payment tender transactions — amount, currency, order reference, and processing time. 7 fields](/data-sources/shopify#schema-tender-transactions) ## S01 · Step 1 ## Step 1: Create a Snowflake data storage Start by connecting your own Snowflake account as a [data storage](/data-storages). * Use your Snowflake account, database, and schema * Select a dedicated Snowflake warehouse to control cost and performance * Keep full ownership of Shopify data [Connect Snowflake](https://www.owox.com/app-signup) ![Step 1: Create a Snowflake Data Storage](https://cdn.owox.com/www/portfolio-management-connectors/free-criteo-ads-connector-to-snowflake/body/1.png/public) ## S02 · Step 2 ## Step 2: Create Shopify Data Mart(s) Create a new Data Mart and choose Connector as the definition type. * Select Shopify as the data source * Authorize access to your Shopify store by adding a Shop Domain and the Admin API Access Token * Define which e-commerce entities you want to collect [Create Data Mart](https://www.owox.com/app-signup) ![Step 2: Create Shopify Data Mart(s)](https://cdn.owox.com/www/portfolio-management-connectors/free-shopify-connector-to-aws-athena/body/1.png/public) ## S03 · Step 3 ## Step 3: Select Shopify database & fields Choose exactly which Shopify data should be collected. * Select entities such as orders, order items, products, customers, and refunds * Define the dataset and table where data will be stored * Publish Shopify Data Mart once configuration is complete [Collect Shopify Data](https://www.owox.com/app-signup) ![Step 3: Select Shopify Database & Fields](https://cdn.owox.com/www/portfolio-management-connectors/free-shopify-connector-to-aws-athena/body/2.png/public) ## S04 · Step 4 ## Step 4: Run & schedule Shopify data collection Once published, control how and when Shopify data is imported. * Run manually and select Backfill to load historical data * Add a Connector run Trigger so Shopify data is collected on your schedule * All runs are logged and visible in Run History [Run Data Mart](https://www.owox.com/app-signup) ![Step 4: Run & Schedule Shopify Data Collection](https://cdn.owox.com/www/portfolio-management-connectors/free-shopify-connector-to-aws-athena/body/3.png/public) ## S05 · Step 5 ## Step 5: Get more from your Shopify Analytics Your Shopify data is now available in Snowflake. * Build revenue, orders, and product performance reports * Blend Shopify data with ad platforms, GA4, or CRM data * Enable Shopify Analytics AI Insights delivered on a schedule to Slack, MS Teams or by Email [Send Data to Sheets](https://www.owox.com/app-signup) ![Step 5: Get more from your Shopify Analytics](https://cdn.owox.com/www/portfolio-management-connectors/free-shopify-connector-to-aws-athena/body/4.png/public) ## Related connectors [Shopify to AWS Athena](/connectors/free-shopify-connector-to-aws-athena) [Shopify to AWS Redshift](/connectors/free-shopify-connector-to-aws-redshift) [Shopify to Databricks](/connectors/free-shopify-connector-to-databricks) ## What users are saying ## Every claim has a receipt. Real things real customers said — each quote pinned to a specific claim, straight from the quotes database. A3 · re: trusting AI ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack® > _“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”_ C9 · re: one source of truth ![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public) Mark Simmons · CMO, Pürblack® > _“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”_ E7 · re: getting time back ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack® > _“We regained time. And time is the one resource that never comes back.”_ ## Recent updates * [0.39.0 · Backfill any past period](https://docs.owox.com/docs/changelog/#backfill-any-past-period-0390) * [0.39.0 · Facebook Ads imports now retry a corrupted response instead of failing](https://docs.owox.com/docs/changelog/#facebook-ads-imports-now-retry-a-corrupted-response-instead-of-failing-0390) * [0.38.0 · Shopify connector: more orders fields, including line-item discounts](https://docs.owox.com/docs/changelog/#shopify-connector-more-orders-fields-including-line-item-discounts-0380) * [0.37.0 · Short links resolve only on known short link services and domains you allow](https://docs.owox.com/docs/changelog/#short-links-resolve-only-on-known-short-link-services-and-domains-you-allow-0370) * [0.37.0 · Clearer connector errors, and custom connectors that handle more APIs](https://docs.owox.com/docs/changelog/#clearer-connector-errors-and-custom-connectors-that-handle-more-apis-0370) ## Turn Shopify Data into Business Decisions Schedule a quick walkthrough to see how OWOX Data Marts helps you collect Shopify data in Snowflake, reduce reporting complexity, and scale analytics with confidence. [Get Started Free](https://www.owox.com/app-signup) ## References 1. Internal OWOX data as of 2026-10-02 2. [G2 reviews of OWOX](https://www.g2.com/products/owox/reviews) 3. [npm installs stat](https://npm-stat.com/charts.html?package=owox&from=2025-01-01&to=2028-01-01) ## Book a call You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Schedule a meeting You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get Started Free](https://www.owox.com/app-signup) - [Documentation](https://docs.owox.com/packages/connectors/src/sources/shopify/readme) - [Abandoned CheckoutsCheckout sessions that did not complete — customer info, items, and pricing for…](https://www.owox.com/data-sources/shopify) — /data-sources/shopify.md - [data storage](https://www.owox.com/data-storages) — /data-storages.md - [Shopify to AWS Athena](https://www.owox.com/connectors/free-shopify-connector-to-aws-athena) — /connectors/free-shopify-connector-to-aws-athena.md - [Shopify to AWS Redshift](https://www.owox.com/connectors/free-shopify-connector-to-aws-redshift) — /connectors/free-shopify-connector-to-aws-redshift.md - [Shopify to Databricks](https://www.owox.com/connectors/free-shopify-connector-to-databricks) — /connectors/free-shopify-connector-to-databricks.md - [0.39.0 · Backfill any past period](https://docs.owox.com/docs/changelog)