Which Stripe API key should I use?

A restricted key with **Read** permission on the resources you plan to export is enough. Grant read access to Customers in any case, because Renta verifies the key by reading the customer list. The secret key of the account also works.

Why are the amounts 100 times larger than in the Stripe Dashboard?

Stripe reports amounts in the smallest currency unit, and Renta loads them as is: 1999 means 19.99 in a currency with two decimal places. Divide by 100 in your queries. Zero-decimal currencies such as JPY need no division.

Can I export test mode data?

Yes. The pipeline loads the data of the mode the key belongs to: a test key exports test records, a live key exports live ones. The Livemode field shows which mode a record comes from.

How do I convert the Created field into a readable date?

Stripe timestamps arrive as Unix seconds. In BigQuery, use TIMESTAMP_SECONDS(created) . The Created Date parameter is the ready-made date version of the same field.

Stripe

Renta exports Stripe data to your data warehouse: charges, invoices, subscriptions, customers, payouts, and other objects of your account.

Authentication

Renta connects to Stripe with an API key: either the secret key of your account or a restricted key. You create the key in the Stripe Dashboard under Developers > API keys and paste it into the connection form.

For a restricted key, grant Read permission to every resource you plan to export. Read access to Customers is required in any case: Renta verifies the key by reading the customer list when you save the connection. If the key cannot read the resource behind the selected report type, the run stops with a permission error.

Connect Stripe source

Go to the CatalogStep 1

Navigate to the Connections > Catalog section in the left sidebar.
Open the Finance category and click the Stripe card.

Stripe card in the Finance category of the Renta catalog

Fill in the connection formStep 2

Source name.
A display name for this connection. It is used exclusively in the Renta interface.
API key.
Paste your Stripe secret or restricted key.

Add a new Stripe connection page with the Source name and API key fields

Save the connectionStep 3

Check the Source name.
Click Save.

Renta verifies the key with Stripe before saving the connection, so an invalid key, or a restricted key without read access to Customers, fails right on this step.

Stripe connection setup with the source name filled in and the Save button

Source createdStep 4

The new source appears in the Sources list with the Active status. You can now use it in pipelines.

Sources list with the new Stripe source in the Active status

Create a Stripe pipeline

Once the source is connected, create a pipeline to sync your Stripe data into your destination.

Select Stripe as the sourceStep 1

In the left sidebar, click New pipeline. On the Source step, select Stripe under Already connected and click Next step.

Select a source step with Stripe under Already connected

Select your Stripe connectionStep 2

Choose the Stripe connection you created earlier and click Next step. The card shows the name of the connection and the date it was added.

Select your Stripe connection step with the connection card and its creation date

Select a destinationStep 3

On the Destination step, select your destination (for example, Google BigQuery) and click Next step.

Select a destination step with Google BigQuery under Already connected

Select the destination connectionStep 4

Choose the destination connection you want to load data into and click Next step. The card shows the dataset and project the data will land in.

Select your Google BigQuery connection step with the dataset and project identifiers on the card

Pipeline configuration

On the final step, choose the report type, pick its fields, and set the date range and the schedule.

Report type

Select which Stripe object the pipeline exports. One pipeline loads one report type.

Report type	Description
Balance Transactions	Every movement of your Stripe balance: charges, refunds, transfers, payouts, and Stripe fees, with the gross amount, the fee and its breakdown, and the net amount. Amounts of deductions are negative.
Charges	Payments with their amount, status, and currency, card and billing details, the risk outcome, receipt links, and the identifiers of the customer, invoice, and payment intent.
Coupons	Discount coupons: a fixed amount or a percent off, duration, redemption limits, and validity.
Credit Notes	Credit notes issued against invoices: totals, reason, status, the credited lines, and the linked refunds.
Customers	Customers with their email, name, currency, account balance, delinquency flag, invoice settings, and your metadata.
Disputes	Disputed charges with the contested amount, reason, status, and the state of the evidence.
Invoice Line Items	Individual lines of invoices: amount, currency, quantity, billing period, and the identifiers of the price and subscription.
Invoices	Invoices with their totals, the amounts due, paid, and remaining, status, billing reason, collection method, and the timestamps of status changes.
Payment Intents	Payment intents with their amount, status, available payment method types, cancellation reason, and the details of the last payment error.
Payouts	Payouts to your bank account or card: amount, currency, status, method, and arrival date.
Plans	Billing plans of the legacy subscription model: amount, currency, billing interval, and usage type.
Prices	Prices of your products: unit amount, currency, billing scheme, and the recurring interval.
Products	The product catalog: name, description, active flag, images, and attributes.
Refunds	Refunds with their amount, currency, status, reason, and the identifiers of the charge and payment intent.
Subscriptions	Subscriptions with their status, billing period, trial dates, cancellation details, and the subscription items with the attached prices.

Parameters

Select the Stripe fields to include in the destination table.

Report type

