# 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, run `dbt login` and set [`static_analysis: strict`](../../docs/build/about-static-analysis.md?version=2.0) 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 weekly This table is updated weekly from the [Snowflake SQL function reference](https://docs.snowflake.com/en/sql-reference/functions-all) and cross-referenced with Fusion's support list. If you spot a discrepancy, we'd love for you to contribute and [open an issue](https://github.com/dbt-labs/dbt-core/issues) in the dbt Core repository! | Function | Category | Fusion typechecking | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------- | | [TAG\_REFERENCES\_WITH\_LINEAGE](https://docs.snowflake.com/en/sql-reference/functions/tag_references_with_lineage) | Account Usage table | ✓ | | [AGG](https://docs.snowflake.com/en/sql-reference/functions/agg) | Aggregate | — | | [AI\_AGG](https://docs.snowflake.com/en/sql-reference/functions/ai_agg) | Aggregate | — | | [AI\_SUMMARIZE\_AGG](https://docs.snowflake.com/en/sql-reference/functions/ai_summarize_agg) | Aggregate | — | | [ANY\_VALUE](https://docs.snowflake.com/en/sql-reference/functions/any_value) | Aggregate | ✓ | | [APPROX\_COUNT\_DISTINCT](https://docs.snowflake.com/en/sql-reference/functions/approx_count_distinct) | Aggregate | ✓ | | [APPROX\_PERCENTILE](https://docs.snowflake.com/en/sql-reference/functions/approx_percentile) | Aggregate | ✓ | | [APPROX\_PERCENTILE\_ACCUMULATE](https://docs.snowflake.com/en/sql-reference/functions/approx_percentile_accumulate) | Aggregate | ✓ | | [APPROX\_PERCENTILE\_COMBINE](https://docs.snowflake.com/en/sql-reference/functions/approx_percentile_combine) | Aggregate | ✓ | | [APPROX\_PERCENTILE\_ESTIMATE](https://docs.snowflake.com/en/sql-reference/functions/approx_percentile_estimate) | Aggregate | ✓ | | [APPROX\_TOP\_K](https://docs.snowflake.com/en/sql-reference/functions/approx_top_k) | Aggregate | ✓ | | [APPROX\_TOP\_K\_ACCUMULATE](https://docs.snowflake.com/en/sql-reference/functions/approx_top_k_accumulate) | Aggregate | ✓ | | [APPROX\_TOP\_K\_COMBINE](https://docs.snowflake.com/en/sql-reference/functions/approx_top_k_combine) | Aggregate | ✓ | | [APPROX\_TOP\_K\_ESTIMATE](https://docs.snowflake.com/en/sql-reference/functions/approx_top_k_estimate) | Aggregate | ✓ | | [APPROXIMATE\_JACCARD\_INDEX](https://docs.snowflake.com/en/sql-reference/functions/approximate_jaccard_index) | Aggregate | ✓ | | [APPROXIMATE\_SIMILARITY](https://docs.snowflake.com/en/sql-reference/functions/approximate_similarity) | Aggregate | ✓ | | [ARRAY\_AGG](https://docs.snowflake.com/en/sql-reference/functions/array_agg) | Aggregate | ✓ | | [ARRAY\_UNION\_AGG](https://docs.snowflake.com/en/sql-reference/functions/array_union_agg) | Aggregate | ✓ | | [ARRAY\_UNIQUE\_AGG](https://docs.snowflake.com/en/sql-reference/functions/array_unique_agg) | Aggregate | ✓ | | [AVG](https://docs.snowflake.com/en/sql-reference/functions/avg) | Aggregate | ✓ | | [BITAND\_AGG](https://docs.snowflake.com/en/sql-reference/functions/bitand_agg) | Aggregate | ✓ | | [BITMAP\_ABSOLUTE\_POSITION](https://docs.snowflake.com/en/sql-reference/functions/bitmap_absolute_position) | Aggregate | ✓ | | [BITMAP\_AND](https://docs.snowflake.com/en/sql-reference/functions/bitmap_and) | Aggregate | — | | [BITMAP\_AND\_AGG](https://docs.snowflake.com/en/sql-reference/functions/bitmap_and_agg) | Aggregate | — | | [BITMAP\_BIT\_POSITION](https://docs.snowflake.com/en/sql-reference/functions/bitmap_bit_position) | Aggregate | ✓ | | [BITMAP\_BUCKET\_NUMBER](https://docs.snowflake.com/en/sql-reference/functions/bitmap_bucket_number) | Aggregate | ✓ | | [BITMAP\_CONSTRUCT\_AGG](https://docs.snowflake.com/en/sql-reference/functions/bitmap_construct_agg) | Aggregate | ✓ | | [BITMAP\_COUNT](https://docs.snowflake.com/en/sql-reference/functions/bitmap_count) | Aggregate | ✓ | | [BITMAP\_OR](https://docs.snowflake.com/en/sql-reference/functions/bitmap_or) | Aggregate | ✓ | | [BITMAP\_OR\_AGG](https://docs.snowflake.com/en/sql-reference/functions/bitmap_or_agg) | Aggregate | ✓ | | [BITMAP\_TO\_ARRAY](https://docs.snowflake.com/en/sql-reference/functions/bitmap_to_array) | Aggregate | ✓ | | [BITOR\_AGG](https://docs.snowflake.com/en/sql-reference/functions/bitor_agg) | Aggregate | ✓ | | [BITXOR\_AGG](https://docs.snowflake.com/en/sql-reference/functions/bitxor_agg) | Aggregate | ✓ | | [BOOLAND\_AGG](https://docs.snowflake.com/en/sql-reference/functions/booland_agg) | Aggregate | ✓ | | [BOOLOR\_AGG](https://docs.snowflake.com/en/sql-reference/functions/boolor_agg) | Aggregate | ✓ | | [BOOLXOR\_AGG](https://docs.snowflake.com/en/sql-reference/functions/boolxor_agg) | Aggregate | ✓ | | [CORR](https://docs.snowflake.com/en/sql-reference/functions/corr) | Aggregate | ✓ | | [COUNT](https://docs.snowflake.com/en/sql-reference/functions/count) | Aggregate | ✓ | | [COUNT\_IF](https://docs.snowflake.com/en/sql-reference/functions/count_if) | Aggregate | ✓ | | [COVAR\_POP](https://docs.snowflake.com/en/sql-reference/functions/covar_pop) | Aggregate | ✓ | | [COVAR\_SAMP](https://docs.snowflake.com/en/sql-reference/functions/covar_samp) | Aggregate | ✓ | | [DATASKETCHES\_HLL](https://docs.snowflake.com/en/sql-reference/functions/datasketches_hll) | Aggregate | — | | [DATASKETCHES\_HLL\_ACCUMULATE](https://docs.snowflake.com/en/sql-reference/functions/datasketches_hll_accumulate) | Aggregate | — | | [DATASKETCHES\_HLL\_COMBINE](https://docs.snowflake.com/en/sql-reference/functions/datasketches_hll_combine) | Aggregate | — | | [DATASKETCHES\_HLL\_ESTIMATE](https://docs.snowflake.com/en/sql-reference/functions/datasketches_hll_estimate) | Aggregate | — | | [GROUPING](https://docs.snowflake.com/en/sql-reference/functions/grouping) | Aggregate | ✓ | | [GROUPING\_ID](https://docs.snowflake.com/en/sql-reference/functions/grouping_id) | Aggregate | ✓ | | [HASH\_AGG](https://docs.snowflake.com/en/sql-reference/functions/hash_agg) | Aggregate | ✓ | | [HLL](https://docs.snowflake.com/en/sql-reference/functions/hll) | Aggregate | — | | [HLL\_ACCUMULATE](https://docs.snowflake.com/en/sql-reference/functions/hll_accumulate) | Aggregate | ✓ | | [HLL\_COMBINE](https://docs.snowflake.com/en/sql-reference/functions/hll_combine) | Aggregate | ✓ | | [HLL\_ESTIMATE](https://docs.snowflake.com/en/sql-reference/functions/hll_estimate) | Aggregate | ✓ | | [HLL\_EXPORT](https://docs.snowflake.com/en/sql-reference/functions/hll_export) | Aggregate | ✓ | | [HLL\_IMPORT](https://docs.snowflake.com/en/sql-reference/functions/hll_import) | Aggregate | ✓ | | [KURTOSIS](https://docs.snowflake.com/en/sql-reference/functions/kurtosis) | Aggregate | ✓ | | [LISTAGG](https://docs.snowflake.com/en/sql-reference/functions/listagg) | Aggregate | ✓ | | [MAX](https://docs.snowflake.com/en/sql-reference/functions/max) | Aggregate | ✓ | | [MAX\_BY](https://docs.snowflake.com/en/sql-reference/functions/max_by) | Aggregate | ✓ | | [MEDIAN](https://docs.snowflake.com/en/sql-reference/functions/median) | Aggregate | ✓ | | [MIN](https://docs.snowflake.com/en/sql-reference/functions/min) | Aggregate | ✓ | | [MIN\_BY](https://docs.snowflake.com/en/sql-reference/functions/min_by) | Aggregate | ✓ | | [MINHASH](https://docs.snowflake.com/en/sql-reference/functions/minhash) | Aggregate | ✓ | | [MINHASH\_COMBINE](https://docs.snowflake.com/en/sql-reference/functions/minhash_combine) | Aggregate | ✓ | | [MODE](https://docs.snowflake.com/en/sql-reference/functions/mode) | Aggregate | ✓ | | [OBJECT\_AGG](https://docs.snowflake.com/en/sql-reference/functions/object_agg) | Aggregate | ✓ | | [PERCENTILE\_CONT](https://docs.snowflake.com/en/sql-reference/functions/percentile_cont) | Aggregate | — | | [PERCENTILE\_DISC](https://docs.snowflake.com/en/sql-reference/functions/percentile_disc) | Aggregate | — | | [REGR\_AVGX](https://docs.snowflake.com/en/sql-reference/functions/regr_avgx) | Aggregate | ✓ | | [REGR\_AVGY](https://docs.snowflake.com/en/sql-reference/functions/regr_avgy) | Aggregate | ✓ | | [REGR\_COUNT](https://docs.snowflake.com/en/sql-reference/functions/regr_count) | Aggregate | ✓ | | [REGR\_INTERCEPT](https://docs.snowflake.com/en/sql-reference/functions/regr_intercept) | Aggregate | ✓ | | [REGR\_R2](https://docs.snowflake.com/en/sql-reference/functions/regr_r2) | Aggregate | ✓ | | [REGR\_SLOPE](https://docs.snowflake.com/en/sql-reference/functions/regr_slope) | Aggregate | ✓ | | [REGR\_SXX](https://docs.snowflake.com/en/sql-reference/functions/regr_sxx) | Aggregate | ✓ | | [REGR\_SXY](https://docs.snowflake.com/en/sql-reference/functions/regr_sxy) | Aggregate | ✓ | | [REGR\_SYY](https://docs.snowflake.com/en/sql-reference/functions/regr_syy) | Aggregate | ✓ | | [SKEW](https://docs.snowflake.com/en/sql-reference/functions/skew) | Aggregate | ✓ | | [STDDEV\_POP](https://docs.snowflake.com/en/sql-reference/functions/stddev_pop) | Aggregate | ✓ | | [STDDEV, STDDEV\_SAMP](https://docs.snowflake.com/en/sql-reference/functions/stddev) | Aggregate | ✓ | | [SUM](https://docs.snowflake.com/en/sql-reference/functions/sum) | Aggregate | ✓ | | [VAR\_POP](https://docs.snowflake.com/en/sql-reference/functions/var_pop) | Aggregate | ✓ | | [VAR\_SAMP](https://docs.snowflake.com/en/sql-reference/functions/var_samp) | Aggregate | ✓ | | [VARIANCE , VARIANCE\_SAMP](https://docs.snowflake.com/en/sql-reference/functions/variance) | Aggregate | ✓ | | [VARIANCE\_POP](https://docs.snowflake.com/en/sql-reference/functions/variance_pop) | Aggregate | — | | [BITAND](https://docs.snowflake.com/en/sql-reference/functions/bitand) | Bitwise expression | ✓ | | [BITNOT](https://docs.snowflake.com/en/sql-reference/functions/bitnot) | Bitwise expression | ✓ | | [BITOR](https://docs.snowflake.com/en/sql-reference/functions/bitor) | Bitwise expression | ✓ | | [BITSHIFTLEFT](https://docs.snowflake.com/en/sql-reference/functions/bitshiftleft) | Bitwise expression | ✓ | | [BITSHIFTRIGHT](https://docs.snowflake.com/en/sql-reference/functions/bitshiftright) | Bitwise expression | ✓ | | [BITXOR](https://docs.snowflake.com/en/sql-reference/functions/bitxor) | Bitwise expression | ✓ | | [GETBIT](https://docs.snowflake.com/en/sql-reference/functions/getbit) | Bitwise expression | ✓ | | [\[ NOT \] BETWEEN](https://docs.snowflake.com/en/sql-reference/functions/between) | Conditional expression | — | | [\[ NOT \] EQUAL\_NULL](https://docs.snowflake.com/en/sql-reference/functions/equal_null) | Conditional expression | ✓ | | [\[ NOT \] IN](https://docs.snowflake.com/en/sql-reference/functions/in) | Conditional expression | — | | [BOOLAND](https://docs.snowflake.com/en/sql-reference/functions/booland) | Conditional expression | ✓ | | [BOOLNOT](https://docs.snowflake.com/en/sql-reference/functions/boolnot) | Conditional expression | ✓ | | [BOOLOR](https://docs.snowflake.com/en/sql-reference/functions/boolor) | Conditional expression | ✓ | | [BOOLXOR](https://docs.snowflake.com/en/sql-reference/functions/boolxor) | Conditional expression | ✓ | | [CASE](https://docs.snowflake.com/en/sql-reference/functions/case) | Conditional expression | — | | [COALESCE](https://docs.snowflake.com/en/sql-reference/functions/coalesce) | Conditional expression | ✓ | | [DECODE](https://docs.snowflake.com/en/sql-reference/functions/decode) | Conditional expression | — | | [GREATEST](https://docs.snowflake.com/en/sql-reference/functions/greatest) | Conditional expression | ✓ | | [GREATEST\_IGNORE\_NULLS](https://docs.snowflake.com/en/sql-reference/functions/greatest_ignore_nulls) | Conditional expression | ✓ | | [IFF](https://docs.snowflake.com/en/sql-reference/functions/iff) | Conditional expression | ✓ | | [IFNULL](https://docs.snowflake.com/en/sql-reference/functions/ifnull) | Conditional expression | ✓ | | [IS \[ NOT \] DISTINCT FROM](https://docs.snowflake.com/en/sql-reference/functions/is-distinct-from) | Conditional expression | — | | [IS \[ NOT \] NULL](https://docs.snowflake.com/en/sql-reference/functions/is-null) | Conditional expression | — | | [IS\_NULL\_VALUE](https://docs.snowflake.com/en/sql-reference/functions/is_null_value) | Conditional expression | ✓ | | [LEAST](https://docs.snowflake.com/en/sql-reference/functions/least) | Conditional expression | ✓ | | [LEAST\_IGNORE\_NULLS](https://docs.snowflake.com/en/sql-reference/functions/least_ignore_nulls) | Conditional expression | ✓ | | [NULLIF](https://docs.snowflake.com/en/sql-reference/functions/nullif) | Conditional expression | ✓ | | [NULLIFZERO](https://docs.snowflake.com/en/sql-reference/functions/nullifzero) | Conditional expression | ✓ | | [NVL](https://docs.snowflake.com/en/sql-reference/functions/nvl) | Conditional expression | ✓ | | [NVL2](https://docs.snowflake.com/en/sql-reference/functions/nvl2) | Conditional expression | ✓ | | [REGR\_VALX](https://docs.snowflake.com/en/sql-reference/functions/regr_valx) | Conditional expression | ✓ | | [REGR\_VALY](https://docs.snowflake.com/en/sql-reference/functions/regr_valy) | Conditional expression | ✓ | | [ZEROIFNULL](https://docs.snowflake.com/en/sql-reference/functions/zeroifnull) | Conditional expression | ✓ | | [ALL\_USER\_NAMES](https://docs.snowflake.com/en/sql-reference/functions/all_user_names) | Context | ✓ | | [CURRENT\_ACCOUNT](https://docs.snowflake.com/en/sql-reference/functions/current_account) | Context | ✓ | | [CURRENT\_ACCOUNT\_NAME](https://docs.snowflake.com/en/sql-reference/functions/current_account_name) | Context | ✓ | | [CURRENT\_AVAILABLE\_ROLES](https://docs.snowflake.com/en/sql-reference/functions/current_available_roles) | Context | ✓ | | [CURRENT\_CLIENT](https://docs.snowflake.com/en/sql-reference/functions/current_client) | Context | ✓ | | [CURRENT\_DATABASE](https://docs.snowflake.com/en/sql-reference/functions/current_database) | Context | ✓ | | [CURRENT\_DATE](https://docs.snowflake.com/en/sql-reference/functions/current_date) | Context | ✓ | | [CURRENT\_IP\_ADDRESS](https://docs.snowflake.com/en/sql-reference/functions/current_ip_address) | Context | ✓ | | [CURRENT\_ORGANIZATION\_NAME](https://docs.snowflake.com/en/sql-reference/functions/current_organization_name) | Context | ✓ | | [CURRENT\_ORGANIZATION\_USER](https://docs.snowflake.com/en/sql-reference/functions/current_organization_user) | Context | — | | [CURRENT\_REGION](https://docs.snowflake.com/en/sql-reference/functions/current_region) | Context | ✓ | | [CURRENT\_ROLE](https://docs.snowflake.com/en/sql-reference/functions/current_role) | Context | ✓ | | [CURRENT\_ROLE\_TYPE](https://docs.snowflake.com/en/sql-reference/functions/current_role_type) | Context | ✓ | | [CURRENT\_SCHEMA](https://docs.snowflake.com/en/sql-reference/functions/current_schema) | Context | ✓ | | [CURRENT\_SCHEMAS](https://docs.snowflake.com/en/sql-reference/functions/current_schemas) | Context | ✓ | | [CURRENT\_SECONDARY\_ROLES](https://docs.snowflake.com/en/sql-reference/functions/current_secondary_roles) | Context | ✓ | | [CURRENT\_SESSION](https://docs.snowflake.com/en/sql-reference/functions/current_session) | Context | ✓ | | [CURRENT\_STATEMENT](https://docs.snowflake.com/en/sql-reference/functions/current_statement) | Context | ✓ | | [CURRENT\_TIME](https://docs.snowflake.com/en/sql-reference/functions/current_time) | Context | ✓ | | [CURRENT\_TIMESTAMP](https://docs.snowflake.com/en/sql-reference/functions/current_timestamp) | Context | ✓ | | [CURRENT\_TRANSACTION](https://docs.snowflake.com/en/sql-reference/functions/current_transaction) | Context | ✓ | | [CURRENT\_USER](https://docs.snowflake.com/en/sql-reference/functions/current_user) | Context | ✓ | | [CURRENT\_VERSION](https://docs.snowflake.com/en/sql-reference/functions/current_version) | Context | ✓ | | [CURRENT\_WAREHOUSE](https://docs.snowflake.com/en/sql-reference/functions/current_warehouse) | Context | ✓ | | [GET\_CONDITION\_QUERY\_UUID](https://docs.snowflake.com/en/sql-reference/functions/get_condition_query_uuid) | Context | — | | [GET\_CONFIGURATION\_VALUE (SYS\_CONTEXT FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/get_configuration_value) | Context | — | | [GETDATE](https://docs.snowflake.com/en/sql-reference/functions/getdate) | Context | ✓ | | [GETVARIABLE](https://docs.snowflake.com/en/sql-reference/functions/getvariable) | Context | ✓ | | [INVOKER\_ROLE](https://docs.snowflake.com/en/sql-reference/functions/invoker_role) | Context | ✓ | | [INVOKER\_SHARE](https://docs.snowflake.com/en/sql-reference/functions/invoker_share) | Context | ✓ | | [IS\_APPLICATION\_ROLE\_ACTIVATED (SYS\_CONTEXT FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/is_application_role_activated) | Context | — | | [IS\_APPLICATION\_ROLE\_IN\_SESSION](https://docs.snowflake.com/en/sql-reference/functions/is_application_role_in_session) | Context | ✓ | | [IS\_CONFIGURATION\_SET (SYS\_CONTEXT FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/is_configuration_set) | Context | — | | [IS\_DATABASE\_ROLE\_ACTIVATED (SYS\_CONTEXT FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/is_database_role_activated) | Context | — | | [IS\_DATABASE\_ROLE\_IN\_SESSION](https://docs.snowflake.com/en/sql-reference/functions/is_database_role_in_session) | Context | ✓ | | [IS\_GRANTED\_TO\_INVOKER\_ROLE](https://docs.snowflake.com/en/sql-reference/functions/is_granted_to_invoker_role) | Context | ✓ | | [IS\_GROUP\_ACTIVATED (SYS\_CONTEXT FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/is_group_activated) | Context | — | | [IS\_GROUP\_IMPORTED (SYS\_CONTEXT FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/is_group_imported) | Context | — | | [IS\_INSTANCE\_ROLE\_IN\_SESSION](https://docs.snowflake.com/en/sql-reference/functions/is_instance_role_in_session) | Context | — | | [IS\_ORGANIZATION\_USER\_GROUP\_IN\_SESSION](https://docs.snowflake.com/en/sql-reference/functions/is_organization_user_group_in_session) | Context | — | | [IS\_ROLE\_ACTIVATED (SYS\_CONTEXT FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/is_role_activated) | Context | — | | [IS\_ROLE\_IN\_SESSION](https://docs.snowflake.com/en/sql-reference/functions/is_role_in_session) | Context | ✓ | | [IS\_USER\_IMPORTED (SYS\_CONTEXT FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/is_user_imported) | Context | — | | [LAST\_QUERY\_ID](https://docs.snowflake.com/en/sql-reference/functions/last_query_id) | Context | ✓ | | [LAST\_TRANSACTION](https://docs.snowflake.com/en/sql-reference/functions/last_transaction) | Context | ✓ | | [LOCALTIME](https://docs.snowflake.com/en/sql-reference/functions/localtime) | Context | ✓ | | [LOCALTIMESTAMP](https://docs.snowflake.com/en/sql-reference/functions/localtimestamp) | Context | ✓ | | [POLICY\_CONTEXT](https://docs.snowflake.com/en/sql-reference/functions/policy_context) | Context | — | | [SET\_SYS\_CONTEXT](https://docs.snowflake.com/en/sql-reference/functions/set_sys_context) | Context | — | | [SYS\_CONTEXT](https://docs.snowflake.com/en/sql-reference/functions/sys_context) | Context | — | | [SYS\_CONTEXT (SNOWFLAKE$APPLICATION NAMESPACE)](https://docs.snowflake.com/en/sql-reference/functions/sys_context_snowflake_application) | Context | — | | [SYS\_CONTEXT (SNOWFLAKE$ENVIRONMENT NAMESPACE)](https://docs.snowflake.com/en/sql-reference/functions/sys_context_snowflake_environment) | Context | — | | [SYS\_CONTEXT (SNOWFLAKE$ORGANIZATION NAMESPACE)](https://docs.snowflake.com/en/sql-reference/functions/sys_context_snowflake_organization) | Context | — | | [SYS\_CONTEXT (SNOWFLAKE$ORGANIZATION\_SESSION NAMESPACE)](https://docs.snowflake.com/en/sql-reference/functions/sys_context_snowflake_organization_session) | Context | — | | [SYS\_CONTEXT (SNOWFLAKE$SESSION NAMESPACE)](https://docs.snowflake.com/en/sql-reference/functions/sys_context_snowflake_session) | Context | — | | [SYS\_CONTEXT (SNOWFLAKE$SESSION\_ATTRIBUTES NAMESPACE)](https://docs.snowflake.com/en/sql-reference/functions/sys_context_snowflake_session_attributes) | Context | — | | [SYSDATE](https://docs.snowflake.com/en/sql-reference/functions/sysdate) | Context | ✓ | | [SYSTIMESTAMP](https://docs.snowflake.com/en/sql-reference/functions/systimestamp) | Context | ✓ | | [CAST , ::](https://docs.snowflake.com/en/sql-reference/functions/cast) | Conversion | — | | [TO\_ARRAY](https://docs.snowflake.com/en/sql-reference/functions/to_array) | Conversion | ✓ | | [TO\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/to_binary) | Conversion | ✓ | | [TO\_BOOLEAN](https://docs.snowflake.com/en/sql-reference/functions/to_boolean) | Conversion | ✓ | | [TO\_CHAR , TO\_VARCHAR](https://docs.snowflake.com/en/sql-reference/functions/to_char) | Conversion | ✓ | | [TO\_DATE , DATE](https://docs.snowflake.com/en/sql-reference/functions/to_date) | Conversion | ✓ | | [TO\_DECFLOAT](https://docs.snowflake.com/en/sql-reference/functions/to_decfloat) | Conversion | — | | [TO\_DECIMAL , TO\_NUMBER , TO\_NUMERIC](https://docs.snowflake.com/en/sql-reference/functions/to_decimal) | Conversion | ✓ | | [TO\_DOUBLE](https://docs.snowflake.com/en/sql-reference/functions/to_double) | Conversion | ✓ | | [TO\_JSON](https://docs.snowflake.com/en/sql-reference/functions/to_json) | Conversion | ✓ | | [TO\_OBJECT](https://docs.snowflake.com/en/sql-reference/functions/to_object) | Conversion | ✓ | | [TO\_TIME , TIME](https://docs.snowflake.com/en/sql-reference/functions/to_time) | Conversion | ✓ | | [TO\_TIMESTAMP / TO\_TIMESTAMP\_\*](https://docs.snowflake.com/en/sql-reference/functions/to_timestamp) | Conversion | ✓ | | [TO\_UUID](https://docs.snowflake.com/en/sql-reference/functions/to_uuid) | Conversion | — | | [TO\_VARIANT](https://docs.snowflake.com/en/sql-reference/functions/to_variant) | Conversion | ✓ | | [TO\_XML](https://docs.snowflake.com/en/sql-reference/functions/to_xml) | Conversion | ✓ | | [TRY\_CAST](https://docs.snowflake.com/en/sql-reference/functions/try_cast) | Conversion | — | | [TRY\_TO\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/try_to_binary) | Conversion | ✓ | | [TRY\_TO\_BOOLEAN](https://docs.snowflake.com/en/sql-reference/functions/try_to_boolean) | Conversion | ✓ | | [TRY\_TO\_DATE](https://docs.snowflake.com/en/sql-reference/functions/try_to_date) | Conversion | ✓ | | [TRY\_TO\_DECFLOAT](https://docs.snowflake.com/en/sql-reference/functions/try_to_decfloat) | Conversion | — | | [TRY\_TO\_DECIMAL, TRY\_TO\_NUMBER, TRY\_TO\_NUMERIC](https://docs.snowflake.com/en/sql-reference/functions/try_to_decimal) | Conversion | ✓ | | [TRY\_TO\_DOUBLE](https://docs.snowflake.com/en/sql-reference/functions/try_to_double) | Conversion | ✓ | | [TRY\_TO\_TIME](https://docs.snowflake.com/en/sql-reference/functions/try_to_time) | Conversion | ✓ | | [TRY\_TO\_TIMESTAMP / TRY\_TO\_TIMESTAMP\_\*](https://docs.snowflake.com/en/sql-reference/functions/try_to_timestamp) | Conversion | ✓ | | [TRY\_TO\_UUID](https://docs.snowflake.com/en/sql-reference/functions/try_to_uuid) | Conversion | — | | [NORMAL](https://docs.snowflake.com/en/sql-reference/functions/normal) | Data generation | ✓ | | [RANDOM](https://docs.snowflake.com/en/sql-reference/functions/random) | Data generation | ✓ | | [RANDSTR](https://docs.snowflake.com/en/sql-reference/functions/randstr) | Data generation | ✓ | | [SEQ1 / SEQ2 / SEQ4 / SEQ8](https://docs.snowflake.com/en/sql-reference/functions/seq1) | Data generation | ✓ | | [UNIFORM](https://docs.snowflake.com/en/sql-reference/functions/uniform) | Data generation | ✓ | | [ZIPF](https://docs.snowflake.com/en/sql-reference/functions/zipf) | Data generation | ✓ | | [ACCEPTED\_VALUES (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_accepted_values) | Data metric | — | | [AVG (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_avg) | Data metric | ✓ | | [BLANK\_COUNT (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_blank_count) | Data metric | — | | [BLANK\_PERCENT (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_blank_percent) | Data metric | — | | [DATA\_METRIC\_SCHEDULED\_TIME (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_data_metric_schedule_time) | Data metric | — | | [DUPLICATE\_COUNT (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_duplicate_count) | Data metric | — | | [FRESHNESS (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_freshness) | Data metric | — | | [MAX (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_max) | Data metric | ✓ | | [MIN (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_min) | Data metric | ✓ | | [NULL\_COUNT (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_null_count) | Data metric | — | | [NULL\_PERCENT (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_null_percent) | Data metric | — | | [ROW\_COUNT (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_row_count) | Data metric | — | | [STDDEV (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_stddev) | Data metric | ✓ | | [UNIQUE\_COUNT (SYSTEM DATA METRIC FUNCTION)](https://docs.snowflake.com/en/sql-reference/functions/dmf_unique_count) | Data metric | — | | [ADD\_MONTHS](https://docs.snowflake.com/en/sql-reference/functions/add_months) | Date & time | ✓ | | [CONVERT\_TIMEZONE](https://docs.snowflake.com/en/sql-reference/functions/convert_timezone) | Date & time | ✓ | | [DATE\_FROM\_PARTS](https://docs.snowflake.com/en/sql-reference/functions/date_from_parts) | Date & time | ✓ | | [DATE\_PART](https://docs.snowflake.com/en/sql-reference/functions/date_part) | Date & time | ✓ | | [DATE\_TRUNC](https://docs.snowflake.com/en/sql-reference/functions/date_trunc) | Date & time | ✓ | | [DATEADD](https://docs.snowflake.com/en/sql-reference/functions/dateadd) | Date & time | ✓ | | [DATEDIFF](https://docs.snowflake.com/en/sql-reference/functions/datediff) | Date & time | ✓ | | [DAYNAME](https://docs.snowflake.com/en/sql-reference/functions/dayname) | Date & time | ✓ | | [EXTRACT](https://docs.snowflake.com/en/sql-reference/functions/extract) | Date & time | — | | [HOUR / MINUTE / SECOND](https://docs.snowflake.com/en/sql-reference/functions/hour-minute-second) | Date & time | ✓ | | [LAST\_DAY](https://docs.snowflake.com/en/sql-reference/functions/last_day) | Date & time | ✓ | | [LAST\_SUCCESSFUL\_SCHEDULED\_TIME](https://docs.snowflake.com/en/sql-reference/functions/last_successful_scheduled_time) | Date & time | — | | [MONTHNAME](https://docs.snowflake.com/en/sql-reference/functions/monthname) | Date & time | ✓ | | [MONTHS\_BETWEEN](https://docs.snowflake.com/en/sql-reference/functions/months_between) | Date & time | ✓ | | [NEXT\_DAY](https://docs.snowflake.com/en/sql-reference/functions/next_day) | Date & time | ✓ | | [PREVIOUS\_DAY](https://docs.snowflake.com/en/sql-reference/functions/previous_day) | Date & time | ✓ | | [SCHEDULED\_TIME](https://docs.snowflake.com/en/sql-reference/functions/scheduled_time) | Date & time | — | | [TIME\_FROM\_PARTS](https://docs.snowflake.com/en/sql-reference/functions/time_from_parts) | Date & time | ✓ | | [TIME\_SLICE](https://docs.snowflake.com/en/sql-reference/functions/time_slice) | Date & time | ✓ | | [TIMEADD](https://docs.snowflake.com/en/sql-reference/functions/timeadd) | Date & time | — | | [TIMEDIFF](https://docs.snowflake.com/en/sql-reference/functions/timediff) | Date & time | — | | [TIMESTAMP\_FROM\_PARTS](https://docs.snowflake.com/en/sql-reference/functions/timestamp_from_parts) | Date & time | ✓ | | [TIMESTAMPADD](https://docs.snowflake.com/en/sql-reference/functions/timestampadd) | Date & time | — | | [TIMESTAMPDIFF](https://docs.snowflake.com/en/sql-reference/functions/timestampdiff) | Date & time | — | | [TRUNCATE, TRUNC](https://docs.snowflake.com/en/sql-reference/functions/trunc2) | Date & time | — | | [YEAR\* / DAY\* / WEEK\* / MONTH / QUARTER](https://docs.snowflake.com/en/sql-reference/functions/year) | Date & time | ✓ | | [DP\_INTERVAL\_HIGH](https://docs.snowflake.com/en/sql-reference/functions/dp_interval_high) | Differential privacy | — | | [DP\_INTERVAL\_LOW](https://docs.snowflake.com/en/sql-reference/functions/dp_interval_low) | Differential privacy | — | | [ESTIMATE\_REMAINING\_DP\_AGGREGATES](https://docs.snowflake.com/en/sql-reference/functions/estimate_remaining_dp_aggregates) | Differential privacy | — | | [DECRYPT](https://docs.snowflake.com/en/sql-reference/functions/decrypt) | Encryption | ✓ | | [DECRYPT\_RAW](https://docs.snowflake.com/en/sql-reference/functions/decrypt_raw) | Encryption | ✓ | | [ENCRYPT](https://docs.snowflake.com/en/sql-reference/functions/encrypt) | Encryption | ✓ | | [ENCRYPT\_RAW](https://docs.snowflake.com/en/sql-reference/functions/encrypt_raw) | Encryption | ✓ | | [TRY\_DECRYPT](https://docs.snowflake.com/en/sql-reference/functions/try_decrypt) | Encryption | ✓ | | [TRY\_DECRYPT\_RAW](https://docs.snowflake.com/en/sql-reference/functions/try_decrypt_raw) | Encryption | ✓ | | [AI\_TRANSCRIBE](https://docs.snowflake.com/en/sql-reference/functions/ai_transcribe) | File | ✓ | | [BUILD\_SCOPED\_FILE\_URL](https://docs.snowflake.com/en/sql-reference/functions/build_scoped_file_url) | File | — | | [BUILD\_STAGE\_FILE\_URL](https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url) | File | — | | [FL\_GET\_CONTENT\_TYPE](https://docs.snowflake.com/en/sql-reference/functions/fl_get_content_type) | File | — | | [FL\_GET\_ETAG](https://docs.snowflake.com/en/sql-reference/functions/fl_get_etag) | File | — | | [FL\_GET\_FILE\_TYPE](https://docs.snowflake.com/en/sql-reference/functions/fl_get_file_type) | File | — | | [FL\_GET\_LAST\_MODIFIED](https://docs.snowflake.com/en/sql-reference/functions/fl_get_last_modified) | File | — | | [FL\_GET\_RELATIVE\_PATH](https://docs.snowflake.com/en/sql-reference/functions/fl_get_relative_path) | File | — | | [FL\_GET\_SCOPED\_FILE\_URL](https://docs.snowflake.com/en/sql-reference/functions/fl_get_scoped_file_url) | File | — | | [FL\_GET\_SIZE](https://docs.snowflake.com/en/sql-reference/functions/fl_get_size) | File | — | | [FL\_GET\_STAGE](https://docs.snowflake.com/en/sql-reference/functions/fl_get_stage) | File | — | | [FL\_GET\_STAGE\_FILE\_URL](https://docs.snowflake.com/en/sql-reference/functions/fl_get_stage_file_url) | File | — | | [FL\_IS\_AUDIO](https://docs.snowflake.com/en/sql-reference/functions/fl_is_audio) | File | — | | [FL\_IS\_COMPRESSED](https://docs.snowflake.com/en/sql-reference/functions/fl_is_compressed) | File | — | | [FL\_IS\_DOCUMENT](https://docs.snowflake.com/en/sql-reference/functions/fl_is_document) | File | — | | [FL\_IS\_IMAGE](https://docs.snowflake.com/en/sql-reference/functions/fl_is_image) | File | — | | [FL\_IS\_VIDEO](https://docs.snowflake.com/en/sql-reference/functions/fl_is_video) | File | — | | [GET\_ABSOLUTE\_PATH](https://docs.snowflake.com/en/sql-reference/functions/get_absolute_path) | File | — | | [GET\_PRESIGNED\_URL](https://docs.snowflake.com/en/sql-reference/functions/get_presigned_url) | File | — | | [GET\_RELATIVE\_PATH](https://docs.snowflake.com/en/sql-reference/functions/get_relative_path) | File | — | | [GET\_STAGE\_LOCATION](https://docs.snowflake.com/en/sql-reference/functions/get_stage_location) | File | — | | [PARSE\_DOCUMENT (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/parse_document-snowflake-cortex) | File | — | | [TO\_FILE](https://docs.snowflake.com/en/sql-reference/functions/to_file) | File | ✓ | | [TRY\_TO\_FILE](https://docs.snowflake.com/en/sql-reference/functions/try_to_file) | File | ✓ | | [GENERATE\_POSTGRES\_ACCESS\_TOKEN\_FOR\_USER](https://docs.snowflake.com/en/sql-reference/functions/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. | — | | [H3\_CELL\_TO\_BOUNDARY](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_boundary) | Geospatial | ✓ | | [H3\_CELL\_TO\_CHILDREN](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_children) | Geospatial | ✓ | | [H3\_CELL\_TO\_CHILDREN\_STRING](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_children_string) | Geospatial | ✓ | | [H3\_CELL\_TO\_PARENT](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_parent) | Geospatial | ✓ | | [H3\_CELL\_TO\_POINT](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_point) | Geospatial | ✓ | | [H3\_COMPACT\_CELLS](https://docs.snowflake.com/en/sql-reference/functions/h3_compact_cells) | Geospatial | — | | [H3\_COMPACT\_CELLS\_STRINGS](https://docs.snowflake.com/en/sql-reference/functions/h3_compact_cells_strings) | Geospatial | — | | [H3\_COVERAGE](https://docs.snowflake.com/en/sql-reference/functions/h3_coverage) | Geospatial | ✓ | | [H3\_COVERAGE\_STRINGS](https://docs.snowflake.com/en/sql-reference/functions/h3_coverage_strings) | Geospatial | ✓ | | [H3\_GET\_RESOLUTION](https://docs.snowflake.com/en/sql-reference/functions/h3_get_resolution) | Geospatial | ✓ | | [H3\_GRID\_DISK](https://docs.snowflake.com/en/sql-reference/functions/h3_grid_disk) | Geospatial | ✓ | | [H3\_GRID\_DISTANCE](https://docs.snowflake.com/en/sql-reference/functions/h3_grid_distance) | Geospatial | ✓ | | [H3\_GRID\_PATH](https://docs.snowflake.com/en/sql-reference/functions/h3_grid_path) | Geospatial | ✓ | | [H3\_INT\_TO\_STRING](https://docs.snowflake.com/en/sql-reference/functions/h3_int_to_string) | Geospatial | ✓ | | [H3\_IS\_PENTAGON](https://docs.snowflake.com/en/sql-reference/functions/h3_is_pentagon) | Geospatial | — | | [H3\_IS\_VALID\_CELL](https://docs.snowflake.com/en/sql-reference/functions/h3_is_valid_cell) | Geospatial | — | | [H3\_LATLNG\_TO\_CELL](https://docs.snowflake.com/en/sql-reference/functions/h3_latlng_to_cell) | Geospatial | ✓ | | [H3\_LATLNG\_TO\_CELL\_STRING](https://docs.snowflake.com/en/sql-reference/functions/h3_latlng_to_cell_string) | Geospatial | ✓ | | [H3\_POINT\_TO\_CELL](https://docs.snowflake.com/en/sql-reference/functions/h3_point_to_cell) | Geospatial | ✓ | | [H3\_POINT\_TO\_CELL\_STRING](https://docs.snowflake.com/en/sql-reference/functions/h3_point_to_cell_string) | Geospatial | ✓ | | [H3\_POLYGON\_TO\_CELLS](https://docs.snowflake.com/en/sql-reference/functions/h3_polygon_to_cells) | Geospatial | ✓ | | [H3\_POLYGON\_TO\_CELLS\_STRINGS](https://docs.snowflake.com/en/sql-reference/functions/h3_polygon_to_cells_strings) | Geospatial | ✓ | | [H3\_STRING\_TO\_INT](https://docs.snowflake.com/en/sql-reference/functions/h3_string_to_int) | Geospatial | ✓ | | [H3\_TRY\_COVERAGE](https://docs.snowflake.com/en/sql-reference/functions/h3_try_coverage) | Geospatial | — | | [H3\_TRY\_COVERAGE\_STRINGS](https://docs.snowflake.com/en/sql-reference/functions/h3_try_coverage_strings) | Geospatial | — | | [H3\_TRY\_GRID\_DISTANCE](https://docs.snowflake.com/en/sql-reference/functions/h3_try_grid_distance) | Geospatial | — | | [H3\_TRY\_GRID\_PATH](https://docs.snowflake.com/en/sql-reference/functions/h3_try_grid_path) | Geospatial | — | | [H3\_TRY\_POLYGON\_TO\_CELLS](https://docs.snowflake.com/en/sql-reference/functions/h3_try_polygon_to_cells) | Geospatial | — | | [H3\_TRY\_POLYGON\_TO\_CELLS\_STRINGS](https://docs.snowflake.com/en/sql-reference/functions/h3_try_polygon_to_cells_strings) | Geospatial | — | | [H3\_UNCOMPACT\_CELLS](https://docs.snowflake.com/en/sql-reference/functions/h3_uncompact_cells) | Geospatial | — | | [H3\_UNCOMPACT\_CELLS\_STRINGS](https://docs.snowflake.com/en/sql-reference/functions/h3_uncompact_cells_strings) | Geospatial | — | | [HAVERSINE](https://docs.snowflake.com/en/sql-reference/functions/haversine) | Geospatial | ✓ | | [ST\_AREA](https://docs.snowflake.com/en/sql-reference/functions/st_area) | Geospatial | ✓ | | [ST\_ASEWKB](https://docs.snowflake.com/en/sql-reference/functions/st_asewkb) | Geospatial | ✓ | | [ST\_ASEWKT](https://docs.snowflake.com/en/sql-reference/functions/st_asewkt) | Geospatial | ✓ | | [ST\_ASGEOJSON](https://docs.snowflake.com/en/sql-reference/functions/st_asgeojson) | Geospatial | ✓ | | [ST\_ASWKB , ST\_ASBINARY](https://docs.snowflake.com/en/sql-reference/functions/st_aswkb) | Geospatial | ✓ | | [ST\_ASWKT , ST\_ASTEXT](https://docs.snowflake.com/en/sql-reference/functions/st_aswkt) | Geospatial | ✓ | | [ST\_AZIMUTH](https://docs.snowflake.com/en/sql-reference/functions/st_azimuth) | Geospatial | ✓ | | [ST\_BUFFER](https://docs.snowflake.com/en/sql-reference/functions/st_buffer) | Geospatial | ✓ | | [ST\_CENTROID](https://docs.snowflake.com/en/sql-reference/functions/st_centroid) | Geospatial | ✓ | | [ST\_COLLECT](https://docs.snowflake.com/en/sql-reference/functions/st_collect) | Geospatial | ✓ | | [ST\_CONTAINS](https://docs.snowflake.com/en/sql-reference/functions/st_contains) | Geospatial | ✓ | | [ST\_COVEREDBY](https://docs.snowflake.com/en/sql-reference/functions/st_coveredby) | Geospatial | ✓ | | [ST\_COVERS](https://docs.snowflake.com/en/sql-reference/functions/st_covers) | Geospatial | ✓ | | [ST\_DIFFERENCE](https://docs.snowflake.com/en/sql-reference/functions/st_difference) | Geospatial | ✓ | | [ST\_DIMENSION](https://docs.snowflake.com/en/sql-reference/functions/st_dimension) | Geospatial | ✓ | | [ST\_DISJOINT](https://docs.snowflake.com/en/sql-reference/functions/st_disjoint) | Geospatial | ✓ | | [ST\_DISTANCE](https://docs.snowflake.com/en/sql-reference/functions/st_distance) | Geospatial | ✓ | | [ST\_DWITHIN](https://docs.snowflake.com/en/sql-reference/functions/st_dwithin) | Geospatial | ✓ | | [ST\_ENDPOINT](https://docs.snowflake.com/en/sql-reference/functions/st_endpoint) | Geospatial | ✓ | | [ST\_ENVELOPE](https://docs.snowflake.com/en/sql-reference/functions/st_envelope) | Geospatial | ✓ | | [ST\_GEOGFROMGEOHASH](https://docs.snowflake.com/en/sql-reference/functions/st_geogfromgeohash) | Geospatial | ✓ | | [ST\_GEOGPOINTFROMGEOHASH](https://docs.snowflake.com/en/sql-reference/functions/st_geogpointfromgeohash) | Geospatial | ✓ | | [ST\_GEOGRAPHYFROMWKB](https://docs.snowflake.com/en/sql-reference/functions/st_geographyfromwkb) | Geospatial | ✓ | | [ST\_GEOGRAPHYFROMWKT](https://docs.snowflake.com/en/sql-reference/functions/st_geographyfromwkt) | Geospatial | ✓ | | [ST\_GEOHASH](https://docs.snowflake.com/en/sql-reference/functions/st_geohash) | Geospatial | ✓ | | [ST\_GEOMETRYFROMWKB](https://docs.snowflake.com/en/sql-reference/functions/st_geometryfromwkb) | Geospatial | ✓ | | [ST\_GEOMETRYFROMWKT](https://docs.snowflake.com/en/sql-reference/functions/st_geometryfromwkt) | Geospatial | ✓ | | [ST\_GEOMFROMGEOHASH](https://docs.snowflake.com/en/sql-reference/functions/st_geomfromgeohash) | Geospatial | — | | [ST\_GEOMPOINTFROMGEOHASH](https://docs.snowflake.com/en/sql-reference/functions/st_geompointfromgeohash) | Geospatial | — | | [ST\_HAUSDORFFDISTANCE](https://docs.snowflake.com/en/sql-reference/functions/st_hausdorffdistance) | Geospatial | ✓ | | [ST\_INTERPOLATE](https://docs.snowflake.com/en/sql-reference/functions/st_interpolate) | Geospatial | — | | [ST\_INTERSECTION](https://docs.snowflake.com/en/sql-reference/functions/st_intersection) | Geospatial | ✓ | | [ST\_INTERSECTION\_AGG](https://docs.snowflake.com/en/sql-reference/functions/st_intersection_agg) | Geospatial | — | | [ST\_INTERSECTS](https://docs.snowflake.com/en/sql-reference/functions/st_intersects) | Geospatial | ✓ | | [ST\_ISVALID](https://docs.snowflake.com/en/sql-reference/functions/st_isvalid) | Geospatial | ✓ | | [ST\_LENGTH](https://docs.snowflake.com/en/sql-reference/functions/st_length) | Geospatial | ✓ | | [ST\_MAKEGEOMPOINT , ST\_GEOMPOINT](https://docs.snowflake.com/en/sql-reference/functions/st_makegeompoint) | Geospatial | ✓ | | [ST\_MAKELINE](https://docs.snowflake.com/en/sql-reference/functions/st_makeline) | Geospatial | ✓ | | [ST\_MAKEPOINT , ST\_POINT](https://docs.snowflake.com/en/sql-reference/functions/st_makepoint) | Geospatial | ✓ | | [ST\_MAKEPOLYGON , ST\_POLYGON](https://docs.snowflake.com/en/sql-reference/functions/st_makepolygon) | Geospatial | ✓ | | [ST\_MAKEPOLYGONORIENTED](https://docs.snowflake.com/en/sql-reference/functions/st_makepolygonoriented) | Geospatial | ✓ | | [ST\_NPOINTS , ST\_NUMPOINTS](https://docs.snowflake.com/en/sql-reference/functions/st_npoints) | Geospatial | ✓ | | [ST\_PERIMETER](https://docs.snowflake.com/en/sql-reference/functions/st_perimeter) | Geospatial | ✓ | | [ST\_POINTN](https://docs.snowflake.com/en/sql-reference/functions/st_pointn) | Geospatial | ✓ | | [ST\_SETSRID](https://docs.snowflake.com/en/sql-reference/functions/st_setsrid) | Geospatial | ✓ | | [ST\_SIMPLIFY](https://docs.snowflake.com/en/sql-reference/functions/st_simplify) | Geospatial | ✓ | | [ST\_SRID](https://docs.snowflake.com/en/sql-reference/functions/st_srid) | Geospatial | ✓ | | [ST\_STARTPOINT](https://docs.snowflake.com/en/sql-reference/functions/st_startpoint) | Geospatial | ✓ | | [ST\_SYMDIFFERENCE](https://docs.snowflake.com/en/sql-reference/functions/st_symdifference) | Geospatial | ✓ | | [ST\_TRANSFORM](https://docs.snowflake.com/en/sql-reference/functions/st_transform) | Geospatial | ✓ | | [ST\_UNION](https://docs.snowflake.com/en/sql-reference/functions/st_union) | Geospatial | ✓ | | [ST\_UNION\_AGG](https://docs.snowflake.com/en/sql-reference/functions/st_union_agg) | Geospatial | ✓ | | [ST\_WITHIN](https://docs.snowflake.com/en/sql-reference/functions/st_within) | Geospatial | ✓ | | [ST\_X](https://docs.snowflake.com/en/sql-reference/functions/st_x) | Geospatial | ✓ | | [ST\_XMAX](https://docs.snowflake.com/en/sql-reference/functions/st_xmax) | Geospatial | ✓ | | [ST\_XMIN](https://docs.snowflake.com/en/sql-reference/functions/st_xmin) | Geospatial | ✓ | | [ST\_Y](https://docs.snowflake.com/en/sql-reference/functions/st_y) | Geospatial | ✓ | | [ST\_YMAX](https://docs.snowflake.com/en/sql-reference/functions/st_ymax) | Geospatial | ✓ | | [ST\_YMIN](https://docs.snowflake.com/en/sql-reference/functions/st_ymin) | Geospatial | ✓ | | [TO\_GEOGRAPHY](https://docs.snowflake.com/en/sql-reference/functions/to_geography) | Geospatial | ✓ | | [TO\_GEOMETRY](https://docs.snowflake.com/en/sql-reference/functions/to_geometry) | Geospatial | ✓ | | [TRY\_TO\_GEOGRAPHY](https://docs.snowflake.com/en/sql-reference/functions/try_to_geography) | Geospatial | ✓ | | [TRY\_TO\_GEOMETRY](https://docs.snowflake.com/en/sql-reference/functions/try_to_geometry) | Geospatial | ✓ | | [HASH](https://docs.snowflake.com/en/sql-reference/functions/hash) | Hash | ✓ | | [ALERT\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/alert_history) | Information Schema | ✓ | | [APPLICATION\_CALLBACK\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/application_callback_history) | Information Schema | — | | [APPLICATION\_SPECIFICATION\_STATUS\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/application_specification_status_history) | Information Schema | — | | [AUTO\_REFRESH\_REGISTRATION\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/auto_refresh_registration_history) | Information Schema | ✓ | | [AUTOMATIC\_CLUSTERING\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/automatic_clustering_history) | Information Schema | ✓ | | [AVAILABLE\_LISTING\_REFRESH\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/available_listing_refresh_history) | Information Schema | — | | [AVAILABLE\_LISTINGS](https://docs.snowflake.com/en/sql-reference/functions/available_listings) | Information Schema | — | | [BIND\_VALUES](https://docs.snowflake.com/en/sql-reference/functions/bind_values) | Information Schema | — | | [COMPLETE\_TASK\_GRAPHS](https://docs.snowflake.com/en/sql-reference/functions/complete_task_graphs) | Information Schema | ✓ | | [COPY\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/copy_history) | Information Schema | ✓ | | [CORTEX\_SEARCH\_REFRESH\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/cortex_search_refresh_history) | Information Schema | — | | [CURRENT\_TASK\_GRAPHS](https://docs.snowflake.com/en/sql-reference/functions/current_task_graphs) | Information Schema | ✓ | | [DATA\_METRIC\_FUNCTION\_EXPECTATIONS](https://docs.snowflake.com/en/sql-reference/functions/data_metric_function_expectations) | Information Schema | — | | [DATA\_METRIC\_FUNCTION\_REFERENCES](https://docs.snowflake.com/en/sql-reference/functions/data_metric_function_references) | Information Schema | — | | [DATA\_TRANSFER\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/data_transfer_history) | Information Schema | ✓ | | [DATABASE\_REFRESH\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/database_refresh_history) | Information Schema | ✓ | | [DATABASE\_REFRESH\_PROGRESS , DATABASE\_REFRESH\_PROGRESS\_BY\_JOB](https://docs.snowflake.com/en/sql-reference/functions/database_refresh_progress) | Information Schema | ✓ | | [DATABASE\_REPLICATION\_USAGE\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/database_replication_usage_history) | Information Schema | ✓ | | [DATABASE\_STORAGE\_USAGE\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/database_storage_usage_history) | Information Schema | ✓ | | [DBT\_PROJECT\_EXECUTION\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/dbt_project_execution_history) | Information Schema | — | | [DYNAMIC\_TABLE\_GRAPH\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/dynamic_table_graph_history) | Information Schema | ✓ | | [DYNAMIC\_TABLE\_REFRESH\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/dynamic_table_refresh_history) | Information Schema | ✓ | | [DYNAMIC\_TABLES](https://docs.snowflake.com/en/sql-reference/functions/dynamic_tables) | Information Schema | — | | [EXTERNAL\_FUNCTIONS\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/external_functions_history) | Information Schema | ✓ | | [EXTERNAL\_TABLE\_FILE\_REGISTRATION\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/external_table_registration_history) | Information Schema | ✓ | | [EXTERNAL\_TABLE\_FILES](https://docs.snowflake.com/en/sql-reference/functions/external_table_files) | Information Schema | ✓ | | [LISTING\_REFRESH\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/listing_refresh_history) | Information Schema | — | | [LOGIN\_HISTORY , LOGIN\_HISTORY\_BY\_USER](https://docs.snowflake.com/en/sql-reference/functions/login_history) | Information Schema | ✓ | | [MATERIALIZED\_VIEW\_REFRESH\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/materialized_view_refresh_history) | Information Schema | ✓ | | [NETWORK\_RULE\_REFERENCES](https://docs.snowflake.com/en/sql-reference/functions/network_rule_references) | Information Schema | — | | [NOTIFICATION\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/notification_history) | Information Schema | ✓ | | [ONLINE\_FEATURE\_TABLE\_REFRESH\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/online-feature-table-refresh-history) | Information Schema | — | | [PIPE\_USAGE\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/pipe_usage_history) | Information Schema | ✓ | | [POLICY\_REFERENCES](https://docs.snowflake.com/en/sql-reference/functions/policy_references) | Information Schema | ✓ | | [QUERY\_ACCELERATION\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/query_acceleration_history) | Information Schema | ✓ | | [QUERY\_HISTORY , QUERY\_HISTORY\_BY\_\*](https://docs.snowflake.com/en/sql-reference/functions/query_history) | Information Schema | ✓ | | [REPLICATION\_GROUP\_DANGLING\_REFERENCES](https://docs.snowflake.com/en/sql-reference/functions/replication_group_dangling_references) | Information Schema | — | | [REPLICATION\_GROUP\_REFRESH\_HISTORY, REPLICATION\_GROUP\_REFRESH\_HISTORY\_ALL](https://docs.snowflake.com/en/sql-reference/functions/replication_group_refresh_history) | Information Schema | ✓ | | [REPLICATION\_GROUP\_REFRESH\_PROGRESS, REPLICATION\_GROUP\_REFRESH\_PROGRESS\_BY\_JOB, REPLICATION\_GROUP\_REFRESH\_PROGRESS\_ALL](https://docs.snowflake.com/en/sql-reference/functions/replication_group_refresh_progress) | Information Schema | ✓ | | [REPLICATION\_GROUP\_USAGE\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/replication_group_usage_history) | Information Schema | ✓ | | [REPLICATION\_USAGE\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/replication_usage_history) | Information Schema | ✓ | | [SEARCH\_OPTIMIZATION\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/search_optimization_history) | Information Schema | ✓ | | [SERVERLESS\_ALERT\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/serverless_alert_history) | Information Schema | — | | [SERVERLESS\_TASK\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/serverless_task_history) | Information Schema | ✓ | | [STAGE\_DIRECTORY\_FILE\_REGISTRATION\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/stage_directory_file_registration_history) | Information Schema | ✓ | | [STAGE\_STORAGE\_USAGE\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/stage_storage_usage_history) | Information Schema | ✓ | | [TAG\_REFERENCES](https://docs.snowflake.com/en/sql-reference/functions/tag_references) | Information Schema | ✓ | | [TAG\_REFERENCES\_ALL\_COLUMNS](https://docs.snowflake.com/en/sql-reference/functions/tag_references_all_columns) | Information Schema | ✓ | | [TASK\_DEPENDENTS](https://docs.snowflake.com/en/sql-reference/functions/task_dependents) | Information Schema | ✓ | | [TASK\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/task_history) | Information Schema | ✓ | | [VALIDATE\_PIPE\_LOAD](https://docs.snowflake.com/en/sql-reference/functions/validate_pipe_load) | Information Schema | ✓ | | [WAREHOUSE\_LOAD\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/warehouse_load_history) | Information Schema | ✓ | | [WAREHOUSE\_METERING\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/warehouse_metering_history) | Information Schema | ✓ | | [DATA\_QUALITY\_MONITORING\_EXPECTATION\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/data_quality_monitoring_expectation_status) | LOCAL schema | — | | [DATA\_QUALITY\_MONITORING\_RESULTS](https://docs.snowflake.com/en/sql-reference/functions/data_quality_monitoring_results) | LOCAL schema | — | | [GENERATE\_COLUMN\_DESCRIPTION](https://docs.snowflake.com/en/sql-reference/functions/generate_column_description) | Metadata | ✓ | | [GET\_DDL](https://docs.snowflake.com/en/sql-reference/functions/get_ddl) | Metadata | ✓ | | [MODEL\_MONITOR\_DRIFT\_METRIC](https://docs.snowflake.com/en/sql-reference/functions/model-monitor-drift-metric) | Model monitor | — | | [MODEL\_MONITOR\_PERFORMANCE\_METRIC](https://docs.snowflake.com/en/sql-reference/functions/model-monitor-performance-metric) | Model monitor | — | | [MODEL\_MONITOR\_STAT\_METRIC](https://docs.snowflake.com/en/sql-reference/functions/model-monitor-stat-metric) | Model monitor | — | | [APPLICATION\_JSON](https://docs.snowflake.com/en/sql-reference/functions/application_json) | Notification | — | | [EMAIL\_INTEGRATION\_CONFIG](https://docs.snowflake.com/en/sql-reference/functions/email_integration_config) | Notification | — | | [INTEGRATION](https://docs.snowflake.com/en/sql-reference/functions/integration) | Notification | — | | [SANITIZE\_WEBHOOK\_CONTENT](https://docs.snowflake.com/en/sql-reference/functions/sanitize_webhook_content) | Notification | — | | [TEXT\_HTML](https://docs.snowflake.com/en/sql-reference/functions/text_html) | Notification | — | | [TEXT\_PLAIN](https://docs.snowflake.com/en/sql-reference/functions/text_plain) | Notification | — | | [ABS](https://docs.snowflake.com/en/sql-reference/functions/abs) | Numeric | ✓ | | [ACOS](https://docs.snowflake.com/en/sql-reference/functions/acos) | Numeric | ✓ | | [ACOSH](https://docs.snowflake.com/en/sql-reference/functions/acosh) | Numeric | ✓ | | [ASIN](https://docs.snowflake.com/en/sql-reference/functions/asin) | Numeric | ✓ | | [ASINH](https://docs.snowflake.com/en/sql-reference/functions/asinh) | Numeric | ✓ | | [ATAN](https://docs.snowflake.com/en/sql-reference/functions/atan) | Numeric | ✓ | | [ATAN2](https://docs.snowflake.com/en/sql-reference/functions/atan2) | Numeric | ✓ | | [ATANH](https://docs.snowflake.com/en/sql-reference/functions/atanh) | Numeric | ✓ | | [CBRT](https://docs.snowflake.com/en/sql-reference/functions/cbrt) | Numeric | ✓ | | [CEIL](https://docs.snowflake.com/en/sql-reference/functions/ceil) | Numeric | ✓ | | [COS](https://docs.snowflake.com/en/sql-reference/functions/cos) | Numeric | ✓ | | [COSH](https://docs.snowflake.com/en/sql-reference/functions/cosh) | Numeric | ✓ | | [COT](https://docs.snowflake.com/en/sql-reference/functions/cot) | Numeric | ✓ | | [DEGREES](https://docs.snowflake.com/en/sql-reference/functions/degrees) | Numeric | ✓ | | [DIV0](https://docs.snowflake.com/en/sql-reference/functions/div0) | Numeric | ✓ | | [DIV0NULL](https://docs.snowflake.com/en/sql-reference/functions/div0null) | Numeric | ✓ | | [EXP](https://docs.snowflake.com/en/sql-reference/functions/exp) | Numeric | ✓ | | [FACTORIAL](https://docs.snowflake.com/en/sql-reference/functions/factorial) | Numeric | ✓ | | [FLOOR](https://docs.snowflake.com/en/sql-reference/functions/floor) | Numeric | ✓ | | [LN](https://docs.snowflake.com/en/sql-reference/functions/ln) | Numeric | ✓ | | [LOG](https://docs.snowflake.com/en/sql-reference/functions/log) | Numeric | ✓ | | [MOD](https://docs.snowflake.com/en/sql-reference/functions/mod) | Numeric | — | | [PI](https://docs.snowflake.com/en/sql-reference/functions/pi) | Numeric | ✓ | | [POW, POWER](https://docs.snowflake.com/en/sql-reference/functions/pow) | Numeric | ✓ | | [RADIANS](https://docs.snowflake.com/en/sql-reference/functions/radians) | Numeric | ✓ | | [ROUND](https://docs.snowflake.com/en/sql-reference/functions/round) | Numeric | ✓ | | [SIGN](https://docs.snowflake.com/en/sql-reference/functions/sign) | Numeric | ✓ | | [SIN](https://docs.snowflake.com/en/sql-reference/functions/sin) | Numeric | ✓ | | [SINH](https://docs.snowflake.com/en/sql-reference/functions/sinh) | Numeric | ✓ | | [SQRT](https://docs.snowflake.com/en/sql-reference/functions/sqrt) | Numeric | ✓ | | [SQUARE](https://docs.snowflake.com/en/sql-reference/functions/square) | Numeric | ✓ | | [TAN](https://docs.snowflake.com/en/sql-reference/functions/tan) | Numeric | ✓ | | [TANH](https://docs.snowflake.com/en/sql-reference/functions/tanh) | Numeric | ✓ | | [TRUNCATE , TRUNC](https://docs.snowflake.com/en/sql-reference/functions/trunc) | Numeric | ✓ | | [WIDTH\_BUCKET](https://docs.snowflake.com/en/sql-reference/functions/width_bucket) | Numeric | ✓ | | [IS\_ORGANIZATION\_USER](https://docs.snowflake.com/en/sql-reference/functions/is_organization_user) | Organization user and organization user group | — | | [IS\_ORGANIZATION\_USER\_GROUP](https://docs.snowflake.com/en/sql-reference/functions/is_organization_user_group) | Organization user and organization user group | — | | [ARRAY\_APPEND](https://docs.snowflake.com/en/sql-reference/functions/array_append) | Semi-structured and structured data | ✓ | | [ARRAY\_CAT](https://docs.snowflake.com/en/sql-reference/functions/array_cat) | Semi-structured and structured data | ✓ | | [ARRAY\_COMPACT](https://docs.snowflake.com/en/sql-reference/functions/array_compact) | Semi-structured and structured data | ✓ | | [ARRAY\_CONSTRUCT](https://docs.snowflake.com/en/sql-reference/functions/array_construct) | Semi-structured and structured data | ✓ | | [ARRAY\_CONSTRUCT\_COMPACT](https://docs.snowflake.com/en/sql-reference/functions/array_construct_compact) | Semi-structured and structured data | ✓ | | [ARRAY\_CONSTRUCT\_STRUCTURED](https://docs.snowflake.com/en/sql-reference/functions/array_construct_structured) | Semi-structured and structured data | — | | [ARRAY\_CONTAINS](https://docs.snowflake.com/en/sql-reference/functions/array_contains) | Semi-structured and structured data | ✓ | | [ARRAY\_DISTINCT](https://docs.snowflake.com/en/sql-reference/functions/array_distinct) | Semi-structured and structured data | ✓ | | [ARRAY\_EXCEPT](https://docs.snowflake.com/en/sql-reference/functions/array_except) | Semi-structured and structured data | ✓ | | [ARRAY\_FLATTEN](https://docs.snowflake.com/en/sql-reference/functions/array_flatten) | Semi-structured and structured data | ✓ | | [ARRAY\_GENERATE\_RANGE](https://docs.snowflake.com/en/sql-reference/functions/array_generate_range) | Semi-structured and structured data | ✓ | | [ARRAY\_INSERT](https://docs.snowflake.com/en/sql-reference/functions/array_insert) | Semi-structured and structured data | ✓ | | [ARRAY\_INTERSECTION](https://docs.snowflake.com/en/sql-reference/functions/array_intersection) | Semi-structured and structured data | ✓ | | [ARRAY\_MAX](https://docs.snowflake.com/en/sql-reference/functions/array_max) | Semi-structured and structured data | ✓ | | [ARRAY\_MIN](https://docs.snowflake.com/en/sql-reference/functions/array_min) | Semi-structured and structured data | ✓ | | [ARRAY\_POSITION](https://docs.snowflake.com/en/sql-reference/functions/array_position) | Semi-structured and structured data | ✓ | | [ARRAY\_PREPEND](https://docs.snowflake.com/en/sql-reference/functions/array_prepend) | Semi-structured and structured data | ✓ | | [ARRAY\_REMOVE](https://docs.snowflake.com/en/sql-reference/functions/array_remove) | Semi-structured and structured data | ✓ | | [ARRAY\_REMOVE\_AT](https://docs.snowflake.com/en/sql-reference/functions/array_remove_at) | Semi-structured and structured data | ✓ | | [ARRAY\_REVERSE](https://docs.snowflake.com/en/sql-reference/functions/array_reverse) | Semi-structured and structured data | ✓ | | [ARRAY\_SIZE](https://docs.snowflake.com/en/sql-reference/functions/array_size) | Semi-structured and structured data | ✓ | | [ARRAY\_SLICE](https://docs.snowflake.com/en/sql-reference/functions/array_slice) | Semi-structured and structured data | ✓ | | [ARRAY\_SORT](https://docs.snowflake.com/en/sql-reference/functions/array_sort) | Semi-structured and structured data | ✓ | | [ARRAY\_TO\_STRING](https://docs.snowflake.com/en/sql-reference/functions/array_to_string) | Semi-structured and structured data | ✓ | | [ARRAYS\_OVERLAP](https://docs.snowflake.com/en/sql-reference/functions/arrays_overlap) | Semi-structured and structured data | ✓ | | [ARRAYS\_TO\_OBJECT](https://docs.snowflake.com/en/sql-reference/functions/arrays_to_object) | Semi-structured and structured data | ✓ | | [ARRAYS\_ZIP](https://docs.snowflake.com/en/sql-reference/functions/arrays_zip) | Semi-structured and structured data | ✓ | | [AS\_*\*](https://docs.snowflake.com/en/sql-reference/functions/as) | Semi-structured and structured data | — | | [AS\_ARRAY](https://docs.snowflake.com/en/sql-reference/functions/as_array) | Semi-structured and structured data | ✓ | | [AS\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/as_binary) | Semi-structured and structured data | ✓ | | [AS\_BOOLEAN](https://docs.snowflake.com/en/sql-reference/functions/as_boolean) | Semi-structured and structured data | ✓ | | [AS\_CHAR , AS\_VARCHAR](https://docs.snowflake.com/en/sql-reference/functions/as_char-varchar) | Semi-structured and structured data | ✓ | | [AS\_DATE](https://docs.snowflake.com/en/sql-reference/functions/as_date) | Semi-structured and structured data | ✓ | | [AS\_DECIMAL , AS\_NUMBER](https://docs.snowflake.com/en/sql-reference/functions/as_decimal-number) | Semi-structured and structured data | ✓ | | [AS\_DOUBLE , AS\_REAL](https://docs.snowflake.com/en/sql-reference/functions/as_double-real) | Semi-structured and structured data | ✓ | | [AS\_INTEGER](https://docs.snowflake.com/en/sql-reference/functions/as_integer) | Semi-structured and structured data | ✓ | | [AS\_OBJECT](https://docs.snowflake.com/en/sql-reference/functions/as_object) | Semi-structured and structured data | ✓ | | [AS\_TIME](https://docs.snowflake.com/en/sql-reference/functions/as_time) | Semi-structured and structured data | ✓ | | [AS\_TIMESTAMP\_\*](https://docs.snowflake.com/en/sql-reference/functions/as_timestamp) | Semi-structured and structured data | ✓ | | [CHECK\_JSON](https://docs.snowflake.com/en/sql-reference/functions/check_json) | Semi-structured and structured data | ✓ | | [CHECK\_XML](https://docs.snowflake.com/en/sql-reference/functions/check_xml) | Semi-structured and structured data | ✓ | | [FILTER](https://docs.snowflake.com/en/sql-reference/functions/filter) | Semi-structured and structured data | ✓ | | [GET](https://docs.snowflake.com/en/sql-reference/functions/get) | Semi-structured and structured data | ✓ | | [GET\_IGNORE\_CASE](https://docs.snowflake.com/en/sql-reference/functions/get_ignore_case) | Semi-structured and structured data | ✓ | | [GET\_PATH , :](https://docs.snowflake.com/en/sql-reference/functions/get_path) | Semi-structured and structured data | ✓ | | [IS\_*\*](https://docs.snowflake.com/en/sql-reference/functions/is) | Semi-structured and structured data | — | | [IS\_ARRAY](https://docs.snowflake.com/en/sql-reference/functions/is_array) | Semi-structured and structured data | ✓ | | [IS\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/is_binary) | Semi-structured and structured data | ✓ | | [IS\_BOOLEAN](https://docs.snowflake.com/en/sql-reference/functions/is_boolean) | Semi-structured and structured data | ✓ | | [IS\_CHAR , IS\_VARCHAR](https://docs.snowflake.com/en/sql-reference/functions/is_char-varchar) | Semi-structured and structured data | ✓ | | [IS\_DATE , IS\_DATE\_VALUE](https://docs.snowflake.com/en/sql-reference/functions/is_date-value) | Semi-structured and structured data | ✓ | | [IS\_DECIMAL](https://docs.snowflake.com/en/sql-reference/functions/is_decimal) | Semi-structured and structured data | ✓ | | [IS\_DOUBLE , IS\_REAL](https://docs.snowflake.com/en/sql-reference/functions/is_double-real) | Semi-structured and structured data | ✓ | | [IS\_INTEGER](https://docs.snowflake.com/en/sql-reference/functions/is_integer) | Semi-structured and structured data | ✓ | | [IS\_OBJECT](https://docs.snowflake.com/en/sql-reference/functions/is_object) | Semi-structured and structured data | ✓ | | [IS\_TIME](https://docs.snowflake.com/en/sql-reference/functions/is_time) | Semi-structured and structured data | ✓ | | [IS\_TIMESTAMP\_\*](https://docs.snowflake.com/en/sql-reference/functions/is_timestamp) | Semi-structured and structured data | ✓ | | [JSON\_EXTRACT\_PATH\_TEXT](https://docs.snowflake.com/en/sql-reference/functions/json_extract_path_text) | Semi-structured and structured data | ✓ | | [MAP\_CAT](https://docs.snowflake.com/en/sql-reference/functions/map_cat) | Semi-structured and structured data | ✓ | | [MAP\_CONSTRUCT](https://docs.snowflake.com/en/sql-reference/functions/map_construct) | Semi-structured and structured data | — | | [MAP\_CONTAINS\_KEY](https://docs.snowflake.com/en/sql-reference/functions/map_contains_key) | Semi-structured and structured data | ✓ | | [MAP\_DELETE](https://docs.snowflake.com/en/sql-reference/functions/map_delete) | Semi-structured and structured data | ✓ | | [MAP\_ENTRIES](https://docs.snowflake.com/en/sql-reference/functions/map_entries) | Semi-structured and structured data | — | | [MAP\_INSERT](https://docs.snowflake.com/en/sql-reference/functions/map_insert) | Semi-structured and structured data | ✓ | | [MAP\_KEYS](https://docs.snowflake.com/en/sql-reference/functions/map_keys) | Semi-structured and structured data | ✓ | | [MAP\_PICK](https://docs.snowflake.com/en/sql-reference/functions/map_pick) | Semi-structured and structured data | ✓ | | [MAP\_SIZE](https://docs.snowflake.com/en/sql-reference/functions/map_size) | Semi-structured and structured data | ✓ | | [OBJECT\_CONSTRUCT](https://docs.snowflake.com/en/sql-reference/functions/object_construct) | Semi-structured and structured data | ✓ | | [OBJECT\_CONSTRUCT\_KEEP\_NULL](https://docs.snowflake.com/en/sql-reference/functions/object_construct_keep_null) | Semi-structured and structured data | ✓ | | [OBJECT\_CONSTRUCT\_KEEP\_NULL\_STRUCTURED](https://docs.snowflake.com/en/sql-reference/functions/object_construct_keep_null_structured) | Semi-structured and structured data | — | | [OBJECT\_DELETE](https://docs.snowflake.com/en/sql-reference/functions/object_delete) | Semi-structured and structured data | ✓ | | [OBJECT\_INSERT](https://docs.snowflake.com/en/sql-reference/functions/object_insert) | Semi-structured and structured data | ✓ | | [OBJECT\_KEYS](https://docs.snowflake.com/en/sql-reference/functions/object_keys) | Semi-structured and structured data | ✓ | | [OBJECT\_PICK](https://docs.snowflake.com/en/sql-reference/functions/object_pick) | Semi-structured and structured data | ✓ | | [PARSE\_JSON](https://docs.snowflake.com/en/sql-reference/functions/parse_json) | Semi-structured and structured data | ✓ | | [PARSE\_XML](https://docs.snowflake.com/en/sql-reference/functions/parse_xml) | Semi-structured and structured data | ✓ | | [PROMPT](https://docs.snowflake.com/en/sql-reference/functions/prompt) | Semi-structured and structured data | ✓ | | [REDUCE](https://docs.snowflake.com/en/sql-reference/functions/reduce) | Semi-structured and structured data | ✓ | | [STRIP\_NULL\_VALUE](https://docs.snowflake.com/en/sql-reference/functions/strip_null_value) | Semi-structured and structured data | ✓ | | [TRANSFORM](https://docs.snowflake.com/en/sql-reference/functions/transform) | Semi-structured and structured data | ✓ | | [TRY\_PARSE\_JSON](https://docs.snowflake.com/en/sql-reference/functions/try_parse_json) | Semi-structured and structured data | ✓ | | [TYPEOF](https://docs.snowflake.com/en/sql-reference/functions/typeof) | Semi-structured and structured data | ✓ | | [XMLGET](https://docs.snowflake.com/en/sql-reference/functions/xmlget) | Semi-structured and structured data | ✓ | | [\!SPCS\_WAIT\_FOR](https://docs.snowflake.com/en/sql-reference/functions/spcs_wait_for) | Snowpark Container Services | — | | [\[ NOT \] ILIKE](https://docs.snowflake.com/en/sql-reference/functions/ilike) | String & binary | ✓ | | [\[ NOT \] LIKE](https://docs.snowflake.com/en/sql-reference/functions/like) | String & binary | ✓ | | [AGENT\_RUN (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/agent_run-snowflake-cortex) | String & binary | — | | [AI\_CLASSIFY](https://docs.snowflake.com/en/sql-reference/functions/ai_classify) | String & binary | ✓ | | [AI\_COMPLETE](https://docs.snowflake.com/en/sql-reference/functions/ai_complete) | String & binary | ✓ | | [AI\_COMPLETE (PROMPT OBJECT)](https://docs.snowflake.com/en/sql-reference/functions/ai_complete-prompt-object) | String & binary | ✓ | | [AI\_COMPLETE (SINGLE IMAGE)](https://docs.snowflake.com/en/sql-reference/functions/ai_complete-single-file) | String & binary | ✓ | | [AI\_COMPLETE (SINGLE STRING)](https://docs.snowflake.com/en/sql-reference/functions/ai_complete-single-string) | String & binary | ✓ | | [AI\_COUNT\_TOKENS](https://docs.snowflake.com/en/sql-reference/functions/ai_count_tokens) | String & binary | ✓ | | [AI\_EMBED](https://docs.snowflake.com/en/sql-reference/functions/ai_embed) | String & binary | ✓ | | [AI\_EXTRACT](https://docs.snowflake.com/en/sql-reference/functions/ai_extract) | String & binary | ✓ | | [AI\_EXTRACT (DOCUMENT AI LEGACY MODELS)](https://docs.snowflake.com/en/sql-reference/functions/ai_extract-document-ai) | String & binary | ✓ | | [AI\_FILTER](https://docs.snowflake.com/en/sql-reference/functions/ai_filter) | String & binary | ✓ | | [AI\_MULTI\_EMBED](https://docs.snowflake.com/en/sql-reference/functions/ai_multi_embed) | String & binary | — | | [AI\_PARSE\_DOCUMENT](https://docs.snowflake.com/en/sql-reference/functions/ai_parse_document) | String & binary | ✓ | | [AI\_REDACT](https://docs.snowflake.com/en/sql-reference/functions/ai_redact) | String & binary | ✓ | | [AI\_SENTIMENT](https://docs.snowflake.com/en/sql-reference/functions/ai_sentiment) | String & binary | ✓ | | [AI\_SIMILARITY](https://docs.snowflake.com/en/sql-reference/functions/ai_similarity) | String & binary | ✓ | | [AI\_TRANSLATE](https://docs.snowflake.com/en/sql-reference/functions/ai_translate) | String & binary | ✓ | | [ASCII](https://docs.snowflake.com/en/sql-reference/functions/ascii) | String & binary | ✓ | | [BASE64\_DECODE\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/base64_decode_binary) | String & binary | ✓ | | [BASE64\_DECODE\_STRING](https://docs.snowflake.com/en/sql-reference/functions/base64_decode_string) | String & binary | ✓ | | [BASE64\_ENCODE](https://docs.snowflake.com/en/sql-reference/functions/base64_encode) | String & binary | ✓ | | [BIT\_LENGTH](https://docs.snowflake.com/en/sql-reference/functions/bit_length) | String & binary | ✓ | | [CHARINDEX](https://docs.snowflake.com/en/sql-reference/functions/charindex) | String & binary | ✓ | | [CHR , CHAR](https://docs.snowflake.com/en/sql-reference/functions/chr) | String & binary | ✓ | | [CLASSIFY\_TEXT (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/classify_text-snowflake-cortex) | String & binary | ✓ | | [COLLATE](https://docs.snowflake.com/en/sql-reference/functions/collate) | String & binary | ✓ | | [COLLATION](https://docs.snowflake.com/en/sql-reference/functions/collation) | String & binary | ✓ | | [COMPLETE (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/complete-snowflake-cortex) | String & binary | ✓ | | [COMPLETE (SNOWFLAKE.CORTEX) (MULTIMODAL)](https://docs.snowflake.com/en/sql-reference/functions/complete-snowflake-cortex-multimodal) | String & binary | — | | [COMPRESS](https://docs.snowflake.com/en/sql-reference/functions/compress) | String & binary | ✓ | | [CONCAT , \|\|](https://docs.snowflake.com/en/sql-reference/functions/concat) | String & binary | ✓ | | [CONCAT\_WS](https://docs.snowflake.com/en/sql-reference/functions/concat_ws) | String & binary | ✓ | | [CONTAINS](https://docs.snowflake.com/en/sql-reference/functions/contains) | String & binary | ✓ | | [COUNT\_TOKENS (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/count_tokens-snowflake-cortex) | String & binary | ✓ | | [DATA\_AGENT\_RUN (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/data_agent_run-snowflake-cortex) | String & binary | ✓ | | [DECOMPRESS\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/decompress_binary) | String & binary | ✓ | | [DECOMPRESS\_STRING](https://docs.snowflake.com/en/sql-reference/functions/decompress_string) | String & binary | ✓ | | [EDITDISTANCE](https://docs.snowflake.com/en/sql-reference/functions/editdistance) | String & binary | ✓ | | [EMBED\_TEXT\_1024 (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/embed_text_1024-snowflake-cortex) | String & binary | ✓ | | [EMBED\_TEXT\_768 (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/embed_text-snowflake-cortex) | String & binary | — | | [ENDSWITH](https://docs.snowflake.com/en/sql-reference/functions/endswith) | String & binary | ✓ | | [ENTITY\_SENTIMENT (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/entity_sentiment-snowflake-cortex) | String & binary | ✓ | | [EXTRACT\_ANSWER (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/extract_answer-snowflake-cortex) | String & binary | ✓ | | [FINETUNE (‘CANCEL’) (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/finetune-cancel) | String & binary | — | | [FINETUNE (‘CREATE’) (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/finetune-create) | String & binary | — | | [FINETUNE (‘DESCRIBE’) (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/finetune-describe) | String & binary | — | | [FINETUNE (‘SHOW’) (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/finetune-show) | String & binary | ✓ | | [FINETUNE (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/finetune-snowflake-cortex) | String & binary | ✓ | | [HEX\_DECODE\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/hex_decode_binary) | String & binary | ✓ | | [HEX\_DECODE\_STRING](https://docs.snowflake.com/en/sql-reference/functions/hex_decode_string) | String & binary | ✓ | | [HEX\_ENCODE](https://docs.snowflake.com/en/sql-reference/functions/hex_encode) | String & binary | ✓ | | [ILIKE ANY](https://docs.snowflake.com/en/sql-reference/functions/ilike_any) | String & binary | ✓ | | [INITCAP](https://docs.snowflake.com/en/sql-reference/functions/initcap) | String & binary | ✓ | | [INSERT](https://docs.snowflake.com/en/sql-reference/functions/insert) | String & binary | ✓ | | [JAROWINKLER\_SIMILARITY](https://docs.snowflake.com/en/sql-reference/functions/jarowinkler_similarity) | String & binary | ✓ | | [LEFT](https://docs.snowflake.com/en/sql-reference/functions/left) | String & binary | ✓ | | [LENGTH, LEN](https://docs.snowflake.com/en/sql-reference/functions/length) | String & binary | ✓ | | [LIKE ALL](https://docs.snowflake.com/en/sql-reference/functions/like_all) | String & binary | ✓ | | [LIKE ANY](https://docs.snowflake.com/en/sql-reference/functions/like_any) | String & binary | ✓ | | [LOWER](https://docs.snowflake.com/en/sql-reference/functions/lower) | String & binary | ✓ | | [LPAD](https://docs.snowflake.com/en/sql-reference/functions/lpad) | String & binary | ✓ | | [LTRIM](https://docs.snowflake.com/en/sql-reference/functions/ltrim) | String & binary | ✓ | | [MD5 , MD5\_HEX](https://docs.snowflake.com/en/sql-reference/functions/md5) | String & binary | ✓ | | [MD5\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/md5_binary) | String & binary | ✓ | | [MD5\_NUMBER — OBSOLETED](https://docs.snowflake.com/en/sql-reference/functions/md5_number) | String & binary | — | | [MD5\_NUMBER\_LOWER64](https://docs.snowflake.com/en/sql-reference/functions/md5_number_lower64) | String & binary | ✓ | | [MD5\_NUMBER\_UPPER64](https://docs.snowflake.com/en/sql-reference/functions/md5_number_upper64) | String & binary | ✓ | | [OCTET\_LENGTH](https://docs.snowflake.com/en/sql-reference/functions/octet_length) | String & binary | ✓ | | [PARSE\_IP](https://docs.snowflake.com/en/sql-reference/functions/parse_ip) | String & binary | ✓ | | [PARSE\_URL](https://docs.snowflake.com/en/sql-reference/functions/parse_url) | String & binary | ✓ | | [POSITION](https://docs.snowflake.com/en/sql-reference/functions/position) | String & binary | ✓ | | [REPEAT](https://docs.snowflake.com/en/sql-reference/functions/repeat) | String & binary | ✓ | | [REPLACE](https://docs.snowflake.com/en/sql-reference/functions/replace) | String & binary | ✓ | | [REVERSE](https://docs.snowflake.com/en/sql-reference/functions/reverse) | String & binary | ✓ | | [RIGHT](https://docs.snowflake.com/en/sql-reference/functions/right) | String & binary | ✓ | | [RPAD](https://docs.snowflake.com/en/sql-reference/functions/rpad) | String & binary | ✓ | | [RTRIM](https://docs.snowflake.com/en/sql-reference/functions/rtrim) | String & binary | ✓ | | [RTRIMMED\_LENGTH](https://docs.snowflake.com/en/sql-reference/functions/rtrimmed_length) | String & binary | ✓ | | [SEARCH](https://docs.snowflake.com/en/sql-reference/functions/search) | String & binary | ✓ | | [SEARCH\_IP](https://docs.snowflake.com/en/sql-reference/functions/search_ip) | String & binary | — | | [SEARCH\_PREVIEW (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/search_preview-snowflake-cortex) | String & binary | — | | [SENTIMENT (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/sentiment-snowflake-cortex) | String & binary | ✓ | | [SHA1 , SHA1\_HEX](https://docs.snowflake.com/en/sql-reference/functions/sha1) | String & binary | ✓ | | [SHA1\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/sha1_binary) | String & binary | ✓ | | [SHA2 , SHA2\_HEX](https://docs.snowflake.com/en/sql-reference/functions/sha2) | String & binary | ✓ | | [SHA2\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/sha2_binary) | String & binary | ✓ | | [SOUNDEX](https://docs.snowflake.com/en/sql-reference/functions/soundex) | String & binary | ✓ | | [SOUNDEX\_P123](https://docs.snowflake.com/en/sql-reference/functions/soundex_p123) | String & binary | ✓ | | [SPACE](https://docs.snowflake.com/en/sql-reference/functions/space) | String & binary | ✓ | | [SPLIT](https://docs.snowflake.com/en/sql-reference/functions/split) | String & binary | ✓ | | [SPLIT\_PART](https://docs.snowflake.com/en/sql-reference/functions/split_part) | String & binary | ✓ | | [SPLIT\_TEXT\_MARKDOWN\_HEADER (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/split_text_markdown_header-snowflake-cortex) | String & binary | ✓ | | [SPLIT\_TEXT\_RECURSIVE\_CHARACTER (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/split_text_recursive_character-snowflake-cortex) | String & binary | ✓ | | [SPLIT\_TO\_TABLE](https://docs.snowflake.com/en/sql-reference/functions/split_to_table) | String & binary | ✓ | | [STARTSWITH](https://docs.snowflake.com/en/sql-reference/functions/startswith) | String & binary | ✓ | | [STRTOK](https://docs.snowflake.com/en/sql-reference/functions/strtok) | String & binary | ✓ | | [STRTOK\_SPLIT\_TO\_TABLE](https://docs.snowflake.com/en/sql-reference/functions/strtok_split_to_table) | String & binary | ✓ | | [STRTOK\_TO\_ARRAY](https://docs.snowflake.com/en/sql-reference/functions/strtok_to_array) | String & binary | ✓ | | [SUBSTR , SUBSTRING](https://docs.snowflake.com/en/sql-reference/functions/substr) | String & binary | ✓ | | [SUMMARIZE (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/summarize-snowflake-cortex) | String & binary | ✓ | | [TRANSLATE](https://docs.snowflake.com/en/sql-reference/functions/translate) | String & binary | ✓ | | [TRANSLATE (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/translate-snowflake-cortex) | String & binary | ✓ | | [TRIM](https://docs.snowflake.com/en/sql-reference/functions/trim) | String & binary | ✓ | | [TRY\_BASE64\_DECODE\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/try_base64_decode_binary) | String & binary | ✓ | | [TRY\_BASE64\_DECODE\_STRING](https://docs.snowflake.com/en/sql-reference/functions/try_base64_decode_string) | String & binary | ✓ | | [TRY\_COMPLETE (SNOWFLAKE.CORTEX)](https://docs.snowflake.com/en/sql-reference/functions/try_complete-snowflake-cortex) | String & binary | ✓ | | [TRY\_HEX\_DECODE\_BINARY](https://docs.snowflake.com/en/sql-reference/functions/try_hex_decode_binary) | String & binary | ✓ | | [TRY\_HEX\_DECODE\_STRING](https://docs.snowflake.com/en/sql-reference/functions/try_hex_decode_string) | String & binary | ✓ | | [UNICODE](https://docs.snowflake.com/en/sql-reference/functions/unicode) | String & binary | ✓ | | [UPPER](https://docs.snowflake.com/en/sql-reference/functions/upper) | String & binary | ✓ | | [UUID\_STRING](https://docs.snowflake.com/en/sql-reference/functions/uuid_string) | String & binary | ✓ | | [\[ NOT \] REGEXP](https://docs.snowflake.com/en/sql-reference/functions/regexp) | String functions (regular expressions) | ✓ | | [\[ NOT \] RLIKE](https://docs.snowflake.com/en/sql-reference/functions/rlike) | String functions (regular expressions) | ✓ | | [REGEXP\_COUNT](https://docs.snowflake.com/en/sql-reference/functions/regexp_count) | String functions (regular expressions) | ✓ | | [REGEXP\_INSTR](https://docs.snowflake.com/en/sql-reference/functions/regexp_instr) | String functions (regular expressions) | ✓ | | [REGEXP\_LIKE](https://docs.snowflake.com/en/sql-reference/functions/regexp_like) | String functions (regular expressions) | ✓ | | [REGEXP\_REPLACE](https://docs.snowflake.com/en/sql-reference/functions/regexp_replace) | String functions (regular expressions) | ✓ | | [REGEXP\_SUBSTR](https://docs.snowflake.com/en/sql-reference/functions/regexp_substr) | String functions (regular expressions) | ✓ | | [REGEXP\_SUBSTR\_ALL](https://docs.snowflake.com/en/sql-reference/functions/regexp_substr_all) | String functions (regular expressions) | ✓ | | [EXECUTE\_AI\_EVALUATION](https://docs.snowflake.com/en/sql-reference/functions/execute_ai_evaluation) | System | — | | [EXPLAIN\_JSON](https://docs.snowflake.com/en/sql-reference/functions/explain_json) | System | — | | [EXTRACT\_SEMANTIC\_CATEGORIES](https://docs.snowflake.com/en/sql-reference/functions/extract_semantic_categories) | System | — | | [GET\_ANACONDA\_PACKAGES\_REPODATA](https://docs.snowflake.com/en/sql-reference/functions/get_anaconda_packages_repodata) | System | — | | [GET\_PYTHON\_PROFILER\_OUTPUT (SNOWFLAKE.CORE)](https://docs.snowflake.com/en/sql-reference/functions/get_python_profiler_output) | System | — | | [GET\_QUERY\_OPERATOR\_STATS](https://docs.snowflake.com/en/sql-reference/functions/get_query_operator_stats) | System | ✓ | | [SHOW\_PYTHON\_PACKAGES\_DEPENDENCIES](https://docs.snowflake.com/en/sql-reference/functions/show_python_packages_dependencies) | System | — | | [SYSTEM$ABORT\_SESSION](https://docs.snowflake.com/en/sql-reference/functions/system_abort_session) | System | ✓ | | [SYSTEM$ABORT\_TRANSACTION](https://docs.snowflake.com/en/sql-reference/functions/system_abort_transaction) | System | ✓ | | [SYSTEM$ACTIVATE\_CMK\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_activate_cmk_info) | System | — | | [SYSTEM$ACTIVATE\_CMK\_INFO\_POSTGRES](https://docs.snowflake.com/en/sql-reference/functions/system_activate_cmk_info_postgres) | System | — | | [SYSTEM$ADD\_EVENT (FOR SNOWFLAKE SCRIPTING)](https://docs.snowflake.com/en/sql-reference/functions/system_add_event) | System | — | | [SYSTEM$ADD\_REFERENCE](https://docs.snowflake.com/en/sql-reference/functions/system_add_reference) | System | ✓ | | [SYSTEM$ALLOWLIST](https://docs.snowflake.com/en/sql-reference/functions/system_allowlist) | System | — | | [SYSTEM$ALLOWLIST\_PRIVATELINK](https://docs.snowflake.com/en/sql-reference/functions/system_allowlist_privatelink) | System | — | | [SYSTEM$APP\_COMPATIBILITY\_CHECK](https://docs.snowflake.com/en/sql-reference/functions/system_app_compatibility_check) | System | — | | [SYSTEM$APPLICATION\_GET\_LOG\_LEVEL](https://docs.snowflake.com/en/sql-reference/functions/system_application_get_log_level) | System | — | | [SYSTEM$APPLICATION\_GET\_METRIC\_LEVEL](https://docs.snowflake.com/en/sql-reference/functions/system_application_get_metric_level) | System | — | | [SYSTEM$APPLICATION\_GET\_TRACE\_LEVEL](https://docs.snowflake.com/en/sql-reference/functions/system_application_get_trace_level) | System | — | | [SYSTEM$AUTHORIZE\_PRIVATELINK](https://docs.snowflake.com/en/sql-reference/functions/system_authorize_privatelink) | System | — | | [SYSTEM$AUTHORIZE\_STAGE\_PRIVATELINK\_ACCESS](https://docs.snowflake.com/en/sql-reference/functions/system_authorize_stage_privatelink_access) | System | — | | [SYSTEM$AUTO\_REFRESH\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_auto_refresh_status) | System | ✓ | | [SYSTEM$BEGIN\_DEBUG\_APPLICATION](https://docs.snowflake.com/en/sql-reference/functions/system_begin_debug_application) | System | — | | [SYSTEM$BEHAVIOR\_CHANGE\_BUNDLE\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_behavior_change_bundle_status) | System | ✓ | | [SYSTEM$BLOCK\_INTERNAL\_STAGES\_PUBLIC\_ACCESS](https://docs.snowflake.com/en/sql-reference/functions/system_block_internal_stages_public_access) | System | — | | [SYSTEM$BLOCK\_INTERNAL\_STAGES\_PUBLIC\_ACCESS\_WITH\_EXCEPTION](https://docs.snowflake.com/en/sql-reference/functions/system_block_internal_stages_public_access_with_exception) | System | — | | [SYSTEM$CANCEL\_ALL\_QUERIES](https://docs.snowflake.com/en/sql-reference/functions/system_cancel_all_queries) | System | ✓ | | [SYSTEM$CANCEL\_QUERY](https://docs.snowflake.com/en/sql-reference/functions/system_cancel_query) | System | ✓ | | [SYSTEM$CATALOG\_LINK\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_catalog_link_status) | System | — | | [SYSTEM$CKE\_HASH\_FUNCTION](https://docs.snowflake.com/en/sql-reference/functions/system_cke_hash_function) | System | — | | [SYSTEM$CLEANUP\_DATABASE\_ROLE\_GRANTS](https://docs.snowflake.com/en/sql-reference/functions/system_cleanup_database_role_grants) | System | — | | [SYSTEM$CLIENT\_VERSION\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_client_version_info) | System | — | | [SYSTEM$CLIENT\_VULNERABILITY\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_client_vulnerability_info) | System | — | | [SYSTEM$CLUSTERING\_DEPTH](https://docs.snowflake.com/en/sql-reference/functions/system_clustering_depth) | System | ✓ | | [SYSTEM$CLUSTERING\_INFORMATION](https://docs.snowflake.com/en/sql-reference/functions/system_clustering_information) | System | ✓ | | [SYSTEM$CLUSTERING\_RATIO — DEPRECATED](https://docs.snowflake.com/en/sql-reference/functions/system_clustering_ratio) | System | ✓ | | [SYSTEM$COMMIT\_MOVE\_ORGANIZATION\_ACCOUNT](https://docs.snowflake.com/en/sql-reference/functions/system_commit_move_organization_account) | System | — | | [SYSTEM$CONVERT\_PIPES\_SQS\_TO\_SNS](https://docs.snowflake.com/en/sql-reference/functions/system_convert_pipes_sqs_to_sns) | System | ✓ | | [SYSTEM$CREATE\_BILLING\_EVENT](https://docs.snowflake.com/en/sql-reference/functions/system_create_billing_event) | System | — | | [SYSTEM$CREATE\_BILLING\_EVENTS](https://docs.snowflake.com/en/sql-reference/functions/system_create_billing_events) | System | — | | [SYSTEM$CURRENT\_USER\_TASK\_NAME](https://docs.snowflake.com/en/sql-reference/functions/system_current_user_task_name) | System | — | | [SYSTEM$DATA\_METRIC\_SCAN](https://docs.snowflake.com/en/sql-reference/functions/system_data_metric_scan) | System | — | | [SYSTEM$DATABASE\_REFRESH\_HISTORY — DEPRECATED](https://docs.snowflake.com/en/sql-reference/functions/system_database_refresh_history) | System | — | | [SYSTEM$DATABASE\_REFRESH\_PROGRESS , SYSTEM$DATABASE\_REFRESH\_PROGRESS\_BY\_JOB — DEPRECATED](https://docs.snowflake.com/en/sql-reference/functions/system_database_refresh_progress) | System | — | | [SYSTEM$DEACTIVATE\_CMK\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_deactivate_cmk_info) | System | — | | [SYSTEM$DECODE\_PAT](https://docs.snowflake.com/en/sql-reference/functions/system_decode_pat) | System | — | | [SYSTEM$DEPROVISION\_PRIVATELINK\_ENDPOINT](https://docs.snowflake.com/en/sql-reference/functions/system_deprovision_privatelink_endpoint) | System | — | | [SYSTEM$DEPROVISION\_PRIVATELINK\_ENDPOINT\_TSS](https://docs.snowflake.com/en/sql-reference/functions/system_deprovision_privatelink_endpoint_tss) | System | — | | [SYSTEM$DEREGISTER\_CMK\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_deregister_cmk_info) | System | — | | [SYSTEM$DEREGISTER\_CMK\_INFO\_POSTGRES](https://docs.snowflake.com/en/sql-reference/functions/system_deregister_cmk_info_postgres) | System | — | | [SYSTEM$DESC\_ICEBERG\_ACCESS\_IDENTITY](https://docs.snowflake.com/en/sql-reference/functions/system_desc_iceberg_access_identity) | System | — | | [SYSTEM$DISABLE\_BEHAVIOR\_CHANGE\_BUNDLE](https://docs.snowflake.com/en/sql-reference/functions/system_disable_behavior_change_bundle) | System | — | | [SYSTEM$DISABLE\_DATABASE\_REPLICATION](https://docs.snowflake.com/en/sql-reference/functions/system_disable_database_replication) | System | ✓ | | [SYSTEM$DISABLE\_GLOBAL\_DATA\_SHARING\_FOR\_ACCOUNT](https://docs.snowflake.com/en/sql-reference/functions/system_disable_global_data_sharing_for_account) | System | — | | [SYSTEM$DISABLE\_PREVIEW\_ACCESS](https://docs.snowflake.com/en/sql-reference/functions/system_disable_preview_access) | System | — | | [SYSTEM$DISABLE\_PRIVATELINK\_ACCESS\_ONLY](https://docs.snowflake.com/en/sql-reference/functions/system_disable_privatelink_access_only) | System | — | | [SYSTEM$ENABLE\_BEHAVIOR\_CHANGE\_BUNDLE](https://docs.snowflake.com/en/sql-reference/functions/system_enable_behavior_change_bundle) | System | — | | [SYSTEM$ENABLE\_GLOBAL\_DATA\_SHARING\_FOR\_ACCOUNT](https://docs.snowflake.com/en/sql-reference/functions/system_enable_global_data_sharing_for_account) | System | — | | [SYSTEM$ENABLE\_PREVIEW\_ACCESS](https://docs.snowflake.com/en/sql-reference/functions/system_enable_preview_access) | System | — | | [SYSTEM$ENCODE\_CKE\_PRIMARY\_KEY](https://docs.snowflake.com/en/sql-reference/functions/system_encode_cke_primary_key) | System | — | | [SYSTEM$END\_DEBUG\_APPLICATION](https://docs.snowflake.com/en/sql-reference/functions/system_end_debug_application) | System | — | | [SYSTEM$ENFORCE\_PRIVATELINK\_ACCESS\_ONLY](https://docs.snowflake.com/en/sql-reference/functions/system_enforce_privatelink_access_only) | System | — | | [SYSTEM$ESTIMATE\_AUTOMATIC\_CLUSTERING\_COSTS](https://docs.snowflake.com/en/sql-reference/functions/system_estimate_automatic_clustering_costs) | System | — | | [SYSTEM$ESTIMATE\_QUERY\_ACCELERATION](https://docs.snowflake.com/en/sql-reference/functions/system_estimate_query_acceleration) | System | ✓ | | [SYSTEM$ESTIMATE\_SEARCH\_OPTIMIZATION\_COSTS](https://docs.snowflake.com/en/sql-reference/functions/system_estimate_search_optimization_costs) | System | ✓ | | [SYSTEM$EVALUATE\_DATA\_QUALITY\_EXPECTATIONS](https://docs.snowflake.com/en/sql-reference/functions/system_evaluate_data_quality_expectations) | System | — | | [SYSTEM$EVALUATE\_DATA\_QUALITY\_EXPECTATIONS\_PERSIST\_RESULT](https://docs.snowflake.com/en/sql-reference/functions/system_evaluate_data_quality_expectations_persist_result) | System | ✓ | | [SYSTEM$EXPLAIN\_JSON\_TO\_TEXT](https://docs.snowflake.com/en/sql-reference/functions/system_explain_json_to_text) | System | ✓ | | [SYSTEM$EXPLAIN\_PLAN\_JSON](https://docs.snowflake.com/en/sql-reference/functions/system_explain_plan_json) | System | ✓ | | [SYSTEM$EXPORT\_TDS\_FROM\_SEMANTIC\_VIEW](https://docs.snowflake.com/en/sql-reference/functions/system_export_tds_from_semantic_view) | System | — | | [SYSTEM$EXTERNAL\_TABLE\_PIPE\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_external_table_pipe_status) | System | ✓ | | [SYSTEM$FINISH\_OAUTH\_FLOW](https://docs.snowflake.com/en/sql-reference/functions/system_finish_oauth_flow) | System | — | | [SYSTEM$GENERATE\_SAML\_CSR](https://docs.snowflake.com/en/sql-reference/functions/system_generate_saml_csr) | System | ✓ | | [SYSTEM$GENERATE\_SCIM\_ACCESS\_TOKEN](https://docs.snowflake.com/en/sql-reference/functions/system_generate_scim_access_token) | System | — | | [SYSTEM$GET\_ALL\_DEFAULT\_COLUMNS\_OVERRIDES](https://docs.snowflake.com/en/sql-reference/functions/system_get_all_default_columns_overrides) | System | — | | [SYSTEM$GET\_ALL\_REFERENCES](https://docs.snowflake.com/en/sql-reference/functions/system_get_all_references) | System | ✓ | | [SYSTEM$GET\_AWS\_SNS\_IAM\_POLICY](https://docs.snowflake.com/en/sql-reference/functions/system_get_aws_sns_iam_policy) | System | ✓ | | [SYSTEM$GET\_CATALOG\_LINKED\_DATABASE\_CONFIG](https://docs.snowflake.com/en/sql-reference/functions/system_get_catalog_linked_database_config) | System | — | | [SYSTEM$GET\_CLASSIFICATION\_RESULT](https://docs.snowflake.com/en/sql-reference/functions/system_get_classification_result) | System | — | | [SYSTEM$GET\_CMK\_AKV\_CONSENT\_URL](https://docs.snowflake.com/en/sql-reference/functions/system_get_cmk_akv_consent_url) | System | — | | [SYSTEM$GET\_CMK\_CONFIG](https://docs.snowflake.com/en/sql-reference/functions/system_get_cmk_config) | System | — | | [SYSTEM$GET\_CMK\_CONFIG\_POSTGRES](https://docs.snowflake.com/en/sql-reference/functions/system_get_cmk_config_postgres) | System | — | | [SYSTEM$GET\_CMK\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_get_cmk_info) | System | — | | [SYSTEM$GET\_CMK\_INFO\_POSTGRES](https://docs.snowflake.com/en/sql-reference/functions/system_get_cmk_info_postgres) | System | — | | [SYSTEM$GET\_CMK\_KMS\_KEY\_POLICY](https://docs.snowflake.com/en/sql-reference/functions/system_get_cmk_kms_key_policy) | System | — | | [SYSTEM$GET\_COMPUTE\_POOL\_PENDING\_MAINTENANCE](https://docs.snowflake.com/en/sql-reference/functions/system_get_compute_pool_pending_maintenance) | System | — | | [SYSTEM$GET\_DBT\_LOG](https://docs.snowflake.com/en/sql-reference/functions/system_get_dbt_log) | System | — | | [SYSTEM$GET\_DEBUG\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_get_debug_status) | System | — | | [SYSTEM$GET\_DEFAULT\_COLUMNS\_OVERRIDE\_FOR\_SHOW\_COMMAND](https://docs.snowflake.com/en/sql-reference/functions/system_get_default_columns_override_for_show_command) | System | — | | [SYSTEM$GET\_DEFAULT\_COLUMNS\_OVERRIDE\_FOR\_SYSTEM\_OBJECT](https://docs.snowflake.com/en/sql-reference/functions/system_get_default_columns_override_for_system_object) | System | — | | [SYSTEM$GET\_DIRECTORY\_TABLE\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_get_directory_table_status) | System | ✓ | | [SYSTEM$GET\_GCP\_KMS\_CMK\_GRANT\_ACCESS\_CMD](https://docs.snowflake.com/en/sql-reference/functions/system_get_gcp_kms_cmk_grant_access_cmd) | System | — | | [SYSTEM$GET\_HASH\_FOR\_APPLICATION](https://docs.snowflake.com/en/sql-reference/functions/system_get_hash_for_application) | System | — | | [SYSTEM$GET\_ICEBERG\_TABLE\_INFORMATION](https://docs.snowflake.com/en/sql-reference/functions/system_get_iceberg_table_information) | System | ✓ | | [SYSTEM$GET\_INSTANCE\_FAMILY\_PLACEMENT\_GROUPS](https://docs.snowflake.com/en/sql-reference/functions/system_get_instance_family_placement_groups) | System | — | | [SYSTEM$GET\_LOGIN\_FAILURE\_DETAILS](https://docs.snowflake.com/en/sql-reference/functions/system_get_login_failure_details) | System | — | | [SYSTEM$GET\_PREDECESSOR\_RETURN\_VALUE](https://docs.snowflake.com/en/sql-reference/functions/system_get_predecessor_return_value) | System | ✓ | | [SYSTEM$GET\_PREVIEW\_ACCESS\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_get_preview_access_status) | System | — | | [SYSTEM$GET\_PRIVATELINK](https://docs.snowflake.com/en/sql-reference/functions/system_get_privatelink) | System | — | | [SYSTEM$GET\_PRIVATELINK\_AUTHORIZED\_ENDPOINTS](https://docs.snowflake.com/en/sql-reference/functions/system_get_privatelink_authorized_endpoints) | System | — | | [SYSTEM$GET\_PRIVATELINK\_CONFIG](https://docs.snowflake.com/en/sql-reference/functions/system_get_privatelink_config) | System | — | | [SYSTEM$GET\_PRIVATELINK\_ENDPOINT\_REGISTRATIONS](https://docs.snowflake.com/en/sql-reference/functions/system_get_privatelink_endpoint_registrations) | System | — | | [SYSTEM$GET\_PRIVATELINK\_ENDPOINTS\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_get_privatelink_endpoints_info) | System | — | | [SYSTEM$GET\_PURCHASE\_ATTRIBUTES](https://docs.snowflake.com/en/sql-reference/functions/system_get_purchase_attributes) | System | — | | [SYSTEM$GET\_REFERENCED\_OBJECT\_ID\_HASH](https://docs.snowflake.com/en/sql-reference/functions/system_get_referenced_object_id_hash) | System | ✓ | | [SYSTEM$GET\_RESULTSET\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_get_resultset_status) | System | — | | [SYSTEM$GET\_SERVICE\_DNS\_DOMAIN](https://docs.snowflake.com/en/sql-reference/functions/system_get_service_dns_domain) | System | — | | [SYSTEM$GET\_SERVICE\_LOGS](https://docs.snowflake.com/en/sql-reference/functions/system_get_service_logs) | System | ✓ | | [SYSTEM$GET\_SERVICE\_STATUS — DEPRECATED](https://docs.snowflake.com/en/sql-reference/functions/system_get_service_status) | System | ✓ | | [SYSTEM$GET\_SNOWFLAKE\_EGRESS\_IP\_RANGES](https://docs.snowflake.com/en/sql-reference/functions/system_get_snowflake_egress_ip_ranges) | System | — | | [SYSTEM$GET\_SNOWFLAKE\_PLATFORM\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_get_snowflake_platform_info) | System | — | | [SYSTEM$GET\_STAGE\_PRIVATELINK\_AUTHORIZED\_ENDPOINTS](https://docs.snowflake.com/en/sql-reference/functions/system_get_stage_privatelink_authorized_endpoints) | System | — | | [SYSTEM$GET\_TAG](https://docs.snowflake.com/en/sql-reference/functions/system_get_tag) | System | ✓ | | [SYSTEM$GET\_TAG\_ALLOWED\_VALUES](https://docs.snowflake.com/en/sql-reference/functions/system_get_tag_allowed_values) | System | ✓ | | [SYSTEM$GET\_TAG\_ON\_CURRENT\_COLUMN](https://docs.snowflake.com/en/sql-reference/functions/system_get_tag_on_current_column) | System | ✓ | | [SYSTEM$GET\_TAG\_ON\_CURRENT\_TABLE](https://docs.snowflake.com/en/sql-reference/functions/system_get_tag_on_current_table) | System | ✓ | | [SYSTEM$GET\_TASK\_GRAPH\_CONFIG](https://docs.snowflake.com/en/sql-reference/functions/system_get_task_graph_config) | System | ✓ | | [SYSTEM$GLOBAL\_ACCOUNT\_SET\_PARAMETER](https://docs.snowflake.com/en/sql-reference/functions/system_global_account_set_parameter) | System | ✓ | | [SYSTEM$HOLD\_PRIVILEGE\_ON\_ACCOUNT](https://docs.snowflake.com/en/sql-reference/functions/system_hold_privilege_on_account) | System | ✓ | | [SYSTEM$INITIATE\_MOVE\_ORGANIZATION\_ACCOUNT](https://docs.snowflake.com/en/sql-reference/functions/system_initiate_move_organization_account) | System | — | | [SYSTEM$INTERNAL\_STAGES\_PUBLIC\_ACCESS\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_internal_stages_public_access_status) | System | — | | [SYSTEM$IS\_APPLICATION\_ALL\_MANDATORY\_TELEMETRY\_EVENT\_DEFINITIONS\_ENABLED](https://docs.snowflake.com/en/sql-reference/functions/system_is_application_all_mandatory_telemetry_event_definitions_enabled) | System | — | | [SYSTEM$IS\_APPLICATION\_AUTHORIZED\_FOR\_TELEMETRY\_EVENT\_SHARING](https://docs.snowflake.com/en/sql-reference/functions/system_is_application_authorized_for_telemetry_event_sharing) | System | — | | [SYSTEM$IS\_APPLICATION\_INSTALLED\_FROM\_SAME\_ACCOUNT](https://docs.snowflake.com/en/sql-reference/functions/system_is_application_installed_from_same_account) | System | — | | [SYSTEM$IS\_APPLICATION\_SHARING\_EVENTS\_WITH\_PROVIDER](https://docs.snowflake.com/en/sql-reference/functions/system_is_application_sharing_events_with_provider) | System | — | | [SYSTEM$IS\_GLOBAL\_DATA\_SHARING\_ENABLED\_FOR\_ACCOUNT](https://docs.snowflake.com/en/sql-reference/functions/system_is_global_data_sharing_enabled_for_account) | System | — | | [SYSTEM$IS\_LISTING\_PURCHASED](https://docs.snowflake.com/en/sql-reference/functions/system_is_listing_purchased) | System | — | | [SYSTEM$IS\_LISTING\_TRIAL](https://docs.snowflake.com/en/sql-reference/functions/system_is_listing_trial) | System | — | | [SYSTEM$LAST\_CHANGE\_COMMIT\_TIME](https://docs.snowflake.com/en/sql-reference/functions/system_last_change_commit_time) | System | ✓ | | [SYSTEM$LINK\_ACCOUNT\_OBJECTS\_BY\_NAME](https://docs.snowflake.com/en/sql-reference/functions/system_link_account_objects_by_name) | System | — | | [SYSTEM$LINK\_ORGANIZATION\_USER](https://docs.snowflake.com/en/sql-reference/functions/system_link_organization_user) | System | — | | [SYSTEM$LINK\_ORGANIZATION\_USER\_GROUP](https://docs.snowflake.com/en/sql-reference/functions/system_link_organization_user_group) | System | — | | [SYSTEM$LIST\_APPLICATION\_RESTRICTED\_FEATURES](https://docs.snowflake.com/en/sql-reference/functions/system_list_application_restricted_features) | System | — | | [SYSTEM$LIST\_ICEBERG\_TABLES\_FROM\_CATALOG](https://docs.snowflake.com/en/sql-reference/functions/system_list_iceberg_tables_from_catalog) | System | — | | [SYSTEM$LIST\_NAMESPACES\_FROM\_CATALOG](https://docs.snowflake.com/en/sql-reference/functions/system_list_namespaces_from_catalog) | System | — | | [SYSTEM$LOCATE\_DBT\_ARCHIVE](https://docs.snowflake.com/en/sql-reference/functions/system_locate_dbt_archive) | System | — | | [SYSTEM$LOCATE\_DBT\_ARTIFACTS](https://docs.snowflake.com/en/sql-reference/functions/system_locate_dbt_artifacts) | System | — | | [SYSTEM$LOG, SYSTEM$LOG\_\ (FOR SNOWFLAKE SCRIPTING)](https://docs.snowflake.com/en/sql-reference/functions/system_log) | System | — | | [SYSTEM$MIGRATE\_SAML\_IDP\_REGISTRATION](https://docs.snowflake.com/en/sql-reference/functions/system_migrate_saml_idp_registration) | System | ✓ | | [SYSTEM$OPT\_IN\_INTERNAL\_STAGE\_NETWORK\_LOGS](https://docs.snowflake.com/en/sql-reference/functions/system_opt_in_internal_stage_network_logs) | System | — | | [SYSTEM$OPT\_OUT\_INTERNAL\_STAGE\_NETWORK\_LOGS](https://docs.snowflake.com/en/sql-reference/functions/system_opt_out_internal_stage_network_logs) | System | — | | [SYSTEM$OPT\_OUT\_MALICIOUS\_IP\_PROTECTION\_BY\_CATEGORY](https://docs.snowflake.com/en/sql-reference/functions/system_opt_out_malicious_ip_protection_by_category) | System | — | | [SYSTEM$PIPE\_FORCE\_RESUME](https://docs.snowflake.com/en/sql-reference/functions/system_pipe_force_resume) | System | ✓ | | [SYSTEM$PIPE\_REBINDING\_WITH\_NOTIFICATION\_CHANNEL](https://docs.snowflake.com/en/sql-reference/functions/system_pipe_rebinding_with_notification_channel) | System | ✓ | | [SYSTEM$PIPE\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_pipe_status) | System | ✓ | | [SYSTEM$PROVISION\_PRIVATELINK\_ENDPOINT](https://docs.snowflake.com/en/sql-reference/functions/system_provision_privatelink_endpoint) | System | — | | [SYSTEM$PROVISION\_PRIVATELINK\_ENDPOINT\_TSS](https://docs.snowflake.com/en/sql-reference/functions/system_provision_privatelink_endpoint_tss) | System | — | | [SYSTEM$QUERY\_REFERENCE](https://docs.snowflake.com/en/sql-reference/functions/system_query_reference) | System | ✓ | | [SYSTEM$READ\_OSI\_YAML\_FROM\_SEMANTIC\_VIEW](https://docs.snowflake.com/en/sql-reference/functions/system_read_osi_yaml_from_semantic_view) | System | — | | [SYSTEM$READ\_YAML\_FROM\_SEMANTIC\_VIEW](https://docs.snowflake.com/en/sql-reference/functions/system_read_yaml_from_semantic_view) | System | — | | [SYSTEM$REFERENCE](https://docs.snowflake.com/en/sql-reference/functions/system_reference) | System | ✓ | | [SYSTEM$REGISTER\_CMK\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_register_cmk_info) | System | — | | [SYSTEM$REGISTER\_CMK\_INFO\_POSTGRES](https://docs.snowflake.com/en/sql-reference/functions/system_register_cmk_info_postgres) | System | — | | [SYSTEM$REGISTER\_PRIVATELINK\_ENDPOINT](https://docs.snowflake.com/en/sql-reference/functions/system_register_privatelink_endpoint) | System | — | | [SYSTEM$REGISTRY\_LIST\_IMAGES — DEPRECATED](https://docs.snowflake.com/en/sql-reference/functions/system_registry_list_images) | System | — | | [SYSTEM$REMOVE\_ALL\_REFERENCES](https://docs.snowflake.com/en/sql-reference/functions/system_remove_all_references) | System | ✓ | | [SYSTEM$REMOVE\_REFERENCE](https://docs.snowflake.com/en/sql-reference/functions/system_remove_reference) | System | ✓ | | [SYSTEM$REPORT\_HEALTH\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_report_health_status) | System | — | | [SYSTEM$RESOLVE\_PYTHON\_PACKAGES](https://docs.snowflake.com/en/sql-reference/functions/system_resolve_python_packages) | System | — | | [SYSTEM$RESTORE\_PRIVATELINK\_ENDPOINT](https://docs.snowflake.com/en/sql-reference/functions/system_restore_privatelink_endpoint) | System | — | | [SYSTEM$RESTORE\_PRIVATELINK\_ENDPOINT\_TSS](https://docs.snowflake.com/en/sql-reference/functions/system_restore_privatelink_endpoint_tss) | System | — | | [SYSTEM$REVOKE\_PRIVATELINK](https://docs.snowflake.com/en/sql-reference/functions/system_revoke_privatelink) | System | — | | [SYSTEM$REVOKE\_STAGE\_PRIVATELINK\_ACCESS](https://docs.snowflake.com/en/sql-reference/functions/system_revoke_stage_privatelink_access) | System | — | | [SYSTEM$SCHEDULE\_ASYNC\_REPLICATION\_GROUP\_REFRESH](https://docs.snowflake.com/en/sql-reference/functions/system_schedule_async_replication_group_refresh) | System | — | | [SYSTEM$SEND\_NOTIFICATIONS\_TO\_CATALOG](https://docs.snowflake.com/en/sql-reference/functions/system_send_notifications_to_catalog) | System | — | | [SYSTEM$SET\_APPLICATION\_RESTRICTED\_FEATURE\_ACCESS](https://docs.snowflake.com/en/sql-reference/functions/system_set_application_restricted_feature_access) | System | — | | [SYSTEM$SET\_CATALOG\_INTEGRATION](https://docs.snowflake.com/en/sql-reference/functions/system_set_catalog_integration) | System | — | | [SYSTEM$SET\_DEFAULT\_COLUMNS\_OVERRIDE\_FOR\_SHOW\_COMMAND](https://docs.snowflake.com/en/sql-reference/functions/system_set_default_columns_override_for_show_command) | System | — | | [SYSTEM$SET\_DEFAULT\_COLUMNS\_OVERRIDE\_FOR\_SYSTEM\_OBJECT](https://docs.snowflake.com/en/sql-reference/functions/system_set_default_columns_override_for_system_object) | System | — | | [SYSTEM$SET\_EVENT\_SHARING\_ACCOUNT\_FOR\_REGION](https://docs.snowflake.com/en/sql-reference/functions/system_set_event_sharing_account_for_region) | System | — | | [SYSTEM$SET\_PRIVATELINK\_ENDPOINT\_HOSTNAME](https://docs.snowflake.com/en/sql-reference/functions/system_set_privatelink_endpoint_hostname) | System | — | | [SYSTEM$SET\_REFERENCE](https://docs.snowflake.com/en/sql-reference/functions/system_set_reference) | System | ✓ | | [SYSTEM$SET\_RETURN\_VALUE](https://docs.snowflake.com/en/sql-reference/functions/system_set_return_value) | System | ✓ | | [SYSTEM$SET\_ROW\_TIMESTAMP\_ON\_ALL\_SUPPORTED\_TABLES](https://docs.snowflake.com/en/sql-reference/functions/system_set_row_timestamp_on_all_supported_tables) | System | — | | [SYSTEM$SET\_SPAN\_ATTRIBUTES (FOR SNOWFLAKE SCRIPTING)](https://docs.snowflake.com/en/sql-reference/functions/system_set_span_attributes) | System | — | | [SYSTEM$SHOW\_ACTIVE\_BEHAVIOR\_CHANGE\_BUNDLES](https://docs.snowflake.com/en/sql-reference/functions/system_show_active_behavior_change_bundles) | System | ✓ | | [SYSTEM$SHOW\_BUDGETS\_FOR\_RESOURCE](https://docs.snowflake.com/en/sql-reference/functions/system_show_budgets_for_resource) | System | — | | [SYSTEM$SHOW\_BUDGETS\_IN\_ACCOUNT](https://docs.snowflake.com/en/sql-reference/functions/system_show_budgets_in_account) | System | — | | [SYSTEM$SHOW\_EVENT\_SHARING\_ACCOUNTS](https://docs.snowflake.com/en/sql-reference/functions/system_show_event_sharing_accounts) | System | — | | [SYSTEM$SHOW\_MOVE\_ORGANIZATION\_ACCOUNT\_STATUS](https://docs.snowflake.com/en/sql-reference/functions/system_show_move_organization_account_status) | System | — | | [SYSTEM$SHOW\_OAUTH\_CLIENT\_SECRETS](https://docs.snowflake.com/en/sql-reference/functions/system_show_oauth_client_secrets) | System | — | | [SYSTEM$SHOW\_SENSITIVE\_DATA\_MONITORED\_ENTITIES](https://docs.snowflake.com/en/sql-reference/functions/system_show_sensitive_data_monitored_entities) | System | — | | [SYSTEM$SNOWPIPE\_STREAMING\_UPDATE\_CHANNEL\_OFFSET\_TOKEN](https://docs.snowflake.com/en/sql-reference/functions/system_snowpipe_streaming_update_channel_offset_token) | System | ✓ | | [SYSTEM$START\_OAUTH\_FLOW](https://docs.snowflake.com/en/sql-reference/functions/system_start_oauth_flow) | System | — | | [SYSTEM$START\_USER\_EMAIL\_VERIFICATION](https://docs.snowflake.com/en/sql-reference/functions/system_start_user_email_verification) | System | — | | [SYSTEM$STREAM\_GET\_TABLE\_TIMESTAMP](https://docs.snowflake.com/en/sql-reference/functions/system_stream_get_table_timestamp) | System | — | | [SYSTEM$STREAM\_HAS\_DATA](https://docs.snowflake.com/en/sql-reference/functions/system_stream_has_data) | System | — | | [SYSTEM$SUPPORTED\_DBT\_VERSIONS](https://docs.snowflake.com/en/sql-reference/functions/system_supported_dbt_versions) | System | — | | [SYSTEM$TASK\_DEPENDENTS\_ENABLE](https://docs.snowflake.com/en/sql-reference/functions/system_task_dependents_enable) | System | ✓ | | [SYSTEM$TASK\_RUNTIME\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_task_runtime_info) | System | ✓ | | [SYSTEM$TRIGGER\_LISTING\_REFRESH](https://docs.snowflake.com/en/sql-reference/functions/system_trigger_listing_refresh) | System | — | | [SYSTEM$TYPEOF](https://docs.snowflake.com/en/sql-reference/functions/system_typeof) | System | ✓ | | [SYSTEM$UNBLOCK\_INTERNAL\_STAGES\_PUBLIC\_ACCESS](https://docs.snowflake.com/en/sql-reference/functions/system_unblock_internal_stages_public_access) | System | — | | [SYSTEM$UNLINK\_ORGANIZATION\_USER](https://docs.snowflake.com/en/sql-reference/functions/system_unlink_organization_user) | System | — | | [SYSTEM$UNLINK\_ORGANIZATION\_USER\_GROUP](https://docs.snowflake.com/en/sql-reference/functions/system_unlink_organization_user_group) | System | — | | [SYSTEM$UNREGISTER\_PRIVATELINK\_ENDPOINT](https://docs.snowflake.com/en/sql-reference/functions/system_unregister_privatelink_endpoint) | System | — | | [SYSTEM$UNSET\_DEFAULT\_COLUMNS\_OVERRIDE\_FOR\_SHOW\_COMMAND](https://docs.snowflake.com/en/sql-reference/functions/system_unset_default_columns_override_for_show_command) | System | — | | [SYSTEM$UNSET\_DEFAULT\_COLUMNS\_OVERRIDE\_FOR\_SYSTEM\_OBJECT](https://docs.snowflake.com/en/sql-reference/functions/system_unset_default_columns_override_for_system_object) | System | — | | [SYSTEM$UNSET\_EVENT\_SHARING\_ACCOUNT\_FOR\_REGION](https://docs.snowflake.com/en/sql-reference/functions/system_unset_event_sharing_account_for_region) | System | — | | [SYSTEM$USER\_TASK\_CANCEL\_ONGOING\_EXECUTIONS](https://docs.snowflake.com/en/sql-reference/functions/system_user_task_cancel_ongoing_executions) | System | ✓ | | [SYSTEM$VALIDATE\_STORAGE\_INTEGRATION](https://docs.snowflake.com/en/sql-reference/functions/system_validate_storage_integration) | System | — | | [SYSTEM$VERIFY\_CATALOG\_INTEGRATION](https://docs.snowflake.com/en/sql-reference/functions/system_verify_catalog_integration) | System | — | | [SYSTEM$VERIFY\_CMK\_INFO](https://docs.snowflake.com/en/sql-reference/functions/system_verify_cmk_info) | System | — | | [SYSTEM$VERIFY\_CMK\_INFO\_POSTGRES](https://docs.snowflake.com/en/sql-reference/functions/system_verify_cmk_info_postgres) | System | — | | [SYSTEM$VERIFY\_EXTERNAL\_OAUTH\_TOKEN](https://docs.snowflake.com/en/sql-reference/functions/system_verify_ext_oauth_token) | System | ✓ | | [SYSTEM$VERIFY\_EXTERNAL\_VOLUME](https://docs.snowflake.com/en/sql-reference/functions/system_verify_external_volume) | System | — | | [SYSTEM$WAIT](https://docs.snowflake.com/en/sql-reference/functions/system_wait) | System | ✓ | | [SYSTEM$WAIT\_FOR\_SERVICES](https://docs.snowflake.com/en/sql-reference/functions/system_wait_for_services) | System | — | | [SYSTEM$WHITELIST — DEPRECATED](https://docs.snowflake.com/en/sql-reference/functions/system_whitelist) | System | — | | [SYSTEM$WHITELIST\_PRIVATELINK — DEPRECATED](https://docs.snowflake.com/en/sql-reference/functions/system_whitelist_privatelink) | System | — | | [\!SPCS\_CANCEL\_JOB](https://docs.snowflake.com/en/sql-reference/functions/spcs_cancel_job) | Table | — | | [\!SPCS\_GET\_EVENTS](https://docs.snowflake.com/en/sql-reference/functions/spcs_get_events) | Table | — | | [\!SPCS\_GET\_LOGS](https://docs.snowflake.com/en/sql-reference/functions/spcs_get_logs) | Table | — | | [\!SPCS\_GET\_METRICS](https://docs.snowflake.com/en/sql-reference/functions/spcs_get_metrics) | Table | — | | [APPLICATION\_CONFIGURATION\_VALUE\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/application_configuration_value_history) | Table | — | | [CORTEX\_SEARCH\_DATA\_SCAN](https://docs.snowflake.com/en/sql-reference/functions/cortex_search_data_scan) | Table | — | | [CUMULATIVE\_PRIVACY\_LOSSES](https://docs.snowflake.com/en/sql-reference/functions/cumulative_privacy_losses) | Table | — | | [FLATTEN](https://docs.snowflake.com/en/sql-reference/functions/flatten) | Table | ✓ | | [GENERATOR](https://docs.snowflake.com/en/sql-reference/functions/generator) | Table | ✓ | | [GET\_AI\_EVALUATION\_DATA (SNOWFLAKE.LOCAL)](https://docs.snowflake.com/en/sql-reference/functions/get_ai_evaluation_data-snowflake-local) | Table | — | | [GET\_AI\_OBSERVABILITY\_LOGS (SNOWFLAKE.LOCAL)](https://docs.snowflake.com/en/sql-reference/functions/get_ai_observability_logs-snowflake-local) | Table | — | | [GET\_AI\_RECORD\_TRACE (SNOWFLAKE.LOCAL)](https://docs.snowflake.com/en/sql-reference/functions/get_ai_record_trace-snowflake-local) | Table | — | | [GET\_CONTACTS](https://docs.snowflake.com/en/sql-reference/functions/get_contacts) | Table | — | | [GET\_JOB\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/get_job_history) | Table | — | | [GET\_LINEAGE (SNOWFLAKE.CORE)](https://docs.snowflake.com/en/sql-reference/functions/get_lineage-snowflake-core) | Table | — | | [GET\_OBJECT\_REFERENCES](https://docs.snowflake.com/en/sql-reference/functions/get_object_references) | Table | ✓ | | [ICEBERG\_TABLE\_FILES](https://docs.snowflake.com/en/sql-reference/functions/iceberg_table_files) | Table | — | | [ICEBERG\_TABLE\_SNAPSHOT\_REFRESH\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/iceberg_table_snapshot_refresh_history) | Table | — | | [INFER\_SCHEMA](https://docs.snowflake.com/en/sql-reference/functions/infer_schema) | Table | ✓ | | [REST\_EVENT\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/rest_event_history) | Table | ✓ | | [RESULT\_SCAN](https://docs.snowflake.com/en/sql-reference/functions/result_scan) | Table | ✓ | | [STORAGE\_LIFECYCLE\_POLICY\_HISTORY](https://docs.snowflake.com/en/sql-reference/functions/storage_lifecycle_policy_history) | Table | — | | [SYSTEM$STREAM\_BACKLOG](https://docs.snowflake.com/en/sql-reference/functions/system_stream_backlog) | Table | — | | [TO\_QUERY](https://docs.snowflake.com/en/sql-reference/functions/to_query) | Table | — | | [VALIDATE](https://docs.snowflake.com/en/sql-reference/functions/validate) | Table | ✓ | | [VECTOR\_AVG](https://docs.snowflake.com/en/sql-reference/functions/vector_avg) | Vector | ✓ | | [VECTOR\_COSINE\_SIMILARITY](https://docs.snowflake.com/en/sql-reference/functions/vector_cosine_similarity) | Vector | ✓ | | [VECTOR\_INNER\_PRODUCT](https://docs.snowflake.com/en/sql-reference/functions/vector_inner_product) | Vector | ✓ | | [VECTOR\_L1\_DISTANCE](https://docs.snowflake.com/en/sql-reference/functions/vector_l1_distance) | Vector | ✓ | | [VECTOR\_L2\_DISTANCE](https://docs.snowflake.com/en/sql-reference/functions/vector_l2_distance) | Vector | ✓ | | [VECTOR\_MAX](https://docs.snowflake.com/en/sql-reference/functions/vector_max) | Vector | ✓ | | [VECTOR\_MIN](https://docs.snowflake.com/en/sql-reference/functions/vector_min) | Vector | ✓ | | [VECTOR\_NORMALIZE](https://docs.snowflake.com/en/sql-reference/functions/vector_normalize) | Vector | — | | [VECTOR\_SUM](https://docs.snowflake.com/en/sql-reference/functions/vector_sum) | Vector | ✓ | | [VECTOR\_TRUNCATE](https://docs.snowflake.com/en/sql-reference/functions/vector_truncate) | Vector | — | | [CONDITIONAL\_CHANGE\_EVENT](https://docs.snowflake.com/en/sql-reference/functions/conditional_change_event) | Window | ✓ | | [CONDITIONAL\_TRUE\_EVENT](https://docs.snowflake.com/en/sql-reference/functions/conditional_true_event) | Window | ✓ | | [CUME\_DIST](https://docs.snowflake.com/en/sql-reference/functions/cume_dist) | Window | ✓ | | [INTERPOLATE\_BFILL, INTERPOLATE\_FFILL, INTERPOLATE\_LINEAR](https://docs.snowflake.com/en/sql-reference/functions/interpolate_bfill) | Window | — | | [PERCENT\_RANK](https://docs.snowflake.com/en/sql-reference/functions/percent_rank) | Window | ✓ | | [RANK](https://docs.snowflake.com/en/sql-reference/functions/rank) | Window | ✓ | | [RATIO\_TO\_REPORT](https://docs.snowflake.com/en/sql-reference/functions/ratio_to_report) | Window | ✓ | | [DENSE\_RANK](https://docs.snowflake.com/en/sql-reference/functions/dense_rank) | Window function syntax and usage | ✓ | | [FIRST\_VALUE](https://docs.snowflake.com/en/sql-reference/functions/first_value) | Window function syntax and usage | ✓ | | [LAG](https://docs.snowflake.com/en/sql-reference/functions/lag) | Window function syntax and usage | ✓ | | [LAST\_VALUE](https://docs.snowflake.com/en/sql-reference/functions/last_value) | Window function syntax and usage | ✓ | | [LEAD](https://docs.snowflake.com/en/sql-reference/functions/lead) | Window function syntax and usage | ✓ | | [NTH\_VALUE](https://docs.snowflake.com/en/sql-reference/functions/nth_value) | Window function syntax and usage | ✓ | | [NTILE](https://docs.snowflake.com/en/sql-reference/functions/ntile) | Window function syntax and usage | ✓ | | [ROW\_NUMBER](https://docs.snowflake.com/en/sql-reference/functions/row_number) | Window function syntax and usage | ✓ | ## Was this page helpful? YesNo [Privacy policy](https://www.getdbt.com/cloud/privacy-policy)[Create a GitHub issue](https://github.com/dbt-labs/docs.getdbt.com/issues) This site is protected by reCAPTCHA and the Google [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms) apply.