--- title: Stripe description: Connect Stripe, understand its sync behavior, and query every table and column it writes. species: reference --- # Stripe Connect Stripe with a restricted key with read access to the selected resources. The source writes 17 fixed tables under `titan.stripe`. ```sql select id, amount, available_on from titan.stripe.balance_transactions limit 10 ``` ## Connect Stripe 1. Open **Apps**, choose **Connect app**, and select **Stripe**. 2. Enter a restricted key with read access to the selected resources. 3. Review the tables, then save the source. 4. Watch **Sync history** until the first run completes. Credentials are stored as secrets. They never become lake columns or appear in query results. ## Sync behavior Amounts are integer minor units, livemode separates production from test data, and deleted objects remain visible through _deleted. Event-driven updates fall back to a full list when the saved cursor is older than 27 days. A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely. Every lake table also has the [system columns](/v2/docs/concepts/your-lake#the-system-columns) `_synced_at` and `_deleted`; the column reference below lists source columns only. ## Table reference ### `balance_transactions` `titan.stripe.balance_transactions` has 14 source columns. ```columns table=stripe.balance_transactions id string pk Source field `id`. amount integer Source field `amount`. available_on datetime Source field `availableOn`. created_at datetime Source field `createdAt`. currency string Source field `currency`. description string Source field `description`. exchange_rate float Source field `exchangeRate`. fee integer Source field `fee`. fee_details json Source field `feeDetails`. net integer Source field `net`. reporting_category string Source field `reportingCategory`. status string Source field `status`. type string Source field `type`. source string Source field `source`. ``` ### `coupons` `titan.stripe.coupons` has 16 source columns. ```columns table=stripe.coupons id string pk Source field `id`. created_at datetime Source field `createdAt`. amount_off integer Source field `amountOff`. currency string Source field `currency`. duration string Source field `duration`. duration_in_months integer Source field `durationInMonths`. metadata json Source field `metadata`. name string Source field `name`. percent_off float Source field `percentOff`. applies_to json Source field `appliesTo`. currency_options json Source field `currencyOptions`. livemode boolean Source field `livemode`. max_redemptions integer Source field `maxRedemptions`. redeem_by datetime Source field `redeemBy`. times_redeemed integer Source field `timesRedeemed`. valid boolean Source field `valid`. ``` ### `customers` `titan.stripe.customers` has 26 source columns. ```columns table=stripe.customers id string pk Source field `id`. created_at datetime Source field `createdAt`. address json Source field `address`. description string Source field `description`. email string Source field `email`. metadata json Source field `metadata`. name string Source field `name`. phone string Source field `phone`. shipping json Source field `shipping`. tax json Source field `tax`. balance integer Source field `balance`. cash_balance json Source field `cashBalance`. currency string Source field `currency`. default_source string Source field `defaultSource`. delinquent boolean Source field `delinquent`. discount json Source field `discount`. invoice_credit_balance json Source field `invoiceCreditBalance`. invoice_prefix string Source field `invoicePrefix`. invoice_settings json Source field `invoiceSettings`. livemode boolean Source field `livemode`. next_invoice_sequence integer Source field `nextInvoiceSequence`. preferred_locales json Source field `preferredLocales`. sources json Source field `sources`. tax_exempt string Source field `taxExempt`. tax_ids json Source field `taxIds`. test_clock string Source field `testClock`. ``` ### `customer_balance_transactions` `titan.stripe.customer_balance_transactions` has 13 source columns. ```columns table=stripe.customer_balance_transactions id string pk Source field `id`. customer_id string Source field `customerId`. amount integer Source field `amount`. currency string Source field `currency`. description string Source field `description`. ending_balance integer Source field `endingBalance`. metadata json Source field `metadata`. type string Source field `type`. checkout_session_id string Source field `checkoutSessionId`. created_at datetime Source field `createdAt`. credit_note_id string Source field `creditNoteId`. invoice_id string Source field `invoiceId`. livemode boolean Source field `livemode`. ``` ### `invoices` `titan.stripe.invoices` has 70 source columns. ```columns table=stripe.invoices id string pk Source field `id`. customer_id string Source field `customerId`. created_at datetime Source field `createdAt`. auto_advance boolean Source field `autoAdvance`. automatic_tax json Source field `automaticTax`. collection_method string Source field `collectionMethod`. currency string Source field `currency`. description string Source field `description`. hosted_invoice_url string Source field `hostedInvoiceUrl`. metadata json Source field `metadata`. parent json Source field `parent`. period_start datetime Source field `periodStart`. period_end datetime Source field `periodEnd`. status string Source field `status`. total integer Source field `total`. account_country string Source field `accountCountry`. account_name string Source field `accountName`. account_tax_ids json Source field `accountTaxIds`. amount_due integer Source field `amountDue`. amount_overpaid integer Source field `amountOverpaid`. amount_paid integer Source field `amountPaid`. amount_remaining integer Source field `amountRemaining`. amount_shipping integer Source field `amountShipping`. attempt_count integer Source field `attemptCount`. attempted boolean Source field `attempted`. automatically_finalizes_at datetime Source field `automaticallyFinalizesAt`. billing_reason string Source field `billingReason`. custom_fields json Source field `customFields`. customer_address json Source field `customerAddress`. customer_email string Source field `customerEmail`. customer_name string Source field `customerName`. customer_phone string Source field `customerPhone`. customer_shipping json Source field `customerShipping`. customer_tax_exempt string Source field `customerTaxExempt`. customer_tax_ids json Source field `customerTaxIds`. default_payment_method string Source field `defaultPaymentMethod`. default_source string Source field `defaultSource`. default_tax_rates json Source field `defaultTaxRates`. discounts json Source field `discounts`. due_date datetime Source field `dueDate`. effective_at datetime Source field `effectiveAt`. ending_balance integer Source field `endingBalance`. footer string Source field `footer`. from_invoice json Source field `fromInvoice`. invoice_pdf string Source field `invoicePdf`. last_finalization_error json Source field `lastFinalizationError`. latest_revision string Source field `latestRevision`. livemode boolean Source field `livemode`. next_payment_attempt datetime Source field `nextPaymentAttempt`. number string Source field `number`. payment_settings json Source field `paymentSettings`. payments json Source field `payments`. post_payment_credit_notes_amount integer Source field `postPaymentCreditNotesAmount`. pre_payment_credit_notes_amount integer Source field `prePaymentCreditNotesAmount`. receipt_number string Source field `receiptNumber`. rendering json Source field `rendering`. shipping_cost json Source field `shippingCost`. shipping_details json Source field `shippingDetails`. starting_balance integer Source field `startingBalance`. statement_descriptor string Source field `statementDescriptor`. status_transitions json Source field `statusTransitions`. subtotal integer Source field `subtotal`. subtotal_excluding_tax integer Source field `subtotalExcludingTax`. test_clock string Source field `testClock`. threshold_reason json Source field `thresholdReason`. total_discount_amounts json Source field `totalDiscountAmounts`. total_excluding_tax integer Source field `totalExcludingTax`. total_pretax_credit_amounts json Source field `totalPretaxCreditAmounts`. total_taxes json Source field `totalTaxes`. webhooks_delivered_at datetime Source field `webhooksDeliveredAt`. ``` ### `invoice_discounts` `titan.stripe.invoice_discounts` has 9 source columns. ```columns table=stripe.invoice_discounts id string pk Source field `id`. invoice_id string pk Source field `invoiceId`. invoice_item_id string Source field `invoiceItemId`. customer_id string Source field `customerId`. subscription_id string Source field `subscriptionId`. coupon json Source field `coupon`. start datetime Source field `start`. end datetime Source field `end`. checkout_session string Source field `checkoutSession`. ``` ### `invoice_items` `titan.stripe.invoice_items` has 21 source columns. ```columns table=stripe.invoice_items id string pk Source field `id`. invoice_id string Source field `invoiceId`. customer_id string Source field `customerId`. subscription_id string Source field `subscriptionId`. created_at datetime Source field `createdAt`. amount integer Source field `amount`. currency string Source field `currency`. description string Source field `description`. metadata json Source field `metadata`. parent json Source field `parent`. period_start datetime Source field `periodStart`. period_end datetime Source field `periodEnd`. pricing json Source field `pricing`. proration boolean Source field `proration`. date datetime Source field `date`. discountable boolean Source field `discountable`. discounts json Source field `discounts`. livemode boolean Source field `livemode`. quantity integer Source field `quantity`. tax_rates json Source field `taxRates`. test_clock string Source field `testClock`. ``` ### `invoice_line_items` `titan.stripe.invoice_line_items` has 19 source columns. ```columns table=stripe.invoice_line_items id string pk Source field `id`. invoice_id string Source field `invoiceId`. amount integer Source field `amount`. currency string Source field `currency`. description string Source field `description`. metadata json Source field `metadata`. parent json Source field `parent`. period_start datetime Source field `periodStart`. period_end datetime Source field `periodEnd`. pricing json Source field `pricing`. quantity integer Source field `quantity`. discount_amounts json Source field `discountAmounts`. discountable boolean Source field `discountable`. discounts json Source field `discounts`. livemode boolean Source field `livemode`. pretax_credit_amounts json Source field `pretaxCreditAmounts`. taxes json Source field `taxes`. unique_id string Source field `uniqueId`. unique_line_item_id string Source field `uniqueLineItemId`. ``` ### `events` `titan.stripe.events` has 4 source columns. ```columns table=stripe.events id string pk Source field `id`. type string Source field `type`. data json Source field `data`. created_at datetime Source field `createdAt`. ``` ### `charges` `titan.stripe.charges` has 36 source columns. ```columns table=stripe.charges id string pk Source field `id`. created_at datetime Source field `createdAt`. amount integer Source field `amount`. balance_transaction_id string Source field `balanceTransactionId`. customer_id string Source field `customerId`. billing_details json Source field `billingDetails`. currency string Source field `currency`. description string Source field `description`. disputed boolean Source field `disputed`. metadata json Source field `metadata`. payment_intent_id string Source field `paymentIntentId`. payment_method_details json Source field `paymentMethodDetails`. receipt_email string Source field `receiptEmail`. refunded boolean Source field `refunded`. shipping json Source field `shipping`. statement_descriptor string Source field `statementDescriptor`. statement_descriptor_suffix string Source field `statementDescriptorSuffix`. status string Source field `status`. amount_captured integer Source field `amountCaptured`. amount_refunded integer Source field `amountRefunded`. calculated_statement_descriptor string Source field `calculatedStatementDescriptor`. captured boolean Source field `captured`. failure_balance_transaction_id string Source field `failureBalanceTransactionId`. failure_code string Source field `failureCode`. failure_message string Source field `failureMessage`. fraud_details json Source field `fraudDetails`. livemode boolean Source field `livemode`. outcome json Source field `outcome`. paid boolean Source field `paid`. payment_method_id string Source field `paymentMethodId`. presentment_details json Source field `presentmentDetails`. radar_options json Source field `radarOptions`. receipt_number string Source field `receiptNumber`. receipt_url string Source field `receiptUrl`. refunds json Source field `refunds`. review string Source field `review`. ``` ### `payment_methods` `titan.stripe.payment_methods` has 6 source columns. ```columns table=stripe.payment_methods id string pk Source field `id`. customer_id string Source field `customerId`. created_at datetime Source field `createdAt`. billing_details json Source field `billingDetails`. metadata json Source field `metadata`. type string Source field `type`. ``` ### `payment_intents` `titan.stripe.payment_intents` has 29 source columns. ```columns table=stripe.payment_intents id string pk Source field `id`. amount integer Source field `amount`. currency string Source field `currency`. created_at datetime Source field `createdAt`. customer_id string Source field `customerId`. description string Source field `description`. latest_charge string Source field `latestCharge`. metadata json Source field `metadata`. next_action json Source field `nextAction`. payment_method_id string Source field `paymentMethodId`. receipt_email string Source field `receiptEmail`. setup_future_usage string Source field `setupFutureUsage`. shipping json Source field `shipping`. statement_descriptor string Source field `statementDescriptor`. statement_descriptor_suffix string Source field `statementDescriptorSuffix`. status string Source field `status`. amount_capturable integer Source field `amountCapturable`. amount_details json Source field `amountDetails`. amount_received integer Source field `amountReceived`. canceled_at datetime Source field `canceledAt`. cancellation_reason string Source field `cancellationReason`. capture_method string Source field `captureMethod`. confirmation_method string Source field `confirmationMethod`. livemode boolean Source field `livemode`. payment_method_configuration_details json Source field `paymentMethodConfigurationDetails`. payment_method_options json Source field `paymentMethodOptions`. presentment_details json Source field `presentmentDetails`. processing json Source field `processing`. review_id string Source field `reviewId`. ``` ### `subscriptions` `titan.stripe.subscriptions` has 38 source columns. ```columns table=stripe.subscriptions id string pk Source field `id`. automatic_tax json Source field `automaticTax`. currency string Source field `currency`. customer_id string Source field `customerId`. created_at datetime Source field `createdAt`. ended_at datetime Source field `endedAt`. default_payment_method string Source field `defaultPaymentMethod`. description string Source field `description`. latest_invoice string Source field `latestInvoice`. metadata json Source field `metadata`. pending_setup_intent string Source field `pendingSetupIntent`. pending_update json Source field `pendingUpdate`. status string Source field `status`. billing_cycle_anchor datetime Source field `billingCycleAnchor`. billing_cycle_anchor_config json Source field `billingCycleAnchorConfig`. billing_mode json Source field `billingMode`. billing_thresholds json Source field `billingThresholds`. cancel_at datetime Source field `cancelAt`. cancel_at_period_end boolean Source field `cancelAtPeriodEnd`. canceled_at datetime Source field `canceledAt`. cancellation_details json Source field `cancellationDetails`. collection_method string Source field `collectionMethod`. days_until_due integer Source field `daysUntilDue`. default_source string Source field `defaultSource`. default_tax_rates json Source field `defaultTaxRates`. discounts json Source field `discounts`. invoice_settings json Source field `invoiceSettings`. livemode boolean Source field `livemode`. next_pending_invoice_item_invoice datetime Source field `nextPendingInvoiceItemInvoice`. pause_collection json Source field `pauseCollection`. payment_settings json Source field `paymentSettings`. pending_invoice_item_interval json Source field `pendingInvoiceItemInterval`. schedule string Source field `schedule`. start_date datetime Source field `startDate`. test_clock string Source field `testClock`. trial_end datetime Source field `trialEnd`. trial_settings json Source field `trialSettings`. trial_start datetime Source field `trialStart`. ``` ### `subscription_items` `titan.stripe.subscription_items` has 11 source columns. ```columns table=stripe.subscription_items id string pk Source field `id`. metadata json Source field `metadata`. price json Source field `price`. quantity integer Source field `quantity`. subscription_id string Source field `subscriptionId`. created_at datetime Source field `createdAt`. billing_thresholds json Source field `billingThresholds`. current_period_start datetime Source field `currentPeriodStart`. current_period_end datetime Source field `currentPeriodEnd`. discounts json Source field `discounts`. tax_rates json Source field `taxRates`. ``` ### `plans` `titan.stripe.plans` has 19 source columns. ```columns table=stripe.plans id string pk Source field `id`. created_at datetime Source field `createdAt`. active boolean Source field `active`. currency string Source field `currency`. interval string Source field `interval`. interval_count integer Source field `intervalCount`. metadata json Source field `metadata`. nickname string Source field `nickname`. product_id string Source field `productId`. trial_period_days integer Source field `trialPeriodDays`. aggregate_usage string Source field `aggregateUsage`. amount_decimal float Source field `amountDecimal`. billing_scheme string Source field `billingScheme`. livemode boolean Source field `livemode`. meter string Source field `meter`. tiers json Source field `tiers`. tiers_mode string Source field `tiersMode`. transform_usage json Source field `transformUsage`. usage_type string Source field `usageType`. ``` ### `prices` `titan.stripe.prices` has 20 source columns. ```columns table=stripe.prices id string pk Source field `id`. created_at datetime Source field `createdAt`. active boolean Source field `active`. currency string Source field `currency`. metadata json Source field `metadata`. nickname string Source field `nickname`. product_id string Source field `productId`. recurring json Source field `recurring`. tax_behavior string Source field `taxBehavior`. type string Source field `type`. unit_amount integer Source field `unitAmount`. billing_scheme string Source field `billingScheme`. currency_options json Source field `currencyOptions`. custom_unit_amount json Source field `customUnitAmount`. livemode boolean Source field `livemode`. lookup_key string Source field `lookupKey`. tiers json Source field `tiers`. tiers_mode string Source field `tiersMode`. transform_quantity json Source field `transformQuantity`. unit_amount_decimal float Source field `unitAmountDecimal`. ``` ### `refunds` `titan.stripe.refunds` has 19 source columns. ```columns table=stripe.refunds id string pk Source field `id`. amount integer Source field `amount`. created_at datetime Source field `createdAt`. charge_id string Source field `chargeId`. currency string Source field `currency`. description string Source field `description`. metadata json Source field `metadata`. payment_intent_id string Source field `paymentIntentId`. reason string Source field `reason`. status string Source field `status`. balance_transaction_id string Source field `balanceTransactionId`. destination_details json Source field `destinationDetails`. failure_balance_transaction_id string Source field `failureBalanceTransactionId`. failure_reason string Source field `failureReason`. instructions_email string Source field `instructionsEmail`. next_action json Source field `nextAction`. pending_reason string Source field `pendingReason`. receipt_number string Source field `receiptNumber`. refund_application_fee boolean Source field `refundApplicationFee`. ``` ## Deletes and history Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets `_deleted` so queries can choose whether to include history. Filter current-state queries with `where not _deleted`.