Name	API name	Description
ID text	`id`	Unique identifier for the balance transaction.
Status text	`status`	The transaction's current status (available, pending).
Type text	`type`	Transaction type (charge, refund, payout, stripe_fee, etc.).
Reporting Category text	`reporting_category`	Reporting category used for reconciliation (charge, fee, payout, etc.).
Balance Type text	`balance_type`	Balance type this transaction contributes to (payments, issuing, etc.).
Amount int	`amount`	Gross amount of the transaction in smallest currency unit (cents).
Net int	`net`	Net amount of the transaction in smallest currency unit (cents).
Fee int	`fee`	Fees (in cents) paid for this transaction.
Currency text	`currency`	Three-letter ISO currency code.
Description text	`description`	An arbitrary string attached to the transaction.
Exchange Rate float	`exchange_rate`	The exchange rate used if currency conversion occurred. Null if no conversion.
Source text	`source`	ID of the Stripe object this transaction is related to (charge, payout, etc.).
Available On int	`available_on`	Unix timestamp when the transaction funds will be available in your balance.
Created int	`created`	Unix timestamp when the transaction was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Fee Details structure	`fee_details`	Detailed breakdown of fees paid for this transaction.

Name	API name	Description
ID text	`id`	Unique identifier for the charge.
Status text	`status`	The status of the charge (succeeded, pending, failed).
Currency text	`currency`	Three-letter ISO currency code.
Amount int	`amount`	Amount intended to be collected in smallest currency unit (cents).
Amount Captured int	`amount_captured`	Amount in cents that was captured.
Amount Refunded int	`amount_refunded`	Amount in cents refunded.
Customer text	`customer`	ID of the customer this charge belongs to.
Invoice text	`invoice`	ID of the invoice this charge is for.
Payment Intent text	`payment_intent`	ID of the PaymentIntent associated with this charge.
Payment Method text	`payment_method`	ID of the payment method used for this charge.
Balance Transaction text	`balance_transaction`	ID of the balance transaction that describes the impact on your account balance.
Failure Balance Transaction text	`failure_balance_transaction`	ID of the balance transaction created when a charge fails.
Description text	`description`	An arbitrary string describing the charge.
Statement Descriptor text	`statement_descriptor`	Extra information about a charge for the customer's credit card statement.
Statement Descriptor Suffix text	`statement_descriptor_suffix`	Provides information about the charge that customers see on their statements.
Calculated Statement Descriptor text	`calculated_statement_descriptor`	The full statement descriptor that is passed to card networks.
Failure Code text	`failure_code`	Error code explaining reason for charge failure.
Failure Message text	`failure_message`	Message to user further explaining reason for charge failure.
Receipt Email text	`receipt_email`	Email address that the receipt for this charge was sent to.
Receipt Number text	`receipt_number`	Transaction ID for the charge returned by card networks.
Receipt URL text	`receipt_url`	URL to view the receipt for this charge.
Application text	`application`	ID of the Connect application that created the charge.
Application Fee text	`application_fee`	ID of the application fee object created for this charge.
Application Fee Amount int	`application_fee_amount`	Amount in cents of the application fee.
On Behalf Of text	`on_behalf_of`	The account on behalf of which the charge was made.
Transfer Group text	`transfer_group`	String for grouping all related transfers.
Captured bool	`captured`	Whether the charge has been fully captured.
Disputed bool	`disputed`	Whether the charge has been disputed.
Paid bool	`paid`	Whether the charge was paid.
Refunded bool	`refunded`	Whether the charge has been fully refunded.
Livemode bool	`livemode`	Whether the charge exists in live mode.
Created int	`created`	Unix timestamp when the charge was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Billing Details Address City text	`billing_details_address_city`	City from the billing address.
Billing Details Address Country text	`billing_details_address_country`	Country from the billing address (two-letter ISO code).
Billing Details Address Line1 text	`billing_details_address_line1`	Address line 1 from billing details.
Billing Details Address Line2 text	`billing_details_address_line2`	Address line 2 from billing details.
Billing Details Address Postal Code text	`billing_details_address_postal_code`	Postal code from billing address.
Billing Details Address State text	`billing_details_address_state`	State from billing address.
Billing Details Email text	`billing_details_email`	Email from billing details.
Billing Details Name text	`billing_details_name`	Name from billing details.
Billing Details Phone text	`billing_details_phone`	Phone number from billing details.
Outcome Network Status text	`outcome_network_status`	Possible values are approved_by_network, declined_by_network, not_sent_to_network, reversed_after_approval.
Outcome Reason text	`outcome_reason`	Reason for the outcome (e.g. do_not_honor, insufficient_funds, expired_card).
Outcome Risk Level text	`outcome_risk_level`	Stripe's evaluation of the riskiness of the charge (normal, elevated, highest).
Outcome Seller Message text	`outcome_seller_message`	Seller-facing explanation of the outcome.
Outcome Type text	`outcome_type`	The type of outcome (authorized, issuer_declined, blocked, etc.).
Payment Method Details Type text	`payment_method_details_type`	Type of payment method used (card, bank_transfer, etc.).
Payment Method Details Card Brand text	`payment_method_details_card_brand`	Card brand (visa, mastercard, amex, etc.).
Payment Method Details Card Country text	`payment_method_details_card_country`	Two-letter ISO country code of the card issuing country.
Payment Method Details Card Exp Month int	`payment_method_details_card_exp_month`	Card expiry month.
Payment Method Details Card Exp Year int	`payment_method_details_card_exp_year`	Card expiry year.
Payment Method Details Card Fingerprint text	`payment_method_details_card_fingerprint`	Uniquely identifies the card.
Payment Method Details Card Funding text	`payment_method_details_card_funding`	Card funding type (credit, debit, prepaid, unknown).
Payment Method Details Card Last4 text	`payment_method_details_card_last4`	Last four digits of the card number.
Payment Method Details Card Network text	`payment_method_details_card_network`	Identifies which network this charge was processed on.
Metadata json	`metadata`	Set of key-value pairs attached to the charge by the user.
Fraud Details json	`fraud_details`	Information on fraud assessments for the charge.

