Skip to main content

all_user_names

Supported Signatures
πŸ”— Official Documentation

current_account

Supported Signatures
πŸ”— Official Documentation

current_account_name

Supported Signatures
πŸ”— Official Documentation

current_available_roles

Supported Signatures
πŸ”— Official Documentation

current_client

Returns the current client version. Supported Signatures
πŸ”— Official Documentation

current_database

Returns the current database. Supported Signatures
πŸ”— Official Documentation

current_date

Returns the current date. Supported Signatures
πŸ”— Official Documentation

current_ip_address

Returns the Client Internet Protocol address (IP address) of the current request. Supported Signatures
πŸ”— Official Documentation

current_organization_name

Returns the name of the organization the current account belongs to. Supported Signatures
πŸ”— Official Documentation

current_region

Returns the current region name. Supported Signatures
πŸ”— Official Documentation

current_role

Returns the currently active role name. Supported Signatures
πŸ”— Official Documentation

current_role_type

Returns if the current role is of type account or database Supported Signatures
πŸ”— Official Documentation

current_schema

Returns the current schema. Supported Signatures
πŸ”— Official Documentation

current_schemas

Returns active search path schemas Supported Signatures
πŸ”— Official Documentation

current_secondary_roles

Returns the currently active secondary roles’ names. Supported Signatures
πŸ”— Official Documentation

current_session

Returns the current session. Supported Signatures
πŸ”— Official Documentation

current_statement

Returns the text of the currently executing statement. Supported Signatures
πŸ”— Official Documentation

current_time

Returns the current time. Supported Signatures
πŸ”— Official Documentation

current_timestamp

Returns the current timestamp. Supported Signatures
πŸ”— Official Documentation

current_transaction

Returns the transaction id of an open transaction in the current session or scope. Supported Signatures
πŸ”— Official Documentation

current_user

Returns the current user name. Supported Signatures
πŸ”— Official Documentation

current_version

Returns the current software version (major.minor.patch). Supported Signatures
πŸ”— Official Documentation

current_warehouse

Returns the warehouse currently in use. Supported Signatures
πŸ”— Official Documentation

getdate

Returns the current timestamp Supported Signatures
πŸ”— Official Documentation

getvariable

Supported Signatures
πŸ”— Official Documentation

invoker_role

Returns the invoker role Supported Signatures
πŸ”— Official Documentation

invoker_share

Returns the invoker role Supported Signatures
πŸ”— Official Documentation

is_database_role_in_session

Return true if the db role is in current role hierarchy Supported Signatures
πŸ”— Official Documentation

is_granted_to_invoker_role

Returns true if the arg is in invoker_role’s hierarchy Supported Signatures
πŸ”— Official Documentation

is_role_in_session

Return true if in current hierarchy Supported Signatures
πŸ”— Official Documentation

last_query_id

Returns the id of the last executed statement in the current session. Supported Signatures
πŸ”— Official Documentation

last_transaction

Returns the transaction id of the last committed or rolled back transaction in the current session. Supported Signatures
πŸ”— Official Documentation

localtime

Returns the current time. Supported Signatures
πŸ”— Official Documentation

localtimestamp

Returns the current timestamp. Supported Signatures
πŸ”— Official Documentation

sysdate

Returns the current timestamp in the UTC time zone Supported Signatures
πŸ”— Official Documentation

systimestamp

Returns the current timestamp Supported Signatures
πŸ”— Official Documentation