Airtable

The Airtable connector is a Palantir-provided driver for Airtable.

To create a new Airtable source, follow the standard setup flow for Palantir-provided drivers, then use the sections below for Airtable-specific configuration and networking. For the complete property reference, see the official Airtable driver documentation ↗.

Supported capabilities

CapabilityStatus
Exploration🟢 Generally available
Batch syncs🟢 Generally available
Incremental🟢 Generally available
OAuth 2.0 authentication🟢 Generally available
Table exports🟢 Generally available

Configuration

The properties below are mandatory or recommended.

PropertyRequired?DescriptionDefault
DisplayValueMandatorySpecifies the value format.FormattedValue
AuthSchemeRecommendedThe type of authentication to use when connecting to Airtable.PersonalAccessToken
BaseIdRecommendedId of the base. This property is not required when the Metadata API is enabled, but specifying it restricts the metadata that will be retrieved.
BaseNameRecommendedThe schema to use - which corresponds to the name of the Base in Airtable. This property is only used when the Metadata API is enabled.
DisplayObjectIdsRecommendedBoolean determining if schema, table, view and column names should be replaced by their corresponding internal ID.FALSE
InitiateOAuthRecommendedSpecifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working.REFRESH
OAuthAccessTokenRecommendedA token received after authentication to the OAuth network, granting the user access. The access token is used in place of the user's login ID and password, which stay on the server.
OAuthClientIdRecommendedSpecifies the client Id that was assigned when the custom OAuth application was created. (Also known as the consumer key.) This ID registers the custom application with the OAuth authorization server.
OAuthClientSecretRecommendedSpecifies the client secret that was assigned when the custom OAuth application was created. (Also known as the consumer secret). This secret registers the custom application with the OAuth authorization server.
UseSimpleNamesRecommendedBoolean determining if simple names should be used for tables and columns.FALSE

Networking

The table below lists the domains that the source must be able to access to run.

For each domain, add a corresponding egress policy. If the source is hosted on-premises and not directly reachable from Foundry, use an agent proxy egress policy instead. The agent host itself must also be able to reach the listed domains. See using an agent as a proxy for details.

DomainRequired
api.airtable.comAlways
airtable.comIf AuthScheme=OAuthPKCE

OAuth 2.0 authentication

This connector supports OAuth 2.0 authentication. Follow the OAuth 2.0 guidance for Palantir-provided drivers to configure and authorize the connection.

Table exports

This connector supports table exports. Learn how to set up a table export.