How does Kondado move Stripe data into Redshift?

You connect Stripe as a data source, provide Redshift connection details, and choose the Stripe pipelines to replicate. Kondado maps each selected pipeline to a Redshift dataset and runs replication jobs on your configured schedule. You can adjust pipeline selection and schedule settings as reporting needs change.

Which Stripe pipelines are useful for tax and billing analysis in Redshift?

Tax rates, Credit notes, Invoice line items, and Billing meters give finance teams detailed views of tax treatment, credits, invoice composition, and usage-based billing. In Redshift, you can join these pipelines with Invoice payments and Plans to reconcile billed amounts, tax, and credit adjustments. This supports custom finance dashboards and month-end analysis.

How often can Stripe data be replicated to Redshift?

You control update frequency through the schedule in Kondado, with options such as every 5 minutes, every 15 minutes, hourly, or daily. Each scheduled run replicates the selected Stripe pipelines to Redshift. Your Redshift dashboards and SQL queries can then use the latest completed run.

What format does Stripe data take in Redshift?

Each Stripe pipeline lands as a Redshift dataset with typed columns for identifiers, timestamps, amounts, currencies, statuses, and the specific fields available in that pipeline. Detail pipelines such as Invoice line items and Subscription items are replicated as separate datasets for granular analysis. Analysts can query these datasets with standard SQL and join them using shared IDs.

Can I combine Stripe data in Redshift with other business sources?

Yes, Redshift lets you join Stripe pipelines with data from systems such as PostgreSQL , BigQuery , or Google Sheets . This helps you build unified views of customers, revenue, and operations without moving Stripe data out of the warehouse. You can then analyze the combined data with SQL or BI tools.

Does Kondado replicate Stripe Connect account data?

Yes, the Connected accounts (Connect) pipeline captures account identifiers, business profile details, support information, and payment capability statuses. You can combine it with Transfers and Application fees to analyze platform revenue and connected account activity in Redshift. More details are available on the Stripe source page.

Can I build custom dashboards from Stripe data in Redshift?

Yes, once Stripe pipelines are in Redshift, you can connect BI tools such as Power BI or Looker Studio and build custom dashboards for revenue, subscriptions, refunds, and payouts. You define the metrics and dimensions that matter to your team. The dashboards can refresh from Redshift as new scheduled runs complete.

Kondado: Replicate data from Stripe to Redshift

Send Stripe Data to Redshift

To send Stripe data to Redshift, connect your Stripe account as a data source in Kondado, choose the pipelines you need, and set the destination to Redshift. Kondado reads the selected Stripe objects and writes them to your Redshift cluster on a schedule you configure, such as every 15 minutes, hourly, or daily. You can start with core payment pipelines like Charges, Payment intents, and Invoices, then add subscription, customer, refund, and payout pipelines as your reporting needs grow. This gives analysts and technical teams a repeatable way to keep Stripe data available for SQL analysis, custom dashboards, and financial reporting in Redshift.

Kondado replicates Stripe data to Redshift through managed pipelines, with 51 available pipelines and 1,971 fields covering charges, payment intents, invoices, subscriptions, customers, refunds, disputes, payouts, balance transactions, and related payment objects. You select the pipelines to replicate, map them to your Redshift destination, and set an update schedule that fits your reporting cadence.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Available integrations

Subscription schedules

Registry of subscription schedules, with id, customer, subscription, status, creation, cancellation, completion and release dates, current phase, billing mode, default settings, end behavior, and live-mode flag.

Early fraud warnings

Record of early fraud warnings, with id, actionable flag, related charge and PaymentIntent, creation timestamp, fraud type, and live/test mode.

Tax rates

Tax rate record with identifier, active status, country, state and jurisdiction, display name, percentage and effective percentage, flat amount and currency, inclusive flag, rate type and tax type, creation timestamp, and live mode.

Subscriptions

Subscription record with identifier, customer, status, collection method, currency, billing cycle and anchor, creation, start, cancellation and end dates, fee amounts and percentages, discounts, thresholds, invoice and trial settings, plus schedule and pending updates.

Subscriptions - Details - Subscription items

Subscription items, with id, associated subscription and price, quantity, billing and trial periods, usage thresholds, and price attributes such as currency, unit amount, recurring interval, and usage type.

Customers

