Skip to main content

Data export

Metronome can send your sandbox and production data directly to your data warehouse, giving you the flexibility to build reports and dashboards with your favorite data tools.

Getting started

Exporting data from Metronome is a simple process requiring a one-time setup of your data destination. After the initial export, your data will be updated automatically once a day. To set up your destination, please contact your Growth Representative.

Supported destination types

Metronome supports data export to the most common data warehouses, databases, and object storage providers. We continue to add new providers; if your preferred vendor is not listed below, please contact your Growth Representative.

Data warehouse

  • BigQuery
  • Clickhouse
  • Databricks
  • Firebolt
  • Redshift
  • Snowflake

Database

  • Athena
  • MySQL
  • Postgres
  • SingleStore

Object storage

  • Google Cloud Storage
  • S3

Data availability

What can be exported

  • Customer data
  • Finalized invoice data
  • Credit grants
  • Finalized credit grant deductions
  • Credit types
  • Raw ingested usage events

Export frequency

Data will be exported once per day, which means that some data may be up to 24 hours behind.

Schema

Note: Due to our export methodology, all columns may appear as nullable in your destination schema. The Nullable column in the table below reflects how your data is stored in Metronome.

customer

Column nameDescriptionNullable?Postgres data typeSnowflake data typeRedshift data typeBigQuery data typeDatabricks data type
idThe Metronome ID of the customerNtexttextvarcharstringstring
nameThe name of the customerNtexttextvarcharstringstring
ingest_aliasesThe ingest aliases of the customerNjsonbvariantvarcharstringstring
salesforce_account_idThe Salesforce account ID for the customerYtexttextvarcharstringstring
billing_provider_typeThe billing provider connected to customerYtexttextvarcharstringstring
billing_provider_customer_idThe billing provider ID of the customerYtexttextvarcharstringstring
environment_typeThe Metronome environmentNtexttextvarcharstringstring
created_atThe timestamp (UTC) of when the customer was createdNtimestamptztimestamp_tztimestamptztimestamptimestamp
updated_atThe timestamp (UTC) of when the customer was last updatedNtimestamptztimestamp_tztimestamptztimestamptimestamp
archived_atThe timestamp (UTC) of when the customer was archived, if applicableYtimestamptztimestamp_tztimestamptztimestamptimestamp

invoice

Column nameDescriptionNullable?Postgres data typeSnowflake data typeRedshift data typeBigQuery data typeDatabricks data type
idThe Metronome invoice IDNtexttextvarcharstringstring
statusThe Metronome invoice status: FINALIZED or VOID (DRAFT invoices are not supported yet)Ntexttextvarcharstringstring
totalThe invoice totalNdecimaldecimaldecimalnumericdecimal
credit_type_idThe credit type ID for the invoiceNtexttextvarcharstringstring
credit_type_nameThe name of the credit type associated with the invoiceNtexttextvarcharstringstring
customer_idThe Metronome ID of the customerNtexttextvarcharstringstring
plan_idThe plan ID associated with the invoiceNtexttextvarcharstringstring
plan_nameThe name of the plan associated with the invoiceNtexttextvarcharstringstring
start_timestampBeginning of the usage period that this invoice covers (UTC)Ntimestamptztimestamp_tztimestamptztimestamptimestamp
end_timestampEnd of the usage period that this invoice covers (UTC)Ntimestamptztimestamp_tztimestamptztimestamptimestamp
billing_provider_invoice_idThe external invoice ID from the billing provider (e.g., Stripe)Ytexttextvarcharstringstring
billing_provider_invoice_created_atThe timestamp (UTC) the external invoice was created by MetronomeYtimestamptztimestamp_tztimestamptztimestamptimestamp
billing_provider_invoice_external_statusThe status of the corresponding external billing provider invoice (e.g., Stripe): DRAFT, FINALIZED, PAID, UNCOLLECTIBLE, VOID, DELETED, or PAYMENT_FAILEDYtexttextvarcharstringstring
environment_typeThe Metronome environment, SANDBOX or PRODUCTIONNtexttextvarcharstringstring
updated_atThe timestamp (UTC) this row was last updatedNtimestamptztimestamp_tztimestamptztimestamptimestamp

line_item

Column nameDescriptionNullable?Postgres data typeSnowflake data typeRedshift data typeBigQuery data typeDatabricks data type
idThe line item IDNtexttextvarcharstringstring
invoice_idThe Metronome invoice ID associated with the line itemNtexttextvarcharstringstring
credit_type_idThe credit type ID associated with the line itemNtexttextvarcharstringstring
credit_type_nameThe name of the credit type associated with the line itemNtexttextvarcharstringstring
nameThe line item descriptionNtexttextvarcharstringstring
quantityThe quantity associated with the line item; this will always be 1 for invoice adjustmentsYdecimaldecimaldecimalnumericdecimal
totalThe line item totalNdecimaldecimaldecimalnumericdecimal
product_idThe product ID associated with the line item; this will always be NULL for invoice adjustmentsYtexttextvarcharstringstring
group_keyThe group key associated with the line itemYtexttextvarcharstringstring
group_valueThe group value associated with the line itemYtexttextvarcharstringstring
updated_atThe timestamp (UTC) of when the line item was last updatedNtimestamptztimestamp_tztimestamptztimestamptimestamp

sub_line_item

Note: Sub line items with a quantity of zero will not be exported.

