Supernova home
Documentation menu

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 _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

balance_transactions#

titan.stripe.balance_transactions has 14 source columns.

stripe.balance_transactions14 columns
idstringpk

Source field id.

amountinteger

Source field amount.

available_ondatetime

Source field availableOn.

created_atdatetime

Source field createdAt.

currencystring

Source field currency.

descriptionstring

Source field description.

exchange_ratefloat

Source field exchangeRate.

feeinteger

Source field fee.

fee_detailsjson

Source field feeDetails.

netinteger

Source field net.

reporting_categorystring

Source field reportingCategory.

statusstring

Source field status.

typestring

Source field type.

sourcestring

Source field source.

coupons#

titan.stripe.coupons has 16 source columns.

stripe.coupons16 columns
idstringpk

Source field id.

created_atdatetime

Source field createdAt.

amount_offinteger

Source field amountOff.

currencystring

Source field currency.

durationstring

Source field duration.

duration_in_monthsinteger

Source field durationInMonths.

metadatajson

Source field metadata.

namestring

Source field name.

percent_offfloat

Source field percentOff.

applies_tojson

Source field appliesTo.

currency_optionsjson

Source field currencyOptions.

livemodeboolean

Source field livemode.

max_redemptionsinteger

Source field maxRedemptions.

redeem_bydatetime

Source field redeemBy.

times_redeemedinteger

Source field timesRedeemed.

validboolean

Source field valid.

customers#

titan.stripe.customers has 26 source columns.

stripe.customers26 columns
idstringpk

Source field id.

created_atdatetime

Source field createdAt.

addressjson

Source field address.

descriptionstring

Source field description.

emailstring

Source field email.

metadatajson

Source field metadata.

namestring

Source field name.

phonestring

Source field phone.

shippingjson

Source field shipping.

taxjson

Source field tax.

balanceinteger

Source field balance.

cash_balancejson

Source field cashBalance.

currencystring

Source field currency.

default_sourcestring

Source field defaultSource.

delinquentboolean

Source field delinquent.

discountjson

Source field discount.

invoice_credit_balancejson

Source field invoiceCreditBalance.

invoice_prefixstring

Source field invoicePrefix.

invoice_settingsjson

Source field invoiceSettings.

livemodeboolean

Source field livemode.

next_invoice_sequenceinteger

Source field nextInvoiceSequence.

preferred_localesjson

Source field preferredLocales.

sourcesjson

Source field sources.

tax_exemptstring

Source field taxExempt.

tax_idsjson

Source field taxIds.

test_clockstring

Source field testClock.

customer_balance_transactions#

titan.stripe.customer_balance_transactions has 13 source columns.

stripe.customer_balance_transactions13 columns
idstringpk

Source field id.

customer_idstring

Source field customerId.

amountinteger

Source field amount.

currencystring

Source field currency.

descriptionstring

Source field description.

ending_balanceinteger

Source field endingBalance.

metadatajson

Source field metadata.

typestring

Source field type.

checkout_session_idstring

Source field checkoutSessionId.

created_atdatetime

Source field createdAt.

credit_note_idstring

Source field creditNoteId.

invoice_idstring

Source field invoiceId.

livemodeboolean

Source field livemode.

invoices#

titan.stripe.invoices has 70 source columns.

stripe.invoices70 columns
idstringpk

Source field id.

customer_idstring

Source field customerId.

created_atdatetime

Source field createdAt.

auto_advanceboolean

Source field autoAdvance.

automatic_taxjson

Source field automaticTax.

collection_methodstring

Source field collectionMethod.

currencystring

Source field currency.

descriptionstring

Source field description.

hosted_invoice_urlstring

Source field hostedInvoiceUrl.

metadatajson

Source field metadata.

parentjson

Source field parent.

period_startdatetime

Source field periodStart.

period_enddatetime

Source field periodEnd.

statusstring

Source field status.

totalinteger

Source field total.

account_countrystring

Source field accountCountry.

account_namestring

Source field accountName.

account_tax_idsjson

Source field accountTaxIds.

amount_dueinteger

Source field amountDue.

amount_overpaidinteger

Source field amountOverpaid.

amount_paidinteger

Source field amountPaid.

amount_remaininginteger

Source field amountRemaining.

amount_shippinginteger

Source field amountShipping.

attempt_countinteger

Source field attemptCount.

attemptedboolean

Source field attempted.

automatically_finalizes_atdatetime

Source field automaticallyFinalizesAt.

billing_reasonstring

Source field billingReason.

