Skip to main content

​
all_user_names

Supported Signatures 
function all_user_names() returns array
🔗 Official Documentation

​
current_account

Supported Signatures 
function current_account() returns string
🔗 Official Documentation

​
current_account_name

Supported Signatures 
function current_account_name() returns string
🔗 Official Documentation

​
current_available_roles

Supported Signatures 
function current_available_roles() returns string
🔗 Official Documentation

​
current_client

Returns the current client version. Supported Signatures 
function current_client() returns varchar
🔗 Official Documentation

​
current_database

Returns the current database. Supported Signatures 
function current_database() returns varchar
🔗 Official Documentation

​
current_date

Returns the current date. Supported Signatures 
function current_date() returns date
🔗 Official Documentation

​
current_ip_address

Returns the Client Internet Protocol address (IP address) of the current request. Supported Signatures 
function current_ip_address() returns varchar
🔗 Official Documentation

​
current_organization_name

Returns the name of the organization the current account belongs to. Supported Signatures 
function current_organization_name() returns varchar
🔗 Official Documentation

​
current_region

Returns the current region name. Supported Signatures 
function current_region() returns varchar
🔗 Official Documentation

​
current_role

Returns the currently active role name. Supported Signatures 
function current_role() returns varchar
🔗 Official Documentation

​
current_role_type

Returns if the current role is of type account or database Supported Signatures 
function current_role_type() returns varchar
🔗 Official Documentation

​
current_schema

Returns the current schema. Supported Signatures 
function current_schema() returns varchar
🔗 Official Documentation

​
current_schemas

Returns active search path schemas Supported Signatures 
function current_schemas() returns varchar
🔗 Official Documentation

​
current_secondary_roles

Returns the currently active secondary roles’ names. Supported Signatures 
function current_secondary_roles() returns varchar
🔗 Official Documentation

​
current_session

Returns the current session. Supported Signatures 
function current_session() returns varchar
🔗 Official Documentation

​
current_statement

Returns the text of the currently executing statement. Supported Signatures 
function current_statement() returns varchar
🔗 Official Documentation

​
current_time

Returns the current time. Supported Signatures 
function current_time() returns time
function current_time(decimal(38, 0)) returns time
🔗 Official Documentation

​
current_timestamp

Returns the current timestamp. Supported Signatures 
function current_timestamp() returns timestamp
function current_timestamp(decimal(38, 0)) returns timestamp
🔗 Official Documentation

​
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)
🔗 Official Documentation

​
current_user

Returns the current user name. Supported Signatures 
function current_user() returns varchar
🔗 Official Documentation

​
current_version

Returns the current software version (major.minor.patch). Supported Signatures 
function current_version() returns varchar
🔗 Official Documentation

​
current_warehouse

Returns the warehouse currently in use. Supported Signatures 
function current_warehouse() returns varchar
🔗 Official Documentation

​
getdate

Returns the current timestamp Supported Signatures 
function getdate() returns timestamp
🔗 Official Documentation

​
getvariable

Supported Signatures 
function getvariable(string) returns string
🔗 Official Documentation

​
invoker_role

Returns the invoker role Supported Signatures 
function invoker_role() returns varchar
🔗 Official Documentation

​
invoker_share

Returns the invoker role Supported Signatures 
function invoker_share() returns varchar
🔗 Official Documentation

​
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
🔗 Official Documentation

​
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
🔗 Official Documentation

​
is_role_in_session

Return true if in current hierarchy Supported Signatures 
function is_role_in_session(varchar) returns boolean
🔗 Official Documentation

​
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
🔗 Official Documentation

​
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)
🔗 Official Documentation

​
localtime

Returns the current time. Supported Signatures 
function localtime() returns time
function localtime(decimal(38, 0)) returns time
🔗 Official Documentation

​
localtimestamp

Returns the current timestamp. Supported Signatures 
function localtimestamp() returns timestamp
function localtimestamp(decimal(38, 0)) returns timestamp
🔗 Official Documentation

​
sysdate

Returns the current timestamp in the UTC time zone Supported Signatures 
function sysdate() returns timestamp
🔗 Official Documentation

​
systimestamp

Returns the current timestamp Supported Signatures 
function systimestamp() returns timestamp
🔗 Official Documentation