TDV Adapter for Airtable

Build 21.0.8137

Data Model

Overview

This section shows the available API objects and provides more information on executing SQL to Airtable APIs.

Key Features

  • The adapter models Airtable entities like documents, folders, and groups as relational views, allowing you to write SQL to query Airtable data.
  • The columns of the tables and views are heuristically discovered by scanning the records from the data source. The data types of the columns are also heuristically determined if the TypeDetectionScheme property is set to 'RowScan'.
  • Stored procedures allow you to execute operations to Airtable
  • Live connectivity to these objects means any changes to your Airtable account are immediately reflected when using the adapter.

Views

Driver will use TableNames and ViewNames connection properties to specify views of the current base. For each record in TableNames, will be generated two other views, named as "ViewName_Attachments" for exposing attachments information and "ViewName_Collaborations" for exposing collaborator information of the view. An example for this would be Sample table in Views

Collaborative Query Processing

The adapter offloads as much of the SELECT statement processing as possible to Airtable and then processes the rest of the query in memory. API limitations and requirements are also documented in this section.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137