Name	API name	Description
ID text	`id`	Unique identifier for the coupon.
Name text	`name`	Human-readable name for the coupon.
Duration text	`duration`	Specifies how long the discount will be in effect (forever, once, repeating).
Duration In Months int	`duration_in_months`	Number of months the coupon applies when duration is repeating.
Valid bool	`valid`	Whether the coupon can be used.
Livemode bool	`livemode`	Whether the coupon exists in live mode.
Amount Off int	`amount_off`	Amount in smallest currency unit to subtract from an invoice total. Null if percent_off is set.
Currency text	`currency`	Three-letter ISO currency code (only when amount_off is set).
Percent Off float	`percent_off`	Percent discount applied when amount_off is not set.
Max Redemptions int	`max_redemptions`	Maximum number of times this coupon can be redeemed.
Times Redeemed int	`times_redeemed`	Number of times this coupon has been applied to a customer or order.
Redeem By int	`redeem_by`	Unix timestamp after which the coupon can no longer be redeemed.
Created int	`created`	Unix timestamp when the coupon was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Metadata json	`metadata`	Set of key-value pairs attached to the coupon by the user.

Name	API name	Description
ID text	`id`	Unique identifier for the credit note.
Status text	`status`	Status of the credit note (issued, void).
Type text	`type`	Type of the credit note (pre_payment, post_payment).
Number text	`number`	A unique number that identifies this credit note.
Customer text	`customer`	ID of the customer associated with this credit note.
Invoice text	`invoice`	ID of the invoice that this credit note is associated with.
Refund text	`refund`	ID of the refund associated with the credit note.
Memo text	`memo`	Customer-facing text that appears on the credit note PDF.
Reason text	`reason`	Reason for issuing this credit note (duplicate, fraudulent, order_change, product_unsatisfactory).
Currency text	`currency`	Three-letter ISO currency code.
Amount int	`amount`	Total credit note amount in smallest currency unit (cents).
Amount Shipping int	`amount_shipping`	Shipping amount credited in smallest currency unit (cents).
Discount Amount int	`discount_amount`	Total discount amount applied to the credit note.
Subtotal int	`subtotal`	Credit note subtotal in smallest currency unit (cents).
Subtotal Excluding Tax int	`subtotal_excluding_tax`	Credit note subtotal excluding tax in smallest currency unit (cents).
Total int	`total`	Credit note grand total in smallest currency unit (cents).
Total Excluding Tax int	`total_excluding_tax`	Credit note grand total excluding tax in smallest currency unit (cents).
Post Payment Amount int	`post_payment_amount`	Amount that was credited outside of Stripe after payment (cents).
Pre Payment Amount int	`pre_payment_amount`	Amount credited before payment (cents).
Out Of Band Amount int	`out_of_band_amount`	Amount credited outside of Stripe.
PDF text	`pdf`	The link to download the PDF of the credit note.
Livemode bool	`livemode`	Whether the credit note exists in live mode.
Effective At int	`effective_at`	Unix timestamp when the credit note became effective.
Voided At int	`voided_at`	Unix timestamp when the credit note was voided.
Created int	`created`	Unix timestamp when the credit note was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Metadata json	`metadata`	Set of key-value pairs attached to the credit note by the user.
Lines structure	`lines`	List of line items credited within this credit note.
Refunds structure	`refunds`	List of refunds linked to this credit note.

