---
title: "Stripe to Snowflake Connector | OWOX"
canonical: "https://www.owox.com/connectors/stripe-connector-to-snowflake"
updated: "2026-11-09"
---

# Collect Stripe charges in Snowflake

Load Stripe charges, refunds and disputes into your own Snowflake account with a custom OWOX connector. What customers paid, and what went back, land as tables ready to join to orders and the CRM.

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%23635BFF%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M13.976%209.15c-2.172-.806-3.356-1.426-3.356-2.409%200-.831.683-1.305%201.901-1.305%202.227%200%204.515.858%206.09%201.631l.89-5.494C18.252.975%2015.697%200%2012.165%200%209.667%200%207.589.654%206.104%201.872%204.56%203.147%203.757%204.992%203.757%207.218c0%204.039%202.467%205.76%206.476%207.219%202.585.92%203.445%201.574%203.445%202.583%200%20.98-.84%201.545-2.354%201.545-1.875%200-4.965-.921-6.99-2.109l-.9%205.555C5.175%2022.99%208.385%2024%2011.714%2024c2.641%200%204.843-.624%206.328-1.813%201.664-1.305%202.525-3.236%202.525-5.732%200-4.128-2.524-5.851-6.594-7.305h.003z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Stripe · Connected · Balance transact… · Charges · Customers · Disputes

Data Mart · Published · one definition

