SQL Functions Coverage

Overview

This table provides a list of all Snowflake system-defined SQL functions, scalar or table, emulated by LocalStack. The content will be updated as additional query features and functions are implemented.

Function	Supported
ABS	✅
ACOS	✅
ACOSH	✅
ADD_MONTHS	✅
AI_AGG	❓
AI_CLASSIFY	❓
AI_COMPLETE (Prompt object)	❓
AI_COMPLETE (Single image)	❓
AI_COMPLETE (Single string)	❓
AI_COMPLETE	❓
AI_COUNT_TOKENS	❓
AI_EMBED	❓
AI_EXTRACT	❓
AI_FILTER	❓
AI_PARSE_DOCUMENT	❓
AI_SENTIMENT	❓
AI_SIMILARITY	❓
AI_SUMMARIZE_AGG	❓
AI_TRANSCRIBE	❓
AI_TRANSLATE	❓
ALERT_HISTORY	❓
ALL_USER_NAMES	❓
ANY_VALUE	✅
APPLICATION_JSON	❓
APPLICATION_SPECIFICATION_STATUS_HISTORY	❓
APPROX_COUNT_DISTINCT	❓
APPROX_PERCENTILE	❓
APPROX_PERCENTILE_ACCUMULATE	❓
APPROX_PERCENTILE_COMBINE	❓
APPROX_PERCENTILE_ESTIMATE	❓
APPROX_TOP_K	❓
APPROX_TOP_K_ACCUMULATE	❓
APPROX_TOP_K_COMBINE	❓
APPROX_TOP_K_ESTIMATE	❓
APPROXIMATE_JACCARD_INDEX	❓
APPROXIMATE_SIMILARITY	❓
ARRAY_AGG	✅
ARRAY_APPEND	✅
ARRAY_CAT	✅
ARRAY_COMPACT	✅
ARRAY_CONSTRUCT	✅
ARRAY_CONSTRUCT_COMPACT	✅
ARRAY_CONTAINS	✅
ARRAY_DISTINCT	✅
ARRAY_EXCEPT	✅
ARRAY_FLATTEN	✅
ARRAY_GENERATE_RANGE	✅
ARRAY_INSERT	✅
ARRAY_INTERSECTION	✅
ARRAY_MAX	✅
ARRAY_MIN	✅
ARRAY_POSITION	✅
ARRAY_PREPEND	✅
ARRAY_REMOVE	✅
ARRAY_REMOVE_AT	✅
ARRAY_REVERSE	✅
ARRAY_SIZE	✅
ARRAY_SLICE	✅
ARRAY_SORT	✅
ARRAY_TO_STRING	✅
ARRAY_UNION_AGG	✅
ARRAY_UNIQUE_AGG	✅
ARRAYS_OVERLAP	✅
ARRAYS_TO_OBJECT	✅
ARRAYS_ZIP	✅
AS_<object_type>	❓
AS_ARRAY	✅
AS_BINARY	✅
AS_BOOLEAN	✅
AS_CHAR, AS_VARCHAR	✅
AS_DATE	❓
AS_DECIMAL, AS_NUMBER	✅
AS_DOUBLE, AS_REAL	✅
AS_INTEGER	✅
AS_OBJECT	❓
AS_TIME	❓
AS_TIMESTAMP_*	❓
ASCII	✅
ASIN	✅
ASINH	✅
ATAN	✅
ATAN2	✅
ATANH	✅
AUTO_REFRESH_REGISTRATION_HISTORY	❓
AUTOMATIC_CLUSTERING_HISTORY	❓
AVAILABLE_LISTING_REFRESH_HISTORY	❓
AVG	✅
BASE64_DECODE_BINARY	❓
BASE64_DECODE_STRING	❓
BASE64_ENCODE	❓
[ NOT ] BETWEEN	✅
BIND_VALUES	❓
BIT_LENGTH	❓
BITAND	✅
BITAND_AGG	❓
BITMAP_BIT_POSITION	❓
BITMAP_BUCKET_NUMBER	❓
BITMAP_CONSTRUCT_AGG	❓
BITMAP_COUNT	❓
BITMAP_OR_AGG	❓
BITNOT	✅
BITOR	✅
BITOR_AGG	❓
BITSHIFTLEFT	✅
BITSHIFTRIGHT	✅
BITXOR	✅
BITXOR_AGG	❓
BOOLAND	❓
BOOLAND_AGG	❓
BOOLNOT	❓
BOOLOR	❓
BOOLOR_AGG	❓
BOOLXOR	❓
BOOLXOR_AGG	❓
BUILD_SCOPED_FILE_URL	❓
BUILD_STAGE_FILE_URL	❓
CASE	✅
CAST, ::	✅
CBRT	✅
CEIL	✅
CHARINDEX	❓
CHECK_JSON	❓
CHECK_XML	✅
CHR, CHAR	✅
CLASSIFY_TEXT (SNOWFLAKE.CORTEX)	❓
COALESCE	✅
COLLATE	❓
COLLATION	❓
COMPLETE (SNOWFLAKE.CORTEX) (multimodal)	❓
COMPLETE (SNOWFLAKE.CORTEX)	❓
COMPLETE_TASK_GRAPHS	❓
COMPRESS	❓
CONCAT, ||	✅
CONCAT_WS	❓
CONDITIONAL_CHANGE_EVENT	❓
CONDITIONAL_TRUE_EVENT	❓
CONTAINS	✅
CONVERT_TIMEZONE	✅
COPY_HISTORY	❓
CORR	❓
CORTEX_SEARCH_DATA_SCAN	❓
COS	✅
COSH	✅
COT	✅
COUNT	✅
COUNT_IF	✅
COUNT_TOKENS (SNOWFLAKE.CORTEX)	❓
COVAR_POP	❓
COVAR_SAMP	❓
CUME_DIST	❓
CUMULATIVE_PRIVACY_LOSSES	❓
CURRENT_ACCOUNT	✅
CURRENT_ACCOUNT_NAME	✅
CURRENT_AVAILABLE_ROLES	✅
CURRENT_CLIENT	✅
CURRENT_DATABASE	✅
CURRENT_DATE	✅
CURRENT_IP_ADDRESS	✅
CURRENT_ORGANIZATION_NAME	✅
CURRENT_ORGANIZATION_USER	✅
CURRENT_REGION	✅
CURRENT_ROLE	✅
CURRENT_ROLE_TYPE	✅
CURRENT_SCHEMA	✅
CURRENT_SCHEMAS	✅
CURRENT_SECONDARY_ROLES	✅
CURRENT_SESSION	✅
CURRENT_STATEMENT	✅
CURRENT_TASK_GRAPHS	✅
CURRENT_TIME	✅
CURRENT_TIMESTAMP	✅
CURRENT_TRANSACTION	✅
CURRENT_USER	✅
CURRENT_VERSION	✅
CURRENT_WAREHOUSE	✅
DATA_METRIC_FUNCTION_EXPECTATIONS	❓
DATA_METRIC_FUNCTION_REFERENCES	❓
DATA_QUALITY_MONITORING_EXPECTATION_STATUS	❓
DATA_QUALITY_MONITORING_RESULTS	✅
DATA_TRANSFER_HISTORY	❓
DATABASE_REFRESH_HISTORY	❓
DATABASE_REFRESH_PROGRESS, DATABASE_REFRESH_PROGRESS_BY_JOB	❓
DATABASE_REPLICATION_USAGE_HISTORY	❓
DATABASE_STORAGE_USAGE_HISTORY	❓
DATASKETCHES_HLL	❓
DATASKETCHES_HLL_ACCUMULATE	❓
DATASKETCHES_HLL_COMBINE	❓
DATASKETCHES_HLL_ESTIMATE	❓
DATE_FROM_PARTS	✅
DATE_PART	❓
DATE_TRUNC	✅
DATEADD	✅
DATEDIFF	✅
DAYNAME	✅
DECODE	❓
DECOMPRESS_BINARY	❓
DECOMPRESS_STRING	❓
DECRYPT	❓
DECRYPT_RAW	❓
DEGREES	✅
DENSE_RANK	✅
DIV0	✅
DIV0NULL	✅
ACCEPTED_VALUES (system data metric function)	❓
AVG (system data metric function)	❓
BLANK_COUNT (system data metric function)	❓
BLANK_PERCENT (system data metric function)	❓
DATA_METRIC_SCHEDULED_TIME (system data metric function)	❓
DUPLICATE_COUNT (system data metric function)	❓
FRESHNESS (system data metric function)	❓
MAX (system data metric function)	❓
MIN (system data metric function)	❓
NULL_COUNT (system data metric function)	❓
NULL_PERCENT (system data metric function)	❓
ROW_COUNT (system data metric function)	❓
STDDEV (system data metric function)	❓
UNIQUE_COUNT (system data metric function)	❓
DP_INTERVAL_HIGH	❓
DP_INTERVAL_LOW	❓
DYNAMIC_TABLE_GRAPH_HISTORY	❓
DYNAMIC_TABLE_REFRESH_HISTORY	❓
DYNAMIC_TABLES	❓
EDITDISTANCE	❓
EMAIL_INTEGRATION_CONFIG	❓
EMBED_TEXT_768 (SNOWFLAKE.CORTEX)	❓
EMBED_TEXT_1024 (SNOWFLAKE.CORTEX)	❓
ENCRYPT	❓
ENCRYPT_RAW	❓
ENDSWITH	✅
ENTITY_SENTIMENT (SNOWFLAKE.CORTEX)	❓
EQUAL_NULL	✅
ESTIMATE_REMAINING_DP_AGGREGATES	❓
EXP	✅
EXPLAIN_JSON	❓
EXTERNAL_FUNCTIONS_HISTORY	❓
EXTERNAL_TABLE_FILES	❓
EXTERNAL_TABLE_FILE_REGISTRATION_HISTORY	❓
EXTRACT	❓
EXTRACT_ANSWER (SNOWFLAKE.CORTEX)	❓
EXTRACT_SEMANTIC_CATEGORIES	❓
FACTORIAL	✅
FILTER	❓
FINETUNE (‘CANCEL’) (SNOWFLAKE.CORTEX)	❓
FINETUNE (‘CREATE’) (SNOWFLAKE.CORTEX)	❓
FINETUNE (‘DESCRIBE’) (SNOWFLAKE.CORTEX)	❓
FINETUNE (‘SHOW’) (SNOWFLAKE.CORTEX)	❓
FINETUNE (SNOWFLAKE.CORTEX)	❓
FIRST_VALUE	✅
FL_GET_CONTENT_TYPE	❓
FL_GET_ETAG	❓
FL_GET_FILE_TYPE	❓
FL_GET_LAST_MODIFIED	❓
FL_GET_RELATIVE_PATH	❓
FL_GET_SCOPED_FILE_URL	❓
FL_GET_SIZE	❓
FL_GET_STAGE	❓
FL_GET_STAGE_FILE_URL	❓
FL_IS_AUDIO	❓
FL_IS_COMPRESSED	❓
FL_IS_DOCUMENT	❓
FL_IS_IMAGE	❓
FL_IS_VIDEO	❓
FLATTEN	✅
FLOOR	✅
GENERATE_COLUMN_DESCRIPTION	❓
GENERATOR	✅
GET	✅
GET_ABSOLUTE_PATH	❓
GET_ANACONDA_PACKAGES_REPODATA	❓
GET_CONDITION_QUERY_UUID	❓
GET_CONTACTS	❓
GET_DDL	❓
GET_IGNORE_CASE	❓
GET_JOB_HISTORY	❓
GET_LINEAGE (SNOWFLAKE.CORE)	❓
GET_OBJECT_REFERENCES	❓
GET_PATH, :	✅
GET_PRESIGNED_URL	❓
GET_PYTHON_PROFILER_OUTPUT (SNOWFLAKE.CORE)	❓
GET_QUERY_OPERATOR_STATS	❓
GET_RELATIVE_PATH	❓
GET_STAGE_LOCATION	❓
GETBIT	❓
GETDATE	❓
GETVARIABLE	❓
GREATEST	✅
GREATEST_IGNORE_NULLS	✅
GROUPING	❓
GROUPING_ID	❓
H3_CELL_TO_BOUNDARY	❓
H3_CELL_TO_CHILDREN	❓
H3_CELL_TO_CHILDREN_STRING	❓
H3_CELL_TO_PARENT	❓
H3_CELL_TO_POINT	❓
H3_COMPACT_CELLS	❓
H3_COMPACT_CELLS_STRINGS	❓
H3_COVERAGE	❓
H3_COVERAGE_STRINGS	❓
H3_GET_RESOLUTION	❓
H3_GRID_DISK	❓
H3_GRID_DISTANCE	❓
H3_GRID_PATH	❓
H3_INT_TO_STRING	❓
H3_IS_PENTAGON	❓
H3_IS_VALID_CELL	❓
H3_LATLNG_TO_CELL	❓
H3_LATLNG_TO_CELL_STRING	❓
H3_POINT_TO_CELL	❓
H3_POINT_TO_CELL_STRING	❓
H3_POLYGON_TO_CELLS	❓
H3_POLYGON_TO_CELLS_STRINGS	❓
H3_STRING_TO_INT	❓
H3_TRY_COVERAGE	❓
H3_TRY_COVERAGE_STRINGS	❓
H3_TRY_GRID_DISTANCE	❓
H3_TRY_GRID_PATH	❓
H3_TRY_POLYGON_TO_CELLS	❓
H3_TRY_POLYGON_TO_CELLS_STRINGS	❓
H3_UNCOMPACT_CELLS	❓
H3_UNCOMPACT_CELLS_STRINGS	❓
HASH	✅
HASH_AGG	❓
HAVERSINE	✅
HEX_DECODE_BINARY	❓
HEX_DECODE_STRING	❓
HEX_ENCODE	❓
HLL	❓
HLL_ACCUMULATE	❓
HLL_COMBINE	❓
HLL_ESTIMATE	❓
HLL_EXPORT	❓
HLL_IMPORT	❓
HOUR, MINUTE, SECOND	✅
ICEBERG_TABLE_FILES	❓
ICEBERG_TABLE_SNAPSHOT_REFRESH_HISTORY	❓
IFF	✅
IFNULL	✅
[ NOT ] ILIKE	❓
ILIKE ANY	❓
[ NOT ] IN	✅
INFER_SCHEMA	✅
INITCAP	✅
INSERT	✅
INTEGRATION	✅
INTERPOLATE_BFILL, INTERPOLATE_FFILL, INTERPOLATE_LINEAR	❓
INVOKER_ROLE	❓
INVOKER_SHARE	❓
IS [ NOT ] DISTINCT FROM	❓
IS [ NOT ] NULL	✅
IS_<object_type>	❓
IS_APPLICATION_ROLE_ACTIVATED (SYS_CONTEXT function)	❓
IS_APPLICATION_ROLE_IN_SESSION	❓
IS_ARRAY	✅
IS_BINARY	✅
IS_BOOLEAN	✅
IS_CHAR, IS_VARCHAR	✅
IS_DATABASE_ROLE_IN_SESSION	❓
IS_DATE, IS_DATE_VALUE	✅
IS_DECIMAL	✅
IS_DOUBLE, IS_REAL	✅
IS_GRANTED_TO_INVOKER_ROLE	❓
IS_GROUP_ACTIVATED (SYS_CONTEXT function)	❓
IS_GROUP_IMPORTED (SYS_CONTEXT function)	❓
IS_INSTANCE_ROLE_IN_SESSION	❓
IS_INTEGER	✅
IS_NULL_VALUE	✅
IS_OBJECT	✅
IS_ORGANIZATION_USER	❓
IS_ORGANIZATION_USER_GROUP	❓
IS_ORGANIZATION_USER_GROUP_IN_SESSION	❓
IS_ROLE_ACTIVATED (SYS_CONTEXT function)	❓
IS_ROLE_IN_SESSION	❓
IS_TIME	✅
IS_TIMESTAMP_*	❓
IS_USER_IMPORTED (SYS_CONTEXT function)	❓
JAROWINKLER_SIMILARITY	❓
JSON_EXTRACT_PATH_TEXT	❓
KURTOSIS	❓
LAG	✅
LAST_DAY	✅
LAST_QUERY_ID	✅
LAST_SUCCESSFUL_SCHEDULED_TIME	❓
LAST_TRANSACTION	❓
LAST_VALUE	❓
LEAD	✅
LEAST	✅
LEAST_IGNORE_NULLS	✅
LEFT	❓
LENGTH, LEN	✅
[ NOT ] LIKE	✅
LIKE ALL	❓
LIKE ANY	❓
LISTAGG	✅
LISTING_REFRESH_HISTORY	❓
LN	✅
LOCALTIME	❓
LOCALTIMESTAMP	❓
LOG	✅
LOGIN_HISTORY, LOGIN_HISTORY_BY_USER	❓
LOWER	✅
LPAD	❓
LTRIM	✅
MAP_CAT	✅
MAP_CONTAINS_KEY	✅
MAP_DELETE	✅
MAP_INSERT	✅
MAP_KEYS	✅
MAP_PICK	✅
MAP_SIZE	✅
MATERIALIZED_VIEW_REFRESH_HISTORY	❓
MAX	✅
MAX_BY	✅
MD5, MD5_HEX	✅
MD5_BINARY	❓
MD5_NUMBER — Obsoleted	❓
MD5_NUMBER_LOWER64	❓
MD5_NUMBER_UPPER64	❓
MEDIAN	✅
MIN	✅
MIN_BY	✅
MINHASH	❓
MINHASH_COMBINE	❓
MOD	✅
MODE	✅
MODEL_MONITOR_DRIFT_METRIC	❓
MODEL_MONITOR_PERFORMANCE_METRIC	❓
MODEL_MONITOR_STAT_METRIC	❓
MONTHNAME	✅
MONTHS_BETWEEN	❓
NETWORK_RULE_REFERENCES	❓
NEXT_DAY	❓
NORMAL	❓
NOTIFICATION_HISTORY	❓
NTH_VALUE	❓
NTILE	❓
NULLIF	✅
NULLIFZERO	✅
NVL	✅
NVL2	✅
OBJECT_AGG	❓
OBJECT_CONSTRUCT	✅
OBJECT_CONSTRUCT_KEEP_NULL	✅
OBJECT_DELETE	✅
OBJECT_INSERT	✅
OBJECT_KEYS	✅
OBJECT_PICK	❓
OCTET_LENGTH	❓
PARSE_DOCUMENT (SNOWFLAKE.CORTEX)	❓
PARSE_IP	✅
PARSE_JSON	✅
PARSE_URL	❓
PARSE_XML	❓
PERCENT_RANK	✅
PERCENTILE_CONT	❓
PERCENTILE_DISC	❓
PI	✅
PIPE_USAGE_HISTORY	❓
POLICY_CONTEXT	❓
POLICY_REFERENCES	❓
POSITION	❓
POW, POWER	✅
PREVIOUS_DAY	❓
PROMPT	❓
QUERY_ACCELERATION_HISTORY	❓
QUERY_HISTORY, QUERY_HISTORY_BY_*	✅
RADIANS	✅
RANDOM	✅
RANDSTR	✅
RANK	✅
RATIO_TO_REPORT	✅
REDUCE	❓
[ NOT ] REGEXP	❓
REGEXP_COUNT	❓
REGEXP_INSTR	❓
REGEXP_LIKE	❓
REGEXP_REPLACE	✅
REGEXP_SUBSTR	✅
REGEXP_SUBSTR_ALL	❓
REGR_AVGX	❓
REGR_AVGY	❓
REGR_COUNT	❓
REGR_INTERCEPT	❓
REGR_R2	❓
REGR_SLOPE	❓
REGR_SXX	❓
REGR_SXY	❓
REGR_SYY	❓
REGR_VALX	❓
REGR_VALY	❓
REPEAT	✅
REPLACE	✅
REPLICATION_GROUP_DANGLING_REFERENCES	❓
REPLICATION_GROUP_REFRESH_HISTORY, REPLICATION_GROUP_REFRESH_HISTORY_ALL	❓
REPLICATION_GROUP_REFRESH_PROGRESS, REPLICATION_GROUP_REFRESH_PROGRESS_BY_JOB, REPLICATION_GROUP_REFRESH_PROGRESS_ALL	❓
REPLICATION_GROUP_USAGE_HISTORY	❓
REPLICATION_USAGE_HISTORY	❓
REST_EVENT_HISTORY	❓
RESULT_SCAN	✅
REVERSE	✅
RIGHT	✅
[ NOT ] RLIKE	❓
ROUND	✅
ROW_NUMBER	✅
RPAD	❓
RTRIM	✅
RTRIMMED_LENGTH	❓
SANITIZE_WEBHOOK_CONTENT	❓
SCHEDULED_TIME	❓
SEARCH	❓
SEARCH_IP	❓
SEARCH_OPTIMIZATION_HISTORY	❓
SEARCH_PREVIEW (SNOWFLAKE.CORTEX)	❓
SENTIMENT (SNOWFLAKE.CORTEX)	❓
SEQ1, SEQ2, SEQ4, SEQ8	✅
SERVERLESS_ALERT_HISTORY	❓
SERVERLESS_TASK_HISTORY	❓
SHA1, SHA1_HEX	❓
SHA1_BINARY	❓
SHA2, SHA2_HEX	❓
SHA2_BINARY	❓
SHOW_PYTHON_PACKAGES_DEPENDENCIES	❓
SIGN	✅
SIN	✅
SINH	✅
SKEW	❓
SOUNDEX	❓
SOUNDEX_P123	❓
SPACE	❓
<service_name>!SPCS_CANCEL_JOB	❓
<service_name>!SPCS_GET_EVENTS	❓
<service_name>!SPCS_GET_LOGS	❓
<service_name>!SPCS_GET_METRICS	❓
<service_name>!SPCS_WAIT_FOR	❓
SPLIT	✅
SPLIT_PART	❓
SPLIT_TEXT_MARKDOWN_HEADER (SNOWFLAKE.CORTEX)	❓
SPLIT_TEXT_RECURSIVE_CHARACTER (SNOWFLAKE.CORTEX)	❓
SPLIT_TO_TABLE	❓
SQRT	✅
SQUARE	✅
ST_AREA	❓
ST_ASEWKB	❓
ST_ASEWKT	❓
ST_ASGEOJSON	❓
ST_ASWKB, ST_ASBINARY	❓
ST_ASWKT, ST_ASTEXT	❓
ST_AZIMUTH	❓
ST_BUFFER	❓
ST_CENTROID	❓
ST_COLLECT	❓
ST_CONTAINS	❓
ST_COVEREDBY	❓
ST_COVERS	❓
ST_DIFFERENCE	❓
ST_DIMENSION	❓
ST_DISJOINT	❓
ST_DISTANCE	❓
ST_DWITHIN	❓
ST_ENDPOINT	❓
ST_ENVELOPE	❓
ST_GEOGFROMGEOHASH	❓
ST_GEOGPOINTFROMGEOHASH	❓
ST_GEOGRAPHYFROMWKB	❓
ST_GEOGRAPHYFROMWKT	❓
ST_GEOHASH	❓
ST_GEOMETRYFROMWKB	❓
ST_GEOMETRYFROMWKT	❓
ST_GEOMFROMGEOHASH	❓
ST_GEOMPOINTFROMGEOHASH	❓
ST_HAUSDORFFDISTANCE	❓
ST_INTERPOLATE	❓
ST_INTERSECTION	❓
ST_INTERSECTION_AGG	❓
ST_INTERSECTS	❓
ST_ISVALID	❓
ST_LENGTH	❓
ST_MAKEGEOMPOINT, ST_GEOMPOINT	❓
ST_MAKELINE	❓
ST_MAKEPOINT, ST_POINT	❓
ST_MAKEPOLYGON, ST_POLYGON	❓
ST_MAKEPOLYGONORIENTED	❓
ST_NPOINTS, ST_NUMPOINTS	❓
ST_PERIMETER	❓
ST_POINTN	❓
ST_SETSRID	❓
ST_SIMPLIFY	❓
ST_SRID	❓
ST_STARTPOINT	❓
ST_SYMDIFFERENCE	❓
ST_TRANSFORM	❓
ST_UNION	❓
ST_UNION_AGG	❓
ST_WITHIN	❓
ST_X	❓
ST_XMAX	❓
ST_XMIN	❓
ST_Y	❓
ST_YMAX	❓
ST_YMIN	❓
STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY	❓
STAGE_STORAGE_USAGE_HISTORY	❓
STARTSWITH	✅
STDDEV, STDDEV_SAMP	❓
STDDEV_POP	❓
STRIP_NULL_VALUE	❓
STRTOK	❓
STRTOK_SPLIT_TO_TABLE	❓
STRTOK_TO_ARRAY	❓
SUBSTR, SUBSTRING	✅
SUM	✅
SUMMARIZE (SNOWFLAKE.CORTEX)	❓
SYS_CONTEXT	❓
SYS_CONTEXT (SNOWFLAKE$APPLICATION namespace)	❓
SYS_CONTEXT (SNOWFLAKE$ENVIRONMENT namespace)	❓
SYS_CONTEXT (SNOWFLAKE$ORGANIZATION namespace)	❓
SYS_CONTEXT (SNOWFLAKE$ORGANIZATION_SESSION namespace)	❓
SYS_CONTEXT (SNOWFLAKE$SESSION namespace)	❓
SYSDATE	✅
SYSTEM$ABORT_SESSION	❓
SYSTEM$ABORT_TRANSACTION	❓
SYSTEM$ACTIVATE_CMK_INFO	❓
SYSTEM$ADD_EVENT (for Snowflake Scripting)	❓
SYSTEM$ADD_REFERENCE	❓
SYSTEM$ALLOWLIST	✅
SYSTEM$ALLOWLIST_PRIVATELINK	❓
SYSTEM$APP_COMPATIBILITY_CHECK	❓
SYSTEM$APPLICATION_GET_LOG_LEVEL	❓
SYSTEM$APPLICATION_GET_METRIC_LEVEL	❓
SYSTEM$APPLICATION_GET_TRACE_LEVEL	❓
SYSTEM$AUTHORIZE_PRIVATELINK	❓
SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS	❓
SYSTEM$AUTO_REFRESH_STATUS	❓
SYSTEM$BEGIN_DEBUG_APPLICATION	❓
SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS	❓
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS	❓
SYSTEM$CANCEL_ALL_QUERIES	✅
SYSTEM$CANCEL_QUERY	❓
SYSTEM$CATALOG_LINK_STATUS	❓
SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS	❓
SYSTEM$CLIENT_VERSION_INFO	✅
SYSTEM$CLIENT_VULNERABILITY_INFO	❓
SYSTEM$CLUSTERING_DEPTH	❓
SYSTEM$CLUSTERING_INFORMATION	❓
SYSTEM$CLUSTERING_RATIO — Deprecated	❓
SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT	❓
SYSTEM$CONVERT_PIPES_SQS_TO_SNS	❓
SYSTEM$CREATE_BILLING_EVENT	❓
SYSTEM$CREATE_BILLING_EVENTS	❓
SYSTEM$CURRENT_USER_TASK_NAME	❓
SYSTEM$DATA_METRIC_SCAN	❓
SYSTEM$DATABASE_REFRESH_HISTORY — Deprecated	❓
SYSTEM$DATABASE_REFRESH_PROGRESS, SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB — Deprecated	❓
SYSTEM$DEACTIVATE_CMK_INFO	❓
SYSTEM$DECODE_PAT	❓
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT	❓
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT_TSS	❓
SYSTEM$DEREGISTER_CMK_INFO	❓
SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE	❓
SYSTEM$DISABLE_DATABASE_REPLICATION	❓
SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT	❓
SYSTEM$DISABLE_PREVIEW_ACCESS	❓
SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLY	❓
SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE	❓
SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT	❓
SYSTEM$ENABLE_PREVIEW_ACCESS	❓
SYSTEM$END_DEBUG_APPLICATION	❓
SYSTEM$ENFORCE_PRIVATELINK_ACCESS_ONLY	❓
SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS	❓
SYSTEM$ESTIMATE_QUERY_ACCELERATION	❓
SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS	❓
SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS	❓
SYSTEM$EXPLAIN_JSON_TO_TEXT	❓
SYSTEM$EXPLAIN_PLAN_JSON	❓
SYSTEM$EXTERNAL_TABLE_PIPE_STATUS	❓
SYSTEM$FINISH_OAUTH_FLOW	❓
SYSTEM$GENERATE_SAML_CSR	❓
SYSTEM$GENERATE_SCIM_ACCESS_TOKEN	❓
SYSTEM$GET_ALL_REFERENCES	❓
SYSTEM$GET_AWS_SNS_IAM_POLICY	❓
SYSTEM$GET_CLASSIFICATION_RESULT	❓
SYSTEM$GET_CMK_AKV_CONSENT_URL	❓
SYSTEM$GET_CMK_CONFIG	❓
SYSTEM$GET_CMK_INFO	❓
SYSTEM$GET_CMK_KMS_KEY_POLICY	❓
SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCE	❓
SYSTEM$GET_DEBUG_STATUS	❓
SYSTEM$GET_DIRECTORY_TABLE_STATUS	❓
SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMD	❓
SYSTEM$GET_HASH_FOR_APPLICATION	❓
SYSTEM$GET_ICEBERG_TABLE_INFORMATION	❓
SYSTEM$GET_LOGIN_FAILURE_DETAILS	❓
SYSTEM$GET_PREDECESSOR_RETURN_VALUE	❓
SYSTEM$GET_PREVIEW_ACCESS_STATUS	❓
SYSTEM$GET_PRIVATELINK	❓
SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS	❓
SYSTEM$GET_PRIVATELINK_CONFIG	❓
SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS	❓
SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO	❓
SYSTEM$GET_PURCHASE_ATTRIBUTES	❓
SYSTEM$GET_REFERENCED_OBJECT_ID_HASH	❓
SYSTEM$GET_RESULTSET_STATUS	❓
SYSTEM$GET_SERVICE_DNS_DOMAIN	❓
SYSTEM$GET_SERVICE_LOGS	❓
SYSTEM$GET_SERVICE_STATUS — Deprecated	❓
SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO	❓
SYSTEM$GET_TAG	✅
SYSTEM$GET_TAG_ALLOWED_VALUES	❓
SYSTEM$GET_TAG_ON_CURRENT_COLUMN	❓
SYSTEM$GET_TAG_ON_CURRENT_TABLE	❓
SYSTEM$GET_TASK_GRAPH_CONFIG	❓
SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER	❓
SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT	❓
SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT	❓
SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS	❓
SYSTEM$IS_APPLICATION_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLED	❓
SYSTEM$IS_APPLICATION_AUTHORIZED_FOR_TELEMETRY_EVENT_SHARING	❓
SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNT	❓
SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDER	❓
SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT	❓
SYSTEM$IS_LISTING_PURCHASED	❓
SYSTEM$IS_LISTING_TRIAL	❓
SYSTEM$LAST_CHANGE_COMMIT_TIME	❓
SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME	❓
SYSTEM$LINK_ORGANIZATION_USER	❓
SYSTEM$LINK_ORGANIZATION_USER_GROUP	❓
SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES	❓
SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOG	❓
SYSTEM$LIST_NAMESPACES_FROM_CATALOG	❓
SYSTEM$LOG, SYSTEM$LOG_ (for Snowflake Scripting)	✅
SYSTEM$MIGRATE_SAML_IDP_REGISTRATION	❓
SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGS	❓
SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGS	❓
SYSTEM$PIPE_FORCE_RESUME	❓
SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNEL	❓
SYSTEM$PIPE_STATUS	❓
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT	❓
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT_TSS	❓
SYSTEM$QUERY_REFERENCE	❓
SYSTEM$READ_YAML_FROM_SEMANTIC_VIEW	❓
SYSTEM$REFERENCE	❓
SYSTEM$REGISTER_CMK_INFO	❓
SYSTEM$REGISTER_PRIVATELINK_ENDPOINT	❓
SYSTEM$REGISTRY_LIST_IMAGES — Deprecated	❓
SYSTEM$REMOVE_ALL_REFERENCES	❓
SYSTEM$REMOVE_REFERENCE	✅
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT	❓
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT_TSS	❓
SYSTEM$REVOKE_PRIVATELINK	❓
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS	❓
SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESH	❓
SYSTEM$SEND_NOTIFICATIONS_TO_CATALOG	❓
SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS	❓
SYSTEM$SET_CATALOG_INTEGRATION	❓
SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION	❓
SYSTEM$SET_PRIVATELINK_ENDPOINT_HOSTNAME	❓
SYSTEM$SET_REFERENCE	✅
SYSTEM$SET_RETURN_VALUE	❓
SYSTEM$SET_SPAN_ATTRIBUTES (for Snowflake Scripting)	❓
SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES	❓
SYSTEM$SHOW_BUDGETS_FOR_RESOURCE	❓
SYSTEM$SHOW_BUDGETS_IN_ACCOUNT	❓
SYSTEM$SHOW_EVENT_SHARING_ACCOUNTS	❓
SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS	❓
SYSTEM$SHOW_OAUTH_CLIENT_SECRETS	❓
SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIES	❓
SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKEN	❓
SYSTEM$START_OAUTH_FLOW	❓
SYSTEM$START_USER_EMAIL_VERIFICATION	❓
SYSTEM$STREAM_BACKLOG	❓
SYSTEM$STREAM_GET_TABLE_TIMESTAMP	❓
SYSTEM$STREAM_HAS_DATA	❓
SYSTEM$TASK_DEPENDENTS_ENABLE	✅
SYSTEM$TASK_RUNTIME_INFO	❓
SYSTEM$TRIGGER_LISTING_REFRESH	❓
SYSTEM$TYPEOF	❓
SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS	❓
SYSTEM$UNLINK_ORGANIZATION_USER	❓
SYSTEM$UNLINK_ORGANIZATION_USER_GROUP	❓
SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINT	❓
SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGION	❓
SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS	❓
SYSTEM$VALIDATE_STORAGE_INTEGRATION	❓
SYSTEM$VERIFY_CATALOG_INTEGRATION	❓
SYSTEM$VERIFY_CMK_INFO	❓
SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN	❓
SYSTEM$VERIFY_EXTERNAL_VOLUME	❓
SYSTEM$WAIT	✅
SYSTEM$WAIT_FOR_SERVICES	❓
SYSTEM$WHITELIST — Deprecated	❓
SYSTEM$WHITELIST_PRIVATELINK — Deprecated	❓
SYSTIMESTAMP	❓
TAG_REFERENCES	✅
TAG_REFERENCES_ALL_COLUMNS	❓
TAG_REFERENCES_WITH_LINEAGE	❓
TAN	✅
TANH	✅
TASK_DEPENDENTS	❓
TASK_HISTORY	❓
TEXT_HTML	❓
TEXT_PLAIN	❓
TIME_FROM_PARTS	❓
TIME_SLICE	❓
TIMEADD	✅
TIMEDIFF	✅
TIMESTAMP_FROM_PARTS	❓
TIMESTAMPADD	✅
TIMESTAMPDIFF	✅
TO_ARRAY	✅
TO_BINARY	✅
TO_BOOLEAN	✅
TO_CHAR, TO_VARCHAR	✅
TO_DATE, DATE	✅
TO_DECIMAL, TO_NUMBER, TO_NUMERIC	✅
TO_DOUBLE	✅
TO_FILE	❓
TO_GEOGRAPHY	❓
TO_GEOMETRY	❓
TO_JSON	❓
TO_OBJECT	✅
TO_QUERY	❓
TO_TIME, TIME	✅
TO_TIMESTAMP, TO_TIMESTAMP_*	✅
TO_VARIANT	✅
TO_XML	❓
TRANSFORM	❓
TRANSLATE (SNOWFLAKE.CORTEX)	❓
TRANSLATE	❓
TRIM	✅
TRUNCATE, TRUNC	✅
TRUNCATE, TRUNC	✅
TRY_BASE64_DECODE_BINARY	❓
TRY_BASE64_DECODE_STRING	❓
TRY_CAST	✅
TRY_COMPLETE (SNOWFLAKE.CORTEX)	❓
TRY_DECRYPT	❓
TRY_DECRYPT_RAW	❓
TRY_HEX_DECODE_BINARY	❓
TRY_HEX_DECODE_STRING	❓
TRY_PARSE_JSON	✅
TRY_TO_BINARY	✅
TRY_TO_BOOLEAN	✅
TRY_TO_DATE	✅
TRY_TO_DECIMAL, TRY_TO_NUMBER, TRY_TO_NUMERIC	✅
TRY_TO_DOUBLE	✅
TRY_TO_FILE	❓
TRY_TO_GEOGRAPHY	❓
TRY_TO_GEOMETRY	❓
TRY_TO_TIME	✅
TRY_TO_TIMESTAMP, TRY_TO_TIMESTAMP_*	✅
TYPEOF	❓
UNICODE	✅
UNIFORM	✅
UPPER	✅
UUID_STRING	✅
VALIDATE	❓
VALIDATE_PIPE_LOAD	❓
VAR_POP	❓
VAR_SAMP	❓
VARIANCE, VARIANCE_SAMP	❓
VARIANCE_POP	❓
VECTOR_COSINE_SIMILARITY	❓
VECTOR_INNER_PRODUCT	❓
VECTOR_L1_DISTANCE	❓
VECTOR_L2_DISTANCE	❓
WAREHOUSE_LOAD_HISTORY	❓
WAREHOUSE_METERING_HISTORY	❓
WIDTH_BUCKET	❓
XMLGET	❓
YEAR*, DAY*, WEEK*, MONTH, QUARTER	✅
ZEROIFNULL	✅
ZIPF	❓