# Data Pipeline data freshness Understand data availability timelines for Data Pipeline exports. Data Pipeline shares your Stripe data to your destination on a recurring schedule. The time it takes for data to arrive varies by dataset. > Data delivery varies from customer to customer and is largely determined by the data sizes. After sign-up, you can see your actual delivery time in your warehouse. The following terms describe Data Pipeline timing: - **Cadence**: How frequently Stripe shares data to your destination. For example, a cadence of 3 hours means data is shared at 00:00, 03:00, 06:00 UTC, and so on. - **Freshness P50 (hours)**: 50% of the time, data is available within this duration from event creation. - **Freshness P90 (hours)**: 90% of the time, data is available within this duration from event creation. - **Max delay (hours)**: The maximum expected time from event creation to data availability. For example, with a 3-hour cadence, the 03:00 UTC batch includes a record created at 00:01 UTC. With a typical delivery time of 3 hours after the batch closes, the data is available by 06:00 UTC—a P50 freshness of 6 hours from event creation. ## Understanding your pipeline’s data freshness In your Stripe Dashboard, you can view data landing and “data as of” times by dataset. Here are the definitions of all the timestamps: - **Data landed**: The last time the data landed in your destination. - **Data as of**: All API-backed data until this timestamp is included in the exported snapshot. This varies for derived datasets. - **Next sync start time**: The next time your data begins loading. ## Query data load times with Data Pipeline Stripe provides the `data_load_times` table as part of your data share. In your warehouse, you can see when the data in each table is updated by viewing the date in the **LOADED** column. ![](https://b.stripecdn.com/docs-statics-srv/assets/data_load_times.28ab89d873e1295653dcd2ce18629a1b.png) You can use the above values in your queries to filter data based on when it’s most recently updated in each table. Use the following query to get data about your balance transactions from the last week: ```sql select created, id, amount, currency, source_id from balance_transactions, data_load_times where data_load_times.table_name = 'balance_transactions' and datediff(day, created, data_load_times.loaded) <= 7 order by created desc ``` ## Dataset freshness #### API-backed data | Dataset | Table Name | Cadence (hours) | Freshness P50 (hours) | Freshness P90 (hours) | Max delay (hours) | | ------------- | ----------------------------------------------- | --------------- | --------------------- | --------------------- | ----------------- | | billing | coupons | 3 | 6 | 7 | 12 | | billing | coupons_currency_options | 3 | 6 | 7 | 12 | | billing | coupons_metadata | 3 | 6 | 7 | 12 | | billing | credit_note_discount_amounts | 3 | 6 | 7 | 12 | | billing | credit_note_line_item_discount_amounts | 3 | 6 | 7 | 12 | | billing | credit_note_line_item_tax_amounts | 3 | 6 | 7 | 12 | | billing | credit_note_line_items | 3 | 6 | 7 | 12 | | billing | credit_note_tax_amounts | 3 | 6 | 7 | 12 | | billing | credit_notes | 3 | 6 | 7 | 12 | | billing | credit_notes_metadata | 3 | 6 | 7 | 12 | | billing | discounts | 3 | 6 | 7 | 12 | | billing | invoice_custom_fields | 3 | 6 | 7 | 12 | | billing | invoice_customer_tax_ids | 3 | 6 | 7 | 12 | | billing | invoice_items | 3 | 6 | 7 | 12 | | billing | invoice_items_metadata | 3 | 6 | 7 | 12 | | billing | invoice_line_item_discount_amounts | 3 | 6 | 7 | 12 | | billing | invoice_line_item_tax_amounts | 3 | 6 | 7 | 12 | | billing | invoice_line_items | 3 | 6 | 7 | 12 | | billing | invoice_payments | 3 | 6 | 7 | 12 | | billing | invoice_shipping_cost_taxes | 3 | 6 | 7 | 12 | | billing | invoices | 3 | 6 | 7 | 12 | | billing | invoices_metadata | 3 | 6 | 7 | 12 | | billing | plans | 3 | 6 | 7 | 12 | | billing | plans_metadata | 3 | 6 | 7 | 12 | | billing | price_tiers | 3 | 6 | 7 | 12 | | billing | prices | 3 | 6 | 7 | 12 | | billing | prices_currency_options | 3 | 6 | 7 | 12 | | billing | prices_metadata | 3 | 6 | 7 | 12 | | billing | products | 3 | 6 | 7 | 12 | | billing | products_metadata | 3 | 6 | 7 | 12 | | billing | promotion_codes | 3 | 6 | 7 | 12 | | billing | quotes | 3 | 6 | 7 | 12 | | billing | subscription_items | 3 | 6 | 7 | 12 | | billing | subscription_items_metadata | 3 | 6 | 7 | 12 | | billing | subscription_schedule_phase_add_invoice_items | 3 | 6 | 7 | 12 | | billing | subscription_schedule_phase_configuration_items | 3 | 6 | 7 | 12 | | billing | subscription_schedule_phases | 3 | 6 | 7 | 12 | | billing | subscription_schedule_phases_metadata | 3 | 6 | 7 | 12 | | billing | subscription_schedules | 3 | 6 | 7 | 12 | | billing | subscription_schedules_metadata | 3 | 6 | 7 | 12 | | billing | subscriptions | 3 | 6 | 7 | 12 | | billing | subscriptions_metadata | 3 | 6 | 7 | 12 | | billing | tax_rates | 3 | 6 | 7 | 12 | | billing | tax_rates_metadata | 3 | 6 | 7 | 12 | | billing | usage_records | 3 | 6 | 7 | 12 | | capital | financing_balances | 3 | 6 | 7 | 12 | | capital | financing_offers | 3 | 6 | 7 | 12 | | checkout | checkout_custom_fields | 3 | 6 | 7 | 12 | | checkout | checkout_line_items | 3 | 6 | 7 | 12 | | checkout | checkout_sessions | 3 | 6 | 7 | 12 | | checkout | payment_links | 3 | 6 | 7 | 12 | | connect | accounts | 3 | 6 | 7 | 12 | | connect | accounts_metadata | 3 | 6 | 7 | 12 | | connect-fees | application_fee_refunds | 3 | 6 | 7 | 12 | | connect-fees | application_fee_refunds_metadata | 3 | 6 | 7 | 12 | | connect-fees | application_fees | 3 | 6 | 7 | 12 | | crypto | crypto_onramp_sessions | 3 | 6 | 7 | 12 | | customers | customer_balance_transactions | 3 | 6 | 7 | 12 | | customers | customer_balance_transactions_metadata | 3 | 6 | 7 | 12 | | customers | customer_cash_balance_transactions | 3 | 6 | 7 | 12 | | customers | customer_tax_ids | 3 | 6 | 7 | 12 | | customers | customers | 3 | 6 | 7 | 12 | | customers | customers_metadata | 3 | 6 | 7 | 12 | | issuing | issuing_authorizations | 3 | 6 | 7 | 12 | | issuing | issuing_authorizations_metadata | 3 | 6 | 7 | 12 | | issuing | issuing_cardholders | 3 | 6 | 7 | 12 | | issuing | issuing_cardholders_metadata | 3 | 6 | 7 | 12 | | issuing | issuing_cards | 3 | 6 | 7 | 12 | | issuing | issuing_cards_metadata | 3 | 6 | 7 | 12 | | issuing | issuing_disputes | 3 | 6 | 7 | 12 | | issuing | issuing_network_tokens | 3 | 6 | 7 | 12 | | issuing | issuing_transactions | 3 | 6 | 7 | 12 | | issuing | issuing_transactions_metadata | 3 | 6 | 7 | 12 | | payments | balance_transaction_fee_details | 3 | 6 | 7 | 12 | | payments | balance_transactions | 3 | 6 | 7 | 12 | | payments | charges | 3 | 6 | 7 | 12 | | payments | charges_metadata | 3 | 6 | 7 | 12 | | payments | disputes | 3 | 6 | 7 | 12 | | payments | disputes_enhanced_eligibility | 3 | 6 | 7 | 12 | | payments | disputes_metadata | 3 | 6 | 7 | 12 | | payments | payment_intents | 3 | 6 | 7 | 12 | | payments | payment_intents_metadata | 3 | 6 | 7 | 12 | | payments | payment_method_details | 3 | 6 | 7 | 12 | | payments | payment_methods | 3 | 6 | 7 | 12 | | payments | payment_methods_metadata | 3 | 6 | 7 | 12 | | payments | payment_reviews | 3 | 6 | 7 | 12 | | payments | refunds | 3 | 6 | 7 | 12 | | payments | refunds_metadata | 3 | 6 | 7 | 12 | | payments | rule_decisions | 3 | 6 | 7 | 12 | | payments | setup_attempts | 3 | 6 | 7 | 12 | | payments | setup_intents | 3 | 6 | 7 | 12 | | payments | setup_intents_metadata | 3 | 6 | 7 | 12 | | payments | sources | 3 | 6 | 7 | 12 | | payments | sources_metadata | 3 | 6 | 7 | 12 | | tax-reporting | tax_forms | 3 | 6 | 7 | 12 | | terminal | terminal_hardware_order_items | 3 | 6 | 7 | 12 | | terminal | terminal_hardware_order_metadata | 3 | 6 | 7 | 12 | | terminal | terminal_hardware_order_shipment_tracking | 3 | 6 | 7 | 12 | | terminal | terminal_hardware_order_tax_amounts | 3 | 6 | 7 | 12 | | terminal | terminal_hardware_orders | 3 | 6 | 7 | 12 | | transfers | transfer_reversals | 3 | 6 | 7 | 12 | | transfers | transfer_reversals_metadata | 3 | 6 | 7 | 12 | | transfers | transfers | 3 | 6 | 7 | 12 | | transfers | transfers_metadata | 3 | 6 | 7 | 12 | | treasury | treasury_financial_accounts | 3 | 6 | 7 | 12 | | treasury | treasury_financial_accounts_metadata | 3 | 6 | 7 | 12 | | treasury | treasury_inbound_transfers | 3 | 6 | 7 | 12 | | treasury | treasury_inbound_transfers_metadata | 3 | 6 | 7 | 12 | | treasury | treasury_outbound_payments | 3 | 6 | 7 | 12 | | treasury | treasury_outbound_payments_metadata | 3 | 6 | 7 | 12 | | treasury | treasury_outbound_transfers | 3 | 6 | 7 | 12 | | treasury | treasury_outbound_transfers_metadata | 3 | 6 | 7 | 12 | | treasury | treasury_transaction_entries | 3 | 6 | 7 | 12 | | treasury | treasury_transactions | 3 | 6 | 7 | 12 | #### Derived data | Dataset | Table Name | Cadence (hours) | Freshness P50 (hours) | Freshness P90 (hours) | Max delay (hours) | | -------- | ------------------------------------------------------------------- | --------------- | --------------------- | --------------------- | ----------------- | | billing | usage_based_billing_billing_alerts | 3 | 5 | 6 | 15 | | billing | usage_based_billing_billing_alert_filters | 3 | 5 | 6 | 15 | | billing | usage_based_billing_billing_alert_metadata | 3 | 5 | 6 | 15 | | billing | customer_change_events | 24 | 41 | 43 | 79 | | billing | billing_cadences_beta | 3 | 5 | 6 | 15 | | billing | billing_credit_balance_transactions | 3 | 7 | 7 | 15 | | billing | billing_credit_grant_metadata | 3 | 6 | 7 | 15 | | billing | billing_credit_grants | 3 | 6 | 7 | 15 | | billing | billing_intents_beta | 3 | 5 | 6 | 15 | | billing | billing_meters | 6 | 10 | 11 | 19 | | billing | billing_meter_dimensions | 6 | 10 | 11 | 19 | | billing | billing_meter_event_summaries | 6 | 10 | 11 | 19 | | billing | billing_meter_event_summary_segments | 6 | 10 | 11 | 19 | | billing | billing_meter_invalid_events | 6 | 10 | 11 | 19 | | billing | billing_meter_invalid_events_payload | 6 | 10 | 11 | 19 | | billing | subscription_item_change_events_v2_beta | 3 | 6 | 7 | 15 | | billing | license_fee_versions_beta | 3 | 5 | 6 | 15 | | billing | license_fees_beta | 3 | 5 | 6 | 15 | | billing | licensed_items_beta | 3 | 5 | 6 | 15 | | billing | metered_items_beta | 3 | 5 | 6 | 15 | | billing | pricing_plan_components_beta | 3 | 5 | 6 | 15 | | billing | pricing_plan_subscriptions_beta | 3 | 5 | 6 | 15 | | billing | pricing_plan_versions_beta | 3 | 5 | 6 | 15 | | billing | pricing_plans_beta | 3 | 5 | 6 | 15 | | billing | rate_card_rates_beta | 3 | 5 | 6 | 15 | | billing | rate_card_subscriptions_beta | 3 | 5 | 6 | 15 | | billing | rate_card_versions_beta | 3 | 5 | 6 | 15 | | billing | rate_cards_beta | 3 | 5 | 6 | 15 | | billing | recoveries | 24 | 45 | 50 | 79 | | billing | subscription_item_change_events | 24 | 42 | 45 | 55 | | billing | service_actions_beta | 3 | 5 | 6 | 15 | | billing | subscriptions_paid_usage | 3 | 7 | 8 | 18 | | connect | v2__accounts | 24 | 34 | 38 | 55 | | connect | v2__accounts_metadata | 24 | 34 | 38 | 55 | | cost | network_cost_insights_report | 24 | 59 | 85 | 151 | | other | acceptance_reporting_v3_itemized | 24 | 46 | 58 | 99 | | other | activity_lineitems | 24 | 83 | 93 | 130 | | other | connected_account_activity_lineitems | 24 | 83 | 93 | 130 | | other | analytics_page_events | 24 | 38 | 44 | 103 | | other | iins | 24 | 29 | 30 | 55 | | other | cau_fees | 24 | 64 | 72 | 103 | | other | charge_groups | 24 | 43 | 48 | 103 | | other | connect_card_payments_fees_plan_level | 24 | 54 | 58 | 103 | | other | connect_card_payments_fees_transaction_level | 24 | 54 | 58 | 103 | | other | connected_account_itemized_fees | 24 | 44 | 48 | 151 | | other | connected_account_itemized_fees_beta | 24 | 43 | 47 | 151 | | other | connected_account_summarized_balance_transactions | 6 | 12 | 12 | 23 | | other | disputes_reporting_v1_itemized | 24 | 41 | 55 | 99 | | other | disputes_reporting_v1_itemized_v2 | 24 | 69 | 84 | 99 | | other | exchange_rates_from_usd | 24 | 29 | 30 | 55 | | other | fee_credits_activities | 6 | 10 | 11 | 21 | | other | icplus_fees | 24 | 56 | 60 | 103 | | other | itemized_fees | 24 | 44 | 48 | 151 | | other | itemized_fees_beta | 24 | 43 | 47 | 151 | | other | revenue_recognition_debits_and_credits | 6 | 9 | 9 | 16 | | other | revenue_recognition_exclusions | 6 | 9 | 10 | 16 | | other | revenue_recognition_manual_journal_entries | 24 | 31 | 32 | 55 | | other | summarized_balance_transactions | 6 | 12 | 12 | 23 | | other | visa_cedp_report | 24 | 26 | 29 | 151 | | payments | payins_insights_lightning_astro_deduped_aggregated_with_attempts_v2 | 24 | 46 | 54 | 79 | | payments | payins_insights_lightning_astro_raw_aggregated_with_attempts_v2 | 24 | 36 | 42 | 79 | | payments | v2_us_bank_accounts | 24 | 29 | 31 | 55 | | radar | radar_data_integration | 24 | 40 | 45 | 79 | | radar | radar_rule_attributes | 24 | 38 | 42 | 79 | | radar | radar_rules | 24 | 34 | 37 | 55 | | tax | tax_transaction_customer_tax_ids | 24 | 35 | 39 | 55 | | tax | tax_transaction_jurisdiction_details | 24 | 35 | 39 | 55 | | tax | tax_transaction_line_items | 24 | 35 | 39 | 55 | | tax | tax_transaction_line_items_metadata | 24 | 35 | 39 | 55 | | tax | tax_transaction_shipping_costs | 24 | 35 | 39 | 55 | | tax | tax_transactions | 24 | 35 | 39 | 55 | | tax | tax_transactions_metadata | 24 | 35 | 39 | 55 | | terminal | terminal_locations | 24 | 27 | 27 | 151 | | terminal | terminal_readers | 24 | 27 | 27 | 151 | | treasury | v2__adjustments | 3 | 5 | 8 | 22 | | treasury | v2__inbound_transfers | 3 | 5 | 8 | 22 | | treasury | v2__inbound_transfers_history | 3 | 5 | 8 | 22 | | treasury | v2__outbound_payments | 3 | 5 | 8 | 22 | | treasury | v2__outbound_payments_metadata | 3 | 5 | 8 | 22 | | treasury | v2__outbound_transfers | 3 | 5 | 8 | 22 | | treasury | v2__received_credits | 3 | 5 | 8 | 22 | | treasury | v2__transaction_entries | 3 | 5 | 8 | 22 | | treasury | v2__transactions | 3 | 5 | 8 | 22 | | treasury | v2__us_bank_accounts | 3 | 5 | 8 | 22 |