Column nameDescriptionNullable?Postgres data typeSnowflake data typeRedshift data typeBigQuery data typeDatabricks data type
idThe sub line item IDNtexttextvarcharstringstring
line_item_idThe line item ID associated with the sub line itemNtexttextvarcharstringstring
nameThe sub line item descriptionNtexttextvarcharstringstring
quantityThe quantity associated with the sub line itemYdecimaldecimaldecimalnumericdecimal
subtotalThe subtotal associated with the sub line itemYdecimaldecimaldecimalnumericdecimal
charge_idThe charge ID associated with the sub line itemNtexttextvarcharstringstring
billable_metric_idThe billable metric ID associated with the sub line itemYtexttextvarcharstringstring
billable_metric_nameThe name of the billable metric associated with the sub line itemYtexttextvarcharstringstring
tiersInformation about the tiers associated with the sub line item, including sub_line_item_id, name, quantity, subtotal, updated_at, price, and starting_atYjsonbvariantvarcharstringstring
updated_atThe timestamp (UTC) this row was last updatedNtimestamptztimestamp_tztimestamptztimestamptimestamp

credit_grant

Column nameDescriptionNullable?Postgres data typeSnowflake data typeRedshift data typeBigQuery data typeDatabricks data type
idThe credit grant IDNtexttextvarcharstringstring
customer_idThe customer ID associated with the credit grantNtexttextvarcharstringstring
nameThe name of the credit grantNtexttextvarcharstringstring
invoice_idThe ID of the invoice with the purchase charge for the credit grant, if applicableYtexttextvarcharstringstring
priorityThe priority of the credit grantNdecimaldecimaldecimalnumericdecimal
reasonThe reason of the credit grantYtexttextvarcharstringstring
amount_grantedThe amount of credit grantedNdecimaldecimaldecimalnumericdecimal
amount_granted_credit_type_idThe credit type ID for the amount grantedNtexttextvarcharstringstring
amount_paidThe amount paid for the credit grantNdecimaldecimaldecimalnumericdecimal
amount_paid_credit_type_idThe credit type ID for the amount paidNtimestamptztimestamp_tztimestamptztimestamptimestamp
product_idsThe products which the credit grant are applied to; this will be "[]" if the credit grant applies to all productsNjsonbvariantvarcharstringstring
environment_typeThe Metronome environment, SANDBOX or PRODUCTIONNtexttextvarcharstringstring
created_atThe timestamp (UTC) of when the credit grant was createdNtimestamptztimestamp_tztimestamptztimestamptimestamp
updated_atThe timestamp (UTC) of when the credit grant was last updatedNtimestamptztimestamp_tztimestamptztimestamptimestamp
effective_atThe timestamp (UTC) of when the credit grant is effective fromNtimestamptztimestamp_tztimestamptztimestamptimestamp
expires_atThe timestamp (UTC) of when the credit grant expires atNtimestamptztimestamp_tztimestamptztimestamptimestamp
voided_atThe timestamp (UTC) of when the credit grant was voided, if applicableYtimestamptztimestamp_tztimestamptztimestamptimestamp

credit_grant_deduction

Column nameDescriptionNullable?Postgres data typeSnowflake data typeRedshift data typeBigQuery data typeDatabricks data type
idThe credit grant deduction IDNtexttextvarcharstringstring
credit_grant_idThe credit grant ID associated with the credit grant deductionNtexttextvarcharstringstring
amountThe amount of credit deductedNdecimaldecimaldecimalnumericdecimal
memoThe memo of the credit grant deductionNtexttextvarcharstringstring
invoice_idThe invoice ID associated with the credit grant deductionNtexttextvarcharstringstring
effective_atThe timestamp (UTC) of when the credit grant deduction occurredNtimestamptztimestamp_tztimestamptztimestamptimestamp
updated_atThe timestamp (UTC) this row was last updatedNtimestamptztimestamp_tztimestamptztimestamptimestamp

credit_type

Column nameDescriptionNullable?Postgres data typeSnowflake data typeRedshift data typeBigQuery data typeDatabricks data type
idThe credit type IDNtexttextvarcharstringstring
nameThe name of the credit typeNtexttextvarcharstringstring
is_currencyWhether or not the credit type is a currency, TRUE or FALSENbooleanbooleanbooleanboolboolean
environment_typeThe Metronome environment, SANDBOX or PRODUCTION; this will always be NULL for currenciesYtexttextvarcharstringstring
updated_atThe timestamp (UTC) this row was last updatedNtimestamptztimestamp_tztimestamptztimestamptimestamp
_metronome_metadata_idMetronome metadata IDNtexttextvarcharstringstring

events

Column nameDescriptionNullable?Postgres data typeSnowflake data typeRedshift data typeBigQuery data typeDatabricks data type
transaction_idThe unique ID of the eventNtexttextvarcharstringstring
customer_idThe ID of the customer the event applies toNtexttextvarcharstringstring
timestampThe timestamp (UTC) of the eventNtimestamptztimestamp_tztimestamptztimestamptimestamp
event_typeThe event typeNtexttextvarcharstringstring
propertiesThe properties of the eventNjsonbvariantvarcharstringstring
environment_typeThe Metronome environment, SANDBOX or PRODUCTIONNtexttextvarcharstringstring
_metronome_metadata_idMetronome metadata IDNtexttextvarcharstringstring