custom_fieldsjson

Source field customFields.

customer_addressjson

Source field customerAddress.

customer_emailstring

Source field customerEmail.

customer_namestring

Source field customerName.

customer_phonestring

Source field customerPhone.

customer_shippingjson

Source field customerShipping.

customer_tax_exemptstring

Source field customerTaxExempt.

customer_tax_idsjson

Source field customerTaxIds.

default_payment_methodstring

Source field defaultPaymentMethod.

default_sourcestring

Source field defaultSource.

default_tax_ratesjson

Source field defaultTaxRates.

discountsjson

Source field discounts.

due_datedatetime

Source field dueDate.

effective_atdatetime

Source field effectiveAt.

ending_balanceinteger

Source field endingBalance.

from_invoicejson

Source field fromInvoice.

invoice_pdfstring

Source field invoicePdf.

last_finalization_errorjson

Source field lastFinalizationError.

latest_revisionstring

Source field latestRevision.

livemodeboolean

Source field livemode.

next_payment_attemptdatetime

Source field nextPaymentAttempt.

numberstring

Source field number.

payment_settingsjson

Source field paymentSettings.

paymentsjson

Source field payments.

post_payment_credit_notes_amountinteger

Source field postPaymentCreditNotesAmount.

pre_payment_credit_notes_amountinteger

Source field prePaymentCreditNotesAmount.

receipt_numberstring

Source field receiptNumber.

renderingjson

Source field rendering.

shipping_costjson

Source field shippingCost.

shipping_detailsjson

Source field shippingDetails.

starting_balanceinteger

Source field startingBalance.

statement_descriptorstring

Source field statementDescriptor.

status_transitionsjson

Source field statusTransitions.

subtotalinteger

Source field subtotal.

subtotal_excluding_taxinteger

Source field subtotalExcludingTax.

test_clockstring

Source field testClock.

threshold_reasonjson

Source field thresholdReason.

total_discount_amountsjson

Source field totalDiscountAmounts.

total_excluding_taxinteger

Source field totalExcludingTax.

total_pretax_credit_amountsjson

Source field totalPretaxCreditAmounts.

total_taxesjson

Source field totalTaxes.

webhooks_delivered_atdatetime

Source field webhooksDeliveredAt.

invoice_discounts#

titan.stripe.invoice_discounts has 9 source columns.

stripe.invoice_discounts9 columns
idstringpk

Source field id.

invoice_idstringpk

Source field invoiceId.

invoice_item_idstring

Source field invoiceItemId.

customer_idstring

Source field customerId.

subscription_idstring

Source field subscriptionId.

couponjson

Source field coupon.

startdatetime

Source field start.

enddatetime

Source field end.

checkout_sessionstring

Source field checkoutSession.

invoice_items#

titan.stripe.invoice_items has 21 source columns.

stripe.invoice_items21 columns
idstringpk

Source field id.

invoice_idstring

Source field invoiceId.

customer_idstring

Source field customerId.

subscription_idstring

Source field subscriptionId.

created_atdatetime

Source field createdAt.

amountinteger

Source field amount.

currencystring

Source field currency.

descriptionstring

Source field description.

metadatajson

Source field metadata.

parentjson

Source field parent.

period_startdatetime

Source field periodStart.

period_enddatetime

Source field periodEnd.

pricingjson

Source field pricing.

prorationboolean

Source field proration.

datedatetime

Source field date.

discountableboolean

Source field discountable.

discountsjson

Source field discounts.

livemodeboolean

Source field livemode.

quantityinteger

Source field quantity.

tax_ratesjson

Source field taxRates.

test_clockstring

Source field testClock.

invoice_line_items#

titan.stripe.invoice_line_items has 19 source columns.

stripe.invoice_line_items19 columns
idstringpk

Source field id.

invoice_idstring

Source field invoiceId.

amountinteger

Source field amount.

currencystring

Source field currency.

descriptionstring

Source field description.

metadatajson

Source field metadata.

parentjson

Source field parent.

period_startdatetime

Source field periodStart.

period_enddatetime

Source field periodEnd.

pricingjson

Source field pricing.

quantityinteger

Source field quantity.

discount_amountsjson

Source field discountAmounts.

discountableboolean

Source field discountable.

discountsjson

Source field discounts.

livemodeboolean

Source field livemode.

pretax_credit_amountsjson

Source field pretaxCreditAmounts.

taxesjson

Source field taxes.

unique_idstring

Source field uniqueId.

unique_line_item_idstring

Source field uniqueLineItemId.

