Airtable and Snowflake are two of the big players in the modern databases ecosystem.
Their approach is quite different. Snowflake focus on data warehouse features allowing the management of enormous amounts of information in a faster and more flexible way than traditional databases. Airtable, on the other hand, is more similar to Excel on steroids, allowing to build powerful applications with a NoCode approach.
In this post we'll show how YepCode may be used to move information between these two SaaS, creatinga generic process that receives the following input parameters:
The process will start by opening the connection to Snowflake.
Then it will run the query in an asynchronous way (using JS promises).
When the query returns all the rows (or for each row in the streamed approach), it will create new entries in Airtable using the correct column mapping.
In this case, we are not doing a copy&paste of the full process code (as we have done in one previous post for Cryptocurrency dollar-cost averaging sample. Here, we only reference a public view of the process that is already created in our Sandbox account.
From that public page, you couldn't run the sample, but you only have to create your own YepCode account and create the needed Airtable and Snowflake credentials to start to use it!