Stripe customer records, with identifier, name/business, email, address, balance and currency, invoice settings, tax data, shipping, discount, cash balance, and creation timestamp.

Customers - Details - Tax IDs

Registry of each customer's tax IDs (CNPJ, CPF, VAT, etc.), with country, type, value, verification status, creation timestamp, and customer, account, and owner references.

Customers - Details - Payment methods

Payment methods linked to customers, with identifiers, billing details, card details (brand, expiry, last four digits, checks), bank accounts, and digital wallets.

Customers - Details - Customer balance transactions

Each row is a customer credit balance transaction, with id, customer_id, amount, ending_balance, currency, type, created, description, livemode, and related IDs for checkout_session, credit_note, customer, customer_account, and invoice.

Charges

Stripe charge records with id, amount, captured and refunded amounts, currency, creation date, status, paid/captured/refunded/disputed flags, customer, PaymentIntent, payment method, balance transaction, risk outcome, and billing/shipping details.

Billing credit grants

Registry of billing credit grants issued to customers for consumption-based billing, with id, customer/account, monetary amount and currency, type, category, priority, price scope, effective/expiration/void timestamps, live/test mode, and creation/update timestamps.

Connected accounts (Connect)

Registry of connected accounts (Connect), with identifier, business profile (name, MCC, type, estimated annual and monthly revenue, estimated worker count), support details, and payment capability statuses.

Disputes

Stripe dispute records, with id, disputed amount, currency, related charge and PaymentIntent, reason, status, creation and evidence due dates, plus evidence and eligibility details.

Coupons

Registry of discount coupons, with identifier, name, amount or percentage off, currency, duration and duration in months, redemption limits and count, redemption deadline, validity status, livemode flag, and creation timestamp.

Promotion codes

Registry of promotion codes customers enter to apply a coupon, with identifier, code, active status, customer, expiration, redemption limits and count, promotion type, and minimum-amount and first-transaction restrictions.

Events

Record of Stripe account events, with id, account, API version, context, creation time, livemode, pending webhooks, request details, event type, and the affected object's id and type.

Invoices

Registry of invoices, with identifier, customer, currency, amounts due/paid/remaining, creation and due dates, collection method, billing reason, and automatic tax status.

Invoices - Details - Invoice line items

Each row represents a Stripe invoice line item, with invoice, subscription, and parent identifiers, plus amount, subtotal, currency, quantity/quantity_decimal, period_start/period_end, description, discountable, livemode, parent_type, and pricing details (price, product, pricing_type).

Entitlement features

Registry of features that can be granted to customers by product, with unique identifier, active status, live-mode flag, lookup key, and name.

Setup intents

Each row records a SetupIntent, with id, customer, status, usage, created, payment_method, cancellation_reason, last_setup_error fields, automatic_payment_methods, mandate, latest_attempt, and livemode.

Payment intents

Payment intent records, with id, amount and amount received, currency, status, creation date, customer, payment method, capture and confirmation method, cancellation reason, latest charge, and transfer data.

Invoice items

Record of an invoice item, with id, amount and currency, linked customer and invoice, date, description, quantity, discount and proration flags, period, and pricing/subscription details.

Payment links

Registry of payment links, with identifier, active status, URL, currency, post-purchase behavior, tax, invoice, PaymentIntent, subscription, application fee, transfer amount, and session restriction settings.

Payment links - Details - Line items

Line items of payment links, with payment_link_id, id, quantity, description, currency, discount, subtotal, tax and total amounts, plus price data (id, type, billing scheme, recurring interval and unit amount) and adjustable quantity limits.

Radar value lists

Each row represents a Radar value list, with id, alias, name, item type, creator, creation timestamp, and live mode indicator.

Radar value lists - Details - Items

Item in a Radar value list, with its own and parent list identifiers, value, creation timestamp, creator, and live-mode indicator.

Billing meters

Registration of usage billing meters for consumption-based billing, with id, display_name, event_name, default_aggregation_formula, customer_mapping_type, event_time_window, status, livemode, and creation, update, and deactivation timestamps.

Credit notes

Credit notes issued or voided, with identifier, customer, invoice, status, reason, currency, amounts (subtotal, total, tax, shipping and payment amounts), creation/effective/void dates, and PDF link.

Credit notes - Details - Line items