Name	API name	Description
ID text	`id`	Unique identifier for the customer.
Name text	`name`	The customer's full name or business name.
Email text	`email`	The customer's email address.
Phone text	`phone`	The customer's phone number.
Tax Exempt text	`tax_exempt`	Tax exemption status (none, exempt, reverse).
Description text	`description`	An arbitrary string attached to the customer.
Invoice Prefix text	`invoice_prefix`	Unique identifier used to generate invoice numbers for this customer.
Currency text	`currency`	Three-letter ISO currency code of the customer's default currency.
Default Currency text	`default_currency`	Customer's default currency for invoices and subscriptions.
Default Source text	`default_source`	ID of the default payment source attached to this customer.
Balance int	`balance`	Customer's current balance, in smallest currency unit (cents).
Delinquent bool	`delinquent`	Whether the latest invoice from this customer has been paid.
Livemode bool	`livemode`	Whether the customer exists in live mode.
Invoice Settings Default Payment Method text	`invoice_settings_default_payment_method`	ID of the default payment method used for invoices.
Invoice Settings Footer text	`invoice_settings_footer`	Default footer to be displayed on invoices for this customer.
Created int	`created`	Unix timestamp when the customer was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Metadata json	`metadata`	Set of key-value pairs attached to the customer by the user.
Preferred Locales array_string	`preferred_locales`	Customer's preferred languages, ordered by preference.

Name	API name	Description
ID text	`id`	Unique identifier for the dispute.
Status text	`status`	Current status of the dispute (warning_needs_response, needs_response, under_review, charge_refunded, won, lost).
Reason text	`reason`	Reason given by cardholder for dispute (duplicate, fraudulent, subscription_canceled, etc.).
Currency text	`currency`	Three-letter ISO currency code.
Charge text	`charge`	ID of the charge that was disputed.
Payment Intent text	`payment_intent`	ID of the PaymentIntent that was disputed.
Amount int	`amount`	Disputed amount in smallest currency unit (cents).
Is Charge Refundable bool	`is_charge_refundable`	Whether it is still possible to refund the disputed payment.
Livemode bool	`livemode`	Whether the dispute exists in live mode.
Created int	`created`	Unix timestamp when the dispute was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Evidence Details json	`evidence_details`	Evidence details about the dispute (due date, submission count, etc.).
Metadata json	`metadata`	Set of key-value pairs attached to the dispute by the user.

Name	API name	Description
ID text	`id`	Unique identifier for the invoice line item.
Type text	`type`	Type of line item (invoiceitem, subscription).
Currency text	`currency`	Three-letter ISO currency code.
Invoice text	`invoice`	ID of the invoice this line item belongs to.
Subscription text	`subscription`	ID of the subscription that the invoice item pertains to.
Subscription Item text	`subscription_item`	ID of the subscription item associated with this invoice line item.
Description text	`description`	An arbitrary string attached to the line item.
Amount int	`amount`	Amount of the charge in smallest currency unit (cents).
Quantity int	`quantity`	The quantity of the subscription or invoice item.
Discountable bool	`discountable`	Whether discounts apply to this line item.
Proration bool	`proration`	Whether this is a proration.
Livemode bool	`livemode`	Whether the line item exists in live mode.
Price ID text	`price_id`	ID of the price used for this line item.
Price Currency text	`price_currency`	Currency of the price used for this line item.
Price Unit Amount int	`price_unit_amount`	Unit amount of the price in smallest currency unit (cents).
Price Type text	`price_type`	Type of the price (one_time, recurring).
Period Start int	`period_start`	Start of the period this line item covers (Unix timestamp).
Period End int	`period_end`	End of the period this line item covers (Unix timestamp).
Metadata json	`metadata`	Set of key-value pairs attached to the line item by the user.

