Push to Warehouse

Our push to warehouse capability allows us to sync Modern Treasury data directly to your existing data warehouse or database.

Instead of polling Modern Treasury APIs or relying on webhooks to replicate a full copy of the objects in Modern Treasury, you can receive an efficient sync of data directly to your database. You can now leverage this data as a single source of truth to power your reporting and analytics, without the need for dedicated engineering resources to obtain the data via manual extraction.

• Data is synced automatically on a regular cadence.
• Only new and updated data is sent across the wire.
• You can easily trigger a full re-sync of your data—particularly convenient if you migrate destinations or need to load a clean copy.
• Data is delivered in normalized and properly typed tables, making analysis easier for your data team.

Supported Warehouses

Modern Treasury currently supports syncing data to the following destinations:

• Snowflake
• BigQuery
• Redshift
• ClickHouse
• Databricks
• Firebolt
• Postgres
• MySQL
• Athena
• SingleStore
• Google Cloud Storage
• S3

Supported Objects

All Ledgers objects can be synced to supported customer data warehouses, as can all Payments and Compliance objects for which Webhooks are supported.

Setting it up

To learn about activating and setting up this feature, reach out to [email protected].

Setup involves configuring database access for Modern Treasury to push data into your destination. Transfers will automatically occur on a regular basis as objects in Modern Treasury are created or updated.