Data freshness
Sigma and Data Pipeline provide access to the Stripe data available with the Stripe API. You can also access data such as Stripe financial reports, which isn’t available in the Stripe API.
Data freshness
Sigma and Data Pipeline make most of your transaction data available to query within one day.
Data freshness for datasets
View the table below for information on data freshness for specific datasets.
Dataset | Example tables | Sigma freshness | Data Pipeline freshness |
---|---|---|---|
Core API tables (including Connect versions) | balance_transactions , charges , connected_account_balance_transactions | 24 hours | 9 hours |
Daily refreshed tables | exchange_rates_from_usd , radar_rules | 24 hours | 28 hours |
About the schema
Our full-page schema documentation shows the schema in a split-view format and provides more details on table linkages.
The schema follows our API conventions as closely as possible. Many of the tables correspond to specific API objects, with each column representing a specific attribute that’s reported. For instance, the charges
table represents information about Charge objects, which is displayed in the Payments section of the Dashboard.
When you write queries, refer to the our API reference for additional content and values.
Sigma schema tab
The Schema tab in Sigma displays all the available data that you can use in your queries, organized by category. Each category contains a set of tables that represents the available data.
You can select a table to expand it and reveal its available columns, along with a description of the type of data it contains (for example: Boolean
, Varchar
, Foreign key
, and so on). Hover the cursor over any column to reveal a description. Use the search field at the top of the schema to find specific tables and columns.