Name	API name	Description
ID text	`id`	Unique identifier for the invoice.
Status text	`status`	The status of the invoice (draft, open, paid, void, uncollectible).
Number text	`number`	A unique, identifying string that appears on emails sent to the customer.
Collection Method text	`collection_method`	Either charge_automatically or send_invoice.
Billing Reason text	`billing_reason`	Indicates the reason why the invoice was created (subscription, manual, etc.).
Currency text	`currency`	Three-letter ISO currency code.
Customer text	`customer`	ID of the customer who will be billed.
Subscription text	`subscription`	ID of the subscription that the invoice was prepared for.
Charge text	`charge`	ID of the latest charge generated for this invoice.
Payment Intent text	`payment_intent`	ID of the PaymentIntent associated with this invoice.
Default Payment Method text	`default_payment_method`	ID of the default payment method for the invoice.
Account Country text	`account_country`	The country of the business associated with this invoice.
Account Name text	`account_name`	The business name associated with this invoice.
Customer Email text	`customer_email`	The customer's email address.
Customer Name text	`customer_name`	The customer's name.
Customer Phone text	`customer_phone`	The customer's phone number.
Customer Tax Exempt text	`customer_tax_exempt`	The customer's tax exemption status (none, exempt, reverse).
Description text	`description`	An arbitrary string attached to the invoice.
Statement Descriptor text	`statement_descriptor`	Extra information about the invoice for the customer's credit card statement.
Receipt Number text	`receipt_number`	Transaction ID for the invoice payment.
Hosted Invoice URL text	`hosted_invoice_url`	URL for the hosted invoice page.
Invoice PDF text	`invoice_pdf`	URL for the invoice PDF.
Footer text	`footer`	Footer displayed on the invoice.
Amount Due int	`amount_due`	Final amount due at this time for this invoice in cents.
Amount Paid int	`amount_paid`	Amount paid on the invoice in cents.
Amount Remaining int	`amount_remaining`	Amount remaining due on the invoice in cents.
Amount Shipping int	`amount_shipping`	Amount allocated to cover shipping in cents.
Amount Overpaid int	`amount_overpaid`	Amount overpaid on the invoice in cents.
Subtotal int	`subtotal`	Total of all invoice line items in cents.
Subtotal Excluding Tax int	`subtotal_excluding_tax`	Subtotal before tax in cents.
Total int	`total`	Total after discounts and taxes in cents.
Total Excluding Tax int	`total_excluding_tax`	Total excluding tax in cents.
Tax int	`tax`	Amount of tax applied to the invoice in cents.
Starting Balance int	`starting_balance`	Starting customer balance before the invoice is finalized in cents.
Ending Balance int	`ending_balance`	Ending customer balance after the invoice is finalized in cents.
Application Fee Amount int	`application_fee_amount`	Application fee amount in cents.
Pre Payment Credit Notes Amount int	`pre_payment_credit_notes_amount`	Amount of credit notes applied before payment in cents.
Post Payment Credit Notes Amount int	`post_payment_credit_notes_amount`	Amount of credit notes applied after payment in cents.
Attempt Count int	`attempt_count`	Number of payment attempts made for this invoice.
Attempted bool	`attempted`	Whether an attempt has been made to pay the invoice.
Auto Advance bool	`auto_advance`	Whether Stripe will perform automatic collection of the invoice.
Paid bool	`paid`	Whether the invoice has been paid.
Paid Out Of Band bool	`paid_out_of_band`	Whether the invoice was paid outside of Stripe.
Livemode bool	`livemode`	Whether the invoice exists in live mode.
Automatic Tax Enabled bool	`automatic_tax_enabled`	Whether automatic tax calculation is enabled.
Automatic Tax Status text	`automatic_tax_status`	Status of automatic tax calculation (complete, failed, requires_location_inputs).
Status Transitions Finalized At int	`status_transitions_finalized_at`	Unix timestamp when the invoice was finalized.
Status Transitions Marked Uncollectible At int	`status_transitions_marked_uncollectible_at`	Unix timestamp when the invoice was marked uncollectible.
Status Transitions Paid At int	`status_transitions_paid_at`	Unix timestamp when the invoice was paid.
Status Transitions Voided At int	`status_transitions_voided_at`	Unix timestamp when the invoice was voided.
Due Date int	`due_date`	Unix timestamp on which payment for this invoice is due.
Effective At int	`effective_at`	Unix timestamp when the invoice became effective.
Next Payment Attempt int	`next_payment_attempt`	Unix timestamp of next payment attempt.
Webhooks Delivered At int	`webhooks_delivered_at`	Unix timestamp when webhooks for this invoice were successfully delivered.
Period Start int	`period_start`	Start of the usage period during which invoice items were added (Unix timestamp).
Period End int	`period_end`	End of the usage period during which invoice items were added (Unix timestamp).
Created int	`created`	Unix timestamp when the invoice was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Metadata json	`metadata`	Set of key-value pairs attached to the invoice by the user.
Custom Fields structure	`custom_fields`	Custom fields attached to the invoice.

