Lago Data Pipeline lets you automate the flow of your billing, subscription, and usage data into your analytics and storage systems. Whether you’re running complex queries on warehouses, or simply building data visualization dashboards for your finance team, you can keep all your data in sync with just a few clicks.

Lago Data Pipeline is currently in beta. Reach out to your account manager to get access.

Prerequisites

  • Data sync frequency: 1 day by default, but we can go down to 15 minutes;
  • Data transfers: Incremental or Backfill; and
  • Data security: high-level of security and encryption.

Data destinations

You can sync your Lago data to any of the following destinations:

VendorTypeStatus
SnowflakeOLAPSupported
BigQueryOLAPSupported
RedshiftOLAPSupported
DatabricksOLAPSupported
AthenaOLAPSupported
ClickHouseOLAPSupported
MotherDuckOLAPSupported
PostgresOLTPSupported
Aurora PostgresOLTPSupported
MySQLOLTPSupported
Aurora MySQLOLTPSupported
SQL ServerOLTPSupported
SingleStoreOLTPSupported
S3Object StorageSupported
S3-CompatibleObject StorageSupported
GCSObject StorageSupported
ABSObject StorageSupported
Google SheetsSpreadsheetSupported

Data sources

Here is the list of tables synced from Lago to your data destination:

NameType
applied_couponsTable
billable_metricsTable
chargesTable
couponsTable
credit_notes_taxesTable
credit_notesTable
customersTable
fees_taxesTable
feesTable
invoices_taxesTable
invoicesTable
plansTable
subscriptionsTable
taxesTable
wallet_transactionsTable
walletsTable