--- title: "Stripe to AWS Athena Connector | OWOX" canonical: "https://www.owox.com/connectors/stripe-connector-to-aws-athena" updated: "2026-11-09" --- # Collect Stripe prices and products in AWS Athena Keep Stripe products, prices and subscription items as tables that AWS Athena queries. A custom OWOX connector loads the catalogue and what customers actually subscribe to, so plan mix is a query away. ![](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-data-storage/aws-athena/logo/1.png/public)AWS Athena · 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 look at prices beside what customers actually buy A price list says what you sell. Which plans customers pick, and which ones fade, is in the subscription items. Reading the catalogue against real subscriptions needs both in one [data warehouse](/data-storages), joined on the price. * See which plans carry the subscriptions * Spot active prices nobody uses * Compare monthly and yearly plans in one query ![](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 · Catalogue, prices Orders · Store sales Usage · Product events ![](https://cdn.owox.com/www/portfolio-management-data-storage/aws-athena/logo/1.png/public)Your data warehouse · AWS Athena · Stripe · Orders · UsageJoined by id · Price published · Plan subscribedOne query shows which prices customers pick. ## 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. * Prices carries the product, currency, amount, billing scheme and interval * 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 · Prices · 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)Prices · 17 fields · productactivecurrencyunit\_amounttyperecurring\_interval ## S02 · Step 2 ## Step 2: Load Stripe into AWS Athena 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 the database you choose in AWS Athena. The location is pre-filled from your [data storage](/data-storages), and you can change it. * Products, prices and subscription items each get their own table * Every run is logged in Run History ![](https://cdn.owox.com/www/portfolio-management-data-storage/aws-athena/logo/1.png/public)Destination · AWS Athena · Database · stripe · Table · prices · Run Run History · Pending · Running · SuccessIncremental load ![](https://cdn.owox.com/www/portfolio-management-data-storage/aws-athena/logo/1.png/public)Table · stripe.prices ## 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. unit\_amount is in the smallest currency unit, and the schema says so. * recurring\_interval says month, year, week or day for recurring prices * billing\_scheme separates per-unit from tiered prices ![](https://cdn.owox.com/www/portfolio-management-data-storage/aws-athena/logo/1.png/public)stripe.prices · Output schema · Field · Descriptionproduct · Product id (prod\_). Join to… · active · Whether the price can be used… · currency · Three-letter ISO currency code… · unit\_amount · Price per unit in the smallest… · type · one\_time or recurring. · recurring\_interval · month, year, week or day for… ## S04 · Step 4 ## Step 4: Keep the Stripe tables linked Products, prices and subscription items stay separate tables, joined by ids. Together they become the catalogue part of one Stripe [data model](/product/data-modeling). * Prices carry the product id; subscription items carry the price id * Add orders and product usage 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)Products · id · name · active ![](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)Prices · id · product · unit\_amount ![](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)Subscription items · price\_id · quantity · recurring\_interv… ## S05 · Step 5 ## Step 5: Schedule the Stripe refresh and backfill history Set it once. A daily scheduled refresh reads new rows, and a manual backfill reloads the whole catalogue, which is how changes to an existing price arrive. * Daily runs with no pipeline to maintain * Backfill the full catalogue 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 plan 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 AWS Athena](/connectors/quickbooks-connector-to-aws-athena)[Stripe to ChatGPT](/connectors/stripe-connector-to-chatgpt)[Facebook Ads to AWS Athena](/connectors/free-facebook-ads-connector-to-aws-athena)[Google Ads to AWS Athena](/connectors/free-google-ads-connector-to-aws-athena)[Microsoft Ads to AWS Athena](/connectors/free-microsoft-ads-connector-to-aws-athena)[TikTok Ads to AWS Athena](/connectors/free-tiktok-ads-connector-to-aws-athena)[Bank of Canada to AWS Athena](/connectors/bank-of-canada-connector-to-aws-athena)[Criteo Ads to AWS Athena](/connectors/free-criteo-ads-connector-to-aws-athena) · 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 AWS Athena The Stripe product catalogue is a settings page. OWOX makes it a set of tables in your own data warehouse that AWS Athena can query. * **You own the data.** It lands in your own data warehouse, in tables you control. * **Catalogue and demand together.** Prices join subscription items, so plan mix is measured. * **Query it where you already do.** AWS Athena reads the tables directly. * **One place to fix.** A Stripe API change is a new connector version, not a rewrite of your tables. [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 AWS Athena](https://www.owox.com/connectors/quickbooks-connector-to-aws-athena) — /connectors/quickbooks-connector-to-aws-athena.md - [Stripe to ChatGPT](https://www.owox.com/connectors/stripe-connector-to-chatgpt) — /connectors/stripe-connector-to-chatgpt.md - [Facebook Ads to AWS Athena](https://www.owox.com/connectors/free-facebook-ads-connector-to-aws-athena) — /connectors/free-facebook-ads-connector-to-aws-athena.md - [Google Ads to AWS Athena](https://www.owox.com/connectors/free-google-ads-connector-to-aws-athena) — /connectors/free-google-ads-connector-to-aws-athena.md - [Microsoft Ads to AWS Athena](https://www.owox.com/connectors/free-microsoft-ads-connector-to-aws-athena) — /connectors/free-microsoft-ads-connector-to-aws-athena.md - [TikTok Ads to AWS Athena](https://www.owox.com/connectors/free-tiktok-ads-connector-to-aws-athena) — /connectors/free-tiktok-ads-connector-to-aws-athena.md - [Bank of Canada to AWS Athena](https://www.owox.com/connectors/bank-of-canada-connector-to-aws-athena) — /connectors/bank-of-canada-connector-to-aws-athena.md - [Criteo Ads to AWS Athena](https://www.owox.com/connectors/free-criteo-ads-connector-to-aws-athena) — /connectors/free-criteo-ads-connector-to-aws-athena.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