Member-only story
Clone data in Airtable bases with Sync Tables!
Finally, Airtable introduced a way how to natively synchronize data between bases.
Moving data between Airtable bases was one of the most requested features for a long time. Very often you might have sensitive information in some tables of your base and you might not be willing to provide access to all of its entirety. Previously the solution to clone data out of one base into another was to use external tools such as Zapier or Integromat to clone it. You can read here an article about copying Airtable data between bases using Integromat.
The Integromat solution might still be a viable option if you are on the Free Airtable plan. Free Airtable plan allows 1 sync table and you need to sync it manually. The Pro plan on Airtable allows for up to 20 sync tables per base and has an automatic syncing capability.
Creating a synced view
Sync tables in Airtable work based on views, so you need to create first a view of data that you would like to transfer to another Airtable base.
Usually, you would use a filtered view to show for example products belonging only to 1 category or group.