events#

titan.stripe.events has 4 source columns.

stripe.events4 columns
idstringpk

Source field id.

typestring

Source field type.

datajson

Source field data.

created_atdatetime

Source field createdAt.

charges#

titan.stripe.charges has 36 source columns.

stripe.charges36 columns
idstringpk

Source field id.

created_atdatetime

Source field createdAt.

amountinteger

Source field amount.

balance_transaction_idstring

Source field balanceTransactionId.

customer_idstring

Source field customerId.

billing_detailsjson

Source field billingDetails.

currencystring

Source field currency.

descriptionstring

Source field description.

disputedboolean

Source field disputed.

metadatajson

Source field metadata.

payment_intent_idstring

Source field paymentIntentId.

payment_method_detailsjson

Source field paymentMethodDetails.

receipt_emailstring

Source field receiptEmail.

refundedboolean

Source field refunded.

shippingjson

Source field shipping.

statement_descriptorstring

Source field statementDescriptor.

statement_descriptor_suffixstring

Source field statementDescriptorSuffix.

statusstring

Source field status.

amount_capturedinteger

Source field amountCaptured.

amount_refundedinteger

Source field amountRefunded.

calculated_statement_descriptorstring

Source field calculatedStatementDescriptor.

capturedboolean

Source field captured.

failure_balance_transaction_idstring

Source field failureBalanceTransactionId.

failure_codestring

Source field failureCode.

failure_messagestring

Source field failureMessage.

fraud_detailsjson

Source field fraudDetails.

livemodeboolean

Source field livemode.

outcomejson

Source field outcome.

paidboolean

Source field paid.

payment_method_idstring

Source field paymentMethodId.

presentment_detailsjson

Source field presentmentDetails.

radar_optionsjson

Source field radarOptions.

receipt_numberstring

Source field receiptNumber.

receipt_urlstring

Source field receiptUrl.

refundsjson

Source field refunds.

reviewstring

Source field review.

payment_methods#

titan.stripe.payment_methods has 6 source columns.

stripe.payment_methods6 columns
idstringpk

Source field id.

customer_idstring

Source field customerId.

created_atdatetime

Source field createdAt.

billing_detailsjson

Source field billingDetails.

metadatajson

Source field metadata.

typestring

Source field type.

payment_intents#

titan.stripe.payment_intents has 29 source columns.

stripe.payment_intents29 columns
idstringpk

Source field id.

amountinteger

Source field amount.

currencystring

Source field currency.

created_atdatetime

Source field createdAt.

customer_idstring

Source field customerId.

descriptionstring

Source field description.

latest_chargestring

Source field latestCharge.

metadatajson

Source field metadata.

next_actionjson

Source field nextAction.

payment_method_idstring

Source field paymentMethodId.

receipt_emailstring

Source field receiptEmail.

setup_future_usagestring

Source field setupFutureUsage.

shippingjson

Source field shipping.

statement_descriptorstring

Source field statementDescriptor.

statement_descriptor_suffixstring

Source field statementDescriptorSuffix.

statusstring

Source field status.

amount_capturableinteger

Source field amountCapturable.

amount_detailsjson

Source field amountDetails.

amount_receivedinteger

Source field amountReceived.

canceled_atdatetime

Source field canceledAt.

cancellation_reasonstring

Source field cancellationReason.

capture_methodstring

Source field captureMethod.

confirmation_methodstring

Source field confirmationMethod.

livemodeboolean

Source field livemode.

payment_method_configuration_detailsjson

Source field paymentMethodConfigurationDetails.

payment_method_optionsjson

Source field paymentMethodOptions.

presentment_detailsjson

Source field presentmentDetails.

processingjson

Source field processing.

review_idstring

Source field reviewId.

subscriptions#

titan.stripe.subscriptions has 38 source columns.

stripe.subscriptions38 columns
idstringpk

Source field id.

automatic_taxjson

Source field automaticTax.

currencystring

Source field currency.

customer_idstring

Source field customerId.

created_atdatetime

Source field createdAt.

ended_atdatetime

Source field endedAt.

default_payment_methodstring

Source field defaultPaymentMethod.

descriptionstring

Source field description.

latest_invoicestring

Source field latestInvoice.

metadatajson

Source field metadata.

pending_setup_intentstring

Source field pendingSetupIntent.

pending_updatejson

Source field pendingUpdate.

statusstring

Source field status.

billing_cycle_anchordatetime

Source field billingCycleAnchor.

billing_cycle_anchor_configjson

