Supported Snowflake functions in dbt Fusion

Fusion can validate that your Snowflake function arguments match expected types directly in dbt platform, the CLI, or using dbt VS Code extension. To enable this, set static_analysis: strict in your project configuration.

The following table lists every Snowflake built-in function and its typechecking support status. Use the table's search and filters to find specific functions.

Refreshed daily

This table is updated daily from the Snowflake SQL function reference and cross-referenced with Fusion's support list. If you spot a discrepancy, we'd love for you to contribute and open an issue in the Fusion repository!

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

Loading table...

Was this page helpful?

Privacy policyCreate a GitHub issue

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.