Lago Data Pipeline - Lago

PREMIUM ADD-ON ✨This Lago Data Pipeline feature is available upon request only. Please contact us to get access to this premium feature.

Lago Data Pipeline lets you automate the flow of your billing, subscription, and usage data into your analytics and storage systems. Use it to run queries in your warehouse or to build dashboards for your finance team from data that stays in sync.

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:

Vendor	Type	Status
`Snowflake`	OLAP	Supported
`BigQuery`	OLAP	Supported
`Redshift`	OLAP	Supported
`Databricks`	OLAP	Supported
`Athena`	OLAP	Supported
`ClickHouse`	OLAP	Supported
`MotherDuck`	OLAP	Supported
`Postgres`	OLTP	Supported
`Aurora Postgres`	OLTP	Supported
`MySQL`	OLTP	Supported
`Aurora MySQL`	OLTP	Supported
`SQL Server`	OLTP	Supported
`SingleStore`	OLTP	Supported
`S3`	Object Storage	Supported
`S3-Compatible`	Object Storage	Supported
`GCS`	Object Storage	Supported
`ABS`	Object Storage	Supported
`Google Sheets`	Spreadsheet	Supported

Data sources

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

Name	Type
`applied_coupons`	Table
`billable_metrics`	Table
`charges`	Table
`coupons`	Table
`credit_notes_taxes`	Table
`credit_notes`	Table
`customers`	Table
`fees_taxes`	Table
`fees`	Table
`invoices_taxes`	Table
`invoices`	Table
`plans`	Table
`subscriptions`	Table
`taxes`	Table
`wallet_transactions`	Table
`wallets`	Table