From within Airtable, click the profile icon in the top right and select Account. Or click here.
2.
Scroll to the API section. If this is your first time using the API, you'll need to create an API key. Once created, click the box and copy the API key. You'll need that in a minute.
Note: Census's permissions will be the same as this Airtable user. If you think this Airtable user's permissions may change or the account is removed, you may want to create a special Airtable account just for Census to use.
Here you will have to write SQL queries to select the data you want to see in Airtable. Here are some ideas of data you should select.
Orders that to fulfill
Expenses to review
Customer feature requests to prioritize
Once you have created your model, click Save.
5. Create your first Sync
Now head to the Sync page and click the Add Sync button.
In the " What data do you want to sync?" section
For the Connection, select the data warehouse you connected in step 3
For the Source, select the model you created in step 4
Next up is the "Where do you want to sync data to?" section
Pick the name of Airtable from step 2 as the Connection
For Object, pick the table you want to sync data to
For the " How should changes to the source be synced?" section
Select your preferred behavior from the following:
Update only is a great place to start if you have data in Airtable!
Update or Create is great for sending data from the warehouse into Airtable.
Mirror keeps Airtable in sync with the warehouse. Update records, insert missing, and delete removed ones from Airtable
Pick the right mapping key, Airtable only allows a text type from their tables. We recommend you use your own unique id from the database if possible.
Finally, select the fields you want to update in the Mapper in the "Which Fields should be updated?" section.
Here simply map the field from your Airtable instance to the column from your model.
The end result should look something like this:
Click the Next button to see the final preview which will have a recap of what will happen when you start the sync.
6. Confirm the data is in Airtable
Now go back to your Airtable and go view the table object that should have been updated. If everything went well, you should see your data in the table
That's it! In 6 steps, you've connected Airtable and started syncing orders data from your warehouse 🎉
🗄 Supported Objects
Airtable support is pretty straight forward!
Object Name
Supported?
Table
✅
Airtable needs a primary key that is a short text field for Census to be able to join from a source table (though the source can be a numerical type).