Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
CURRENT_USER
Returns the user name of the current "effective" user of the database, as applicable to checking permissions. Usually, this user name will be the same as the session user; however, this can occasionally be changed by superusers.
Note
Do not use trailing parentheses when calling CURRENT_USER.
Syntax
current_user
Return type
CURRENT_USER returns a NAME data type and can be cast as a CHAR or VARCHAR string.
Usage notes
If a stored procedure was created using the SECURITY DEFINER option of the CREATE_PROCEDURE command, when invoking the CURRENT_USER function from within the stored procedure, Amazon Redshift returns the user name of the owner of the stored procedure.
Example
The following query returns the name of the current database user:
select current_user; current_user -------------- dwuser (1 row)