ADO.NET Provider for Airtable

Build 21.0.7930

Data Model

Overview

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

Key Features

  • The provider models Airtable entities like documents, folders, and groups as relational views, allowing you to write SQL to query Airtable data.
  • 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 provider.

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 provider 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.

See SupportEnhancedSQL for more information on how the provider circumvents API limitations with in-memory client-side processing.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930