Functions Coverage
Overview of the implemented Snowflake SQL functions in LocalStack
Overview
This table provides a list of all Snowflake system-defined SQL functions, scalar or table, emulated by LocalStack. The table is a work in progress and will be updated as more functions are implemented.
Function | Supported | Tested |
---|---|---|
ABS | ✅ | ✅ |
ACOS | ✅ | ✅ |
ACOSH | ❓ | ❓ |
ADD_MONTHS | ✅ | ✅ |
ALERT_HISTORY | ❓ | ❓ |
ALL_USER_NAMES | ❓ | ❓ |
ANY_VALUE | ❓ | ❓ |
APPLICATION_JSON | ❓ | ❓ |
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_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 | ❓ | ❓ |
AVG | ❓ | ❓ |
BASE64_DECODE_BINARY | ❓ | ❓ |
BASE64_DECODE_STRING | ❓ | ❓ |
BASE64_ENCODE | ❓ | ❓ |
[ NOT ] BETWEEN | ❓ | ❓ |
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 | ❓ | ❓ |
COALESCE | ✅ | ✅ |
COLLATE | ❓ | ❓ |
COLLATION | ❓ | ❓ |
COMPLETE (SNOWFLAKE.CORTEX) | ❓ | ❓ |
COMPLETE_TASK_GRAPHS | ❓ | ❓ |
COMPRESS | ❓ | ❓ |
CONCAT , | ||
CONCAT_WS | ❓ | ❓ |
CONDITIONAL_CHANGE_EVENT | ❓ | ❓ |
CONDITIONAL_TRUE_EVENT | ❓ | ❓ |
CONTAINS | ❓ | ❓ |
CONVERT_TIMEZONE | ✅ | ✅ |
COPY_HISTORY | ❓ | ❓ |
CORR | ❓ | ❓ |
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_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_REFERENCES | ❓ | ❓ |
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 | ❓ | ❓ |
DATE_FROM_PARTS | ✅ | ✅ |
DATE_PART | ❓ | ❓ |
DATE_TRUNC | ✅ | ✅ |
DATEADD | ✅ | ✅ |
DATEDIFF | ✅ | ✅ |
DAYNAME | ✅ | ✅ |
DECODE | ❓ | ❓ |
DECOMPRESS_BINARY | ❓ | ❓ |
DECOMPRESS_STRING | ❓ | ❓ |
DECRYPT | ❓ | ❓ |
DECRYPT_RAW | ❓ | ❓ |
DEGREES | ❓ | ❓ |
DENSE_RANK | ✅ | ✅ |
DIV0 | ✅ | ✅ |
DIV0NULL | ❓ | ❓ |
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_ESTIMATE_HIGH | ❓ | ❓ |
DP_ESTIMATE_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 | ❓ | ❓ |
EQUAL_NULL | ❓ | ❓ |
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 | ❓ | ❓ |
FLATTEN | ✅ | ✅ |
FLOOR | ✅ | ✅ |
GENERATE_COLUMN_DESCRIPTION | ❓ | ❓ |
GENERATOR | ✅ | ✅ |
GET | ✅ | ✅ |
GET_ABSOLUTE_PATH | ❓ | ❓ |
GET_ANACONDA_PACKAGES_REPODATA | ❓ | ❓ |
GET_CONDITION_QUERY_UUID | ❓ | ❓ |
GET_DDL | ❓ | ❓ |
GET_IGNORE_CASE | ❓ | ❓ |
GET_OBJECT_REFERENCES | ❓ | ❓ |
GET_PATH , : | ❓ | ❓ |
GET_PRESIGNED_URL | ❓ | ❓ |
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 | ❓ | ❓ |
IFF | ✅ | ✅ |
IFNULL | ❓ | ❓ |
[ NOT ] ILIKE | ❓ | ❓ |
ILIKE ANY | ❓ | ❓ |
[ NOT ] IN | ❓ | ❓ |
INFER_SCHEMA | ✅ | ✅ |
INITCAP | ✅ | ✅ |
INSERT | ✅ | ✅ |
INTEGRATION | ❓ | ❓ |
INVOKER_ROLE | ❓ | ❓ |
INVOKER_SHARE | ❓ | ❓ |
IS [ NOT ] DISTINCT FROM | ❓ | ❓ |
IS [ NOT ] NULL | ❓ | ❓ |
IS_<object_type> | ❓ | ❓ |
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_INSTANCE_ROLE_IN_SESSION | ❓ | ❓ |
IS_INTEGER | ❓ | ❓ |
IS_NULL_VALUE | ✅ | ✅ |
IS_OBJECT | ❓ | ❓ |
IS_ROLE_IN_SESSION | ❓ | ❓ |
IS_TIME | ❓ | ❓ |
IS_TIMESTAMP_* | ❓ | ❓ |
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 | ✅ | ✅ |
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 | ❓ | ❓ |
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_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 | ❓ | ❓ |
QUERY_ACCELERATION_HISTORY | ❓ | ❓ |
QUERY_HISTORY , QUERY_HISTORY_BY_* | ❓ | ❓ |
RADIANS | ✅ | ✅ |
RANDOM | ✅ | ✅ |
RANDSTR | ✅ | ✅ |
RANK | ✅ | ✅ |
RATIO_TO_REPORT | ✅ | ✅ |
[ 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_REFRESH_HISTORY | ❓ | ❓ |
REPLICATION_GROUP_REFRESH_PROGRESS, REPLICATION_GROUP_REFRESH_PROGRESS_BY_JOB | ❓ | ❓ |
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_OPTIMIZATION_HISTORY | ❓ | ❓ |
SEARCH_PREVIEW (SNOWFLAKE.CORTEX) | ❓ | ❓ |
SENTIMENT (SNOWFLAKE.CORTEX) | ❓ | ❓ |
SEQ1 / SEQ2 / SEQ4 / SEQ8 | ❓ | ❓ |
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 | ❓ | ❓ |
SPLIT | ✅ | ✅ |
SPLIT_PART | ❓ | ❓ |
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_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) | ❓ | ❓ |
SYSDATE | ❓ | ❓ |
SYSTEM$ABORT_SESSION | ❓ | ❓ |
SYSTEM$ABORT_TRANSACTION | ❓ | ❓ |
SYSTEM$ADD_EVENT (for Snowflake Scripting) | ❓ | ❓ |
SYSTEM$ALLOWLIST | ❓ | ❓ |
SYSTEM$ALLOWLIST_PRIVATELINK | ❓ | ❓ |
SYSTEM$AUTHORIZE_PRIVATELINK | ❓ | ❓ |
SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS | ❓ | ❓ |
SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS | ❓ | ❓ |
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS | ❓ | ❓ |
SYSTEM$CANCEL_ALL_QUERIES | ✅ | ✅ |
SYSTEM$CANCEL_QUERY | ❓ | ❓ |
SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS | ❓ | ❓ |
SYSTEM$CLIENT_VERSION_INFO | ❓ | ❓ |
SYSTEM$CLUSTERING_DEPTH | ❓ | ❓ |
SYSTEM$CLUSTERING_INFORMATION | ❓ | ❓ |
SYSTEM$CLUSTERING_RATIO — Deprecated | ❓ | ❓ |
SYSTEM$CONVERT_PIPES_SQS_TO_SNS | ❓ | ❓ |
SYSTEM$CREATE_BILLING_EVENT | ❓ | ❓ |
SYSTEM$CURRENT_USER_TASK_NAME | ❓ | ❓ |
SYSTEM$DATABASE_REFRESH_HISTORY — Deprecated | ❓ | ❓ |
SYSTEM$DATABASE_REFRESH_PROGRESS , SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB — Deprecated | ❓ | ❓ |
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT | ❓ | ❓ |
SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE | ❓ | ❓ |
SYSTEM$DISABLE_DATABASE_REPLICATION | ❓ | ❓ |
SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE | ❓ | ❓ |
SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS | ❓ | ❓ |
SYSTEM$ESTIMATE_QUERY_ACCELERATION | ❓ | ❓ |
SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS | ❓ | ❓ |
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_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_STATUS | ❓ | ❓ |
SYSTEM$GET_DIRECTORY_TABLE_STATUS | ❓ | ❓ |
SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMD | ❓ | ❓ |
SYSTEM$GET_ICEBERG_TABLE_INFORMATION | ❓ | ❓ |
SYSTEM$GET_LOGIN_FAILURE_DETAILS | ❓ | ❓ |
SYSTEM$GET_PREDECESSOR_RETURN_VALUE | ❓ | ❓ |
SYSTEM$GET_PRIVATELINK | ❓ | ❓ |
SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS | ❓ | ❓ |
SYSTEM$GET_PRIVATELINK_CONFIG | ❓ | ❓ |
SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO | ❓ | ❓ |
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$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS | ❓ | ❓ |
SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNT | ❓ | ❓ |
SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDER | ❓ | ❓ |
SYSTEM$LAST_CHANGE_COMMIT_TIME | ❓ | ❓ |
SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME | ❓ | ❓ |
SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES | ❓ | ❓ |
SYSTEM$LOG, SYSTEM$LOG_ | ❓ | ❓ |
SYSTEM$MIGRATE_SAML_IDP_REGISTRATION | ❓ | ❓ |
SYSTEM$PIPE_FORCE_RESUME | ❓ | ❓ |
SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNEL | ❓ | ❓ |
SYSTEM$PIPE_STATUS | ❓ | ❓ |
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT | ❓ | ❓ |
SYSTEM$QUERY_REFERENCE | ❓ | ❓ |
SYSTEM$REFERENCE | ❓ | ❓ |
SYSTEM$REGISTER_CMK_INFO | ❓ | ❓ |
SYSTEM$REGISTRY_LIST_IMAGES — Deprecated | ❓ | ❓ |
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT | ❓ | ❓ |
SYSTEM$REVOKE_PRIVATELINK | ❓ | ❓ |
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS | ❓ | ❓ |
SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS | ❓ | ❓ |
SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION | ❓ | ❓ |
SYSTEM$SET_RETURN_VALUE | ❓ | ❓ |
SYSTEM$SET_SPAN_ATTRIBUTES (for Snowflake Scripting) | ❓ | ❓ |
SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES | ❓ | ❓ |
SYSTEM$SHOW_BUDGETS_IN_ACCOUNT | ❓ | ❓ |
SYSTEM$SHOW_EVENT_SHARING_ACCOUNTS | ❓ | ❓ |
SYSTEM$SHOW_OAUTH_CLIENT_SECRETS | ❓ | ❓ |
SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKEN | ❓ | ❓ |
SYSTEM$START_OAUTH_FLOW | ❓ | ❓ |
SYSTEM$STREAM_BACKLOG | ❓ | ❓ |
SYSTEM$STREAM_GET_TABLE_TIMESTAMP | ❓ | ❓ |
SYSTEM$STREAM_HAS_DATA | ❓ | ❓ |
SYSTEM$TASK_DEPENDENTS_ENABLE | ❓ | ❓ |
SYSTEM$TASK_RUNTIME_INFO | ❓ | ❓ |
SYSTEM$TYPEOF | ❓ | ❓ |
SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS | ❓ | ❓ |
SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGION | ❓ | ❓ |
SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS | ❓ | ❓ |
SYSTEM$VALIDATE_STORAGE_INTEGRATION | ❓ | ❓ |
SYSTEM$VERIFY_CMK_INFO | ❓ | ❓ |
SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN | ❓ | ❓ |
SYSTEM$WAIT | ❓ | ❓ |
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_GEOGRAPHY | ❓ | ❓ |
TO_GEOMETRY | ❓ | ❓ |
TO_JSON | ❓ | ❓ |
TO_OBJECT | ✅ | ✅ |
TO_QUERY | ❓ | ❓ |
TO_TIME , TIME | ❓ | ❓ |
TO_TIMESTAMP / TO_TIMESTAMP_* | ❓ | ❓ |
TO_VARIANT | ✅ | ✅ |
TO_XML | ❓ | ❓ |
TOP_INSIGHTS (SNOWFLAKE.ML) | ❓ | ❓ |
TRANSFORM | ❓ | ❓ |
TRANSLATE (SNOWFLAKE.CORTEX) | ❓ | ❓ |
TRANSLATE | ❓ | ❓ |
TRIM | ✅ | ✅ |
TRUNCATE , TRUNC | ❓ | ❓ |
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_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_L2_DISTANCE | ❓ | ❓ |
WAREHOUSE_LOAD_HISTORY | ❓ | ❓ |
WAREHOUSE_METERING_HISTORY | ❓ | ❓ |
WIDTH_BUCKET | ❓ | ❓ |
XMLGET | ❓ | ❓ |
YEAR* / DAY* / WEEK* / MONTH / QUARTER | ❓ | ❓ |
ZEROIFNULL | ❓ | ❓ |
ZIPF | ❓ | ❓ |