Data Model
The CData ODBC Driver for Airtable models Airtable bases as easy-to-use SQL databases with tables, views, and stored procedures. Live connectivity to these objects means any changes to your Airtable account are immediately reflected when using the driver.
The Information schema Views section, which lists read-only SQL tables, contains samples of what you might have access to in your Airtable account.
The views included with the driver Information schema are:
| View | Description |
| Bases | Retrieves a list of all bases the authenticated user has access to in Airtable, including their identifiers, names, and associated permissions. |
| GroupCollaborators | Retrieves a list of collaborators in a specific Airtable group, including their identifiers, display names, permission levels, and whether base access is granted directly or inherited from workspace permissions. |
| GroupMembers | Retrieves a list of members belonging to a specific Airtable user group, including their unique identifiers and associated group information. |
| Groups | Retrieves a list of user groups within an Airtable workspace, including their unique identifiers and display names. |
| IndividualCollaborators | Retrieves a list of individual collaborators for Airtable bases and workspaces, including their identifiers, contact details, permission levels, and whether base access is granted directly or inherited from workspace permissions. |
| Tables | Retrieves a list of tables available in Airtable bases, including their identifiers, names, descriptions, primary fields, associated fields, and related views. |
| Users | Retrieves a list of Airtable users, including their identifiers, status, names, creation dates, and associated groups. |
The driver exposes each Airtable base as a separate schema. SampleBase is an example of a base schema.
Batch Processing
The driver supports batch INSERT, UPDATE, and DELETE operations for regular Airtable tables. Batch statements, INSERT statements with multiple VALUES rows, and UPDATE and DELETE statements with multiple keys are submitted to Airtable in bulk requests of at most 10 records for INSERT and 25 records for UPDATE and DELETE.
For example, the following statement creates three records in a single request:
INSERT INTO [SampleTable] ([Name]) VALUES ('Row 1'), ('Row 2'), ('Row 3')
Similarly, the following statement updates both records in a single request:
UPDATE [SampleTable] SET [Name] = 'New name' WHERE [Internal_Id] IN ('recRWPyEzoSjl5x9X', 'recyDboB1k4Pl3oei')
The following statement deletes both records in a single request:
DELETE FROM [SampleTable] WHERE [Internal_Id] IN ('recRWPyEzoSjl5x9X', 'recyDboB1k4Pl3oei')
Only regular Airtable tables support bulk requests. Batch operations on any other table, such as the attachment and collaborator child tables (for example, SampleTable_Attachments) or the Information schema views, are executed one row at a time. See BatchSize for details on how the rows of a batch are split into requests.