---
title: "Stripe to Google BigQuery Connector | OWOX"
canonical: "https://www.owox.com/connectors/stripe-connector-to-google-bigquery"
updated: "2026-11-09"
---

# Collect Stripe subscriptions in Google BigQuery

Load Stripe subscriptions, invoices and customers into your own BigQuery project with a custom OWOX connector: one table per endpoint, readable columns, a refresh on a schedule. Recurring revenue then joins to orders and ad spend.

![](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/webflow/679a01994def1d262136d80a_431.svg/public)Google BigQuery · 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 subscriptions with sales and ad data

Stripe knows who subscribes and when they renew. It does not know which ad brought them or what they ordered first. To read recurring revenue against acquisition cost, all of it has to sit in one [data warehouse](/data-storages).

*   Compute monthly recurring revenue from subscriptions and invoices
*   Set acquisition spend beside new subscriptions
*   See churn next to the open or uncollectible invoices before it

![](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 · Subscriptions

Orders · Store sales

Ad platforms · Spend

![](https://cdn.owox.com/www/webflow/679a01994def1d262136d80a_431.svg/public)Your data warehouse · BigQuery · Stripe · Orders · Ad spendJoined by id · Ad clicked · Subscription renewsOne query links acquisition to recurring revenue.

## 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.

*   Subscriptions carries customer, status, period dates and cancellation fields
*   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 · Subscriptions · Balance transacti… · Charges · Customers

![](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)Subscriptions · 23 fields · customerstatusstart\_datecurrent\_period\_endcancel\_at\_period\_endcurrency

## S02 · Step 2

## Step 2: Load Stripe into Google BigQuery

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 dataset of your own Google BigQuery project. The location is pre-filled from your [data storage](/data-storages), and you can change it.

*   Each endpoint gets its own table, not one table for the account
*   Every run is logged in Run History

![](https://cdn.owox.com/www/webflow/679a01994def1d262136d80a_431.svg/public)Destination · BigQuery · Dataset · stripe · Table · subscriptions · Run

Run History · Pending · Running · SuccessIncremental load

![](https://cdn.owox.com/www/webflow/679a01994def1d262136d80a_431.svg/public)Table · stripe.subscriptions

## 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. Timestamps arrive as Unix seconds, and the schema says so. Your [data quality](/product/data-quality) checks can read it too.

*   status lists trialing, active, past\_due, unpaid, canceled and the incomplete states
*   Unix seconds convert with one function in SQL

![](https://cdn.owox.com/www/webflow/679a01994def1d262136d80a_431.svg/public)stripe.subscriptions · Output schema · Field · Descriptioncustomer · Customer id (cus\_). Join to… · status · trialing, active, past\_due… · start\_date · When the subscription started… · current\_period\_end · End of the current billing… · cancel\_at\_period\_end · true when set to cancel at the… · currency · Three-letter ISO currency code…

## S04 · Step 4

## Step 4: Keep the Stripe tables linked

Customers, subscriptions and invoices stay separate tables, joined by ids. Together they become one Stripe [data model](/product/data-modeling), ready to join to orders and ad spend.

*   Subscriptions carry customer; invoices carry subscription
*   Add orders and ad platforms 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)Customers · id · email · delinquent

![](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)Subscriptions · id · customer · status

![](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)Invoices · subscription · status · currency

## S05 · Step 5

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

Set it once. A daily scheduled refresh keeps the tables current, and a manual backfill reloads history, which refreshes fields that change after creation, such as status.

*   Daily runs with no pipeline to maintain
*   Backfill the subscription 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 monthly recurring revenue 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 Google BigQuery](/connectors/quickbooks-connector-to-google-bigquery)[Stripe to ChatGPT](/connectors/stripe-connector-to-chatgpt)[Facebook Ads to Google BigQuery](/connectors/free-facebook-ads-connector-to-google-bigquery)[Google Ads to Google BigQuery](/connectors/free-google-ads-connector-to-google-bigquery)[Microsoft Ads to Google BigQuery](/connectors/free-microsoft-ads-connector-to-google-bigquery)[TikTok Ads to Google BigQuery](/connectors/free-tiktok-ads-connector-to-google-bigquery)[Bank of Canada to Google BigQuery](/connectors/bank-of-canada-connector-to-google-bigquery)[Criteo Ads to Google BigQuery](/connectors/free-criteo-ads-connector-to-google-bigquery) · 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 Google BigQuery

Stripe dashboards, hand-built API scripts or a generic ETL tool each get subscriptions out. OWOX also keeps them yours, readable and ready to join to acquisition.

*   **You own the data.** It lands in your own data warehouse, in tables you control.
*   **A custom connector, built to be extended.** The Stripe connector is made in OWOX Data Marts, so an endpoint or field can be added when the account needs it.
*   **Ready for a data model.** Separate tables per endpoint, joined by ids, built to connect to orders, ad spend and web analytics.
*   **One place to fix.** When Stripe changes its API, you fix one connector, not a pile of scripts.

[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 quality](https://www.owox.com/product/data-quality) — /product/data-quality.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 Google BigQuery](https://www.owox.com/connectors/quickbooks-connector-to-google-bigquery) — /connectors/quickbooks-connector-to-google-bigquery.md
- [Stripe to ChatGPT](https://www.owox.com/connectors/stripe-connector-to-chatgpt) — /connectors/stripe-connector-to-chatgpt.md
- [Facebook Ads to Google BigQuery](https://www.owox.com/connectors/free-facebook-ads-connector-to-google-bigquery) — /connectors/free-facebook-ads-connector-to-google-bigquery.md
- [Google Ads to Google BigQuery](https://www.owox.com/connectors/free-google-ads-connector-to-google-bigquery) — /connectors/free-google-ads-connector-to-google-bigquery.md
- [Microsoft Ads to Google BigQuery](https://www.owox.com/connectors/free-microsoft-ads-connector-to-google-bigquery) — /connectors/free-microsoft-ads-connector-to-google-bigquery.md
- [TikTok Ads to Google BigQuery](https://www.owox.com/connectors/free-tiktok-ads-connector-to-google-bigquery) — /connectors/free-tiktok-ads-connector-to-google-bigquery.md
- [Bank of Canada to Google BigQuery](https://www.owox.com/connectors/bank-of-canada-connector-to-google-bigquery) — /connectors/bank-of-canada-connector-to-google-bigquery.md
- [Criteo Ads to Google BigQuery](https://www.owox.com/connectors/free-criteo-ads-connector-to-google-bigquery) — /connectors/free-criteo-ads-connector-to-google-bigquery.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