Each row represents a credit note line item, with credit note and item IDs, amount, description, discount amount, linked invoice line item, livemode flag, quantity, type, and unit amounts.

Quotes

Record of quotes with id, status, customer, invoice and subscription, currency, subtotal/total amounts and computed recurring and upfront totals, discount, shipping and tax details, creation/expiration/status-transition dates, and invoice and subscription settings.

Quotes - Details - Line items

Each row represents a quote line item, with quote_id and id, description, quantity, currency, discount, subtotal, tax, and total amounts, plus price details (id, type, unit amount, recurrence, product) and adjustable quantity limits.

Invoice payments

Payments applied to invoices, with id, related invoice, paid and requested amounts, currency, status, payment type and originating payment references, default flag, livemode, and creation, payment, and cancellation timestamps.

Plans

Registry of recurring price plans, with id, active status, amount and currency, billing scheme, interval and interval count, product, nickname, tiers mode, usage type, trial days, meter, usage transformation, creation timestamp, and live/test mode.

Prices

Registry of product prices (one-time or recurring), with id, active status, currency, unit amount, billing scheme, recurring interval, associated product, and tier and tax settings.

Products

Stripe catalog product record, with identifier, name, description, active status, default price, package dimensions, tax code, unit label, URL, and creation and update timestamps.

Top-ups

Record of each balance top-up, with id, amount and currency, status, creation time, balance transaction, payment method, initiator, failure code/message, expected availability date, description, statement descriptor, source ID, and transfer group.

Refunds

Each row represents a Stripe refund, with id, amount, currency, status, reason, creation date, links to charge, customer, and PaymentIntent, plus balance transaction, destination, failure/pending, and presentment details.

Payouts

Each row is a payout, with id, amount, currency, status, creation and arrival dates, method, destination, balance transaction, failure code/message, and reversal references.

Payouts - Details - Payout transactions

Each row is a balance transaction linked to a payout, with identifier, gross amount, fee, net amount, currency, status, type, reporting category, availability and creation dates, source, and exchange rate.

Radar reviews

Each row represents a Radar review, with its identifier, associated charge and PaymentIntent, open/closed status and reasons, creation timestamp, IP and location data, session details, and live-mode flag.

Current balance

Current Stripe account balance per balance type and currency, with amount, portions from cards, bank accounts, and FPX, production/test mode flag, and read timestamp.

Checkout sessions

Checkout sessions, with unique id, creation and expiration timestamps, currency, subtotal and total amounts, customer, invoice, and PaymentIntent references, plus address, tax, branding, and consent data.

Checkout sessions - Details - Line items

Line items of a checkout session, with session and item identifiers, quantity, description, currency, discount, subtotal, tax and total amounts, plus price details such as product, type, recurrence, tax behavior and unit amount.

Identity verification sessions

Each row represents an identity verification session, with id, client_reference_id, created, status, type, livemode, document/email/phone and matching options, provided details, latest error, redaction_status, related customer/person, verification_flow, and verified outputs (address, date of birth, email, name, ID number, phone, and sex).

Shipping rates

Each row represents a shipping rate, with id, active status, creation time, display name, delivery estimate minimum/maximum unit and value, fixed amount and currency, livemode, tax behavior, tax code, and calculation type.

Application fees

Each row represents a Stripe application fee, with its identifier, account, application, related charge and balance transaction, amount and amount refunded, currency, creation time, fee source, live mode, and full-refund indicator.

Terminal readers

Registry of terminal readers, with id, label, serial number, device type and software version, IP address, location, network status, last seen, livemode, and action details such as type, status, API errors, refund, display, print, and processing configurations.

Terminal locations

Registry of physical locations for Stripe Terminal readers, with id, address (including kana/kanji variants), display name, configuration override, phone, and live-mode flag.

Balance transactions

Each row is a Stripe balance transaction, with id, gross amount, fee, net impact, currency, exchange rate, creation and availability dates, balance type, reporting category, source, status, and transaction type.

Transfers

Stripe transfer record with identifier, amount and reversed amount, balance transaction, creation timestamp, currency, description, destination account, destination payment, live mode, reversal status, source charge, source type, and transfer group.

Transfers - Details - Reversals

Transfer reversals, with id, reversed transfer, amount, currency, creation timestamp, balance transaction, and linked source/destination payment refunds.

See all available data → Send Stripe to Redshift →