Connector Improvement: Airtable connector - give users more control of the data warehouse destination
AnsweredRight now the Airtable connector is setup so that an Airtable base gets copied to a data warehouse schema. However, if you have lots of Airtable bases, that means that you will have lots of schemas. Instead it would be great if you could specify the Airtable base-table to data warehouse schema-table mapping directly. That would also limit the amount of data that gets copied into your data warehouse, as you could copy just a single Airtable base-table instead of all.
-
Official comment
Hi David -
Thanks for submitting this feature request. At this time we don't have a plan to change the airbase to schema ratio, however it's definitely a worthwhile improvement and i will monitor for demand for this feature.
Best,
Erin
-
The Airtable connector creates too many schemas in destination. The design should be to have schema for each "workspace" in Airtable and all the "BASES" ( equivalent to tables in database ) should be created in respective "workspace" schema. This is really urgent requirement for us.
the current design is not sustainable for us since we have 50+users in Airtable and if they create multiple bases in each of their workspaces, there would be 100s of schemas in our destination. that sounds like a bug and it needs to be fixed ASAP.thank you,
Nitin Kudre
Please sign in to leave a comment.
Comments
2 comments