Почему суммы в 100 раз больше, чем в Stripe Dashboard?

Stripe отдаёт суммы в минимальных единицах валюты, и Renta загружает их без изменений: 1999 означает 19.99 в валюте с двумя знаками после запятой. Делите на 100 в своих запросах. Для валют без дробной части, таких как JPY, деление не нужно.

Попадают ли в таблицу изменения уже загруженных записей?

При инкрементальной загрузке нет. Renta отбирает записи по дате создания, поэтому запись загружается один раз, и её последующие изменения в хранилище не попадают. Если текущее состояние важнее скорости загрузки, создайте пайплайн без параметра Created Date : тогда каждый запуск перечитывает весь период и перезаписывает таблицу.

Можно ли выгрузить данные тестового режима?

Да. Пайплайн загружает данные того режима, к которому относится ключ: тестовый ключ выгружает тестовые записи, боевой ключ выгружает боевые. Поле Livemode показывает, из какого режима запись.

Как превратить поле Created в читаемую дату?

Временные метки Stripe приходят в Unix-секундах. В BigQuery используйте TIMESTAMP_SECONDS(created) . Параметр Created Date содержит готовую дату из того же поля.

Stripe

Renta выгружает данные Stripe в ваше хранилище: платежи, счета, подписки, клиентов, выплаты и другие объекты аккаунта.

Аутентификация

Renta подключается к Stripe по API-ключу: секретному ключу аккаунта или restricted-ключу. Ключ создаётся в Stripe Dashboard в разделе Developers > API keys и вставляется в форму подключения.

Для restricted-ключа выдайте право Read на каждый ресурс, который собираетесь выгружать. Право на чтение Customers нужно в любом случае: Renta проверяет ключ, читая список клиентов при сохранении подключения. Если ключ не может читать ресурс выбранного типа отчёта, запуск останавливается с ошибкой прав доступа.

Подключение источника Stripe

Откройте каталогStep 1

Перейдите в раздел Connections > Catalog в левом меню.
Откройте категорию Finance и нажмите карточку Stripe.

Карточка Stripe в категории Finance каталога Renta

Заполните форму подключенияStep 2

Source name.
Название подключения. Используется только в интерфейсе Renta.
API key.
Вставьте ваш секретный или restricted-ключ Stripe.

Страница добавления подключения Stripe с полями Source name и API key

Сохраните подключениеStep 3

Проверьте Source name.
Нажмите Save.

Перед сохранением Renta проверяет ключ на стороне Stripe, поэтому недействительный ключ или restricted-ключ без права на чтение Customers отклоняется прямо на этом шаге.

Настройка подключения Stripe с заполненным названием источника и кнопкой Save

Источник созданStep 4

Новый источник появляется в списке Sources со статусом Active. Теперь его можно использовать в пайплайнах.

Список источников с новым источником Stripe в статусе Active

Создание пайплайна Stripe

После подключения источника создайте пайплайн, чтобы выгружать данные Stripe в хранилище.

Выберите Stripe как источникStep 1

В левом меню нажмите New pipeline. На шаге Source выберите Stripe в списке Already connected и нажмите Next step.

Шаг выбора источника со Stripe в списке Already connected

Выберите подключение StripeStep 2

Выберите подключение Stripe, созданное ранее, и нажмите Next step. На карточке видны название подключения и дата его добавления.

Шаг выбора подключения Stripe с карточкой подключения и датой его создания

Выберите назначениеStep 3

На шаге Destination выберите ваше назначение (например, Google BigQuery) и нажмите Next step.

Шаг выбора назначения с Google BigQuery в списке Already connected

Выберите подключение назначенияStep 4

Выберите подключение, в которое нужно загружать данные, и нажмите Next step. На карточке видны датасет и проект, куда попадут данные.

Шаг выбора подключения Google BigQuery с идентификаторами датасета и проекта на карточке

Настройка пайплайна

На последнем шаге выберите тип отчёта, отметьте его поля и задайте диапазон дат и расписание.

Тип отчёта

Выберите, какой объект Stripe выгружает пайплайн. Один пайплайн загружает один тип отчёта.

Настройки пайплайна Stripe с открытым выпадающим списком Report Types

Тип отчёта	Описание
Balance Transactions	Все движения баланса Stripe: платежи, возвраты, переводы, выплаты и комиссии Stripe, с валовой суммой, комиссией и её разбивкой, а также чистой суммой. Суммы списаний отрицательные.
Charges	Платежи с суммой, статусом и валютой, данными карты и плательщика, оценкой риска, ссылками на чеки и идентификаторами клиента, счёта и платёжного намерения.
Coupons	Купоны на скидку: фиксированная сумма или процент, длительность, лимиты применения и срок действия.
Credit Notes	Кредитные ноты, выпущенные по счетам: итоги, причина, статус, кредитуемые строки и связанные возвраты.
Customers	Клиенты с email, именем, валютой, балансом аккаунта, признаком просрочки, настройками счетов и вашими метаданными.
Disputes	Оспоренные платежи с оспариваемой суммой, причиной, статусом и состоянием доказательств.
Invoice Line Items	Отдельные строки счетов: сумма, валюта, количество, расчётный период и идентификаторы цены и подписки.
Invoices	Счета с итогами, суммами к оплате, оплаченными и оставшимися, статусом, причиной выставления, способом оплаты и временными метками смены статусов.
Payment Intents	Платёжные намерения с суммой, статусом, доступными способами оплаты, причиной отмены и деталями последней ошибки платежа.
Payouts	Выплаты на банковский счёт или карту: сумма, валюта, статус, способ и дата поступления.
Plans	Тарифные планы устаревшей модели подписок: сумма, валюта, интервал списания и тип использования.
Prices	Цены ваших продуктов: сумма за единицу, валюта, схема тарификации и интервал повторения.
Products	Каталог продуктов: название, описание, признак активности, изображения и атрибуты.
Refunds	Возвраты с суммой, валютой, статусом, причиной и идентификаторами платежа и платёжного намерения.
Subscriptions	Подписки со статусом, расчётным периодом, датами пробного периода, деталями отмены и позициями подписки с привязанными ценами.

