Data freshness

Sigma and Data Pipeline allow you to analyse and export the same underlying data that’s accessible through the Stripe API, but through different interfaces. While the Stripe API provides programmatic access to your data, Sigma offers a SQL-based interface for custom queries and analysis, and Data Pipeline enables bulk data exports.

Additionally, Sigma and Data Pipeline provide access to certain data that isn’t available through the Stripe API, such as reports.

Data freshness

Sigma and Data Pipeline make most of your transaction data available to query within one day.

select
  id,
  amount,
  fee,
  currency
from balance_transactions -- this table is the canonical record of changes to your Stripe balance
where
  created < data_load_time and
  created >= data_load_time - interval '1' month
order by created desc
limit 10

select
  ic.charge_id,
  ic.billing_currency,
  ic.billing_amount,
  ic.balance_transaction_id,
  ic.balance_transaction_created_at
from icplus_fees as ic
join balance_transactions as bt
  on ic.balance_transaction_id = bt.id
where bt.created >= data_load_time - interval '1' month
  and bt.created < data_load_time

Data schema

You can view the complete schema, which closely follows our API conventions, in a split-view format that shows details on table relationships. It displays all the available data that you can use in your queries, organised by category. Each category contains a set of tables that represents the available data. Many tables correspond to specific API objects, with each column representing a reported attribute. For example, the charges table represents information about Charge objects, which appears in the Payments section of the Dashboard.

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, and Foreign key). 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. When writing queries, refer to our API reference for additional context and values.

Dataset freshness

View the following tables for information on data freshness for specific datasets: