Recurly's Snowflake integration shares your merchant data directly into your Snowflake account — automatically, every hour. No ETL pipelines to manage, no third-party vendors, no manual exports. Combine your Recurly data with other datasets in Snowflake for a complete view of your business.

Not included in Starter or Pro — contact Recurly Sales to upgrade

1Definition 2Key benefits 3Key details 4Integration guide 5FAQs

Definition

Recurly's Snowflake integration uses Snowflake's secure data sharing to push your complete Recurly export data directly into your Snowflake account — updated every hour or daily. Setup is handled by Recurly's Professional Services team, and once configured, data flows automatically with no ongoing maintenance required on your end.

Key benefits

No-code data integration Recurly handles all data transfer automatically — no ETL pipelines, no coding, no server management required.

Hourly data refresh Stay current with automatic hourly updates so your latest business metrics are always available in Snowflake.

Unified data analysis Combine Recurly data with other datasets in Snowflake for cross-platform analytics and custom reporting using Snowflake's full capabilities.

Time and cost savings Bypass traditional intermediaries and third-party ETL vendors — the integration handles everything so your team can focus on analysis, not data plumbing.

Full historical data All historical Recurly data is available in the share from day one — not just recent records.

Key details

What Snowflake offers

Recurly integrates with Snowflake to share merchant data directly. If you're a Recurly customer, contact our Account Management to enable this feature. The enablement of the Snowflake integration is managed by Recurly's Professional Services: a Recurly Solutions Manager will be assigned to gather your Snowflake credentials and configure the secure data share. With updates every hour or daily, you're assured up-to-date data. Together, Recurly and Snowflake provide a clear view of your business operations. For more details, refer to Recurly's official documentation.

How the integration works

Recurly uses Snowflake's secure data sharing to push your full export dataset directly into your Snowflake account. This eliminates the need for traditional import processes — no data copying, no manual transfers. Updates run every hour or daily depending on your configuration.

The integration includes all Recurly exports, with two exceptions: the deprecated invoices and revenue recognition schedules exports are not included.

Schema notes

The schema mirrors the standard Recurly exports with the following differences:

All timestamps are in UTC
Custom fields appear as a JSON object in the custom_fields column instead of separate columns
Additional status columns on accounts and subscriptions mirror the export settings available in the UI
An export_id column is included to ensure data integrity

Data refresh

Frequency: Daily or hourly — configured during setup
Daily refresh timing: Starts at 07:00 UTC; may take several hours to complete and isn't configurable
Guaranteed completion: Daily refresh finish times aren't guaranteed — if timing is critical, opt for hourly refreshes
Historical data: All historical data is available from the start — if you have ten years of data in Recurly, all ten years appear in the Snowflake share

Schema changes

New tables are added to the share automatically. New columns are appended to the end of existing tables. For any breaking changes — such as a column drop — Recurly communicates well in advance. During a schema change, the affected table may be momentarily unavailable; implement retry logic in any downstream processes that depend on real-time availability.

Time zone support

All timestamps are stored in UTC. Use Snowflake's built-in time zone conversion features to adapt them for your analytics use cases.

Integration guide

The Snowflake integration is set up and managed by Recurly's Professional Services team.

Contact your account manager

Reach out to your Recurly Account Manager to request enablement of the Snowflake integration.

Work with a Solutions Manager

A Recurly Solutions Manager will be assigned to gather your Snowflake credentials and configure the secure data share on your behalf.

Data flows automatically

Once configured, your Recurly data exports to Snowflake on your chosen schedule — hourly or daily — with no ongoing maintenance required.

FAQs

Which tables are included in the exports?

All Recurly exports are included, except for the deprecated invoices and revenue recognition schedules exports.

What is the schema for each table?

The schema mirrors the standard Recurly exports with a few differences: all timestamps are in UTC; custom fields appear as a JSON object in the custom_fields column instead of separate columns; additional status columns on accounts and subscriptions mirror the export UI settings; and an export_id column is included for data integrity.

What historical data is included?

All historical data is available. If you have ten years of data in Recurly, all ten years are available in the Snowflake share from day one.

How are schema changes managed?

New tables are added automatically, and new columns are appended to the end of existing tables. For breaking changes — such as a column drop — Recurly communicates well in advance. During a schema change, the affected table may be momentarily unavailable, so implement retry logic in any downstream processes that depend on it.

How frequently does data refresh?

Data refreshes either daily or hourly, depending on your configuration.

When do daily refreshes run, and can I adjust the timing?

Daily refreshes begin at 07:00 UTC and may take several hours to complete. The refresh time isn't configurable.

Is there a guaranteed finish time for daily refreshes?

No — daily refresh finish times aren't guaranteed. If timing is critical for your workflows, opt for hourly refreshes instead.

Can I change the time zone of the timestamps?

All timestamps are stored in UTC, but Snowflake's built-in time zone conversion features let you adapt them for any analytics use case.