Data Model
The CData Excel Add-In 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 add-in.
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 add-in 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 add-in exposes each Airtable base as a separate schema. SampleBase is an example of a base schema.