Skip to main content

SHOW USERS

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Lists the users that match an optionally supplied regular expression pattern. If you don't supply a pattern, the command lists all the users in the system.

Syntax​

SHOW USERS [ [ LIKE ] pattern_expression ]

Parameters​

  • pattern_expression

    A limited pattern expression that is used to filter the results of the statement.

    • The * character is used at the start and end of a pattern to match on a substring.
    • The * character is used only at end of a pattern to match the start of a username.
    • The | character is used to separate multiple different expressions, any of which can match.
    • The pattern match is case-insensitive.

Returns​

A result set with the following columns:

  • name STRING NOT NULL

    The name of the principal.

The result set is truncated to 10,000 rows.

Examples​

SQL
-- Lists all users.
> SHOW USERS;
               name
 ------------------
  user1@example.com
  user2@example.com
  user3@example.com

-- Lists users with name containing with string pattern `SEr`
> SHOW USERS LIKE '*SEr*';
               name
 ------------------
  user1@example.com
  user2@example.com
  user3@example.com

-- Lists users with name containing 1 or `3`
SHOW USERS LIKE '*1*|*3*';
               name
 ------------------
  user1@example.com
  user3@example.com
Last updated on