Upgrading Airtable data connections
Who can use this feature?
👤 Available onall plansand is free. Upgrades are only required for Airtable data connections in workspaces created before the 10th of April. Workspaces created after this date are already upgraded.
Airtable data connection upgrade explained
Airtable data connections in Stacker use Airtable API keys. Upgrading your Airtable connections means that your Airtable data connection will use a new authentication method.
The upgrade will also give your apps new functionality, for example such as real time data sync between your Airtable base and Stacker, also known as real time Airtable sync. Read more about real time Airtable sync here.
Aside from getting real time updates, it is important to upgrade because Airtable is deprecating their API keys on the 1st of February 2024. In other words, you will need to upgrade for your apps to continue working.
The upgrade is free, and does not change your data structure or layouts.
Note: Any Airtable data connections created in workspaces created after the 10th of April already use the new authentication method, and do not need to be upgraded. \
Better security
The new authentication methods also provide a higher standard for security, as compared to API keys. You can see more in this article from Airtable.
Personal Access Tokens and OAuth provide a higher standard for security over API Keys, which were the predecessor that provided “all-or-nothing” access over everything that an Airtable user account could see or do. These new methods have more granular control of resources and scopes and allow you to extend Airtable, all while ensuring the highest grade of security.
How to upgrade
You will need to upgrade each data connection separately, and only takes a few minutes. See the video below, or follow the instructions here:
Click App Settings
Under Data Sources, click the Upgrade button
Follow the flow which directs you to Airtable to grant access to Stacker
We suggest you pick “All current and future bases in all current and future workspaces” in the dropdown, so that you do not have to go through the full upgrade flow for future data connections. After granting access you will be redirected to Stacker.
Click Grant access
This Airtable base is not accessible error showing on the top of the data grid or the app settings page means that your Airtable data connection has lost access to Stacker.
You will need to repair your Airtable data connection if:
The token is still valid but no longer provides access to the base it is connected to. For example, you've adjusted the permission of the token to no longer include the base.
The token is no longer valid. For example, the token was revoked in Airtable.
The data connection has no token assigned. For example, the Stacker user who set up the data connection has been removed from Stacker.
To fix your data connection, you will need to Repair the data connection from the app settings page in Stacker:
Go to App Settings
Click Data Sources
Find the data connection that says This Airtable base is not accessible
Click the Repair button
Depending on the reason for repair, you may be asked to either re-authenticate your data connection, or adjust the permissions of your token.
Re-authenticate Airtable Connection
If you need to re-authenticate, you will be guided to Airtable to grant access to Stacker:
Pick “All current and future bases in all current and future workspaces” in the dropdown, so that you do not have to go through the full upgrade flow for future data connections
Click Grant access
Your data source should be repaired with no error message
Adjust token permissions in Airtable
If you are asked to adjust the permissions of your token, you will be shown this video after clicking Repair. The video will walk you through the steps to adjust permissions:
From the Repair modal, click on the word Airtable to be navigated to Airtable in a new tab.
In Airtable, click your profile image in the top right-hand corner
Click Integrations in the dropdown menu
Click Third-party integrations
Click Stacker
Under All Workspaces, check that the base you are using in Stacker is available.
Change the permissions to All current and future bases in all current and future workspaces
Navigate back to Stacker and click Try Again
Your data source should be repaired with no error message
Troubleshooting
If this does not repair your data connector:
Your Airtable account may not have access to the base of the data connector. If this is the case, contact the owner of the base and ask them to share the base with you, or ask them to go through the repair flow.
The base may no longer exist—it may have been deleted. In this case, we are unable to repair the data connection.