CURRENT_AWS_ACCOUNT

Returns the AWS account associated with the Amazon Redshift cluster that submitted a query.

Syntax

current_aws_account

Return type

Returns an integer.

Example

The following query returns the name of the current database.

select user, current_aws_account; 
current_user | current_account
-------------+--------------- 
dwuser       | 987654321

(1 row)