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 |
---|---|
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_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 | ❓ |
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 | ✅ |
CLASSIFY_TEXT (SNOWFLAKE.CORTEX) | ❓ |
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_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 | ❓ |
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 | ❓ |
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_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 | ❓ |
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_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_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 | ❓ |
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_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) | ❓ |
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$AUTO_REFRESH_STATUS | ❓ |
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$COMMIT_MOVE_ORGANIZATION_ACCOUNT | ❓ |
SYSTEM$CONVERT_PIPES_SQS_TO_SNS | ❓ |
SYSTEM$CREATE_BILLING_EVENT | ❓ |
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$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$INITIATE_MOVE_ORGANIZATION_ACCOUNT | ❓ |
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$LIST_ICEBERG_TABLES_FROM_CATALOG | ❓ |
SYSTEM$LIST_NAMESPACES_FROM_CATALOG | ❓ |
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$SEND_NOTIFICATIONS_TO_CATALOG | ❓ |
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_MOVE_ORGANIZATION_ACCOUNT_STATUS | ❓ |
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$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_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 | ❓ |
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 | ❓ |