Name	API name	Description
ID text	`id`	Unique identifier for the payment intent.
Status text	`status`	Status of the PaymentIntent (requires_payment_method, requires_confirmation, requires_action, processing, succeeded, canceled).
Currency text	`currency`	Three-letter ISO currency code.
Capture Method text	`capture_method`	Controls when the funds will be captured (automatic, manual).
Confirmation Method text	`confirmation_method`	Confirmation method (automatic, manual).
Cancellation Reason text	`cancellation_reason`	Reason for cancellation (duplicate, fraudulent, requested_by_customer, abandoned, failed_invoice).
Setup Future Usage text	`setup_future_usage`	Indicates usage of the payment method after this payment (on_session, off_session).
Statement Descriptor text	`statement_descriptor`	Statement descriptor for the payment.
Statement Descriptor Suffix text	`statement_descriptor_suffix`	Suffix appended to the statement descriptor.
Description text	`description`	An arbitrary string attached to the PaymentIntent.
Receipt Email text	`receipt_email`	Email address that the receipt was sent to.
Customer text	`customer`	ID of the customer this PaymentIntent belongs to.
Invoice text	`invoice`	ID of the invoice that created this PaymentIntent.
Payment Method text	`payment_method`	ID of the payment method used to pay this PaymentIntent.
Latest Charge text	`latest_charge`	ID of the latest charge created by this PaymentIntent.
Application text	`application`	ID of the Connect application that created the PaymentIntent.
Application Fee Amount int	`application_fee_amount`	Amount of the application fee in cents.
Transfer Group text	`transfer_group`	Identifies the group of transfers associated with this PaymentIntent.
On Behalf Of text	`on_behalf_of`	The account on behalf of which the charge is made.
Amount int	`amount`	Amount intended to be collected in smallest currency unit (cents).
Amount Capturable int	`amount_capturable`	Amount that can be captured in cents.
Amount Received int	`amount_received`	Amount that was collected in cents.
Livemode bool	`livemode`	Whether the PaymentIntent exists in live mode.
Canceled At int	`canceled_at`	Unix timestamp when the PaymentIntent was canceled.
Created int	`created`	Unix timestamp when the PaymentIntent was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Last Payment Error Code text	`last_payment_error_code`	Error code of the last payment error.
Last Payment Error Type text	`last_payment_error_type`	Type of the last payment error (api_error, card_error, etc.).
Last Payment Error Message text	`last_payment_error_message`	Human-readable message of the last payment error.
Payment Method Types array_string	`payment_method_types`	List of payment method types that this PaymentIntent is allowed to use.
Metadata json	`metadata`	Set of key-value pairs attached to the PaymentIntent by the user.

Name	API name	Description
ID text	`id`	Unique identifier for the payout.
Status text	`status`	Current status of the payout (paid, pending, in_transit, canceled, failed).
Type text	`type`	Can be bank_account or card.
Method text	`method`	The method used to send this payout (standard, instant).
Source Type text	`source_type`	Balance transaction source type (card, bank_account).
Reconciliation Status text	`reconciliation_status`	Reconciliation status (not_applicable, in_progress, completed).
Currency text	`currency`	Three-letter ISO currency code.
Description text	`description`	An arbitrary string attached to the payout.
Statement Descriptor text	`statement_descriptor`	Extra information about the payout that appears on the user's bank statement.
Failure Code text	`failure_code`	Error code explaining why the payout failed.
Failure_message text	`failure_message`	Message explaining why the payout failed.
Destination text	`destination`	ID of the bank account or card the payout was sent to.
Balance Transaction text	`balance_transaction`	ID of the balance transaction that describes the impact on your account balance.
Failure Balance Transaction text	`failure_balance_transaction`	ID of the balance transaction created when a payout fails.
Original Payout text	`original_payout`	ID of the original payout (set when a payout is reversed).
Reversed By text	`reversed_by`	ID of the payout that reverses this payout.
Amount int	`amount`	Amount (in cents) to be transferred to your bank account or debit card.
Application Fee int	`application_fee`	Amount of the application fee in cents.
Application Fee Amount int	`application_fee_amount`	Amount of the application fee in cents.
Automatic bool	`automatic`	Whether the payout is an automatic Stripe payout.
Livemode bool	`livemode`	Whether the payout exists in live mode.
Arrival Date int	`arrival_date`	Unix timestamp when the payout is expected to arrive in the bank.
Created int	`created`	Unix timestamp when the payout was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Trace ID Status text	`trace_id_status`	Status of the trace ID for the payout.
Trace ID Value text	`trace_id_value`	Trace ID value assigned by the bank.
Metadata json	`metadata`	Set of key-value pairs attached to the payout by the user.

Name	API name	Description
ID text	`id`	Unique identifier for the plan (same as price ID in newer Stripe API).
Nickname text	`nickname`	A brief description of the plan, hidden from customers.
Billing Scheme text	`billing_scheme`	Describes how to compute the price per period (per_unit, tiered).
Interval text	`interval`	Frequency at which a subscription is billed (day, week, month, year).
Interval Count int	`interval_count`	Number of intervals between subscription billings.
Usage Type text	`usage_type`	Configures how the quantity per period should be determined (metered, licensed).
Aggregate Usage text	`aggregate_usage`	Specifies a usage aggregation strategy for metered plans (sum, last_during_period, last_ever, max).
Tiers Mode text	`tiers_mode`	Defines if the tiering price should be graduated or volume (graduated, volume).
Currency text	`currency`	Three-letter ISO currency code.
Product text	`product`	ID of the product the plan belongs to.
Meter text	`meter`	The meter tracking usage for this plan.
Amount int	`amount`	Per unit amount in smallest currency unit (cents).
Amount Decimal text	`amount_decimal`	Per unit amount in string decimal form.
Trial Period Days int	`trial_period_days`	Default number of trial days attached to plans.
Active bool	`active`	Whether the plan can be used for new purchases.
Livemode bool	`livemode`	Whether the plan exists in live mode.
Created int	`created`	Unix timestamp when the plan was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Metadata json	`metadata`	Set of key-value pairs attached to the plan by the user.

