Users

Retrieves a list of Airtable users, including their identifiers, status, names, creation dates, and associated groups.

View-Specific Information

Note: This view is only available to users with an Airtable Enterprise plan.

-- Retrieve all users
SELECT * FROM [Information].[Users]

-- Retrieve user emails and roles
SELECT Id, Email, Role FROM [Information].[Users];


Name	Type	Description
Id [KEY]	String	The unique identifier assigned to the Airtable user, used to reference the account in API calls and integrations.
Active	Bool	Indicates whether the user account is currently active or has been deactivated.
UserName	String	The username chosen by the user for their Airtable account.
GivenName	String	The given (first) name associated with the user’s profile.
FamilyName	String	The family (last) name associated with the user’s profile.
CreatedAt	Timestamp	The date and time when the user account was created in Airtable.
Groups	String	A JSON-formatted list of user groups the account is a member of, including each group’s identifiers and names.