Sync Airtable to Snowflake in Five Minutes

Having accurate and up-to-date information synced from Airtable to Snowflake is crucial for data operations and analytics.

However, there is no native integration between these two systems to make it happen.

Luckily, Polytomic enables fast data syncing between Airtable and Snowflake.

This blog post will explore how you can use Polytomic to set up a sync between Airtable and Snowflake in less than five minutes. No coding required.

Step 1 - Setup

Once you get started with Polytomic, the first thing you’ll do is connect Airtable and Snowflake to Polytomic.

To connect Airtable, just grab your Airtable API key from your Airtable account page under ‘API’, then enter your API key in Polytomic for instant connection.

To connect Snowflake and enable Polytomic to write to Snowflake, you will need to take the steps outlined on our docs page.

Once everything is connected to Polytomic, the next step is to create your data model.

Step 2 - Create a Bulk Sync

When syncing to a data warehouse like Snowflake, you will set up what is known as a bulk sync.

When setting up this bulk sync, you will choose the source system (Airtable in this case) and your destination (Snowflake in this case). You can then choose the Schema within Snowflake that you’d like to send the data to or create a new one.

You can then select the tables from Airtable that you’d like to have synced over. Most of our customers sync all of their tables in bulk (hence why it’s called a ‘bulk sync’), but you could also choose specific tables or even specific fields within those tables.

With all of the data selected, the last thing you need to do is choose your sync frequency. It could be continuous, hourly, daily, weekly, one-time, or based on a custom schedule.

Once saved, you can sync five random records to make sure everything is working as expected, and then turn on the sync to run according to the schedule you set.

And that’s it! Your data is now seamlessly flowing from Airtable to Snowflake.

Other Nice Features

Some other things we think you’ll love:

• Only sync data that has changed
• Minimal API usage
• Custom SQL queries
• Error detection and handling
• ‘Best Support’ in our category according to G2

Conclusion

With two quick steps, Polytomic makes it easy to have seamless data integration between Airtable and Snowflake.

Start today by getting a free trial.