Context Functions
all_user_names
Supported Signatures
function all_user_names() returns array
current_account
Supported Signatures
function current_account() returns string
current_account_name
Supported Signatures
function current_account_name() returns string
current_available_roles
Supported Signatures
function current_available_roles() returns string
current_client
Returns the current client version. Supported Signatures
function current_client() returns varchar
function current_client() returns string
current_database
Returns the current database. Supported Signatures
function current_database() returns varchar
current_date
Returns the current date. Supported Signatures
function current_date() returns date
current_ip_address
Returns the Client Internet Protocol address (IP address) of the current request. Supported Signatures
function current_ip_address() returns varchar
current_organization_name
Returns the name of the organization the current account belongs to. Supported Signatures
function current_organization_name() returns varchar
current_region
Returns the current region name. Supported Signatures
function current_region() returns varchar
current_role
Returns the currently active role name. Supported Signatures
function current_role() returns varchar
current_role_type
Returns if the current role is of type account or database Supported Signatures
function current_role_type() returns varchar
current_schema
Returns the current schema. Supported Signatures
function current_schema() returns varchar
current_schemas
Returns active search path schemas Supported Signatures
function current_schemas() returns varchar
current_secondary_roles
Returns the currently active secondary roles’ names. Supported Signatures
function current_secondary_roles() returns varchar
current_session
Returns the current session. Supported Signatures
function current_session() returns varchar
current_statement
Returns the text of the currently executing statement. Supported Signatures
function current_statement() returns varchar
current_time
Returns the current time. Supported Signatures
function current_time() returns time
function current_time(decimal(38, 0)) returns time
current_timestamp
Returns the current timestamp. Supported Signatures
function current_timestamp() returns timestamp
function current_timestamp(decimal(38, 0)) returns timestamp
current_transaction
Returns the transaction id of an open transaction in the current session or scope. Supported Signatures
function current_transaction() returns decimal(38, 0)
current_user
Returns the current user name. Supported Signatures
function current_user() returns varchar
current_version
Returns the current software version (major.minor.patch). Supported Signatures
function current_version() returns varchar
current_warehouse
Returns the warehouse currently in use. Supported Signatures
function current_warehouse() returns varchar
getdate
Returns the current timestamp Supported Signatures
function getdate() returns timestamp
getvariable
Supported Signatures
function getvariable(string) returns string
invoker_role
Returns the invoker role Supported Signatures
function invoker_role() returns varchar
invoker_share
Returns the invoker role Supported Signatures
function invoker_share() returns varchar
is_database_role_in_session
Return true if the db role is in current role hierarchy Supported Signatures
function is_database_role_in_session(varchar) returns boolean
is_granted_to_invoker_role
Returns true if the arg is in invoker_role’s hierarchy Supported Signatures
function is_granted_to_invoker_role(varchar) returns boolean
is_role_in_session
Return true if in current hierarchy Supported Signatures
function is_role_in_session(varchar) returns boolean
last_query_id
Returns the id of the last executed statement in the current session. Supported Signatures
function last_query_id() returns varchar
function last_query_id(decimal(38, 0)) returns varchar
last_transaction
Returns the transaction id of the last committed or rolled back transaction in the current session. Supported Signatures
function last_transaction() returns decimal(38, 0)
localtime
Returns the current time. Supported Signatures
function localtime() returns time
function localtime(decimal(38, 0)) returns time
localtimestamp
Returns the current timestamp. Supported Signatures
function localtimestamp() returns timestamp
function localtimestamp(decimal(38, 0)) returns timestamp
sysdate
Returns the current timestamp in the UTC time zone Supported Signatures
function sysdate() returns timestamp
systimestamp
Returns the current timestamp Supported Signatures
function systimestamp() returns timestamp