Data Model
The CData ADO.NET Provider 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 provider.
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 provider 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 provider exposes each Airtable base as a separate schema. SampleBase is an example of a base schema.