Параметры

Выберите поля Stripe, которые попадут в таблицу назначения.

Выбор параметров Stripe с вкладками Parameters и Selected и кнопкой Select All

Тип отчёта

Поиск

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Название	Имя в API	Описание
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 · Обязательный 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.

Имя колонки в таблице назначения указано под каждым полем. Select All отмечает полный набор, результат виден на вкладке Selected.

Набор доступных полей зависит от типа отчёта. По полю Created Date (готовой дате из временной метки создания) Renta партиционирует таблицу назначения, а инкрементальная загрузка работает только тогда, когда оно выбрано.

Stripe отдаёт денежные суммы в минимальных единицах валюты, и Renta загружает их без изменений: платёж на $19.99 приходит как 1999. Временные метки, такие как Created, приходят в Unix-секундах. Created Date остаётся единственной готовой колонкой с датой.

Поля, которые ссылаются на другой объект Stripe, содержат его идентификатор: поле Customer платежа хранит ID клиента. Чтобы получить атрибуты связанного объекта, создайте пайплайн для его типа отчёта и соедините таблицы по ID. Вложенные объекты приходят разложенными на отдельные колонки с префиксом родителя, например данные плательщика и способа оплаты у платежа.

Поля со списками значений загружаются вложенными записями.

Тип отчёта	Поля, которые загружаются вложенными записями
Balance Transactions	Fee Details
Credit Notes	Lines, Refunds
Invoices	Custom Fields
Subscriptions	Items

Поле Metadata, а также Fraud Details у платежей и Evidence Details у споров приходят строкой JSON. Ключи внутри Metadata те, что вы задали в Stripe, поэтому извлекайте их JSON-функциями вашего хранилища.

Имя таблицы

Назовите пайплайн и таблицу назначения.

Поля названия интеграции и имени таблицы Stripe со списком выбранных параметров выше

Integration name.
Название пайплайна. Используется только в интерфейсе Renta.
Table name.
Имя таблицы назначения. Можно оставить автоматически созданное имя или задать своё.

Диапазон дат

Задайте период, который покрывает пайплайн. Renta отбирает записи по дате их создания в Stripe.

Блок Date Range с полем Date start и выпадающим списком Date end со значением Today

Date start.
Первая дата периода.
Date end.
Последняя дата периода. Оставьте Today, чтобы конец периода сдвигался с каждым запуском.

Запуск загружает записи, созданные до начала дня запуска (UTC). Записи, созданные в течение дня, попадают в таблицу со следующим запуском.

Для Invoice Line Items период применяется к счетам: Renta загружает строки счетов, созданных внутри периода.

Расписание

Выберите, как часто запускается пайплайн.

Выбор типа расписания Stripe с отмеченным вариантом Daily

Тип расписания	Описание
Manual	Пайплайн запускается только вручную через интерфейс или по API.
Daily	Пайплайн запускается раз в день в указанное время.
Interval	Пайплайн запускается через заданные интервалы времени.
Cron Expression	Пайплайн запускается по расписанию, заданному cron-выражением.

Для расписания Daily укажите Update time (точное время запуска) и нажмите Create pipeline.

Выбор времени обновления и кнопка Create pipeline

Renta также поддерживает запуск по API и интеграцию с внешними оркестраторами, такими как Apache Airflow, Dagster и Prefect. Подробности в документации по расписаниям.

Новый пайплайн появляется в разделе Pipelines на вкладке ETL, где видны его запуски, прогресс и имя таблицы назначения.

Список пайплайнов с новой интеграцией Stripe в статусе Completed

Стратегия синхронизации

Как Renta синхронизирует тип отчёта Stripe, зависит от того, выбран ли параметр Created Date.

Стратегия	Поддерживаемые типы отчётов	Описание
Инкрементальное обновление	Balance Transactions, Charges, Coupons, Credit Notes, Customers, Disputes, Invoices, Payment Intents, Payouts, Plans, Prices, Products, Refunds, Subscriptions (с выбранным параметром Created Date)	Таблица назначения партиционируется по дню создания записи. Renta отбирает записи по дате создания, поэтому каждый запуск забирает записи, созданные после предыдущего, и заменяет только затронутые дневные партиции. Первый запуск загружает весь настроенный диапазон дат.
Полная перезагрузка	Invoice Line Items, а также перечисленные выше типы отчётов без выбранного параметра Created Date	Renta перечитывает весь настроенный диапазон дат на каждом запуске и заменяет содержимое таблицы назначения. У строк счетов нет собственной даты создания, поэтому этот тип отчёта всегда работает так.

Renta отбирает записи по дате создания, поэтому изменения уже загруженных записей в таблицу не попадают: платёж, чей статус поменялся после загрузки, сохраняет в хранилище старый статус. Если текущее состояние важнее скорости загрузки, создайте пайплайн без Created Date: тогда каждый запуск перечитывает весь период.

Renta укладывается в лимиты Stripe API, поэтому первый запуск по истории за несколько лет занимает заметно больше времени, чем ежедневные приросты. Invoice Line Items загружается медленнее всех: Stripe отдаёт строки счетов по одному счёту за раз.

Часто задаваемые вопросы

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.