# Cloud storage file organization Learn how your files are structured within cloud storage. Data populated from *live mode* (Use this mode when you’re ready to launch your app. Card networks or payment providers process payments) appears in the `livemode` directory. Data from testing environments (like *sandboxes* (A sandbox is an isolated test environment that allows you to test Stripe functionality in your account without affecting your live integration. Use sandboxes to safely experiment with new features and changes)) appears in the `testmode` directory. Different datasets have distinct freshness requirements and refresh intervals, resulting in varying SUCCESS files after completion of their loading processes. Below is a mapping of these SUCCESS files to their corresponding datasets. Use the correct SUCCESS file for each dataset to verify successful loading. #### API-backed data After the coreapi tables listed below have completed loading, the `coreapi_SUCCESS` file is generated for each run date. These tables adhere to a 12-hour [data freshness](https://docs.stripe.com/stripe-data/data-pipeline/data-freshness.md#dataset-freshness) requirement and maintain a 6-hour refresh interval. | Dataset | Table Name | Success file | | ------------- | ------------------------------------------------- | ----------------- | | billing | `coupons` | `coreapi_SUCCESS` | | billing | `coupons_currency_options` | `coreapi_SUCCESS` | | billing | `coupons_metadata` | `coreapi_SUCCESS` | | billing | `credit_note_discount_amounts` | `coreapi_SUCCESS` | | billing | `credit_note_line_item_discount_amounts` | `coreapi_SUCCESS` | | billing | `credit_note_line_item_tax_amounts` | `coreapi_SUCCESS` | | billing | `credit_note_line_items` | `coreapi_SUCCESS` | | billing | `credit_note_tax_amounts` | `coreapi_SUCCESS` | | billing | `credit_notes` | `coreapi_SUCCESS` | | billing | `credit_notes_metadata` | `coreapi_SUCCESS` | | billing | `discounts` | `coreapi_SUCCESS` | | billing | `invoice_custom_fields` | `coreapi_SUCCESS` | | billing | `invoice_customer_tax_ids` | `coreapi_SUCCESS` | | billing | `invoice_items` | `coreapi_SUCCESS` | | billing | `invoice_items_metadata` | `coreapi_SUCCESS` | | billing | `invoice_line_item_discount_amounts` | `coreapi_SUCCESS` | | billing | `invoice_line_item_tax_amounts` | `coreapi_SUCCESS` | | billing | `invoice_line_items` | `coreapi_SUCCESS` | | billing | `invoice_payments` | `coreapi_SUCCESS` | | billing | `invoice_shipping_cost_taxes` | `coreapi_SUCCESS` | | billing | `invoices` | `coreapi_SUCCESS` | | billing | `invoices_metadata` | `coreapi_SUCCESS` | | billing | `plans` | `coreapi_SUCCESS` | | billing | `plans_metadata` | `coreapi_SUCCESS` | | billing | `price_tiers` | `coreapi_SUCCESS` | | billing | `prices` | `coreapi_SUCCESS` | | billing | `prices_currency_options` | `coreapi_SUCCESS` | | billing | `prices_metadata` | `coreapi_SUCCESS` | | billing | `products` | `coreapi_SUCCESS` | | billing | `products_metadata` | `coreapi_SUCCESS` | | billing | `promotion_codes` | `coreapi_SUCCESS` | | billing | `quotes` | `coreapi_SUCCESS` | | billing | `subscription_items` | `coreapi_SUCCESS` | | billing | `subscription_items_metadata` | `coreapi_SUCCESS` | | billing | `subscription_schedule_phase_add_invoice_items` | `coreapi_SUCCESS` | | billing | `subscription_schedule_phase_configuration_items` | `coreapi_SUCCESS` | | billing | `subscription_schedule_phases` | `coreapi_SUCCESS` | | billing | `subscription_schedule_phases_metadata` | `coreapi_SUCCESS` | | billing | `subscription_schedules` | `coreapi_SUCCESS` | | billing | `subscription_schedules_metadata` | `coreapi_SUCCESS` | | billing | `subscriptions` | `coreapi_SUCCESS` | | billing | `subscriptions_metadata` | `coreapi_SUCCESS` | | billing | `tax_rates` | `coreapi_SUCCESS` | | billing | `tax_rates_metadata` | `coreapi_SUCCESS` | | billing | `usage_records` | `coreapi_SUCCESS` | | capital | `financing_balances` | `coreapi_SUCCESS` | | capital | `financing_offers` | `coreapi_SUCCESS` | | capital | `financing_transactions` | `coreapi_SUCCESS` | | checkout | `checkout_custom_fields` | `coreapi_SUCCESS` | | checkout | `checkout_line_items` | `coreapi_SUCCESS` | | checkout | `checkout_sessions` | `coreapi_SUCCESS` | | checkout | `payment_links` | `coreapi_SUCCESS` | | connect | `accounts` | `coreapi_SUCCESS` | | connect | `accounts_metadata` | `coreapi_SUCCESS` | | connect-fees | `application_fee_refunds` | `coreapi_SUCCESS` | | connect-fees | `application_fee_refunds_metadata` | `coreapi_SUCCESS` | | connect-fees | `application_fees` | `coreapi_SUCCESS` | | crypto | `crypto_onramp_sessions` | `coreapi_SUCCESS` | | customers | `customer_balance_transactions` | `coreapi_SUCCESS` | | customers | `customer_balance_transactions_metadata` | `coreapi_SUCCESS` | | customers | `customer_cash_balance_transactions` | `coreapi_SUCCESS` | | customers | `customer_tax_ids` | `coreapi_SUCCESS` | | customers | `customers` | `coreapi_SUCCESS` | | customers | `customers_metadata` | `coreapi_SUCCESS` | | issuing | `issuing_authorizations` | `coreapi_SUCCESS` | | issuing | `issuing_authorizations_metadata` | `coreapi_SUCCESS` | | issuing | `issuing_cardholders` | `coreapi_SUCCESS` | | issuing | `issuing_cardholders_metadata` | `coreapi_SUCCESS` | | issuing | `issuing_cards` | `coreapi_SUCCESS` | | issuing | `issuing_cards_metadata` | `coreapi_SUCCESS` | | issuing | `issuing_disputes` | `coreapi_SUCCESS` | | issuing | `issuing_network_tokens` | `coreapi_SUCCESS` | | issuing | `issuing_transactions` | `coreapi_SUCCESS` | | issuing | `issuing_transactions_metadata` | `coreapi_SUCCESS` | | payments | `balance_transaction_fee_details` | `coreapi_SUCCESS` | | payments | `balance_transactions` | `coreapi_SUCCESS` | | payments | `charges` | `coreapi_SUCCESS` | | payments | `charges_metadata` | `coreapi_SUCCESS` | | payments | `disputes` | `coreapi_SUCCESS` | | payments | `disputes_enhanced_eligibility` | `coreapi_SUCCESS` | | payments | `disputes_metadata` | `coreapi_SUCCESS` | | payments | `payment_intents` | `coreapi_SUCCESS` | | payments | `payment_intents_metadata` | `coreapi_SUCCESS` | | payments | `payment_method_details` | `coreapi_SUCCESS` | | payments | `payment_methods` | `coreapi_SUCCESS` | | payments | `payment_methods_metadata` | `coreapi_SUCCESS` | | payments | `payment_reviews` | `coreapi_SUCCESS` | | payments | `refunds` | `coreapi_SUCCESS` | | payments | `refunds_metadata` | `coreapi_SUCCESS` | | payments | `rule_decisions` | `coreapi_SUCCESS` | | payments | `setup_attempts` | `coreapi_SUCCESS` | | payments | `setup_intents` | `coreapi_SUCCESS` | | payments | `setup_intents_metadata` | `coreapi_SUCCESS` | | payments | `sources` | `coreapi_SUCCESS` | | payments | `sources_metadata` | `coreapi_SUCCESS` | | radar | `early_fraud_warnings` | `coreapi_SUCCESS` | | tax-reporting | `tax_forms` | `coreapi_SUCCESS` | | terminal | `terminal_hardware_order_items` | `coreapi_SUCCESS` | | terminal | `terminal_hardware_order_metadata` | `coreapi_SUCCESS` | | terminal | `terminal_hardware_order_shipment_tracking` | `coreapi_SUCCESS` | | terminal | `terminal_hardware_order_tax_amounts` | `coreapi_SUCCESS` | | terminal | `terminal_hardware_orders` | `coreapi_SUCCESS` | | transfers | `transfer_reversals` | `coreapi_SUCCESS` | | transfers | `transfer_reversals_metadata` | `coreapi_SUCCESS` | | transfers | `transfers` | `coreapi_SUCCESS` | | transfers | `transfers_metadata` | `coreapi_SUCCESS` | | treasury | `treasury_financial_accounts` | `coreapi_SUCCESS` | | treasury | `treasury_financial_accounts_metadata` | `coreapi_SUCCESS` | | treasury | `treasury_inbound_transfers` | `coreapi_SUCCESS` | | treasury | `treasury_inbound_transfers_metadata` | `coreapi_SUCCESS` | | treasury | `treasury_outbound_payments` | `coreapi_SUCCESS` | | treasury | `treasury_outbound_payments_metadata` | `coreapi_SUCCESS` | | treasury | `treasury_outbound_transfers` | `coreapi_SUCCESS` | | treasury | `treasury_outbound_transfers_metadata` | `coreapi_SUCCESS` | | treasury | `treasury_transaction_entries` | `coreapi_SUCCESS` | | treasury | `treasury_transactions` | `coreapi_SUCCESS` | #### Connect API-backed data The `connect-coreapi_SUCCESS` file is generated for each run date after the coreapi tables listed below have completed loading. These tables adhere to a 12-hour [data freshness](https://docs.stripe.com/stripe-data/data-pipeline/data-freshness.md#dataset-freshness) requirement and maintain a 6-hour refresh interval. | Dataset | Table Name | Success file | | ----------------- | ------------------------------------------------------------------- | ------------------------- | | connect-accounts | `connected_accounts` | `connect-coreapi_SUCCESS` | | connect-accounts | `connected_accounts_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_coupons` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_coupons_currency_options` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_coupons_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_credit_note_discount_amounts` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_credit_note_line_item_discount_amounts` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_credit_note_line_item_tax_amounts` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_credit_note_line_items` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_credit_note_tax_amounts` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_credit_notes` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_credit_notes_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_discounts` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoice_custom_fields` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoice_customer_tax_ids` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoice_items` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoice_items_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoice_line_item_discount_amounts` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoice_line_item_tax_amounts` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoice_line_items` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoice_shipping_cost_taxes` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoices` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_invoices_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_plans` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_plans_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_price_tiers` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_prices` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_prices_currency_options` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_prices_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_products` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_products_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_promotion_codes` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_quotes` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscription_items` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscription_items_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscription_schedule_phase_add_invoice_items` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscription_schedule_phase_configuration_items` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscription_schedule_phases` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscription_schedule_phases_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscription_schedules` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscription_schedules_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscriptions` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_subscriptions_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_tax_rates` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_tax_rates_metadata` | `connect-coreapi_SUCCESS` | | connect-billing | `connected_account_usage_records` | `connect-coreapi_SUCCESS` | | connect-capital | `connected_account_financing_balances` | `connect-coreapi_SUCCESS` | | connect-capital | `connected_account_financing_offers` | `connect-coreapi_SUCCESS` | | connect-capital | `connected_account_financing_transactions` | `connect-coreapi_SUCCESS` | | connect-crypto | `connected_account_crypto_onramp_sessions` | `connect-coreapi_SUCCESS` | | connect-customers | `connected_account_customer_balance_transactions` | `connect-coreapi_SUCCESS` | | connect-customers | `connected_account_customer_balance_transactions_metadata` | `connect-coreapi_SUCCESS` | | connect-customers | `connected_account_customer_cash_balance_transactions` | `connect-coreapi_SUCCESS` | | connect-customers | `connected_account_customer_tax_ids` | `connect-coreapi_SUCCESS` | | connect-customers | `connected_account_customers` | `connect-coreapi_SUCCESS` | | connect-customers | `connected_account_customers_metadata` | `connect-coreapi_SUCCESS` | | connect-fees | `connected_account_application_fee_refunds` | `connect-coreapi_SUCCESS` | | connect-fees | `connected_account_application_fee_refunds_metadata` | `connect-coreapi_SUCCESS` | | connect-fees | `connected_account_application_fees` | `connect-coreapi_SUCCESS` | | connect-issuing | `connected_account_issuing_authorizations` | `connect-coreapi_SUCCESS` | | connect-issuing | `connected_account_issuing_authorizations_metadata` | `connect-coreapi_SUCCESS` | | connect-issuing | `connected_account_issuing_cardholders` | `connect-coreapi_SUCCESS` | | connect-issuing | `connected_account_issuing_cardholders_metadata` | `connect-coreapi_SUCCESS` | | connect-issuing | `connected_account_issuing_cards` | `connect-coreapi_SUCCESS` | | connect-issuing | `connected_account_issuing_cards_metadata` | `connect-coreapi_SUCCESS` | | connect-issuing | `connected_account_issuing_disputes` | `connect-coreapi_SUCCESS` | | connect-issuing | `connected_account_issuing_transactions` | `connect-coreapi_SUCCESS` | | connect-issuing | `connected_account_issuing_transactions_metadata` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_balance_transaction_fee_details` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_balance_transactions` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_charges` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_charges_metadata` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_disputes` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_disputes_enhanced_eligibility` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_disputes_metadata` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_external_account_bank_accounts` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_external_account_cards` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_payment_intents` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_payment_intents_metadata` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_payment_method_details` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_payment_methods` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_payment_methods_metadata` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_payment_reviews` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_refunds` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_refunds_metadata` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_rule_decisions` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_setup_attempts` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_setup_intents` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_setup_intents_metadata` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_sources` | `connect-coreapi_SUCCESS` | | connect-payments | `connected_account_sources_metadata` | `connect-coreapi_SUCCESS` | | connect-radar | `connected_account_early_fraud_warnings` | `connect-coreapi_SUCCESS` | | connect-transfers | `connected_account_transfer_reversals` | `connect-coreapi_SUCCESS` | | connect-transfers | `connected_account_transfer_reversals_metadata` | `connect-coreapi_SUCCESS` | | connect-transfers | `connected_account_transfers` | `connect-coreapi_SUCCESS` | | connect-transfers | `connected_account_transfers_metadata` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_financial_accounts` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_financial_accounts_metadata` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_inbound_transfers` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_inbound_transfers_metadata` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_outbound_payments` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_outbound_payments_metadata` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_outbound_transfers` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_outbound_transfers_metadata` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_transaction_entries` | `connect-coreapi_SUCCESS` | | connect-treasury | `connected_account_treasury_transactions` | `connect-coreapi_SUCCESS` | #### Derived data The analytical datasets generate several unique SUCCESS files, each corresponding to their specific tables. These tables have varying data freshness requirements ranging from 28 to over 100 hours and maintain daily refresh intervals that are based on their respective data freshness. Consequently, these tables only appear in a share according to their associated refresh intervals. Make sure to verify the successful loading of these datasets by checking the corresponding SUCCESS files. | Dataset | Table Name | Success file | | --------- | --------------------------------------------------- | -------------------------------------------------------- | | analytics | `aggregate_optimization_details` | `aggregate_non_charge_optimization_details_SUCCESS` | | analytics | `authentication_report_attempts` | `authentication_report_attempts_SUCCESS` | | analytics | `charge_optimization_details` | `charge_optimization_details_SUCCESS` | | billing | `recoveries` | `recovery_analytics_SUCCESS` | | billing | `subscription_item_change_events` | `revenue_reporting_denorm_mrr_SUCCESS` | | billing | `subscription_item_change_events_testmode` | `sigma_subscription_item_change_events_testmode_SUCCESS` | | cost | `network_cost_insights_report` | `network_cost_insights_report_SUCCESS` | | other | `acceptance_reporting_v3_itemized` | `acceptance_reporting_v3_itemized_SUCCESS` | | other | `activity_report_itemized` | `activity_report_SUCCESS` | | other | `cau_fees` | `cau_SUCCESS` | | other | `charge_groups` | `charge_groups_SUCCESS` | | other | `connected_account_activity_report_itemized` | `activity_report_SUCCESS` | | other | `connected_account_itemized_fees` | `itemized_fees_SUCCESS` | | other | `connected_account_itemized_fees_beta` | `itemized_fees_beta_SUCCESS` | | other | `connected_account_summarized_balance_transactions` | `summarized_balance_transactions_SUCCESS` | | other | `exchange_rates_from_usd` | `exchange_rates_from_usd_SUCCESS` | | other | `icplus_fees` | `icplus_SUCCESS` | | other | `itemized_fees` | `itemized_fees_SUCCESS` | | other | `itemized_fees_beta` | `itemized_fees_beta_SUCCESS` | | other | `revenue_recognition_debits_and_credits` | `revenue_recognition_debits_and_credits_SUCCESS` | | other | `summarized_balance_transactions` | `summarized_balance_transactions_SUCCESS` | | radar | `card_testing` | `card_testing_sigma_SUCCESS` | | radar | `radar_data_integration` | `radar_data_integration_SUCCESS` | | radar | `radar_rule_attributes` | `radar_rule_attributes_SUCCESS` | | radar | `radar_rules` | `radar_rules_SUCCESS` | | tax | `tax_transaction_jurisdiction_details` | `stripetax_sigma_SUCCESS` | | tax | `tax_transaction_line_items` | `stripetax_sigma_SUCCESS` | | tax | `tax_transaction_line_items_metadata` | `stripetax_sigma_SUCCESS` | | tax | `tax_transaction_shipping_costs` | `stripetax_sigma_SUCCESS` | | tax | `tax_transactions` | `stripetax_sigma_SUCCESS` | | tax | `tax_transactions_metadata` | `stripetax_sigma_SUCCESS` | | terminal | `terminal_locations` | `terminal_sharded_location_SUCCESS` | | terminal | `terminal_readers` | `terminal_sharded_reader_SUCCESS` |