SQL Functions Coverage
Overview
Section titled “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_EMBED | ❓ |
| AI_FILTER | ❓ |
| AI_SIMILARITY | ❓ |
| AI_SUMMARIZE_AGG | ❓ |
| 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 | ❓ |
| AVAILABLE_LISTING_REFRESH_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) (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_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 | ❓ |
| 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_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 | ✅ |
| 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_ORGANIZATION_USER | ❓ |
| IS_ORGANIZATION_USER_GROUP | ❓ |
| IS_ORGANIZATION_USER_GROUP_IN_SESSION | ❓ |
| 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 | ✅ |
| 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 function | ❓ |
| 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_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 | ❓ |
| SPLIT | ✅ |
| SPLIT_PART | ❓ |
| 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) | ❓ |
| SYSDATE | ❓ |
| SYSTEM$ABORT_SESSION | ❓ |
| SYSTEM$ABORT_TRANSACTION | ❓ |
| 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$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$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$DECODE_PAT | ❓ |
| SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT | ❓ |
| SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE | ❓ |
| SYSTEM$DISABLE_DATABASE_REPLICATION | ❓ |
| SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT | ❓ |
| SYSTEM$DISABLE_PREVIEW_ACCESS | ❓ |
| SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE | ❓ |
| SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT | ❓ |
| SYSTEM$ENABLE_PREVIEW_ACCESS | ❓ |
| SYSTEM$END_DEBUG_APPLICATION | ❓ |
| 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_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_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_ | ✅ |
| 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$REGISTER_PRIVATELINK_ENDPOINT | ❓ |
| SYSTEM$REGISTRY_LIST_IMAGES — Deprecated | ❓ |
| SYSTEM$REMOVE_ALL_REFERENCES | ❓ |
| SYSTEM$REMOVE_REFERENCE | ✅ |
| SYSTEM$RESTORE_PRIVATELINK_ENDPOINT | ❓ |
| 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_EVENT_SHARING_ACCOUNT_FOR_REGION | ❓ |
| 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$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 | ❓ |