Name	API name	Description
ID text	`id`	Unique identifier for the price.
Type text	`type`	Whether the price is one_time or recurring.
Billing Scheme text	`billing_scheme`	Describes how to compute the price per period (per_unit, tiered).
Tax Behavior text	`tax_behavior`	Specifies whether the price is considered inclusive of taxes (inclusive, exclusive, unspecified).
Tiers Mode text	`tiers_mode`	Defines if the tiering price should be graduated or volume.
Nickname text	`nickname`	A brief description of the price, hidden from customers.
Lookup Key text	`lookup_key`	A lookup key used to retrieve prices dynamically from a static string.
Currency text	`currency`	Three-letter ISO currency code.
Product text	`product`	ID of the product this price is for.
Unit Amount int	`unit_amount`	Unit amount in smallest currency unit (cents).
Unit Amount Decimal text	`unit_amount_decimal`	String representation of unit amount for fractional cents.
Active bool	`active`	Whether the price can be used for new purchases.
Livemode bool	`livemode`	Whether the price exists in live mode.
Created int	`created`	Unix timestamp when the price was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Metadata json	`metadata`	Set of key-value pairs attached to the price by the user.

Name	API name	Description
ID text	`id`	Unique identifier for the product.
Name text	`name`	The product's name.
Type text	`type`	The type of the product (service, good).
Active bool	`active`	Whether the product is currently available for purchase.
Livemode bool	`livemode`	Whether the product exists in live mode.
Description text	`description`	The product's description.
Statement Descriptor text	`statement_descriptor`	Extra information about the product, shown on customer statements.
Unit Label text	`unit_label`	Label that represents units of this product in Stripe and on customers' receipts.
Tax Code text	`tax_code`	Tax code designating the product's tax category.
Default Price text	`default_price`	ID of the default price for this product.
Shippable bool	`shippable`	Whether the product is shipped (physical goods).
URL text	`url`	URL of a publicly-accessible webpage for this product.
Created int	`created`	Unix timestamp when the product was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Updated int	`updated`	Unix timestamp when the product was last updated.
Metadata json	`metadata`	Set of key-value pairs attached to the product by the user.
Images array_string	`images`	List of image URLs for this product.
Attributes array_string	`attributes`	List of attribute names that each SKU can provide values for.

Name	API name	Description
ID text	`id`	Unique identifier for the refund.
Status text	`status`	Status of the refund (pending, succeeded, failed, canceled).
Reason text	`reason`	Reason for the refund (duplicate, fraudulent, requested_by_customer, expired_uncaptured_charge).
Currency text	`currency`	Three-letter ISO currency code.
Charge text	`charge`	ID of the charge that was refunded.
Payment Intent text	`payment_intent`	ID of the PaymentIntent that was refunded.
Balance Transaction text	`balance_transaction`	ID of the balance transaction that describes the impact on your account balance.
Source Transfer Reversal text	`source_transfer_reversal`	ID of the transfer reversal if charge was made using connected account.
Transfer Reversal text	`transfer_reversal`	ID of the transfer reversal associated with this refund.
Receipt Number text	`receipt_number`	Transaction ID returned by card networks for this refund.
Amount int	`amount`	Amount refunded in smallest currency unit (cents).
Created int	`created`	Unix timestamp when the refund was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Destination Details Type text	`destination_details_type`	Type of destination for refund details (card, bank_transfer, etc.).
Destination Details Card Reference text	`destination_details_card_reference`	Reference issued by the card network for the refund.
Destination Details Card Reference Status text	`destination_details_card_reference_status`	Status of the card reference (available, pending, unavailable).
Destination Details Card Reference Type text	`destination_details_card_reference_type`	Type of card reference (acquirer_reference_number, etc.).
Destination Details Card Type text	`destination_details_card_type`	Type of card refund (refund, reversal).
Metadata json	`metadata`	Set of key-value pairs attached to the refund by the user.

