Security functions

GoogleSQL for BigQuery supports the following security functions.

Function list

SESSION_USER

  SESSION_USER 
 () 
 

Description

For first-party users, returns the email address of the user that's running the query. For third-party users, returns the principal identifier of the user that's running the query. For more information about identities, see Principals .

Return Data Type

STRING

Example

  SELECT 
  
 SESSION_USER 
 () 
  
 as 
  
 user 
 ; 
 /*----------------------+ 
 | user                 | 
 +----------------------+ 
 | jdoe@example.com     | 
 +----------------------*/