Skip to main content
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. Exporting data from Metronome is a simple process requiring a one-time setup of your data destination at https://app.metronome.com/connections/data-export. After the initial export, your data is updated automatically at least once a day (depending on the table).
GET STARTEDTo set up your destination data warehouse, contact your Metronome 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, contact your Metronome representative.
ONE DESTINATION LIMITOnly a single destination for data exports can be configured across all Metronome environments. Distinct destinations cannot be set up for Production and Sandbox.

​
Data warehouse

  • BigQuery
  • Clickhouse
  • Databricks
  • Redshift
  • Snowflake

​
Database

  • Athena
  • MySQL
  • Postgres
  • SingleStore

​
Object storage

  • Google Cloud Storage
  • S3
Folder structure: 
<bucket_name>/<folder_name>/<table_name>/dt=<transfer_date>/<file_part>_<transfer_timestamp>.parquet
Path components:
ComponentDescription
<bucket_name>Your configured bucket name
<folder_name>Your configured folder path
<table_name>Table being transferred (e.g., invoice, customer)
<transfer_date>Transfer date in YYYY-MM-DD format (e.g., 2025-01-01)
<transfer_timestamp>Transfer timestamp in YYYYMMDDHHmmss format (e.g., 20250102150405)
<file_part>Monotonically increasing integer (no special meaning)
APPEND-ONLYObject storage destinations listed above export files as an append-only log with at-least-once semantics. There will be rows with the same primary key in multiple files because of updates to the row or transfer retries. Metronome customers need to handle these appropriately by using the most recent data for each row.

​
Data availability

Metronome can export these types of sandbox and production data:
Metronome dataTable nameTransfer Frequency†Average Freshness††Table Type
Billable Metricsbillable_metric2 hours4 hoursIncremental
Credit Typecredit_type2 hours4 hoursIncremental
Eventsevents2 hours4 hoursIncremental
Customerscustomer2 hours4 hoursIncremental
Customerscustomer_billing_provider_configuration2 hours4 hoursIncremental
Finalized Invoicesinvoice2 hours4 hoursIncremental
Finalized Invoicesline_item2 hours4 hoursIncremental
Draft Invoicesdraft_invoice24 hours24 hoursSnapshot
Draft Invoicesdraft_line_item24 hours24 hoursSnapshot
Invoice Breakdownsbreakdowns_invoices24 hours24 hoursIncremental
Invoice Breakdownsbreakdowns_line_items24 hours24 hoursIncremental
Invoice Breakdownsbreakdowns_draft_invoices24 hours24 hoursSnapshot
Invoice Breakdownsbreakdowns_draft_line_items24 hours24 hoursSnapshot
Contractscontracts_contracts24 hours24 hoursSnapshot
Contractscontracts_commits24 hours24 hoursSnapshot
Contractscontracts_balances24 hours24 hoursSnapshot
Contractscontracts_recurring_commits_and_credits24 hours24 hoursSnapshot
Contractscontracts_subscriptions24 hours24 hoursSnapshot
Contractscontracts_scheduled_charges24 hours24 hoursSnapshot
Contractscontracts_usage_filter_schedule24 hours24 hoursSnapshot
Contractscontracts_usage_filters24 hours24 hoursSnapshot
Contractscontracts_billing_provider_configuration2 hours4 hoursIncremental
Contractscontracts_prepaid_balance_threshold_configurations24 hours24 hoursSnapshot
Contractscontracts_spend_threshold_configurations24 hours24 hoursSnapshot
Contract Modificationscontracts_overrides24 hours24 hoursSnapshot
Contract Modificationscontracts_transitions24 hours24 hoursSnapshot
Contract Modificationscontracts_edits24 hours24 hoursSnapshot
Contract Modificationscontracts_amendments24 hours24 hoursSnapshot
Contract Pricingcontracts_rate_cards24 hours24 hoursSnapshot
Contract Pricingcontracts_rate_card_entries24 hours24 hoursSnapshot
Contract Pricingcontracts_product_list_item_versions24 hours24 hoursSnapshot
Alertsalert2 hours4 hoursIncremental
Alertscustomer_alert_history2 hours4 hoursIncremental
† Transfer frequency indicates the frequency at which new records get sent to your destination. †† Average Freshness indicates the average delay between when data is generated in Metronome and when the data appears in your destination.
INCREMENTAL DATA EXPORTSData exports of incremental tables contain only the rows of data that have changed since the last export. Use the updated_at column to pull the latest updates.
⌘I