Name	API name	Description
ID text	`id`	Unique identifier for the subscription.
Status text	`status`	Subscription status (active, past_due, unpaid, canceled, incomplete, incomplete_expired, trialing, paused).
Collection Method text	`collection_method`	Either charge_automatically or send_invoice.
Currency text	`currency`	Three-letter ISO currency code.
Customer text	`customer`	ID of the customer who owns the subscription.
Default Payment Method text	`default_payment_method`	ID of the default payment method for the subscription.
Latest Invoice text	`latest_invoice`	ID of the most recent invoice generated for this subscription.
Description text	`description`	Description of the subscription.
Cancel At Period End bool	`cancel_at_period_end`	Whether the subscription will be canceled at the end of the current period.
Livemode bool	`livemode`	Whether the subscription exists in live mode.
Quantity int	`quantity`	Quantity of the plan the customer should be subscribed to.
Plan ID text	`plan_id`	ID of the plan the customer is subscribed to (if single plan).
Plan Amount int	`plan_amount`	Per unit amount in smallest currency unit (cents) of the plan.
Plan Currency text	`plan_currency`	Currency of the plan.
Plan Interval text	`plan_interval`	Billing interval of the plan (day, week, month, year).
Current Period Start int	`current_period_start`	Unix timestamp of the start of the current billing period.
Current Period End int	`current_period_end`	Unix timestamp of the end of the current billing period.
Trial Start int	`trial_start`	Unix timestamp when the trial started.
Trial End int	`trial_end`	Unix timestamp when the trial ends.
Canceled At int	`canceled_at`	Unix timestamp when the subscription was canceled.
Ended At int	`ended_at`	Unix timestamp when the subscription ended.
Created int	`created`	Unix timestamp when the subscription was created.
Created Date · Required date	`created_date`	Creation date derived from unix timestamp (created). Used as partition key.
Metadata json	`metadata`	Set of key-value pairs attached to the subscription by the user.
Items structure	`items`	List of subscription items, each with an attached plan and price.

Each field lists its destination column name right under it. Select All checks the full set, and the Selected tab shows the result.

The set of available fields depends on the report type. Created Date is a date column that Renta derives from the creation timestamp: the destination table is partitioned by it, and incremental loading works only when it is selected.

Stripe reports monetary amounts in the smallest currency unit, and Renta loads them as is: a charge of $19.99 arrives as 1999. Timestamps such as Created arrive as Unix seconds. Created Date is the only ready-made date column.

Fields that reference another Stripe object hold its identifier: the Customer field of a charge is the customer ID. To get the attributes of the related object, create a pipeline for its report type and join the tables by ID. Nested objects arrive flattened into separate columns prefixed with the parent name, such as the billing details and payment method details of a charge.

Fields that hold a list of values load as nested records.

Report type	Fields that load as nested records
Balance Transactions	Fee Details
Credit Notes	Lines, Refunds
Invoices	Custom Fields
Subscriptions	Items

The Metadata field, along with Fraud Details on charges and Evidence Details on disputes, arrives as a JSON string. The keys inside Metadata are the ones you set in Stripe, so extract them with the JSON functions of your warehouse.

Table name

Name the pipeline and the destination table.

Integration name.
The name of the pipeline. It is used exclusively in the Renta interface.
Table name.
The destination table name. You can keep the auto-generated name or enter your own.

Date range

Set the period the pipeline covers. Renta selects records by their creation date in Stripe.

Date start.
The first date of the period.
Date end.
The last date of the period. Keep Today so that the end of the period advances with every run.

A run loads the records created before the start of the run day (UTC). Records created during the day arrive with the next run.

For Invoice Line Items, the period applies to the invoices: Renta loads the lines of the invoices created within the period.

Schedule

Choose how often the pipeline runs.

Schedule type	Description
Manual	The pipeline runs only when triggered manually through the interface or via API.
Daily	The pipeline runs once a day at the specified update time.
Interval	The pipeline runs at specified time intervals.
Cron Expression	The pipeline runs on a schedule defined by a cron expression.

For Daily schedules, set the Update time, the exact time each run starts, then click Create pipeline.

Update time selection and the Create pipeline button

Renta also supports API triggers and integration with external orchestrators such as Apache Airflow, Dagster, and Prefect. See the full scheduling documentation for details.

The new pipeline appears in the Pipelines section under the ETL tab, where you can track its runs, progress, and the destination table name.

Pipelines list with the new Stripe integration in the Completed status

Sync strategy

How Renta synchronizes a Stripe report type depends on whether the Created Date parameter is selected.

Strategy	Supported report types	Description
Incremental	Balance Transactions, Charges, Coupons, Credit Notes, Customers, Disputes, Invoices, Payment Intents, Payouts, Plans, Prices, Products, Refunds, Subscriptions (with the Created Date parameter selected)	The destination table is partitioned by the day of record creation. Renta selects records by creation date, so each run picks up the records created since the previous run and replaces only the daily partitions it touches. The first run loads the whole configured date range.
Full reload	Invoice Line Items, and the report types above when the Created Date parameter is not selected	Renta reads the entire configured date range on every run and replaces the contents of the destination table. Invoice line items carry no creation date of their own, so this report type always works this way.

Because Renta selects records by creation date, changes to already loaded records stay out of the table: a charge whose status changed after it was loaded keeps the old status in the warehouse. If the current state matters more than loading speed, create the pipeline without Created Date: every run then re-reads the whole period.

Renta keeps within the Stripe API rate limits, so the first run over several years of history takes noticeably longer than the daily increments. Invoice Line Items is the slowest report type, because Stripe returns line items invoice by invoice.

Frequently asked questions

Ready to get started?

Build your data pipeline today or get a personalized demo. Start free!

Need help?

Get expert support to ensure your project succeeds. We're here to help!

Feature requests?

Help shape our product! Share your ideas for new features and integrations.