![](https://cdn.owox.com/www/portfolio-management-connectors/snowflake-connector-to-google-sheets/icon/1.png/public)Snowflake · Id · Accou… · Livem…Daily 09:00

Refreshed on a schedule. No exports, no copy-paste.

[Get started free](https://www.owox.com/app-signup)

## Endpoints

## Stripe Endpoints

[Documentation](https://docs.stripe.com/api)

14 Stripe endpoints you can import. Each lands in its own table in your data warehouse.

*   [Balance transactions Every movement of money through the Stripe balance: charges, refunds, disputes, fees, payouts, adjustments. 16 fields · Time series](/data-sources/stripe#schema-balance-transactions)

*   [Charges One row per charge attempt: amount, outcome, card details, who paid and which invoice or payment intent it belongs to. 33 fields · Time series](/data-sources/stripe#schema-charges)

*   [Customers Every customer object: identity, billing country, delinquency and balance. 17 fields](/data-sources/stripe#schema-customers)

*   [Disputes One row per dispute (chargeback) with its status and evidence deadline. 14 fields · Time series](/data-sources/stripe#schema-disputes)

*   [Events The audit trail: every change Stripe recorded (invoice.paid, customer.subscription.updated, charge.refunded, …) with the id of the object it concerns. 11 fields · Time series](/data-sources/stripe#schema-events)

*   [Invoice line items Every line on every invoice: what was billed, for which price and product, for which period. 19 fields](/data-sources/stripe#schema-invoice-line-items)

*   [Invoices One row per invoice with amounts, status and period. 31 fields · Time series](/data-sources/stripe#schema-invoices)

*   [Payment intents One row per payment attempt lifecycle: how much was asked for, how much was received, and where it stands. 22 fields · Time series](/data-sources/stripe#schema-payment-intents)

*   [Payouts One row per transfer from the Stripe balance to the bank account: amount, arrival date, status. 18 fields · Time series](/data-sources/stripe#schema-payouts)

*   [Prices Every price (plan) of every product, active or not, with amount, currency and billing interval. 17 fields](/data-sources/stripe#schema-prices)

*   [Products The catalogue: every product, active or not. 13 fields](/data-sources/stripe#schema-products)

*   [Refunds One row per refund: how much was returned on which charge, why, and the balance transaction that reversed the money. 13 fields · Time series](/data-sources/stripe#schema-refunds)

*   [Subscription items The lines of every subscription: which price, how many units. 14 fields](/data-sources/stripe#schema-subscription-items)

*   [Subscriptions One row per subscription in any status (status=all), full refresh every run so cancellations and past-due states are current. 23 fields](/data-sources/stripe#schema-subscriptions)

## S00 · Why

## Why join Stripe charges with orders and the CRM

A charge is money taken. Which order it paid for, and which account it belongs to, lives in the store and the CRM. To tie revenue to customers, the three have to meet in one [data warehouse](/data-storages), joined on keys.

*   Reconcile Stripe charges with store orders on the key your checkout carries
*   See refunds and disputes beside the charge they touch
*   Group revenue by customer email, not only by card

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%23635BFF%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M13.976%209.15c-2.172-.806-3.356-1.426-3.356-2.409%200-.831.683-1.305%201.901-1.305%202.227%200%204.515.858%206.09%201.631l.89-5.494C18.252.975%2015.697%200%2012.165%200%209.667%200%207.589.654%206.104%201.872%204.56%203.147%203.757%204.992%203.757%207.218c0%204.039%202.467%205.76%206.476%207.219%202.585.92%203.445%201.574%203.445%202.583%200%20.98-.84%201.545-2.354%201.545-1.875%200-4.965-.921-6.99-2.109l-.9%205.555C5.175%2022.99%208.385%2024%2011.714%2024c2.641%200%204.843-.624%206.328-1.813%201.664-1.305%202.525-3.236%202.525-5.732%200-4.128-2.524-5.851-6.594-7.305h.003z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Stripe · Charges, refunds

Orders · Store sales

CRM · Accounts

![](https://cdn.owox.com/www/portfolio-management-connectors/snowflake-connector-to-google-sheets/icon/1.png/public)Your data warehouse · Snowflake · Stripe · Orders · CRMJoined by id · Order placed · Charge settledOne query shows what was taken for each order.

## S01 · Step 1

## Step 1: Connect Stripe and pick the fields

Create a Data Mart, choose Stripe as the [data source](/data-sources) and add a restricted API key with read access. Open an endpoint and tick only the fields you need.

*   Charges carries amounts, outcome, refund total and dispute flag
*   A custom connector: the restricted API key is yours

New Data Mart · Choose a source · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Cg%20clip-path%3D%22url\(%23clip0_14430_15244\)%22%3E%0A%3Cpath%20d%3D%22M40.1006%209.24272C40.0674%209.00032%2039.8556%208.86584%2039.6798%208.8512C39.5054%208.83656%2036.0883%208.78464%2036.0883%208.78464C36.0883%208.78464%2033.2305%206.0094%2032.9482%205.72708C32.6659%205.44477%2032.1146%205.52999%2031.9002%205.59391C31.8975%205.59525%2031.3635%205.76038%2030.4646%206.0387C30.3142%205.5513%2030.093%204.95204%2029.7774%204.35012C28.7601%202.40853%2027.2699%201.3818%2025.4694%201.37914C25.4668%201.37914%2025.4654%201.37914%2025.4628%201.37914C25.3376%201.37914%2025.2138%201.39113%2025.0886%201.40178C25.0354%201.33786%2024.9821%201.27527%2024.9262%201.21401C24.1418%200.375052%2023.1364%20-0.0337745%2021.9312%200.0021809C19.6061%200.068765%2017.2903%201.74802%2015.4126%204.73098C14.0916%206.82971%2013.0862%209.46648%2012.8012%2011.5079C10.1312%2012.3349%208.26414%2012.9128%208.22286%2012.9262C6.87519%2013.3496%206.83258%2013.3909%206.6568%2014.6614C6.5263%2015.6214%203%2042.889%203%2042.889L32.5514%2048L45.3594%2044.8159C45.3594%2044.8159%2040.1339%209.48512%2040.1006%209.24272ZM28.9851%206.49679C28.3046%206.7072%2027.5309%206.9469%2026.6919%207.20658C26.6746%206.02938%2026.5348%204.39141%2025.9862%202.97582C27.7506%203.31008%2028.6189%205.30627%2028.9851%206.49679ZM25.1458%207.68598C23.5971%208.16536%2021.9072%208.68872%2020.212%209.21344C20.6887%207.38769%2021.593%205.56994%2022.7036%204.37809C23.1164%203.93464%2023.6943%203.44058%2024.3788%203.15826C25.022%204.5006%2025.1618%206.40091%2025.1458%207.68598ZM21.9778%201.54959C22.5238%201.53761%2022.9832%201.65746%2023.3761%201.91581C22.7475%202.24207%2022.1402%202.71082%2021.5703%203.32206C20.0934%204.90677%2018.9615%207.36638%2018.5101%209.73944C17.1025%2010.1749%2015.7255%2010.6024%2014.4578%2010.9939C15.2582%207.25852%2018.3889%201.65346%2021.9778%201.54959Z%22%20fill%3D%22%2395BF47%22%2F%3E%0A%3Cpath%20d%3D%22M39.6812%208.85246C39.5068%208.83782%2036.0897%208.7859%2036.0897%208.7859C36.0897%208.7859%2033.2319%206.01065%2032.9496%205.72834C32.8444%205.62313%2032.7019%205.56853%2032.5527%205.5459L32.5541%2047.9986L45.3609%2044.8159C45.3609%2044.8159%2040.1354%209.48638%2040.1021%209.24398C40.0687%209.00158%2039.8557%208.8671%2039.6812%208.85246Z%22%20fill%3D%22%235E8E3E%22%2F%3E%0A%3Cpath%20d%3D%22M25.4536%2015.4377L23.9662%2021.0028C23.9662%2021.0028%2022.3069%2020.2477%2020.34%2020.3716C17.4555%2020.554%2017.4249%2022.3731%2017.4543%2022.8299C17.6114%2025.3188%2024.1592%2025.8621%2024.5268%2031.6922C24.8158%2036.2785%2022.0938%2039.416%2018.172%2039.6636C13.4645%2039.9606%2010.873%2037.184%2010.873%2037.184L11.8705%2032.9413C11.8705%2032.9413%2014.4792%2034.9096%2016.5673%2034.7777C17.931%2034.6912%2018.4183%2033.5819%2018.3691%2032.7975C18.164%2029.5508%2012.8319%2029.7426%2012.4951%2024.4079C12.2114%2019.9188%2015.1598%2015.3698%2021.665%2014.9596C24.1712%2014.7985%2025.4536%2015.4377%2025.4536%2015.4377Z%22%20fill%3D%22white%22%2F%3E%0A%3C%2Fg%3E%0A%3Cdefs%3E%0A%3CclipPath%20id%3D%22clip0_14430_15244%22%3E%0A%3Crect%20fill%3D%22white%22%20height%3D%2248%22%20transform%3D%22translate\(3\)%22%20width%3D%2242.4%22%2F%3E%0A%3C%2FclipPath%3E%0A%3C%2Fdefs%3E%0A%3C%2Fsvg%3E%0A)Shopify · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%23635BFF%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M13.976%209.15c-2.172-.806-3.356-1.426-3.356-2.409%200-.831.683-1.305%201.901-1.305%202.227%200%204.515.858%206.09%201.631l.89-5.494C18.252.975%2015.697%200%2012.165%200%209.667%200%207.589.654%206.104%201.872%204.56%203.147%203.757%204.992%203.757%207.218c0%204.039%202.467%205.76%206.476%207.219%202.585.92%203.445%201.574%203.445%202.583%200%20.98-.84%201.545-2.354%201.545-1.875%200-4.965-.921-6.99-2.109l-.9%205.555C5.175%2022.99%208.385%2024%2011.714%2024c2.641%200%204.843-.624%206.328-1.813%201.664-1.305%202.525-3.236%202.525-5.732%200-4.128-2.524-5.851-6.594-7.305h.003z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Stripe · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Cpath%20d%3D%22M16.3343%207.52231C16.7982%206.30445%2017.4362%205.18325%2018.3834%204.2747C22.1723%200.58247%2028.4355%201.51036%2031.0065%206.14981C32.9397%209.66805%2034.9887%2013.109%2036.9798%2016.5886C40.3048%2022.3685%2043.6684%2028.1485%2046.9546%2033.9478C49.719%2038.7999%2046.7227%2044.9278%2041.2327%2045.7591C37.8691%2046.2617%2034.7181%2044.7152%2032.9783%2041.6996C30.0593%2036.6155%2027.121%2031.5314%2024.202%2026.4667C24.144%2026.3507%2024.0667%2026.2541%2023.9894%2026.1574C23.6801%2025.9061%2023.5448%2025.5388%2023.3515%2025.2102C22.0563%2022.9291%2020.7224%2020.6674%2019.4273%2018.4057C18.596%2016.9365%2017.7261%2015.4867%2016.8949%2014.0175C16.141%2012.703%2015.793%2011.2725%2015.8317%209.76471C15.8897%208.99147%2015.9863%208.21823%2016.3343%207.52231Z%22%20fill%3D%22%233C8BD9%22%2F%3E%0A%3Cpath%20d%3D%22M16.3343%207.52246C16.1603%208.21838%2016.0057%208.91429%2015.967%209.64887C15.909%2011.2727%2016.315%2012.7805%2017.1269%2014.1917C19.2533%2017.8452%2021.3797%2021.5181%2023.4868%2025.191C23.6801%2025.5196%2023.8347%2025.8483%2024.028%2026.1576C22.8682%2028.168%2021.7083%2030.1591%2020.5291%2032.1695C18.9053%2034.9725%2017.2815%2037.7948%2015.6384%2040.5978C15.5611%2040.5978%2015.5417%2040.5592%2015.5224%2040.5012C15.5031%2040.3465%2015.5611%2040.2112%2015.5997%2040.0566C16.3923%2037.1569%2015.735%2034.5859%2013.7439%2032.3822C12.5261%2031.0483%2010.9796%2030.2944%209.20114%2030.0431C6.88142%2029.7145%204.83233%2030.3137%202.99588%2031.7636C2.66726%2032.0149%202.45462%2032.3822%202.068%2032.5755C1.99067%2032.5755%201.95201%2032.5368%201.93268%2032.4788C2.86057%2030.8743%203.76913%2029.2699%204.69702%2027.6654C8.52456%2021.0155%2012.3521%2014.3656%2016.199%207.7351C16.2376%207.65778%2016.2956%207.59979%2016.3343%207.52246Z%22%20fill%3D%22%23FABC04%22%2F%3E%0A%3Cpath%20d%3D%22M2.01%2032.5366C2.37729%2032.2079%202.72525%2031.86%203.11187%2031.5507C7.80931%2027.8391%2014.8651%2030.5261%2015.8897%2036.4028C16.141%2037.8139%2016.0057%2039.1671%2015.5804%2040.5203C15.561%2040.6363%2015.5417%2040.7329%2015.5031%2040.8489C15.3291%2041.1582%2015.1744%2041.4868%2014.9811%2041.7961C13.2607%2044.6378%2010.7283%2046.049%207.40336%2045.8363C3.59514%2045.5657%200.598834%2042.7047%200.0768961%2038.9158C-0.174407%2037.0794%200.192882%2035.3589%201.1401%2033.7738C1.33341%2033.4258%201.56539%2033.1165%201.77803%2032.7685C1.87468%2032.6912%201.83602%2032.5366%202.01%2032.5366Z%22%20fill%3D%22%2334A852%22%2F%3E%0A%3Cpath%20d%3D%22M2.00996%2032.5363C1.93263%2032.6136%201.93263%2032.7489%201.79732%2032.7683C1.77798%2032.633%201.85531%2032.5556%201.93263%2032.459L2.00996%2032.5363Z%22%20fill%3D%22%23FABC04%22%2F%3E%0A%3Cpath%20d%3D%22M15.5031%2040.8491C15.4258%2040.7138%2015.5031%2040.6172%2015.5804%2040.5205C15.5998%2040.5398%2015.6384%2040.5785%2015.6577%2040.5978L15.5031%2040.8491Z%22%20fill%3D%22%23E1C025%22%2F%3E%0A%3C%2Fsvg%3E%0A)Google Ads · AuthorizeConnected · Endpoint · Charges · Balance transacti… · Customers · Disputes

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%23635BFF%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M13.976%209.15c-2.172-.806-3.356-1.426-3.356-2.409%200-.831.683-1.305%201.901-1.305%202.227%200%204.515.858%206.09%201.631l.89-5.494C18.252.975%2015.697%200%2012.165%200%209.667%200%207.589.654%206.104%201.872%204.56%203.147%203.757%204.992%203.757%207.218c0%204.039%202.467%205.76%206.476%207.219%202.585.92%203.445%201.574%203.445%202.583%200%20.98-.84%201.545-2.354%201.545-1.875%200-4.965-.921-6.99-2.109l-.9%205.555C5.175%2022.99%208.385%2024%2011.714%2024c2.641%200%204.843-.624%206.328-1.813%201.664-1.305%202.525-3.236%202.525-5.732%200-4.128-2.524-5.851-6.594-7.305h.003z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Charges · 33 fields · createdamountamount\_refundedcurrencystatusdisputed

## S02 · Step 2

## Step 2: Load Stripe into Snowflake

Each endpoint becomes its own table, and refresh settings are set in the Data Mart. Run it and the first load lands as a table in a schema of the database you choose in Snowflake. The location is pre-filled from your [data storage](/data-storages), and you can change it.

*   Charges, refunds and disputes each get their own table
*   Every run is logged in Run History

![](https://cdn.owox.com/www/portfolio-management-connectors/snowflake-connector-to-google-sheets/icon/1.png/public)Destination · Snowflake · DatabaseSchema · stripe · Table · charges · Run

Run History · Pending · Running · SuccessIncremental load

![](https://cdn.owox.com/www/portfolio-management-connectors/snowflake-connector-to-google-sheets/icon/1.png/public)Table · stripe.charges

## S03 · Step 3

## Step 3: Get a business-friendly Stripe output schema

After the first run you get the output schema: every field with its type and a description. Amounts are in the smallest currency unit, and the schema says so.

*   amount\_captured and amount\_refunded sit beside the requested amount
*   disputed is true when a chargeback exists on the charge

![](https://cdn.owox.com/www/portfolio-management-connectors/snowflake-connector-to-google-sheets/icon/1.png/public)stripe.charges · Output schema · Field · Descriptioncreated · When Stripe created the object… · amount · Amount requested in the… · amount\_refunded · Amount refunded so far in the… · currency · Three-letter ISO currency code… · status · succeeded, pending or failed. · disputed · true when a dispute (chargeback)…

## S04 · Step 4

## Step 4: Keep the Stripe tables linked

Charges, refunds and disputes stay separate tables, joined by the charge id. Together they become the money-returned part of one Stripe [data model](/product/data-modeling).

*   Refunds and disputes both name the charge they touch
*   Add orders and the CRM to the same model

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%23635BFF%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M13.976%209.15c-2.172-.806-3.356-1.426-3.356-2.409%200-.831.683-1.305%201.901-1.305%202.227%200%204.515.858%206.09%201.631l.89-5.494C18.252.975%2015.697%200%2012.165%200%209.667%200%207.589.654%206.104%201.872%204.56%203.147%203.757%204.992%203.757%207.218c0%204.039%202.467%205.76%206.476%207.219%202.585.92%203.445%201.574%203.445%202.583%200%20.98-.84%201.545-2.354%201.545-1.875%200-4.965-.921-6.99-2.109l-.9%205.555C5.175%2022.99%208.385%2024%2011.714%2024c2.641%200%204.843-.624%206.328-1.813%201.664-1.305%202.525-3.236%202.525-5.732%200-4.128-2.524-5.851-6.594-7.305h.003z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Charges · id · amount · disputed

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%23635BFF%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M13.976%209.15c-2.172-.806-3.356-1.426-3.356-2.409%200-.831.683-1.305%201.901-1.305%202.227%200%204.515.858%206.09%201.631l.89-5.494C18.252.975%2015.697%200%2012.165%200%209.667%200%207.589.654%206.104%201.872%204.56%203.147%203.757%204.992%203.757%207.218c0%204.039%202.467%205.76%206.476%207.219%202.585.92%203.445%201.574%203.445%202.583%200%20.98-.84%201.545-2.354%201.545-1.875%200-4.965-.921-6.99-2.109l-.9%205.555C5.175%2022.99%208.385%2024%2011.714%2024c2.641%200%204.843-.624%206.328-1.813%201.664-1.305%202.525-3.236%202.525-5.732%200-4.128-2.524-5.851-6.594-7.305h.003z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Refunds · charge · amount · reason

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%23635BFF%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M13.976%209.15c-2.172-.806-3.356-1.426-3.356-2.409%200-.831.683-1.305%201.901-1.305%202.227%200%204.515.858%206.09%201.631l.89-5.494C18.252.975%2015.697%200%2012.165%200%209.667%200%207.589.654%206.104%201.872%204.56%203.147%203.757%204.992%203.757%207.218c0%204.039%202.467%205.76%206.476%207.219%202.585.92%203.445%201.574%203.445%202.583%200%20.98-.84%201.545-2.354%201.545-1.875%200-4.965-.921-6.99-2.109l-.9%205.555C5.175%2022.99%208.385%2024%2011.714%2024c2.641%200%204.843-.624%206.328-1.813%201.664-1.305%202.525-3.236%202.525-5.732%200-4.128-2.524-5.851-6.594-7.305h.003z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Disputes · charge · amount · status

## S05 · Step 5

## Step 5: Schedule the Stripe refresh and backfill history

Set it once. A daily scheduled refresh keeps the charge tables current, and a manual backfill reloads earlier periods, which refreshes fields that change after creation, such as amount\_refunded.

*   Daily runs with no pipeline to maintain
*   Backfill charge history the first time you connect

Schedule · Run on a schedule · Daily 09:00

Backfill · Run backfill

Run History · Daily schedule · Manual backfill · Daily schedule

## S06 · Step 6

## Step 6: Reuse the same Stripe table everywhere

One table feeds your [data model](/product/data-modeling), [spreadsheets](/product/spreadsheets), [dashboards](/product/dashboards), [AI assistants](/product/ai-assistants) and scheduled insights in Slack or email.

*   Define a successful payment once
*   Every report reads the same table

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%23635BFF%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M13.976%209.15c-2.172-.806-3.356-1.426-3.356-2.409%200-.831.683-1.305%201.901-1.305%202.227%200%204.515.858%206.09%201.631l.89-5.494C18.252.975%2015.697%200%2012.165%200%209.667%200%207.589.654%206.104%201.872%204.56%203.147%203.757%204.992%203.757%207.218c0%204.039%202.467%205.76%206.476%207.219%202.585.92%203.445%201.574%203.445%202.583%200%20.98-.84%201.545-2.354%201.545-1.875%200-4.965-.921-6.99-2.109l-.9%205.555C5.175%2022.99%208.385%2024%2011.714%2024c2.641%200%204.843-.624%206.328-1.813%201.664-1.305%202.525-3.236%202.525-5.732%200-4.128-2.524-5.851-6.594-7.305h.003z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Stripe · Data Mart · Published

Your data model

![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets

![](https://cdn.owox.com/www/portfolio-management-data-destination/data-studio/logo/1.svg/public)Data Studio dashboards

![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude, ChatGPT

![](https://cdn.owox.com/www/portfolio-management-data-destination/slack/logo/2.svg/public)Slack, email

## Related connectors

[Stripe to Claude](/connectors/stripe-connector-to-claude)[QuickBooks to Snowflake](/connectors/quickbooks-connector-to-snowflake)[Stripe to ChatGPT](/connectors/stripe-connector-to-chatgpt)[Facebook Ads to Snowflake](/connectors/free-facebook-ads-connector-to-snowflake)[Google Ads to Snowflake](/connectors/free-google-ads-connector-to-snowflake)[Microsoft Ads to Snowflake](/connectors/free-microsoft-ads-connector-to-snowflake)[TikTok Ads to Snowflake](/connectors/free-tiktok-ads-connector-to-snowflake)[Bank of Canada to Snowflake](/connectors/bank-of-canada-connector-to-snowflake)[Criteo Ads to Snowflake](/connectors/free-criteo-ads-connector-to-snowflake) · Show 6 more · Show fewer

## Recent updates

*   [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410)
*   [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410)
*   [0.41.0 · Shared SQL logic stays in one place: build a Data Mart on top of another](https://docs.owox.com/docs/changelog/#shared-sql-logic-stays-in-one-place-build-a-data-mart-on-top-of-another-0410)
*   [0.41.0 · Rotating a connector key is one change: Sources share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-connector-key-is-one-change-sources-share-reusable-credentials-0410)
*   [0.40.0 · Connecting a plan from Google Sheets takes fewer guesses](https://docs.owox.com/docs/changelog/#connecting-a-plan-from-google-sheets-takes-fewer-guesses-0400)

## Why OWOX

## Why OWOX for Stripe in Snowflake

Payment exports from Stripe go stale on the day they are made. OWOX keeps charges in Snowflake current and joined to what else you know about the customer.

*   **You own the data.** It lands in your own data warehouse, in tables you control.
*   **Taken, returned, disputed.** Charges, refunds and disputes are separate tables joined by charge.
*   **The whole account.** 14 endpoints are available, so charges can grow into the full billing picture.
*   **One place to fix.** When Stripe's API changes, you fix the connector once.

[Book a call](/book-a-call)

[Get started free](https://www.owox.com/app-signup)

## 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)
- [Balance transactionsEvery movement of money through the Stripe balance: charges, refunds, disputes,…](https://www.owox.com/data-sources/stripe) — /data-sources/stripe.md
- [data warehouse](https://www.owox.com/data-storages) — /data-storages.md
- [data source](https://www.owox.com/data-sources) — /data-sources.md
- [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md
- [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md
- [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md
- [AI assistants](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md
- [Stripe to Claude](https://www.owox.com/connectors/stripe-connector-to-claude) — /connectors/stripe-connector-to-claude.md
- [QuickBooks to Snowflake](https://www.owox.com/connectors/quickbooks-connector-to-snowflake) — /connectors/quickbooks-connector-to-snowflake.md
- [Stripe to ChatGPT](https://www.owox.com/connectors/stripe-connector-to-chatgpt) — /connectors/stripe-connector-to-chatgpt.md
- [Facebook Ads to Snowflake](https://www.owox.com/connectors/free-facebook-ads-connector-to-snowflake) — /connectors/free-facebook-ads-connector-to-snowflake.md
- [Google Ads to Snowflake](https://www.owox.com/connectors/free-google-ads-connector-to-snowflake) — /connectors/free-google-ads-connector-to-snowflake.md
- [Microsoft Ads to Snowflake](https://www.owox.com/connectors/free-microsoft-ads-connector-to-snowflake) — /connectors/free-microsoft-ads-connector-to-snowflake.md
- [TikTok Ads to Snowflake](https://www.owox.com/connectors/free-tiktok-ads-connector-to-snowflake) — /connectors/free-tiktok-ads-connector-to-snowflake.md
- [Bank of Canada to Snowflake](https://www.owox.com/connectors/bank-of-canada-connector-to-snowflake) — /connectors/bank-of-canada-connector-to-snowflake.md
- [Criteo Ads to Snowflake](https://www.owox.com/connectors/free-criteo-ads-connector-to-snowflake) — /connectors/free-criteo-ads-connector-to-snowflake.md
- [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog)
- [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md