Introduction

Polytomic can sync data to a variety of destinations:

Data warehouses and databases like Snowflake, Databricks, BigQuery, Redshift, PostgreSQL, MySQL, MongoDB, and others.
Business applications like Salesforce, Marketo, HubSpot, Intercom, Stripe, and others.
Cloud storage buckets like Amazon S3, Google Cloud Storage, and Azure Blob Storage
Spreadsheet applications like Google Sheets, Airtable, Smartsheets, and Monday.com.
Arbitrary webhooks.

Sync types

There are two types of syncs you can create:

1. Bulk syncs

Bulk syncs are for syncing data (whether CDC streaming from other databases, or SaaS applications, or spreadsheets) into data warehouses, databases, and cloud storage systems like Amazon S3 (this is the ELT pattern: extract, load, and transform). All schema migrations in your destination are handled automatically.

2. Model syncs

Model syncs are for all other use cases. For example:

Syncing from your databases and data warehouses into business applications like Salesforce, HubSpot, and such (otherwise known as the Reverse ETL pattern).
Persisting SQL transformations on your data warehouse into new tables (sometimes called persistent derived tables).
Syncing between SaaS applications. For example, moving data in either direction between Salesforce and NetSuite, HubSpot and Zendesk, and so on (often referred to as iPaaS).

Creating a sync

Creating a sync is a five-step process:

Select your sync type (Model Sync or Bulk Sync, based on the guidelines above).
Select your source and destination.
Select the data to sync.
Specify a sync schedule.
Save your selections.