We have a large volume of data in two tables (Facilities and Users) that we’ve imported via a HyperDB. We want to make routine updates from our company data lake into these two Airtable tables. There is linked data between our two tables (Facilities, Users). The updates don’t have to be instant - once daily or even a little less frequently is ok. It looks like this won’t be able to be done via a script - that it will require manual intervention via the browser tools, is this correct? Thanks in advance. Trying to point our development team in the right direction and are also open to help.
Question
Best approach for syncing updates from an external source to multiple tables in Airtable
+2Hi
A couple of questions to better understand your setup. What does your data lake run on? And when you say updates, are you mostly adding new records, updating existing ones, or both?
Leo from UseEfficiently
Hi
As for the plan:
The records will need updates to the existing ones as well as net new records being brought into our base. We plan to synchronize using Airtable's published synchronization APIs, using our custom automations.
What we are concerned about:
Airtable's synchronization APIs leave many manual steps required for the users to complete, some of them requiring admin users to complete them before data can flow.
Looking to see if there is an alternative workflow - one of our developers asked if perhaps we can use MoveIT or sftp integration?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.