Source field billingCycleAnchorConfig.

billing_modejson

Source field billingMode.

billing_thresholdsjson

Source field billingThresholds.

cancel_atdatetime

Source field cancelAt.

cancel_at_period_endboolean

Source field cancelAtPeriodEnd.

canceled_atdatetime

Source field canceledAt.

cancellation_detailsjson

Source field cancellationDetails.

collection_methodstring

Source field collectionMethod.

days_until_dueinteger

Source field daysUntilDue.

default_sourcestring

Source field defaultSource.

default_tax_ratesjson

Source field defaultTaxRates.

discountsjson

Source field discounts.

invoice_settingsjson

Source field invoiceSettings.

livemodeboolean

Source field livemode.

next_pending_invoice_item_invoicedatetime

Source field nextPendingInvoiceItemInvoice.

pause_collectionjson

Source field pauseCollection.

payment_settingsjson

Source field paymentSettings.

pending_invoice_item_intervaljson

Source field pendingInvoiceItemInterval.

schedulestring

Source field schedule.

start_datedatetime

Source field startDate.

test_clockstring

Source field testClock.

trial_enddatetime

Source field trialEnd.

trial_settingsjson

Source field trialSettings.

trial_startdatetime

Source field trialStart.

subscription_items#

titan.stripe.subscription_items has 11 source columns.

stripe.subscription_items11 columns
idstringpk

Source field id.

metadatajson

Source field metadata.

pricejson

Source field price.

quantityinteger

Source field quantity.

subscription_idstring

Source field subscriptionId.

created_atdatetime

Source field createdAt.

billing_thresholdsjson

Source field billingThresholds.

current_period_startdatetime

Source field currentPeriodStart.

current_period_enddatetime

Source field currentPeriodEnd.

discountsjson

Source field discounts.

tax_ratesjson

Source field taxRates.

plans#

titan.stripe.plans has 19 source columns.

stripe.plans19 columns
idstringpk

Source field id.

created_atdatetime

Source field createdAt.

activeboolean

Source field active.

currencystring

Source field currency.

intervalstring

Source field interval.

interval_countinteger

Source field intervalCount.

metadatajson

Source field metadata.

nicknamestring

Source field nickname.

product_idstring

Source field productId.

trial_period_daysinteger

Source field trialPeriodDays.

aggregate_usagestring

Source field aggregateUsage.

amount_decimalfloat

Source field amountDecimal.

billing_schemestring

Source field billingScheme.

livemodeboolean

Source field livemode.

meterstring

Source field meter.

tiersjson

Source field tiers.

tiers_modestring

Source field tiersMode.

transform_usagejson

Source field transformUsage.

usage_typestring

Source field usageType.

prices#

titan.stripe.prices has 20 source columns.

stripe.prices20 columns
idstringpk

Source field id.

created_atdatetime

Source field createdAt.

activeboolean

Source field active.

currencystring

Source field currency.

metadatajson

Source field metadata.

nicknamestring

Source field nickname.

product_idstring

Source field productId.

recurringjson

Source field recurring.

tax_behaviorstring

Source field taxBehavior.

typestring

Source field type.

unit_amountinteger

Source field unitAmount.

billing_schemestring

Source field billingScheme.

currency_optionsjson

Source field currencyOptions.

custom_unit_amountjson

Source field customUnitAmount.

livemodeboolean

Source field livemode.

lookup_keystring

Source field lookupKey.

tiersjson

Source field tiers.

tiers_modestring

Source field tiersMode.

transform_quantityjson

Source field transformQuantity.

unit_amount_decimalfloat

Source field unitAmountDecimal.

refunds#

titan.stripe.refunds has 19 source columns.

stripe.refunds19 columns
idstringpk

Source field id.

amountinteger

Source field amount.

created_atdatetime

Source field createdAt.

charge_idstring

Source field chargeId.

currencystring

Source field currency.

descriptionstring

Source field description.

metadatajson

Source field metadata.

payment_intent_idstring

Source field paymentIntentId.

reasonstring

Source field reason.

statusstring

Source field status.

balance_transaction_idstring

Source field balanceTransactionId.

destination_detailsjson

Source field destinationDetails.

failure_balance_transaction_idstring

Source field failureBalanceTransactionId.

failure_reasonstring

Source field failureReason.

instructions_emailstring

Source field instructionsEmail.

next_actionjson

Source field nextAction.

pending_reasonstring

Source field pendingReason.

receipt_numberstring

Source field receiptNumber.

refund_application_feeboolean

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.