Snowflake - Scalar Functions - Context Functions - Part 3

Опубликовано: 07 Август 2026
на канале: Generative AI and Technology

201

GitHub Code - https://github.com/sardetushar/Snowfl...

This video covers following Snowflake Context Functions
1. General Context

CURRENT_CLIENT
CURRENT_DATE
CURRENT_IP_ADDRESS
CURRENT_REGION
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_VERSION
LOCALTIME - CURRENT_TIME.
LOCALTIMESTAMP - CURRENT_TIMESTAMP.
SYSDATE

2. Session Context

ALL_USER_NAMES
CURRENT_ACCOUNT
CURRENT_ROLE
CURRENT_AVAILABLE_ROLES
CURRENT_SESSION
CURRENT_STATEMENT
CURRENT_TRANSACTION
CURRENT_USER
LAST_QUERY_ID
LAST_TRANSACTION

3. Session Object Context

CURRENT_DATABASE
CURRENT_SCHEMA
CURRENT_SCHEMAS
CURRENT_WAREHOUSE
INVOKER_ROLE
INVOKER_SHARE
IS_GRANTED_TO_INVOKER_ROLE
IS_ROLE_IN_SESSION

/************************************************************************************
REF - https://docs.snowflake.com/en/sql-ref...
************************************************************************************/