Skip to main content
Version: 24.3.x

SYS.USERS

The sys.users table contains metadata for users in the Dremio instance.

Syntax
SELECT * 
FROM sys.users

Example Output

user_iduser_namefirst_namelast_namestatususer_typecreatedowner_idowner_typecreated_by
1ebd39a7-d571-4edb-b113-206eb263c775test.userTestUseractiveEXTERNAL2021-12-10 04:43:50.902empty textuserAUTO_SYNC
80702009-37c5-454c-93f2-ec41ea1722eddremio.adminGnarlyempty textactiveLOCAL2021-12-10 04:54:13.093empty textuserLOCAL
5aabeeae-8d3b-4dcc-ba04-051e5b08b11atest.user2empty textempty textinvitedEXTERNAL2021-10-05 18:07:32.377empty textuserSCIM

Fields

FieldData TypeDescription
user_idvarcharThe UUID to identify the user.
user_namevarcharThe username that is created by the user.
first_namevarcharThe first name of the user.
last_namevarcharThe last name of the user.
statusvarcharThe state of the user depending on if they have accepted the invite to the organization and have logged in to the application.
Enum: active, invited
user_typevarcharThe type of user based on how it was created.
Enum: EXTERNAL, LOCAL
createdtimestampThe timestamp for when the user was created.
owner_idvarcharThe UUID for the owner (user or role) of the user. This UUID corresponds to the user_id or role_id in the users or roles table.
owner_typevarcharThe type of owner of the user.
Enum: user, role
created_byvarcharThe method of creation.
Enum: LOCAL, AUTO_SYNC, SCIM