session_user function

Applies to: Databricks SQL Databricks Runtime 14.1 and above

Returns the user connected to Azure Databricks.

Note

The SQL standard differentiates between CURRENT_USER and SESSION_USER. In Databricks SQL and Databricks Runtime 14.1 and above you should use SESSION_USER instead of CURRENT_USER or USER.

Syntax

session_user()

Arguments

This function takes no arguments.

Returns

A STRING.

The braces are optional.

Note

When called by a service principal, this function returns the UUID of the service principal instead of a readable name.

Examples

> SELECT session_user();
 user1

> SELECT session_user;
 user1

Related functions

• is_member function
• current_user function
• user function