<!-- Generated file — do not edit. Regenerate with `make catalog`. -->
# LocalStack for Snowflake (`snowflake-next`) — feature catalog

What `localstack/snowflake-next` **0.1.0** supports. Generated for each
build from the emulator itself, and measured against everything Snowflake's SQL
reference lists (scraped 2026-09-05). Machine-readable form:
[`feature-catalog.json`](feature-catalog.json).

| Status | Meaning |
|---|---|
| ✅ supported | Works as in Snowflake. |
| 🟡 partial | Works for common usage; some inputs or behaviors still differ from Snowflake. |
| ❌ not supported | Not available yet. |

## Summary

| Surface | Snowflake documents | Covered | Coverage | Also supported |
|---|---|---|---|---|
| Functions | 973 | 555 | 57% | 46 |
| SQL statements | 571 | 233 | 41% | 9 |
| Query features | 39 | 35 | 90% | 15 |

**Covered** counts documented entries that are supported or partial. **Also supported**
counts entries the emulator accepts that the reference index does not list separately —
aliases and internal helpers. Data types: 19 supported · 0 partial · 0 not supported.

## SQL statements

| Statement | Status | In the SQL reference |
|---|---|---|
| `ALTER ACCOUNT` | ✅ supported | yes |
| `ALTER AGENT` | ❌ not supported | yes |
| `ALTER AGGREGATION POLICY` | ❌ not supported | yes |
| `ALTER ALERT` | ✅ supported | yes |
| `ALTER API INTEGRATION` | ✅ supported | yes |
| `ALTER APPLICATION` | ❌ not supported | yes |
| `ALTER APPLICATION DROP CONFIGURATION DEFINITION` | ❌ not supported | yes |
| `ALTER APPLICATION DROP SPECIFICATION` | ❌ not supported | yes |
| `ALTER APPLICATION PACKAGE` | ❌ not supported | yes |
| `ALTER APPLICATION ROLE` | ❌ not supported | yes |
| `ALTER APPLICATION SET CONFIGURATION DEFINITION` | ❌ not supported | yes |
| `ALTER APPLICATION SET CONFIGURATION VALUE` | ❌ not supported | yes |
| `ALTER APPLICATION SET SPECIFICATION` | ❌ not supported | yes |
| `ALTER APPLICATION UNSET CONFIGURATION` | ❌ not supported | yes |
| `ALTER AUTHENTICATION POLICY` | ❌ not supported | yes |
| `ALTER BACKUP POLICY` | ❌ not supported | yes |
| `ALTER BACKUP SET` | ❌ not supported | yes |
| `ALTER CATALOG INTEGRATION` | ❌ not supported | yes |
| `ALTER COMPUTE POOL` | ❌ not supported | yes |
| `ALTER CONNECTION` | ❌ not supported | yes |
| `ALTER CONTACT` | ❌ not supported | yes |
| `ALTER CORTEX SEARCH SERVICE` | ❌ not supported | yes |
| `ALTER DATABASE` | ✅ supported | yes |
| `ALTER DATABASE ROLE` | ✅ supported | yes |
| `ALTER DATASET` | ❌ not supported | yes |
| `ALTER DBT PROJECT` | ❌ not supported | yes |
| `ALTER DCM PROJECT` | ❌ not supported | yes |
| `ALTER DYNAMIC TABLE` | ✅ supported | yes |
| `ALTER EXPERIMENT` | ❌ not supported | yes |
| `ALTER EXTERNAL ACCESS INTEGRATION` | ✅ supported | yes |
| `ALTER EXTERNAL AGENT` | ❌ not supported | yes |
| `ALTER EXTERNAL TABLE` | ✅ supported | yes |
| `ALTER EXTERNAL VOLUME` | ✅ supported | yes |
| `ALTER FAILOVER GROUP` | ❌ not supported | yes |
| `ALTER FEATURE POLICY` | ❌ not supported | yes |
| `ALTER FILE FORMAT` | ✅ supported | yes |
| `ALTER FUNCTION` | ✅ supported | yes |
| `ALTER GATEWAY` | ❌ not supported | yes |
| `ALTER GIT REPOSITORY` | ❌ not supported | yes |
| `ALTER ICEBERG TABLE` | ✅ supported | yes |
| `ALTER INTEGRATION` | ❌ not supported | yes |
| `ALTER JOIN POLICY` | ❌ not supported | yes |
| `ALTER LISTING` | ❌ not supported | yes |
| `ALTER MAINTENANCE POLICY` | ❌ not supported | yes |
| `ALTER MASKING POLICY` | ✅ supported | yes |
| `ALTER MATERIALIZED VIEW` | ✅ supported | yes |
| `ALTER MODEL` | ❌ not supported | yes |
| `ALTER MODEL MONITOR` | ❌ not supported | yes |
| `ALTER NETWORK POLICY` | ✅ supported | yes |
| `ALTER NETWORK RULE` | ✅ supported | yes |
| `ALTER NOTEBOOK` | ❌ not supported | yes |
| `ALTER NOTIFICATION INTEGRATION` | ✅ supported | yes |
| `ALTER ONLINE FEATURE TABLE` | ❌ not supported | yes |
| `ALTER OPENFLOW DATA PLANE` | ❌ not supported | yes |
| `ALTER ORGANIZATION ACCOUNT` | ❌ not supported | yes |
| `ALTER ORGANIZATION PROFILE` | ❌ not supported | yes |
| `ALTER ORGANIZATION USER` | ❌ not supported | yes |
| `ALTER ORGANIZATION USER GROUP` | ❌ not supported | yes |
| `ALTER PACKAGES POLICY` | ❌ not supported | yes |
| `ALTER PASSWORD POLICY` | ❌ not supported | yes |
| `ALTER PIPE` | ✅ supported | yes |
| `ALTER POSTGRES INSTANCE` | ❌ not supported | yes |
| `ALTER PRIVACY POLICY` | ❌ not supported | yes |
| `ALTER PROCEDURE` | ✅ supported | yes |
| `ALTER PROJECTION POLICY` | ❌ not supported | yes |
| `ALTER REPLICATION GROUP` | ❌ not supported | yes |
| `ALTER RESOURCE MONITOR` | ✅ supported | yes |
| `ALTER RESTRICTED SESSION SCOPE` | ❌ not supported | yes |
| `ALTER ROLE` | ✅ supported | yes |
| `ALTER ROW ACCESS POLICY` | ✅ supported | yes |
| `ALTER SCHEMA` | ✅ supported | yes |
| `ALTER SECRET` | ✅ supported | yes |
| `ALTER SECURITY INTEGRATION` | ✅ supported | yes |
| `ALTER SEMANTIC VIEW` | ❌ not supported | yes |
| `ALTER SEQUENCE` | ✅ supported | yes |
| `ALTER SERVICE` | ❌ not supported | yes |
| `ALTER SESSION` | ✅ supported | yes |
| `ALTER SESSION POLICY` | ❌ not supported | yes |
| `ALTER SHARE` | 🟡 partial | yes |
| `ALTER SNAPSHOT` | ❌ not supported | yes |
| `ALTER STAGE` | ✅ supported | yes |
| `ALTER STORAGE INTEGRATION` | ✅ supported | yes |
| `ALTER STORAGE LIFECYCLE POLICY` | ❌ not supported | yes |
| `ALTER STREAM` | ✅ supported | yes |
| `ALTER STREAMLIT` | ❌ not supported | yes |
| `ALTER TABLE` | ✅ supported | yes |
| `ALTER TAG` | ✅ supported | yes |
| `ALTER TASK` | ✅ supported | yes |
| `ALTER TYPE` | ❌ not supported | yes |
| `ALTER USER` | ✅ supported | yes |
| `ALTER VIEW` | ✅ supported | yes |
| `ALTER WAREHOUSE` | ✅ supported | yes |
| `BEGIN` | ✅ supported | yes |
| `CALL` | ✅ supported | yes |
| `COMMENT` | ✅ supported | yes |
| `COMMIT` | 🟡 partial | yes |
| `COPY FILES` | ❌ not supported | yes |
| `COPY INTO <LOCATION>` | ✅ supported | yes |
| `COPY INTO <TABLE>` | ✅ supported | yes |
| `CREATE ACCOUNT` | ✅ supported | yes |
| `CREATE AGENT` | ❌ not supported | yes |
| `CREATE AGGREGATION POLICY` | ✅ supported | yes |
| `CREATE ALERT` | ✅ supported | yes |
| `CREATE API INTEGRATION` | ✅ supported | yes |
| `CREATE APPLICATION` | ❌ not supported | yes |
| `CREATE APPLICATION PACKAGE` | ❌ not supported | yes |
| `CREATE APPLICATION ROLE` | ❌ not supported | yes |
| `CREATE AUTHENTICATION POLICY` | ❌ not supported | yes |
| `CREATE BACKUP POLICY` | ❌ not supported | yes |
| `CREATE BACKUP SET` | ❌ not supported | yes |
| `CREATE CATALOG INTEGRATION` | ✅ supported | yes |
| `CREATE COMPUTE POOL` | ❌ not supported | yes |
| `CREATE CONNECTION` | ❌ not supported | yes |
| `CREATE CONTACT` | ❌ not supported | yes |
| `CREATE CORTEX SEARCH SERVICE` | ❌ not supported | yes |
| `CREATE DATA METRIC FUNCTION` | ✅ supported | yes |
| `CREATE DATABASE` | ✅ supported | yes |
| `CREATE DATABASE ROLE` | ✅ supported | yes |
| `CREATE DATASET` | ❌ not supported | yes |
| `CREATE DBT PROJECT` | ❌ not supported | yes |
| `CREATE DCM PROJECT` | ❌ not supported | yes |
| `CREATE DYNAMIC TABLE` | ✅ supported | yes |
| `CREATE EVENT TABLE` | ❌ not supported | yes |
| `CREATE EXPERIMENT` | ❌ not supported | yes |
| `CREATE EXTERNAL ACCESS INTEGRATION` | ✅ supported | yes |
| `CREATE EXTERNAL AGENT` | ❌ not supported | yes |
| `CREATE EXTERNAL FUNCTION` | ✅ supported | yes |
| `CREATE EXTERNAL TABLE` | 🟡 partial | yes |
| `CREATE EXTERNAL VOLUME` | 🟡 partial | yes |
| `CREATE FAILOVER GROUP` | ❌ not supported | yes |
| `CREATE FEATURE POLICY` | ❌ not supported | yes |
| `CREATE FILE FORMAT` | ✅ supported | yes |
| `CREATE FUNCTION` | ✅ supported | yes |
| `CREATE GATEWAY` | ❌ not supported | yes |
| `CREATE GIT REPOSITORY` | ❌ not supported | yes |
| `CREATE HYBRID TABLE` | 🟡 partial | yes |
| `CREATE ICEBERG TABLE` | ✅ supported | yes |
| `CREATE IMAGE REPOSITORY` | ❌ not supported | yes |
| `CREATE INDEX` | ❌ not supported | yes |
| `CREATE INTEGRATION` | ❌ not supported | yes |
| `CREATE INTERACTIVE TABLE` | ❌ not supported | yes |
| `CREATE INTERACTIVE WAREHOUSE` | ❌ not supported | yes |
| `CREATE JOIN POLICY` | ❌ not supported | yes |
| `CREATE LISTING` | ❌ not supported | yes |
| `CREATE MAINTENANCE POLICY` | ❌ not supported | yes |
| `CREATE MANAGED ACCOUNT` | ❌ not supported | yes |
| `CREATE MASKING POLICY` | ✅ supported | yes |
| `CREATE MATERIALIZED VIEW` | ✅ supported | yes |
| `CREATE MCP SERVER` | ❌ not supported | yes |
| `CREATE MODEL` | ❌ not supported | yes |
| `CREATE MODEL MONITOR` | ❌ not supported | yes |
| `CREATE NETWORK POLICY` | ✅ supported | yes |
| `CREATE NETWORK RULE` | ✅ supported | yes |
| `CREATE NOTEBOOK` | ❌ not supported | yes |
| `CREATE NOTEBOOK PROJECT` | ❌ not supported | yes |
| `CREATE NOTIFICATION INTEGRATION` | ✅ supported | yes |
| `CREATE ONLINE FEATURE TABLE` | ❌ not supported | yes |
| `CREATE OR ALTER <OBJECT>` | ✅ supported | yes |
| `CREATE OR ALTER VERSIONED SCHEMA` | ❌ not supported | yes |
| `CREATE ORGANIZATION ACCOUNT` | ❌ not supported | yes |
| `CREATE ORGANIZATION LISTING` | ❌ not supported | yes |
| `CREATE ORGANIZATION PROFILE` | ❌ not supported | yes |
| `CREATE ORGANIZATION USER` | ❌ not supported | yes |
| `CREATE ORGANIZATION USER GROUP` | ❌ not supported | yes |
| `CREATE PACKAGES POLICY` | ❌ not supported | yes |
| `CREATE PASSWORD POLICY` | ❌ not supported | yes |
| `CREATE PIPE` | ✅ supported | yes |
| `CREATE POSTGRES INSTANCE` | ❌ not supported | yes |
| `CREATE PRIVACY POLICY` | ❌ not supported | yes |
| `CREATE PROCEDURE` | ✅ supported | yes |
| `CREATE PROJECTION POLICY` | ✅ supported | yes |
| `CREATE PROVISIONED THROUGHPUT` | ❌ not supported | yes |
| `CREATE REPLICATION GROUP` | ❌ not supported | yes |
| `CREATE RESOURCE MONITOR` | ✅ supported | yes |
| `CREATE RESTRICTED SESSION SCOPE` | ❌ not supported | yes |
| `CREATE ROLE` | ✅ supported | yes |
| `CREATE ROW ACCESS POLICY` | ✅ supported | yes |
| `CREATE SCHEMA` | ✅ supported | yes |
| `CREATE SECRET` | ✅ supported | yes |
| `CREATE SECURITY INTEGRATION` | ✅ supported | yes |
| `CREATE SEMANTIC VIEW` | ❌ not supported | yes |
| `CREATE SEQUENCE` | ✅ supported | yes |
| `CREATE SERVICE` | ❌ not supported | yes |
| `CREATE SESSION POLICY` | ❌ not supported | yes |
| `CREATE SHARE` | ✅ supported | yes |
| `CREATE SNAPSHOT` | ❌ not supported | yes |
| `CREATE STAGE` | ✅ supported | yes |
| `CREATE STORAGE INTEGRATION` | ✅ supported | yes |
| `CREATE STORAGE LIFECYCLE POLICY` | ❌ not supported | yes |
| `CREATE STREAM` | 🟡 partial | yes |
| `CREATE STREAMLIT` | ❌ not supported | yes |
| `CREATE TABLE` | ✅ supported | yes |
| `CREATE TAG` | ✅ supported | yes |
| `CREATE TASK` | 🟡 partial | yes |
| `CREATE TYPE` | ❌ not supported | yes |
| `CREATE USER` | ✅ supported | yes |
| `CREATE VIEW` | ✅ supported | yes |
| `CREATE WAREHOUSE` | ✅ supported | yes |
| `CREATE \| ALTER TABLE` | ❌ not supported | yes |
| `DELETE` | ✅ supported | yes |
| `DESCRIBE AGENT` | ❌ not supported | yes |
| `DESCRIBE AGGREGATION POLICY` | ❌ not supported | yes |
| `DESCRIBE ALERT` | ✅ supported | yes |
| `DESCRIBE APPLICATION` | ❌ not supported | yes |
| `DESCRIBE APPLICATION PACKAGE` | ❌ not supported | yes |
| `DESCRIBE AUTHENTICATION POLICY` | ❌ not supported | yes |
| `DESCRIBE AVAILABLE LISTING` | ❌ not supported | yes |
| `DESCRIBE AVAILABLE ORGANIZATION PROFILE` | ❌ not supported | yes |
| `DESCRIBE BACKUP POLICY` | ❌ not supported | yes |
| `DESCRIBE BACKUP SET` | ❌ not supported | yes |
| `DESCRIBE CATALOG INTEGRATION` | ✅ supported | yes |
| `DESCRIBE COMPUTE POOL` | ❌ not supported | yes |
| `DESCRIBE CONFIGURATION` | ❌ not supported | yes |
| `DESCRIBE CORTEX SEARCH SERVICE` | ❌ not supported | yes |
| `DESCRIBE DATABASE` | ✅ supported | yes |
| `DESCRIBE DBT PROJECT` | ❌ not supported | yes |
| `DESCRIBE DCM PROJECT` | ❌ not supported | yes |
| `DESCRIBE DYNAMIC TABLE` | ✅ supported | yes |
| `DESCRIBE EVENT TABLE` | ❌ not supported | yes |
| `DESCRIBE EXTERNAL AGENT` | ❌ not supported | yes |
| `DESCRIBE EXTERNAL TABLE` | ✅ supported | yes |
| `DESCRIBE EXTERNAL VOLUME` | ✅ supported | yes |
| `DESCRIBE FEATURE POLICY` | ❌ not supported | yes |
| `DESCRIBE FILE FORMAT` | ✅ supported | yes |
| `DESCRIBE FUNCTION` | ✅ supported | yes |
| `DESCRIBE GATEWAY` | ❌ not supported | yes |
| `DESCRIBE GIT REPOSITORY` | ❌ not supported | yes |
| `DESCRIBE ICEBERG TABLE` | ✅ supported | yes |
| `DESCRIBE INTEGRATION` | ✅ supported | yes |
| `DESCRIBE JOIN POLICY` | ❌ not supported | yes |
| `DESCRIBE LISTING` | ❌ not supported | yes |
| `DESCRIBE MAINTENANCE POLICY` | ❌ not supported | yes |
| `DESCRIBE MASKING POLICY` | ✅ supported | yes |
| `DESCRIBE MATERIALIZED VIEW` | ✅ supported | yes |
| `DESCRIBE MCP SERVER` | ❌ not supported | yes |
| `DESCRIBE MODEL MONITOR` | ❌ not supported | yes |
| `DESCRIBE NETWORK POLICY` | ✅ supported | yes |
| `DESCRIBE NETWORK RULE` | ✅ supported | yes |
| `DESCRIBE NOTEBOOK` | ❌ not supported | yes |
| `DESCRIBE NOTIFICATION INTEGRATION` | ✅ supported | yes |
| `DESCRIBE ONLINE FEATURE TABLE` | ❌ not supported | yes |
| `DESCRIBE OPENFLOW DATA PLANE INTEGRATION` | ❌ not supported | yes |
| `DESCRIBE ORGANIZATION PROFILE` | ❌ not supported | yes |
| `DESCRIBE PACKAGES POLICY` | ❌ not supported | yes |
| `DESCRIBE PASSWORD POLICY` | ❌ not supported | yes |
| `DESCRIBE PIPE` | ✅ supported | yes |
| `DESCRIBE POSTGRES INSTANCE` | ❌ not supported | yes |
| `DESCRIBE PRIVACY POLICY` | ❌ not supported | yes |
| `DESCRIBE PROCEDURE` | ✅ supported | yes |
| `DESCRIBE PROJECTION POLICY` | ❌ not supported | yes |
| `DESCRIBE RESTRICTED SESSION SCOPE` | ❌ not supported | yes |
| `DESCRIBE RESULT` | ✅ supported | yes |
| `DESCRIBE ROW ACCESS POLICY` | ✅ supported | yes |
| `DESCRIBE SCHEMA` | ✅ supported | yes |
| `DESCRIBE SEARCH OPTIMIZATION` | ❌ not supported | yes |
| `DESCRIBE SECRET` | ✅ supported | yes |
| `DESCRIBE SEMANTIC VIEW` | ❌ not supported | yes |
| `DESCRIBE SEQUENCE` | ✅ supported | yes |
| `DESCRIBE SERVICE` | ❌ not supported | yes |
| `DESCRIBE SESSION POLICY` | ❌ not supported | yes |
| `DESCRIBE SHARE` | ✅ supported | yes |
| `DESCRIBE SNAPSHOT` | ❌ not supported | yes |
| `DESCRIBE SNAPSHOT POLICY` | ❌ not supported | yes |
| `DESCRIBE SNAPSHOT SET` | ❌ not supported | yes |
| `DESCRIBE SPECIFICATION` | ❌ not supported | yes |
| `DESCRIBE STAGE` | ✅ supported | yes |
| `DESCRIBE STORAGE LIFECYCLE POLICY` | ❌ not supported | yes |
| `DESCRIBE STREAM` | ✅ supported | yes |
| `DESCRIBE STREAMLIT` | ❌ not supported | yes |
| `DESCRIBE TABLE` | ✅ supported | yes |
| `DESCRIBE TASK` | 🟡 partial | yes |
| `DESCRIBE TRANSACTION` | ✅ supported | yes |
| `DESCRIBE TYPE` | ❌ not supported | yes |
| `DESCRIBE USER` | ✅ supported | yes |
| `DESCRIBE VIEW` | ✅ supported | yes |
| `DESCRIBE WAREHOUSE` | ✅ supported | yes |
| `DROP ACCOUNT` | ❌ not supported | yes |
| `DROP AGENT` | ❌ not supported | yes |
| `DROP AGGREGATION POLICY` | ❌ not supported | yes |
| `DROP ALERT` | ✅ supported | yes |
| `DROP APPLICATION` | ❌ not supported | yes |
| `DROP APPLICATION PACKAGE` | ❌ not supported | yes |
| `DROP APPLICATION ROLE` | ❌ not supported | yes |
| `DROP AUTHENTICATION POLICY` | ❌ not supported | yes |
| `DROP BACKUP POLICY` | ❌ not supported | yes |
| `DROP BACKUP SET` | ❌ not supported | yes |
| `DROP CATALOG INTEGRATION` | ✅ supported | yes |
| `DROP COMPUTE POOL` | ❌ not supported | yes |
| `DROP CONNECTION` | ❌ not supported | yes |
| `DROP CONTACT` | ❌ not supported | yes |
| `DROP CORTEX SEARCH SERVICE` | ❌ not supported | yes |
| `DROP DATABASE` | ✅ supported | yes |
| `DROP DATABASE ROLE` | ✅ supported | yes |
| `DROP DBT PROJECT` | ❌ not supported | yes |
| `DROP DCM PROJECT` | ❌ not supported | yes |
| `DROP DYNAMIC TABLE` | ✅ supported | yes |
| `DROP EXPERIMENT` | ❌ not supported | yes |
| `DROP EXTERNAL AGENT` | ❌ not supported | yes |
| `DROP EXTERNAL TABLE` | ✅ supported | yes |
| `DROP EXTERNAL VOLUME` | 🟡 partial | yes |
| `DROP FAILOVER GROUP` | ❌ not supported | yes |
| `DROP FEATURE POLICY` | ❌ not supported | yes |
| `DROP FILE FORMAT` | ✅ supported | yes |
| `DROP FUNCTION` | ✅ supported | yes |
| `DROP GATEWAY` | ❌ not supported | yes |
| `DROP GIT REPOSITORY` | ❌ not supported | yes |
| `DROP ICEBERG TABLE` | ✅ supported | yes |
| `DROP IMAGE REPOSITORY` | ❌ not supported | yes |
| `DROP INDEX` | ❌ not supported | yes |
| `DROP INTEGRATION` | ✅ supported | yes |
| `DROP JOIN POLICY` | ❌ not supported | yes |
| `DROP LISTING` | ❌ not supported | yes |
| `DROP MAINTENANCE POLICY` | ❌ not supported | yes |
| `DROP MANAGED ACCOUNT` | ❌ not supported | yes |
| `DROP MASKING POLICY` | ✅ supported | yes |
| `DROP MATERIALIZED VIEW` | ✅ supported | yes |
| `DROP MCP SERVER` | ❌ not supported | yes |
| `DROP MODEL` | ❌ not supported | yes |
| `DROP MODEL MONITOR` | ❌ not supported | yes |
| `DROP NETWORK POLICY` | ✅ supported | yes |
| `DROP NETWORK RULE` | ✅ supported | yes |
| `DROP NOTEBOOK` | ❌ not supported | yes |
| `DROP ONLINE FEATURE TABLE` | ❌ not supported | yes |
| `DROP ORGANIZATION PROFILE` | ❌ not supported | yes |
| `DROP ORGANIZATION USER` | ❌ not supported | yes |
| `DROP ORGANIZATION USER GROUP` | ❌ not supported | yes |
| `DROP PACKAGES POLICY` | ❌ not supported | yes |
| `DROP PASSWORD POLICY` | ❌ not supported | yes |
| `DROP PIPE` | ✅ supported | yes |
| `DROP POSTGRES INSTANCE` | ❌ not supported | yes |
| `DROP PRIVACY POLICY` | ❌ not supported | yes |
| `DROP PROCEDURE` | ✅ supported | yes |
| `DROP PROJECTION POLICY` | ❌ not supported | yes |
| `DROP REPLICATION GROUP` | ❌ not supported | yes |
| `DROP RESOURCE MONITOR` | ✅ supported | yes |
| `DROP RESTRICTED SESSION SCOPE` | ❌ not supported | yes |
| `DROP ROLE` | ✅ supported | yes |
| `DROP ROW ACCESS POLICY` | ✅ supported | yes |
| `DROP SCHEMA` | ✅ supported | yes |
| `DROP SECRET` | ✅ supported | yes |
| `DROP SEMANTIC VIEW` | ❌ not supported | yes |
| `DROP SEQUENCE` | ✅ supported | yes |
| `DROP SERVICE` | ❌ not supported | yes |
| `DROP SESSION POLICY` | ❌ not supported | yes |
| `DROP SHARE` | ✅ supported | yes |
| `DROP SNAPSHOT` | ❌ not supported | yes |
| `DROP STAGE` | ✅ supported | yes |
| `DROP STORAGE LIFECYCLE POLICY` | ❌ not supported | yes |
| `DROP STREAM` | 🟡 partial | yes |
| `DROP STREAMLIT` | ❌ not supported | yes |
| `DROP TABLE` | ✅ supported | yes |
| `DROP TAG` | ✅ supported | yes |
| `DROP TASK` | 🟡 partial | yes |
| `DROP TYPE` | ❌ not supported | yes |
| `DROP USER` | ✅ supported | yes |
| `DROP VIEW` | ✅ supported | yes |
| `DROP WAREHOUSE` | ✅ supported | yes |
| `EXECUTE ALERT` | ✅ supported | yes |
| `EXECUTE DBT PROJECT` | ❌ not supported | yes |
| `EXECUTE DCM PROJECT` | ❌ not supported | yes |
| `EXECUTE IMMEDIATE` | 🟡 partial | yes |
| `EXECUTE IMMEDIATE FROM` | ✅ supported | yes |
| `EXECUTE INFERENCE JOB SERVICE` | ❌ not supported | yes |
| `EXECUTE JOB SERVICE` | ❌ not supported | yes |
| `EXECUTE NOTEBOOK` | ❌ not supported | yes |
| `EXECUTE NOTEBOOK PROJECT` | ❌ not supported | yes |
| `EXECUTE TASK` | 🟡 partial | yes |
| `EXPLAIN` | ✅ supported | yes |
| `GET` | ✅ supported | yes |
| `GRANT <PRIVILEGE>` | ❌ not supported | yes |
| `GRANT <PRIVILEGES>` | ✅ supported | yes |
| `GRANT APPLICATION ROLE` | ❌ not supported | yes |
| `GRANT CALLER` | ❌ not supported | yes |
| `GRANT DATABASE ROLE` | ✅ supported | yes |
| `GRANT OWNERSHIP` | ✅ supported | yes |
| `GRANT ROLE` | ✅ supported | yes |
| `GRANT SERVICE ROLE` | ❌ not supported | yes |
| `INSERT` | ✅ supported | yes |
| `LIST` | ✅ supported | yes |
| `MERGE` | ✅ supported | yes |
| `PUT` | ✅ supported | yes |
| `REMOVE` | ✅ supported | yes |
| `REVOKE <PRIVILEGE>` | ❌ not supported | yes |
| `REVOKE <PRIVILEGES>` | ✅ supported | yes |
| `REVOKE APPLICATION ROLE` | ❌ not supported | yes |
| `REVOKE CALLER` | ❌ not supported | yes |
| `REVOKE DATABASE ROLE` | ✅ supported | yes |
| `REVOKE ROLE` | ✅ supported | yes |
| `REVOKE SERVICE ROLE` | ❌ not supported | yes |
| `ROLLBACK` | ✅ supported | yes |
| `SELECT` | ✅ supported | yes |
| `SET` | ✅ supported | yes |
| `SHOW ACCOUNTS` | ✅ supported | yes |
| `SHOW AGENTS` | ❌ not supported | yes |
| `SHOW AGGREGATION POLICIES` | ❌ not supported | yes |
| `SHOW ALERTS` | ✅ supported | yes |
| `SHOW APPLICATION PACKAGES` | ❌ not supported | yes |
| `SHOW APPLICATION ROLES` | ❌ not supported | yes |
| `SHOW APPLICATIONS` | ❌ not supported | yes |
| `SHOW AUTHENTICATION POLICIES` | ❌ not supported | yes |
| `SHOW AVAILABLE LISTINGS` | ❌ not supported | yes |
| `SHOW AVAILABLE OFFERS` | ❌ not supported | yes |
| `SHOW AVAILABLE ORGANIZATION PROFILES` | ❌ not supported | yes |
| `SHOW BACKUP POLICIES` | ❌ not supported | yes |
| `SHOW BACKUP SETS` | ❌ not supported | yes |
| `SHOW BACKUPS IN BACKUP SET` | ❌ not supported | yes |
| `SHOW CALLER GRANTS` | ❌ not supported | yes |
| `SHOW CATALOG INTEGRATIONS` | ✅ supported | yes |
| `SHOW CHANNELS` | ❌ not supported | yes |
| `SHOW CLASSES` | ❌ not supported | yes |
| `SHOW COLUMNS` | ✅ supported | yes |
| `SHOW COMPUTE POOL INSTANCE FAMILIES` | ❌ not supported | yes |
| `SHOW COMPUTE POOLS` | ❌ not supported | yes |
| `SHOW CONFIGURATIONS` | ❌ not supported | yes |
| `SHOW CONNECTIONS` | ✅ supported | yes |
| `SHOW CONTACTS` | ❌ not supported | yes |
| `SHOW CORTEX SEARCH SERVICES` | ❌ not supported | yes |
| `SHOW DATA METRIC FUNCTIONS` | ✅ supported | yes |
| `SHOW DATABASE ROLES` | ✅ supported | yes |
| `SHOW DATABASES` | ✅ supported | yes |
| `SHOW DATABASES IN FAILOVER GROUP` | ❌ not supported | yes |
| `SHOW DATABASES IN REPLICATION GROUP` | ❌ not supported | yes |
| `SHOW DATASETS` | ❌ not supported | yes |
| `SHOW DBT PROJECTS` | ❌ not supported | yes |
| `SHOW DCM PROJECTS` | ❌ not supported | yes |
| `SHOW DELEGATED AUTHORIZATIONS` | ❌ not supported | yes |
| `SHOW DEPLOYMENTS IN DCM PROJECT` | ❌ not supported | yes |
| `SHOW DYNAMIC TABLES` | ✅ supported | yes |
| `SHOW ENDPOINTS` | ❌ not supported | yes |
| `SHOW ENTITIES IN DCM PROJECT` | ❌ not supported | yes |
| `SHOW EVENT TABLES` | ❌ not supported | yes |
| `SHOW EXPERIMENTS` | ❌ not supported | yes |
| `SHOW EXTERNAL AGENTS` | ❌ not supported | yes |
| `SHOW EXTERNAL FUNCTIONS` | ✅ supported | yes |
| `SHOW EXTERNAL TABLES` | ✅ supported | yes |
| `SHOW EXTERNAL VOLUMES` | ✅ supported | yes |
| `SHOW FAILOVER GROUPS` | ❌ not supported | yes |
| `SHOW FEATURE POLICIES` | ❌ not supported | yes |
| `SHOW FILE FORMATS` | ✅ supported | yes |
| `SHOW FUNCTIONS` | ✅ supported | yes |
| `SHOW FUNCTIONS IN MODEL` | ❌ not supported | yes |
| `SHOW GATEWAYS` | ❌ not supported | yes |
| `SHOW GIT BRANCHES` | ❌ not supported | yes |
| `SHOW GIT REPOSITORIES` | ❌ not supported | yes |
| `SHOW GIT TAGS` | ❌ not supported | yes |
| `SHOW GLOBAL ACCOUNTS` | ❌ not supported | yes |
| `SHOW GRANTS` | ✅ supported | yes |
| `SHOW GRANTS IN DCM PROJECT` | ❌ not supported | yes |
| `SHOW HYBRID TABLES` | ✅ supported | yes |
| `SHOW ICEBERG TABLES` | ✅ supported | yes |
| `SHOW IMAGE REPOSITORIES` | ❌ not supported | yes |
| `SHOW IMAGES IN IMAGE REPOSITORY` | ❌ not supported | yes |
| `SHOW INDEXES` | ❌ not supported | yes |
| `SHOW INTEGRATIONS` | ✅ supported | yes |
| `SHOW JOIN POLICIES` | ❌ not supported | yes |
| `SHOW LISTINGS` | ❌ not supported | yes |
| `SHOW LISTINGS IN FAILOVER GROUP` | ❌ not supported | yes |
| `SHOW LOCKS` | ❌ not supported | yes |
| `SHOW MAINTENANCE POLICIES` | ❌ not supported | yes |
| `SHOW MANAGED ACCOUNTS` | ❌ not supported | yes |
| `SHOW MASKING POLICIES` | ✅ supported | yes |
| `SHOW MATERIALIZED VIEWS` | ✅ supported | yes |
| `SHOW MCP SERVERS` | ❌ not supported | yes |
| `SHOW MFA METHODS` | ❌ not supported | yes |
| `SHOW MODEL MONITORS` | ❌ not supported | yes |
| `SHOW MODELS` | ❌ not supported | yes |
| `SHOW NETWORK POLICIES` | ✅ supported | yes |
| `SHOW NETWORK RULES` | ✅ supported | yes |
| `SHOW NOTEBOOK PROJECTS` | ❌ not supported | yes |
| `SHOW NOTEBOOKS` | ❌ not supported | yes |
| `SHOW NOTIFICATION INTEGRATIONS` | ✅ supported | yes |
| `SHOW OBJECTS` | ✅ supported | yes |
| `SHOW OBJECTS OWNED BY APPLICATION` | ❌ not supported | yes |
| `SHOW OFFERS` | ❌ not supported | yes |
| `SHOW ONLINE FEATURE TABLES` | ❌ not supported | yes |
| `SHOW OPENFLOW DATA PLANE INTEGRATIONS` | ❌ not supported | yes |
| `SHOW ORGANIZATION ACCOUNTS` | ✅ supported | yes |
| `SHOW ORGANIZATION PROFILES` | ❌ not supported | yes |
| `SHOW ORGANIZATION USER GROUPS` | ❌ not supported | yes |
| `SHOW ORGANIZATION USERS` | ❌ not supported | yes |
| `SHOW PACKAGES POLICIES` | ❌ not supported | yes |
| `SHOW PARAMETERS` | ✅ supported | yes |
| `SHOW PASSWORD POLICIES` | ❌ not supported | yes |
| `SHOW PIPES` | ✅ supported | yes |
| `SHOW POSTGRES INSTANCES` | ❌ not supported | yes |
| `SHOW PRICING PLANS` | ❌ not supported | yes |
| `SHOW PRIMARY KEYS` | ✅ supported | yes |
| `SHOW PRIVACY POLICIES` | ❌ not supported | yes |
| `SHOW PRIVILEGES` | ❌ not supported | yes |
| `SHOW PROCEDURES` | ✅ supported | yes |
| `SHOW PROJECTION POLICIES` | ❌ not supported | yes |
| `SHOW REFERENCES` | ❌ not supported | yes |
| `SHOW REGIONS` | ❌ not supported | yes |
| `SHOW RELEASE CHANNELS` | ❌ not supported | yes |
| `SHOW RELEASE DIRECTIVES` | ❌ not supported | yes |
| `SHOW REPLICATION ACCOUNTS` | ✅ supported | yes |
| `SHOW REPLICATION DATABASES` | ✅ supported | yes |
| `SHOW REPLICATION GROUPS` | ❌ not supported | yes |
| `SHOW RESOURCE MONITORS` | ✅ supported | yes |
| `SHOW RESTRICTED SESSION SCOPES` | ❌ not supported | yes |
| `SHOW ROLES` | ✅ supported | yes |
| `SHOW ROLES IN SERVICE` | ❌ not supported | yes |
| `SHOW ROW ACCESS POLICIES` | ✅ supported | yes |
| `SHOW RUN` | ❌ not supported | yes |
| `SHOW RUNS IN EXPERIMENT` | ❌ not supported | yes |
| `SHOW SCHEMAS` | ✅ supported | yes |
| `SHOW SECRETS` | ✅ supported | yes |
| `SHOW SEMANTIC DIMENSIONS` | ❌ not supported | yes |
| `SHOW SEMANTIC DIMENSIONS FOR METRIC` | ❌ not supported | yes |
| `SHOW SEMANTIC FACTS` | ❌ not supported | yes |
| `SHOW SEMANTIC METRICS` | ❌ not supported | yes |
| `SHOW SEMANTIC VIEWS` | ❌ not supported | yes |
| `SHOW SEQUENCES` | ✅ supported | yes |
| `SHOW SERVICE CONTAINERS IN SERVICE` | ❌ not supported | yes |
| `SHOW SERVICE INSTANCES IN SERVICE` | ❌ not supported | yes |
| `SHOW SERVICE VOLUMES IN SERVICE` | ❌ not supported | yes |
| `SHOW SERVICES` | ❌ not supported | yes |
| `SHOW SESSION POLICIES` | ❌ not supported | yes |
| `SHOW SHARED CONTENT IN APPLICATION PACKAGE` | ❌ not supported | yes |
| `SHOW SHARES` | ✅ supported | yes |
| `SHOW SHARES IN FAILOVER GROUP` | ❌ not supported | yes |
| `SHOW SHARES IN REPLICATION GROUP` | ❌ not supported | yes |
| `SHOW SNAPSHOTS` | ❌ not supported | yes |
| `SHOW SPECIFICATIONS` | ❌ not supported | yes |
| `SHOW STAGES` | ✅ supported | yes |
| `SHOW STORAGE LIFECYCLE POLICIES` | ❌ not supported | yes |
| `SHOW STREAMLITS` | ❌ not supported | yes |
| `SHOW STREAMS` | 🟡 partial | yes |
| `SHOW TABLES` | ✅ supported | yes |
| `SHOW TAGS` | ✅ supported | yes |
| `SHOW TASKS` | 🟡 partial | yes |
| `SHOW TELEMETRY EVENT DEFINITIONS` | ❌ not supported | yes |
| `SHOW TRANSACTIONS` | ✅ supported | yes |
| `SHOW TYPES` | ❌ not supported | yes |
| `SHOW USER FUNCTIONS` | ✅ supported | yes |
| `SHOW USER KEY PAIRS` | ❌ not supported | yes |
| `SHOW USER PROCEDURES` | ❌ not supported | yes |
| `SHOW USER PROGRAMMATIC ACCESS TOKENS` | ❌ not supported | yes |
| `SHOW USER WORKLOAD IDENTITY AUTHENTICATION METHODS` | ❌ not supported | yes |
| `SHOW USERS` | ✅ supported | yes |
| `SHOW VARIABLES` | ✅ supported | yes |
| `SHOW VERSIONS IN APPLICATION PACKAGE` | ❌ not supported | yes |
| `SHOW VERSIONS IN DATASET` | ❌ not supported | yes |
| `SHOW VERSIONS IN DBT PROJECT` | ❌ not supported | yes |
| `SHOW VERSIONS IN LISTING` | ❌ not supported | yes |
| `SHOW VERSIONS IN MODEL` | ❌ not supported | yes |
| `SHOW VERSIONS IN ORGANIZATION PROFILE` | ❌ not supported | yes |
| `SHOW VIEWS` | ✅ supported | yes |
| `SHOW WAREHOUSES` | ✅ supported | yes |
| `SHOW WORKSPACES` | ❌ not supported | yes |
| `TRUNCATE MATERIALIZED VIEW` | ✅ supported | yes |
| `TRUNCATE TABLE` | ✅ supported | yes |
| `UNDROP ACCOUNT` | ❌ not supported | yes |
| `UNDROP DATABASE` | 🟡 partial | yes |
| `UNDROP DYNAMIC TABLE` | ✅ supported | yes |
| `UNDROP EXTERNAL VOLUME` | ❌ not supported | yes |
| `UNDROP ICEBERG TABLE` | ❌ not supported | yes |
| `UNDROP NOTEBOOK` | ❌ not supported | yes |
| `UNDROP SCHEMA` | 🟡 partial | yes |
| `UNDROP SNAPSHOT` | ❌ not supported | yes |
| `UNDROP STREAMLIT` | ❌ not supported | yes |
| `UNDROP TABLE` | ✅ supported | yes |
| `UNDROP TAG` | ❌ not supported | yes |
| `UNDROP TYPE` | ❌ not supported | yes |
| `UNSET` | ✅ supported | yes |
| `UPDATE` | ✅ supported | yes |
| `USE DATABASE` | ✅ supported | yes |
| `USE ROLE` | ✅ supported | yes |
| `USE SCHEMA` | ✅ supported | yes |
| `USE SECONDARY ROLES` | ✅ supported | yes |
| `USE WAREHOUSE` | 🟡 partial | yes |
| `BEGIN … END (Snowflake Scripting block)` | ✅ supported | no |
| `DECLARE … BEGIN … END (Snowflake Scripting block)` | ✅ supported | no |
| `REVOKE OWNERSHIP` | ✅ supported | no |
| `SHOW EXPORTED KEYS` | ✅ supported | no |
| `SHOW IMPORTED KEYS` | ✅ supported | no |
| `SHOW UNIQUE KEYS` | ✅ supported | no |
| `UNDROP ALERT` | ✅ supported | no |
| `UNDROP EXTERNAL TABLE` | ✅ supported | no |
| `UNDROP VIEW` | ✅ supported | no |

## Query features

| Feature | Status | In the SQL reference |
|---|---|---|
| ASOF JOIN | ✅ supported | yes |
| AT \| BEFORE | 🟡 partial | yes |
| CHANGES | 🟡 partial | yes |
| CONNECT BY | ❌ not supported | yes |
| FOR UPDATE | ❌ not supported | yes |
| FROM | ✅ supported | yes |
| GROUP BY | ✅ supported | yes |
| GROUP BY CUBE | ✅ supported | yes |
| GROUP BY GROUPING SETS | ✅ supported | yes |
| GROUP BY ROLLUP | ✅ supported | yes |
| HAVING | ✅ supported | yes |
| INTO | ✅ supported | yes |
| JOIN | ✅ supported | yes |
| LATERAL | ✅ supported | yes |
| LIMIT / FETCH | ✅ supported | yes |
| MATCH_RECOGNIZE | 🟡 partial | yes |
| ORDER BY | ✅ supported | yes |
| PIVOT | 🟡 partial | yes |
| QUALIFY | ✅ supported | yes |
| RESAMPLE | ❌ not supported | yes |
| SAMPLE / TABLESAMPLE | ✅ supported | yes |
| SEMANTIC_VIEW | ❌ not supported | yes |
| TOP <N> | ✅ supported | yes |
| UNPIVOT | ✅ supported | yes |
| VALUES | ✅ supported | yes |
| WHERE | ✅ supported | yes |
| WITH | ✅ supported | yes |
| : | ✅ supported | yes |
| :: | ✅ supported | yes |
| BETWEEN | ✅ supported | yes |
| ILIKE | ✅ supported | yes |
| ILIKE ANY | ✅ supported | yes |
| IN | ✅ supported | yes |
| IS DISTINCT FROM | ✅ supported | yes |
| IS NULL | ✅ supported | yes |
| LIKE | ✅ supported | yes |
| LIKE ALL | ✅ supported | yes |
| LIKE ANY | ✅ supported | yes |
| \|\| | ✅ supported | yes |
| Recursive CTEs (WITH RECURSIVE) | 🟡 partial | no |
| Window functions (OVER) | ✅ supported | no |
| GROUP BY ALL | ✅ supported | no |
| DISTINCT | ✅ supported | no |
| NATURAL JOIN | ✅ supported | no |
| FLATTEN | ✅ supported | no |
| TABLE(...) table functions | ✅ supported | no |
| Set operators (UNION / INTERSECT / EXCEPT / MINUS) | ✅ supported | no |
| Subqueries (IN / EXISTS / ANY / ALL) | ✅ supported | no |
| INTERVAL literals | ✅ supported | no |
| IDENTIFIER(...) | ✅ supported | no |
| Positional column references ($1) | ✅ supported | no |
| SELECT * EXCLUDE / RENAME / REPLACE | ✅ supported | no |
| WITHIN GROUP (ordered-set aggregates) | ✅ supported | no |
| Session variables ($var / SET) | ✅ supported | no |

## Data types

| Type | Synonyms | Status |
|---|---|---|
| `ARRAY` | — | ✅ supported |
| `BINARY` | `VARBINARY` | ✅ supported |
| `BOOLEAN` | — | ✅ supported |
| `DATE` | — | ✅ supported |
| `DECFLOAT` | — | ✅ supported |
| `FILE` | — | ✅ supported |
| `FLOAT` | `FLOAT4`, `FLOAT8`, `DOUBLE`, `DOUBLE PRECISION`, `REAL` | ✅ supported |
| `GEOGRAPHY` | — | ✅ supported |
| `GEOMETRY` | — | ✅ supported |
| `MAP` | — | ✅ supported |
| `NUMBER` | `DECIMAL`, `NUMERIC`, `INT`, `INTEGER`, `BIGINT`, `SMALLINT`, `TINYINT`, `BYTEINT` | ✅ supported |
| `OBJECT` | — | ✅ supported |
| `TIME` | — | ✅ supported |
| `TIMESTAMP_LTZ` | — | ✅ supported |
| `TIMESTAMP_NTZ` | `TIMESTAMP`, `DATETIME` | ✅ supported |
| `TIMESTAMP_TZ` | — | ✅ supported |
| `VARCHAR` | `STRING`, `TEXT`, `CHAR`, `CHARACTER`, `NCHAR`, `NVARCHAR`, `NVARCHAR2`, `CHAR VARYING`, `NCHAR VARYING` | ✅ supported |
| `VARIANT` | — | ✅ supported |
| `VECTOR` | — | ✅ supported |

## Functions

Signatures use Snowflake type names; `ANY` accepts every Snowflake type.

### Account Usage table functions (1)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `TAG_REFERENCES_WITH_LINEAGE` | unknown | ❌ not supported | — |

### Aggregate functions (82)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `AGG` | unknown | ❌ not supported | — |
| `AI_AGG` | unknown | ❌ not supported | — |
| `AI_SUMMARIZE_AGG` | unknown | ❌ not supported | — |
| `ANY_VALUE` | aggregate | ✅ supported | `(ANY)` |
| `APPROXIMATE_JACCARD_INDEX` | aggregate | ✅ supported | `(OBJECT)` |
| `APPROXIMATE_SIMILARITY` | aggregate | ✅ supported | `(OBJECT)` |
| `APPROX_COUNT_DISTINCT` | aggregate | ✅ supported | `(ANY)`<br>`(ANY, ANY)` |
| `APPROX_PERCENTILE` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `APPROX_PERCENTILE_ACCUMULATE` | aggregate | ✅ supported | `(FLOAT)` |
| `APPROX_PERCENTILE_COMBINE` | aggregate | ✅ supported | `(OBJECT)` |
| `APPROX_PERCENTILE_ESTIMATE` | scalar | ✅ supported | `(OBJECT, FLOAT) → FLOAT` |
| `APPROX_TOP_K` | aggregate | ✅ supported | `(ANY, NUMBER)` |
| `APPROX_TOP_K_ACCUMULATE` | aggregate | ✅ supported | `(ANY, NUMBER)` |
| `APPROX_TOP_K_COMBINE` | aggregate | ✅ supported | `(OBJECT)` |
| `APPROX_TOP_K_ESTIMATE` | scalar | ✅ supported | `(OBJECT, NUMBER) → VARIANT` |
| `ARRAY_AGG` | aggregate | ✅ supported | `(ANY)` |
| `ARRAY_UNION_AGG` | aggregate | ✅ supported | `(ARRAY)` |
| `ARRAY_UNIQUE_AGG` | aggregate | ✅ supported | `(ANY)` |
| `AVG` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)`<br>`(NUMBER)` |
| `BITAND_AGG` | aggregate | ✅ supported | `(NUMBER)` |
| `BITMAP_ABSOLUTE_POSITION` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |
| `BITMAP_AND` | scalar | ✅ supported | `(ANY, BINARY) → BINARY`<br>`(BINARY, ANY) → BINARY`<br>`(BINARY, BINARY) → BINARY`<br>`(BINARY, NUMBER) → BINARY`<br>`(BINARY, VARCHAR) → BINARY`<br>`(BINARY, VARIANT) → BINARY`<br>`(NUMBER, BINARY) → BINARY`<br>`(VARCHAR, BINARY) → BINARY`<br>`(VARIANT, BINARY) → BINARY` |
| `BITMAP_AND_AGG` | aggregate | ✅ supported | `(ANY)`<br>`(BINARY)`<br>`(NUMBER) → BINARY`<br>`(VARCHAR) → BINARY`<br>`(VARIANT) → BINARY` |
| `BITMAP_BIT_POSITION` | scalar | ✅ supported | `(NUMBER) → NUMBER` |
| `BITMAP_BUCKET_NUMBER` | scalar | ✅ supported | `(NUMBER) → NUMBER` |
| `BITMAP_CONSTRUCT_AGG` | aggregate | ✅ supported | `(NUMBER)` |
| `BITMAP_COUNT` | scalar | ✅ supported | `(BINARY) → NUMBER` |
| `BITMAP_OR` | scalar | ✅ supported | `(ANY, BINARY) → BINARY`<br>`(BINARY, ANY) → BINARY`<br>`(BINARY, BINARY) → BINARY`<br>`(BINARY, NUMBER) → BINARY`<br>`(BINARY, VARCHAR) → BINARY`<br>`(BINARY, VARIANT) → BINARY`<br>`(NUMBER, BINARY) → BINARY`<br>`(VARCHAR, BINARY) → BINARY`<br>`(VARIANT, BINARY) → BINARY` |
| `BITMAP_OR_AGG` | aggregate | ✅ supported | `(BINARY)` |
| `BITMAP_TO_ARRAY` | scalar | ✅ supported | `(ANY) → ARRAY`<br>`(BINARY) → ARRAY`<br>`(NUMBER) → ARRAY`<br>`(VARCHAR) → ARRAY`<br>`(VARIANT) → ARRAY` |
| `BITOR_AGG` | aggregate | ✅ supported | `(NUMBER)` |
| `BITXOR_AGG` | aggregate | ✅ supported | `(NUMBER)` |
| `BOOLAND_AGG` | aggregate | ✅ supported | `(ANY)`<br>`(BOOLEAN)`<br>`(NUMBER)` |
| `BOOLOR_AGG` | aggregate | ✅ supported | `(ANY)`<br>`(BOOLEAN)`<br>`(NUMBER)`<br>`(VARCHAR)` |
| `BOOLXOR_AGG` | aggregate | ✅ supported | `(ANY)`<br>`(BOOLEAN)`<br>`(NUMBER)`<br>`(VARCHAR)` |
| `CORR` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `COUNT` | aggregate | ✅ supported | `(*)`<br>`(ANY)` |
| `COUNT_IF` | aggregate | ✅ supported | `(BOOLEAN)` |
| `COVAR_POP` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `COVAR_SAMP` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `DATASKETCHES_HLL` | aggregate | ✅ supported | `(ANY)`<br>`(ANY, ANY)` |
| `DATASKETCHES_HLL_ACCUMULATE` | aggregate | ✅ supported | `(ANY)` |
| `DATASKETCHES_HLL_COMBINE` | aggregate | ✅ supported | `(BINARY)` |
| `DATASKETCHES_HLL_ESTIMATE` | scalar | ✅ supported | `(BINARY) → FLOAT` |
| `GROUPING` | unknown | ✅ supported | — |
| `GROUPING_ID` | unknown | ✅ supported | — |
| `HASH_AGG` | aggregate | ✅ supported | `(NUMBER)` |
| `HLL` | aggregate | ✅ supported | `(ANY)`<br>`(ANY, ANY)` |
| `HLL_ACCUMULATE` | aggregate | ✅ supported | `(ANY)` |
| `HLL_COMBINE` | aggregate | ✅ supported | `(BINARY)` |
| `HLL_ESTIMATE` | scalar | ✅ supported | `(BINARY) → NUMBER` |
| `HLL_EXPORT` | scalar | ✅ supported | `(BINARY) → OBJECT` |
| `HLL_IMPORT` | scalar | ✅ supported | `(ANY) → BINARY`<br>`(OBJECT) → BINARY`<br>`(VARIANT) → BINARY` |
| `KURTOSIS` | aggregate | ✅ supported | `(ANY)`<br>`(FLOAT)`<br>`(NUMBER)` |
| `LISTAGG` | aggregate | ✅ supported | `(VARCHAR, VARCHAR)` |
| `MAX_BY` | aggregate | ✅ supported | `(ANY, ANY)`<br>`(ANY, ANY, NUMBER)` |
| `MEDIAN` | unknown | ✅ supported | — |
| `MINHASH` | aggregate | ✅ supported | `(NUMBER, ANY)` |
| `MINHASH_COMBINE` | aggregate | ✅ supported | `(OBJECT)` |
| `MIN_BY` | aggregate | ✅ supported | `(ANY, ANY)`<br>`(ANY, ANY, NUMBER)` |
| `MODE` | aggregate | ✅ supported | `(ANY)` |
| `OBJECT_AGG` | aggregate | ✅ supported | `(VARCHAR, VARIANT)` |
| `PERCENTILE_CONT` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)` |
| `PERCENTILE_DISC` | aggregate | ✅ supported | `(ANY)` |
| `REGR_AVGX` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `REGR_AVGY` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `REGR_COUNT` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `REGR_INTERCEPT` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `REGR_R2` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `REGR_SLOPE` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `REGR_SXX` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `REGR_SXY` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `REGR_SYY` | aggregate | ✅ supported | `(FLOAT, FLOAT)` |
| `SKEW` | aggregate | ✅ supported | `(ANY)`<br>`(FLOAT)` |
| `STDDEV_POP` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)` |
| `STDDEV_SAMP` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)` |
| `SUM` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)`<br>`(NUMBER)` |
| `VARIANCE` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)`<br>`(NUMBER)` |
| `VARIANCE_POP` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)`<br>`(NUMBER)` |
| `VARIANCE_SAMP` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)`<br>`(NUMBER)` |
| `VAR_POP` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)`<br>`(NUMBER)` |
| `VAR_SAMP` | aggregate | ✅ supported | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)`<br>`(NUMBER)` |

### Bitwise expression functions (7)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `BITAND` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(DECFLOAT, DECFLOAT) → NUMBER`<br>`(NUMBER, NUMBER) → NUMBER` |
| `BITNOT` | scalar | ✅ supported | `(NUMBER) → NUMBER` |
| `BITOR` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |
| `BITSHIFTLEFT` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |
| `BITSHIFTRIGHT` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |
| `BITXOR` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |
| `GETBIT` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |

### Conditional expression functions (21)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `BOOLAND` | scalar | 🟡 partial | `(ANY, ANY) → BOOLEAN`<br>`(NUMBER, NUMBER) → BOOLEAN`<br>`(NUMBER, VARCHAR) → BOOLEAN`<br>`(VARCHAR, NUMBER) → BOOLEAN`<br>`(VARCHAR, VARCHAR) → BOOLEAN` |
| `BOOLNOT` | scalar | 🟡 partial | `(ANY) → BOOLEAN`<br>`(NUMBER) → BOOLEAN`<br>`(VARCHAR) → BOOLEAN` |
| `BOOLOR` | scalar | 🟡 partial | `(ANY, ANY) → BOOLEAN`<br>`(NUMBER, NUMBER) → BOOLEAN`<br>`(NUMBER, VARCHAR) → BOOLEAN`<br>`(VARCHAR, NUMBER) → BOOLEAN`<br>`(VARCHAR, VARCHAR) → BOOLEAN` |
| `BOOLXOR` | scalar | 🟡 partial | `(ANY, ANY) → BOOLEAN`<br>`(NUMBER, NUMBER) → BOOLEAN`<br>`(NUMBER, VARCHAR) → BOOLEAN`<br>`(VARCHAR, NUMBER) → BOOLEAN`<br>`(VARCHAR, VARCHAR) → BOOLEAN` |
| `CASE` | syntax | ✅ supported | — |
| `COALESCE` | scalar | ✅ supported | `(ANY) → SNOWFLAKE_NULL` |
| `DECODE` | unknown | ✅ supported | — |
| `EQUAL_NULL` | unknown | ✅ supported | — |
| `GREATEST` | scalar | ✅ supported | `(ANY) → SNOWFLAKE_NULL` |
| `GREATEST_IGNORE_NULLS` | unknown | ✅ supported | — |
| `IFF` | unknown | ✅ supported | — |
| `IFNULL` | unknown | ✅ supported | — |
| `LEAST` | scalar | ✅ supported | `(ANY) → SNOWFLAKE_NULL` |
| `LEAST_IGNORE_NULLS` | unknown | ✅ supported | — |
| `NULLIF` | unknown | ✅ supported | — |
| `NULLIFZERO` | unknown | ✅ supported | — |
| `NVL` | unknown | ✅ supported | — |
| `NVL2` | unknown | ✅ supported | — |
| `REGR_VALX` | scalar | ✅ supported | `(ANY, ANY) → FLOAT`<br>`(FLOAT, FLOAT) → FLOAT`<br>`(NUMBER, FLOAT) → FLOAT`<br>`(VARCHAR, FLOAT) → FLOAT`<br>`(VARIANT, FLOAT) → FLOAT` |
| `REGR_VALY` | scalar | ✅ supported | `(ANY, ANY) → FLOAT`<br>`(FLOAT, FLOAT) → FLOAT`<br>`(FLOAT, NUMBER) → FLOAT`<br>`(FLOAT, VARCHAR) → FLOAT`<br>`(FLOAT, VARIANT) → FLOAT` |
| `ZEROIFNULL` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → NUMBER`<br>`(VARCHAR) → FLOAT`<br>`(VARIANT) → FLOAT` |

### Context functions (52)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `ALL_USER_NAMES` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_ACCOUNT` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_ACCOUNT_NAME` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_AVAILABLE_ROLES` | scalar | 🟡 partial | `() → VARCHAR` |
| `CURRENT_CLIENT` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_DATABASE` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_DATE` | scalar | ✅ supported | `() → DATE` |
| `CURRENT_IP_ADDRESS` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_ORGANIZATION_NAME` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_ORGANIZATION_USER` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_REGION` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_ROLE` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_ROLE_TYPE` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_SCHEMA` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_SCHEMAS` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_SECONDARY_ROLES` | scalar | 🟡 partial | `() → VARCHAR` |
| `CURRENT_SESSION` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_STATEMENT` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_TIME` | scalar | ✅ supported | `() → TIME` |
| `CURRENT_TIMESTAMP` | scalar | ✅ supported | `() → TIMESTAMP_LTZ` |
| `CURRENT_TRANSACTION` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_USER` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_VERSION` | scalar | ✅ supported | `() → VARCHAR` |
| `CURRENT_WAREHOUSE` | scalar | ✅ supported | `() → VARCHAR` |
| `GETDATE` | scalar | ✅ supported | `() → TIMESTAMP_LTZ` |
| `GETVARIABLE` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `GET_CONDITION_QUERY_UUID` | unknown | ✅ supported | — |
| `GET_CONFIGURATION_VALUE` | unknown | ❌ not supported | — |
| `INVOKER_ROLE` | unknown | ❌ not supported | — |
| `INVOKER_SHARE` | unknown | ❌ not supported | — |
| `IS_APPLICATION_ROLE_ACTIVATED` | unknown | ❌ not supported | — |
| `IS_APPLICATION_ROLE_IN_SESSION` | unknown | ❌ not supported | — |
| `IS_CONFIGURATION_SET` | unknown | ❌ not supported | — |
| `IS_DATABASE_ROLE_ACTIVATED` | unknown | ❌ not supported | — |
| `IS_DATABASE_ROLE_IN_SESSION` | unknown | ❌ not supported | — |
| `IS_GRANTED_TO_INVOKER_ROLE` | unknown | ❌ not supported | — |
| `IS_GROUP_ACTIVATED` | unknown | ❌ not supported | — |
| `IS_GROUP_IMPORTED` | unknown | ❌ not supported | — |
| `IS_INSTANCE_ROLE_IN_SESSION` | unknown | ❌ not supported | — |
| `IS_ORGANIZATION_USER_GROUP_IN_SESSION` | unknown | ❌ not supported | — |
| `IS_ROLE_ACTIVATED` | unknown | ❌ not supported | — |
| `IS_ROLE_IN_SESSION` | unknown | ❌ not supported | — |
| `IS_USER_IMPORTED` | unknown | ❌ not supported | — |
| `LAST_QUERY_ID` | scalar | ✅ supported | `(NUMBER) → VARCHAR` |
| `LAST_TRANSACTION` | scalar | ✅ supported | `() → VARCHAR` |
| `LOCALTIME` | scalar | ✅ supported | `() → TIME` |
| `LOCALTIMESTAMP` | scalar | ✅ supported | `() → TIMESTAMP_LTZ` |
| `POLICY_CONTEXT` | unknown | ❌ not supported | — |
| `SET_SYS_CONTEXT` | unknown | ❌ not supported | — |
| `SYSDATE` | scalar | 🟡 partial | `() → TIMESTAMP_NTZ` |
| `SYSTIMESTAMP` | unknown | ❌ not supported | — |
| `SYS_CONTEXT` | unknown | ❌ not supported | — |

### Conversion functions (39)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `CAST` | syntax | 🟡 partial | — |
| `DATE` | scalar | ✅ supported | `(ANY) → DATE`<br>`(NUMBER) → DATE`<br>`(TIMESTAMP_LTZ) → DATE`<br>`(TIMESTAMP_NTZ) → DATE`<br>`(TIMESTAMP_TZ) → DATE`<br>`(VARCHAR) → DATE`<br>`(VARIANT) → DATE`<br>`(VARCHAR, VARCHAR) → DATE` |
| `TIME` | scalar | ✅ supported | `(ANY) → TIME`<br>`(NUMBER) → TIME`<br>`(TIMESTAMP_LTZ) → TIME`<br>`(TIMESTAMP_NTZ) → TIME`<br>`(TIMESTAMP_TZ) → TIME`<br>`(VARCHAR) → TIME`<br>`(VARIANT) → TIME`<br>`(VARCHAR, VARCHAR) → TIME` |
| `TO_ARRAY` | scalar | ✅ supported | `(ANY) → ARRAY`<br>`(ARRAY) → ARRAY`<br>`(BINARY) → ARRAY`<br>`(BOOLEAN) → ARRAY`<br>`(DATE) → ARRAY`<br>`(FLOAT) → ARRAY`<br>`(NUMBER) → ARRAY`<br>`(OBJECT) → ARRAY`<br>`(TIME) → ARRAY`<br>`(TIMESTAMP_LTZ) → ARRAY`<br>`(TIMESTAMP_NTZ) → ARRAY`<br>`(TIMESTAMP_TZ) → ARRAY`<br>`(VARCHAR) → ARRAY`<br>`(VARIANT) → ARRAY` |
| `TO_BINARY` | scalar | ✅ supported | `(ANY) → BINARY`<br>`(VARCHAR) → BINARY`<br>`(VARCHAR, VARCHAR) → BINARY` |
| `TO_BOOLEAN` | scalar | ✅ supported | `(ANY) → BOOLEAN`<br>`(BOOLEAN) → BOOLEAN`<br>`(FLOAT) → BOOLEAN`<br>`(NUMBER) → BOOLEAN`<br>`(VARCHAR) → BOOLEAN`<br>`(VARIANT) → BOOLEAN` |
| `TO_CHAR` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(BOOLEAN) → VARCHAR`<br>`(DATE) → VARCHAR`<br>`(FLOAT) → VARCHAR`<br>`(NUMBER) → VARCHAR`<br>`(SNOWFLAKE_UUID) → VARCHAR`<br>`(TIMESTAMP_LTZ) → VARCHAR`<br>`(TIMESTAMP_NTZ) → VARCHAR`<br>`(TIMESTAMP_TZ) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(VARIANT) → VARCHAR`<br>`(BINARY, VARCHAR) → VARCHAR`<br>`(DATE, VARCHAR) → VARCHAR`<br>`(FLOAT, VARCHAR) → VARCHAR`<br>`(NUMBER, VARCHAR) → VARCHAR`<br>`(TIMESTAMP_LTZ, VARCHAR) → VARCHAR`<br>`(TIMESTAMP_NTZ, VARCHAR) → VARCHAR`<br>`(TIMESTAMP_TZ, VARCHAR) → VARCHAR` |
| `TO_DATE` | scalar | ✅ supported | `(ANY) → DATE`<br>`(NUMBER) → DATE`<br>`(TIMESTAMP_LTZ) → DATE`<br>`(TIMESTAMP_NTZ) → DATE`<br>`(TIMESTAMP_TZ) → DATE`<br>`(VARCHAR) → DATE`<br>`(VARIANT) → DATE`<br>`(VARCHAR, VARCHAR) → DATE` |
| `TO_DECFLOAT` | scalar | ✅ supported | `(ANY) → DECFLOAT`<br>`(FLOAT) → DECFLOAT`<br>`(NUMBER) → DECFLOAT`<br>`(VARCHAR) → DECFLOAT`<br>`(VARCHAR, VARCHAR) → DECFLOAT` |
| `TO_DECIMAL` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(BOOLEAN, NUMBER) → NUMBER`<br>`(NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(BOOLEAN, NUMBER, NUMBER) → NUMBER`<br>`(NUMBER, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER` |
| `TO_DOUBLE` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(BOOLEAN) → FLOAT`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → FLOAT`<br>`(VARCHAR) → FLOAT`<br>`(VARCHAR, VARCHAR) → FLOAT` |
| `TO_JSON` | scalar | ✅ supported | `(VARIANT) → VARCHAR` |
| `TO_NUMBER` | scalar | 🟡 partial | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(BOOLEAN, NUMBER) → NUMBER`<br>`(NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(BOOLEAN, NUMBER, NUMBER) → NUMBER`<br>`(NUMBER, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER` |
| `TO_NUMERIC` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(BOOLEAN, NUMBER) → NUMBER`<br>`(NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(BOOLEAN, NUMBER, NUMBER) → NUMBER`<br>`(NUMBER, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER` |
| `TO_OBJECT` | scalar | ✅ supported | `(ANY) → OBJECT`<br>`(NUMBER) → OBJECT`<br>`(OBJECT) → OBJECT`<br>`(VARIANT) → OBJECT` |
| `TO_TIME` | scalar | ✅ supported | `(ANY) → TIME`<br>`(NUMBER) → TIME`<br>`(TIMESTAMP_LTZ) → TIME`<br>`(TIMESTAMP_NTZ) → TIME`<br>`(TIMESTAMP_TZ) → TIME`<br>`(VARCHAR) → TIME`<br>`(VARIANT) → TIME`<br>`(VARCHAR, VARCHAR) → TIME` |
| `TO_TIMESTAMP` | scalar | ✅ supported | `(ANY) → TIMESTAMP_NTZ`<br>`(NUMBER) → TIMESTAMP_NTZ`<br>`(VARCHAR) → TIMESTAMP_NTZ`<br>`(VARIANT) → TIMESTAMP_NTZ`<br>`(VARCHAR, VARCHAR) → TIMESTAMP_NTZ` |
| `TO_TIMESTAMP_LTZ` | scalar | ✅ supported | `(ANY) → TIMESTAMP_LTZ`<br>`(NUMBER) → TIMESTAMP_LTZ`<br>`(VARCHAR) → TIMESTAMP_LTZ`<br>`(VARIANT) → TIMESTAMP_LTZ`<br>`(VARCHAR, VARCHAR) → TIMESTAMP_LTZ` |
| `TO_TIMESTAMP_NTZ` | scalar | ✅ supported | `(ANY) → TIMESTAMP_NTZ`<br>`(NUMBER) → TIMESTAMP_NTZ`<br>`(VARCHAR) → TIMESTAMP_NTZ`<br>`(VARIANT) → TIMESTAMP_NTZ`<br>`(VARCHAR, VARCHAR) → TIMESTAMP_NTZ` |
| `TO_TIMESTAMP_TZ` | scalar | ✅ supported | `(ANY) → TIMESTAMP_TZ`<br>`(NUMBER) → TIMESTAMP_TZ`<br>`(VARCHAR) → TIMESTAMP_TZ`<br>`(VARIANT) → TIMESTAMP_TZ`<br>`(VARCHAR, VARCHAR) → TIMESTAMP_TZ` |
| `TO_UUID` | scalar | ✅ supported | `(ANY) → SNOWFLAKE_UUID`<br>`(SNOWFLAKE_UUID) → SNOWFLAKE_UUID`<br>`(VARCHAR) → SNOWFLAKE_UUID`<br>`(VARIANT) → SNOWFLAKE_UUID` |
| `TO_VARCHAR` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(BOOLEAN) → VARCHAR`<br>`(DATE) → VARCHAR`<br>`(FLOAT) → VARCHAR`<br>`(NUMBER) → VARCHAR`<br>`(SNOWFLAKE_UUID) → VARCHAR`<br>`(TIMESTAMP_LTZ) → VARCHAR`<br>`(TIMESTAMP_NTZ) → VARCHAR`<br>`(TIMESTAMP_TZ) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(VARIANT) → VARCHAR`<br>`(BINARY, VARCHAR) → VARCHAR`<br>`(DATE, VARCHAR) → VARCHAR`<br>`(FLOAT, VARCHAR) → VARCHAR`<br>`(NUMBER, VARCHAR) → VARCHAR`<br>`(TIMESTAMP_LTZ, VARCHAR) → VARCHAR`<br>`(TIMESTAMP_NTZ, VARCHAR) → VARCHAR`<br>`(TIMESTAMP_TZ, VARCHAR) → VARCHAR` |
| `TO_VARIANT` | scalar | ✅ supported | `(ANY) → VARIANT`<br>`(ARRAY) → VARIANT`<br>`(BINARY) → VARIANT`<br>`(BOOLEAN) → VARIANT`<br>`(DATE) → VARIANT`<br>`(DECFLOAT) → VARIANT`<br>`(FLOAT) → VARIANT`<br>`(NUMBER) → VARIANT`<br>`(OBJECT) → VARIANT`<br>`(SNOWFLAKE_UUID) → VARIANT`<br>`(TIME) → VARIANT`<br>`(TIMESTAMP_LTZ) → VARIANT`<br>`(TIMESTAMP_NTZ) → VARIANT`<br>`(TIMESTAMP_TZ) → VARIANT`<br>`(VARCHAR) → VARIANT`<br>`(VARIANT) → VARIANT` |
| `TO_XML` | scalar | ✅ supported | `(VARIANT) → VARCHAR` |
| `TRY_CAST` | syntax | ✅ supported | — |
| `TRY_TO_BINARY` | scalar | ✅ supported | `(ANY) → BINARY`<br>`(VARCHAR) → BINARY`<br>`(VARCHAR, VARCHAR) → BINARY` |
| `TRY_TO_BOOLEAN` | scalar | ✅ supported | `(ANY) → BOOLEAN`<br>`(BOOLEAN) → BOOLEAN`<br>`(FLOAT) → BOOLEAN`<br>`(NUMBER) → BOOLEAN`<br>`(VARCHAR) → BOOLEAN` |
| `TRY_TO_DATE` | scalar | ✅ supported | `(ANY) → DATE`<br>`(VARCHAR) → DATE`<br>`(VARIANT) → DATE`<br>`(VARCHAR, VARCHAR) → DATE`<br>`(VARIANT, VARCHAR) → DATE` |
| `TRY_TO_DECFLOAT` | scalar | ✅ supported | `(VARCHAR) → DECFLOAT` |
| `TRY_TO_DECIMAL` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(VARCHAR, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER` |
| `TRY_TO_DOUBLE` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(VARCHAR) → FLOAT`<br>`(VARCHAR, VARCHAR) → FLOAT` |
| `TRY_TO_NUMBER` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(VARCHAR, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER` |
| `TRY_TO_NUMERIC` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(VARCHAR, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER` |
| `TRY_TO_TIME` | scalar | ✅ supported | `(ANY) → TIME`<br>`(VARCHAR) → TIME`<br>`(VARIANT) → TIME`<br>`(VARCHAR, VARCHAR) → TIME`<br>`(VARIANT, VARCHAR) → TIME` |
| `TRY_TO_TIMESTAMP` | scalar | ✅ supported | `(ANY) → TIMESTAMP_NTZ`<br>`(VARCHAR) → TIMESTAMP_NTZ`<br>`(VARIANT) → TIMESTAMP_NTZ`<br>`(VARCHAR, VARCHAR) → TIMESTAMP_NTZ`<br>`(VARIANT, VARCHAR) → TIMESTAMP_NTZ` |
| `TRY_TO_TIMESTAMP_LTZ` | scalar | ✅ supported | `(ANY) → TIMESTAMP_LTZ`<br>`(VARCHAR) → TIMESTAMP_LTZ`<br>`(VARIANT) → TIMESTAMP_LTZ`<br>`(VARCHAR, VARCHAR) → TIMESTAMP_LTZ`<br>`(VARIANT, VARCHAR) → TIMESTAMP_LTZ` |
| `TRY_TO_TIMESTAMP_NTZ` | scalar | ✅ supported | `(ANY) → TIMESTAMP_NTZ`<br>`(VARCHAR) → TIMESTAMP_NTZ`<br>`(VARIANT) → TIMESTAMP_NTZ`<br>`(VARCHAR, VARCHAR) → TIMESTAMP_NTZ`<br>`(VARIANT, VARCHAR) → TIMESTAMP_NTZ` |
| `TRY_TO_TIMESTAMP_TZ` | scalar | ✅ supported | `(ANY) → TIMESTAMP_TZ`<br>`(VARCHAR) → TIMESTAMP_TZ`<br>`(VARIANT) → TIMESTAMP_TZ`<br>`(VARCHAR, VARCHAR) → TIMESTAMP_TZ`<br>`(VARIANT, VARCHAR) → TIMESTAMP_TZ` |
| `TRY_TO_UUID` | scalar | ✅ supported | `(ANY) → SNOWFLAKE_UUID`<br>`(VARCHAR) → SNOWFLAKE_UUID`<br>`(VARIANT) → SNOWFLAKE_UUID` |

### Data generation functions (9)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `NORMAL` | scalar | ✅ supported | `(FLOAT, FLOAT, FLOAT) → FLOAT` |
| `RANDOM` | scalar | ✅ supported | `() → NUMBER`<br>`(ANY) → NUMBER`<br>`(NUMBER) → NUMBER` |
| `RANDSTR` | scalar | ✅ supported | `(ANY, ANY) → VARCHAR`<br>`(NUMBER, NUMBER) → VARCHAR` |
| `SEQ1` | scalar | ✅ supported | `() → NUMBER` |
| `SEQ2` | scalar | ✅ supported | `() → NUMBER` |
| `SEQ4` | scalar | ✅ supported | `() → NUMBER` |
| `SEQ8` | scalar | ✅ supported | `() → NUMBER` |
| `UNIFORM` | scalar | ✅ supported | `(ANY, ANY, ANY) → NUMBER`<br>`(FLOAT, FLOAT, FLOAT) → FLOAT`<br>`(NUMBER, NUMBER, NUMBER) → NUMBER` |
| `ZIPF` | scalar | ✅ supported | `(FLOAT, NUMBER, NUMBER) → NUMBER` |

### Data metric functions (13)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `ACCEPTED_VALUES` | unknown | ✅ supported | — |
| `BLANK_COUNT` | unknown | ✅ supported | — |
| `BLANK_PERCENT` | unknown | ✅ supported | — |
| `DATA_METRIC_SCHEDULED_TIME` | unknown | ✅ supported | — |
| `DUPLICATE_COUNT` | unknown | ✅ supported | — |
| `FRESHNESS` | unknown | ✅ supported | — |
| `MAX` | aggregate | ✅ supported | `(ANY)`<br>`(DATE)`<br>`(DECFLOAT)`<br>`(FLOAT)`<br>`(NUMBER)`<br>`(TIME)`<br>`(TIMESTAMP_LTZ)`<br>`(TIMESTAMP_NTZ)`<br>`(TIMESTAMP_TZ)`<br>`(VARCHAR)` |
| `MIN` | aggregate | ✅ supported | `(ANY)`<br>`(DATE)`<br>`(DECFLOAT)`<br>`(FLOAT)`<br>`(NUMBER)`<br>`(TIME)`<br>`(TIMESTAMP_LTZ)`<br>`(TIMESTAMP_NTZ)`<br>`(TIMESTAMP_TZ)`<br>`(VARCHAR)` |
| `NULL_COUNT` | unknown | ✅ supported | — |
| `NULL_PERCENT` | unknown | ✅ supported | — |
| `ROW_COUNT` | unknown | ✅ supported | — |
| `STDDEV` | aggregate | 🟡 partial | `(ANY)`<br>`(DECFLOAT)`<br>`(FLOAT)` |
| `UNIQUE_COUNT` | unknown | ✅ supported | — |

### Date & time functions (39)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `ADD_MONTHS` | scalar | ✅ supported | `(ANY, ANY) → TIMESTAMP_NTZ`<br>`(DATE, NUMBER) → DATE`<br>`(TIMESTAMP_LTZ, NUMBER) → TIMESTAMP_LTZ`<br>`(TIMESTAMP_NTZ, NUMBER) → TIMESTAMP_NTZ`<br>`(TIMESTAMP_TZ, NUMBER) → TIMESTAMP_TZ` |
| `CONVERT_TIMEZONE` | scalar | ✅ supported | `(ANY, ANY) → TIMESTAMP_TZ`<br>`(VARCHAR, TIMESTAMP_LTZ) → TIMESTAMP_TZ`<br>`(VARCHAR, TIMESTAMP_NTZ) → TIMESTAMP_TZ`<br>`(VARCHAR, TIMESTAMP_TZ) → TIMESTAMP_TZ`<br>`(ANY, ANY, ANY) → TIMESTAMP_NTZ`<br>`(VARCHAR, VARCHAR, TIMESTAMP_NTZ) → TIMESTAMP_NTZ` |
| `DATEADD` | unknown | ✅ supported | — |
| `DATEDIFF` | scalar | ✅ supported | `(ANY, ANY, ANY) → NUMBER`<br>`(VARCHAR, DATE, DATE) → NUMBER`<br>`(VARCHAR, TIME, TIME) → NUMBER`<br>`(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR, VARCHAR, VARCHAR) → NUMBER` |
| `DATE_FROM_PARTS` | scalar | ✅ supported | `(NUMBER, NUMBER, NUMBER) → DATE` |
| `DATE_PART` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(VARCHAR, DATE) → NUMBER`<br>`(VARCHAR, TIME) → NUMBER`<br>`(VARCHAR, TIMESTAMP_LTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_NTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_TZ) → NUMBER` |
| `DATE_TRUNC` | scalar | ✅ supported | `(ANY, ANY) → TIMESTAMP_NTZ`<br>`(VARCHAR, DATE) → DATE`<br>`(VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, TIME) → TIME`<br>`(VARCHAR, TIMESTAMP_LTZ) → TIMESTAMP_LTZ`<br>`(VARCHAR, TIMESTAMP_NTZ) → TIMESTAMP_NTZ`<br>`(VARCHAR, TIMESTAMP_TZ) → TIMESTAMP_TZ`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `DAY` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(DATE) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `DAYNAME` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BOOLEAN) → VARCHAR`<br>`(DATE) → VARCHAR`<br>`(FLOAT) → VARCHAR`<br>`(NUMBER) → VARCHAR`<br>`(TIMESTAMP_LTZ) → VARCHAR`<br>`(TIMESTAMP_NTZ) → VARCHAR`<br>`(TIMESTAMP_TZ) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `DAYOFMONTH` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(DATE) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `DAYOFWEEK` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(DATE) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `DAYOFWEEKISO` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(DATE) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `DAYOFYEAR` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(DATE) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `EXTRACT` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(VARCHAR, DATE) → NUMBER`<br>`(VARCHAR, TIME) → NUMBER`<br>`(VARCHAR, TIMESTAMP_LTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_NTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_TZ) → NUMBER` |
| `HOUR` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIME) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `LAST_DAY` | scalar | ✅ supported | `(ANY) → DATE`<br>`(DATE) → DATE`<br>`(TIMESTAMP_LTZ) → DATE`<br>`(TIMESTAMP_NTZ) → DATE`<br>`(TIMESTAMP_TZ) → DATE`<br>`(ANY, ANY) → DATE`<br>`(DATE, VARCHAR) → DATE`<br>`(TIMESTAMP_LTZ, VARCHAR) → DATE`<br>`(TIMESTAMP_NTZ, VARCHAR) → DATE`<br>`(TIMESTAMP_TZ, VARCHAR) → DATE` |
| `LAST_SUCCESSFUL_SCHEDULED_TIME` | unknown | ✅ supported | — |
| `MINUTE` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIME) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `MONTH` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(DATE) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `MONTHNAME` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BOOLEAN) → VARCHAR`<br>`(DATE) → VARCHAR`<br>`(FLOAT) → VARCHAR`<br>`(NUMBER) → VARCHAR`<br>`(TIMESTAMP_LTZ) → VARCHAR`<br>`(TIMESTAMP_NTZ) → VARCHAR`<br>`(TIMESTAMP_TZ) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `MONTHS_BETWEEN` | scalar | ✅ supported | `(ANY, ANY) → FLOAT`<br>`(DATE, DATE) → FLOAT`<br>`(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → FLOAT`<br>`(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → FLOAT`<br>`(TIMESTAMP_TZ, TIMESTAMP_TZ) → FLOAT` |
| `NEXT_DAY` | scalar | ✅ supported | `(ANY, ANY) → DATE`<br>`(DATE, VARCHAR) → DATE`<br>`(TIMESTAMP_LTZ, VARCHAR) → DATE`<br>`(TIMESTAMP_NTZ, VARCHAR) → DATE`<br>`(TIMESTAMP_TZ, VARCHAR) → DATE`<br>`(VARCHAR, VARCHAR) → DATE` |
| `PREVIOUS_DAY` | scalar | ✅ supported | `(ANY, ANY) → DATE`<br>`(DATE, VARCHAR) → DATE`<br>`(TIMESTAMP_LTZ, VARCHAR) → DATE`<br>`(TIMESTAMP_NTZ, VARCHAR) → DATE`<br>`(TIMESTAMP_TZ, VARCHAR) → DATE`<br>`(VARCHAR, VARCHAR) → DATE` |
| `QUARTER` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(DATE) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `SCHEDULED_TIME` | unknown | ✅ supported | — |
| `SECOND` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIME) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `TIMEADD` | unknown | ✅ supported | — |
| `TIMEDIFF` | scalar | ✅ supported | `(ANY, ANY, ANY) → NUMBER`<br>`(VARCHAR, DATE, DATE) → NUMBER`<br>`(VARCHAR, TIME, TIME) → NUMBER`<br>`(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR, VARCHAR, VARCHAR) → NUMBER` |
| `TIMESTAMPADD` | unknown | ✅ supported | — |
| `TIMESTAMPDIFF` | scalar | ✅ supported | `(ANY, ANY, ANY) → NUMBER`<br>`(VARCHAR, DATE, DATE) → NUMBER`<br>`(VARCHAR, TIME, TIME) → NUMBER`<br>`(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER`<br>`(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR, VARCHAR, VARCHAR) → NUMBER` |
| `TIMESTAMP_FROM_PARTS` | scalar | 🟡 partial | `(DATE, TIME) → TIMESTAMP_NTZ`<br>`(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ` |
| `TIME_FROM_PARTS` | scalar | ✅ supported | `(ANY, ANY, ANY) → TIME`<br>`(NUMBER, NUMBER, NUMBER) → TIME`<br>`(NUMBER, NUMBER, NUMBER, NUMBER) → TIME` |
| `TIME_SLICE` | scalar | ✅ supported | `(ANY, NUMBER, VARCHAR) → DATE`<br>`(DATE, NUMBER, VARCHAR) → DATE`<br>`(TIMESTAMP_LTZ, NUMBER, VARCHAR) → TIMESTAMP_NTZ`<br>`(TIMESTAMP_NTZ, NUMBER, VARCHAR) → TIMESTAMP_NTZ`<br>`(TIMESTAMP_TZ, NUMBER, VARCHAR) → TIMESTAMP_NTZ`<br>`(ANY, NUMBER, VARCHAR, VARCHAR) → DATE`<br>`(DATE, NUMBER, VARCHAR, VARCHAR) → DATE`<br>`(TIMESTAMP_LTZ, NUMBER, VARCHAR, VARCHAR) → TIMESTAMP_NTZ`<br>`(TIMESTAMP_NTZ, NUMBER, VARCHAR, VARCHAR) → TIMESTAMP_NTZ`<br>`(TIMESTAMP_TZ, NUMBER, VARCHAR, VARCHAR) → TIMESTAMP_NTZ` |
| `WEEK` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DATE) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIME) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `WEEKISO` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DATE) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIME) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `WEEKOFYEAR` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DATE) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIME) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `YEAR` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(DATE) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `YEAROFWEEK` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BOOLEAN) → NUMBER`<br>`(DATE) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `YEAROFWEEKISO` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DATE) → NUMBER`<br>`(NUMBER) → NUMBER`<br>`(TIME) → NUMBER`<br>`(TIMESTAMP_LTZ) → NUMBER`<br>`(TIMESTAMP_NTZ) → NUMBER`<br>`(TIMESTAMP_TZ) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARIANT) → NUMBER` |

### Differential privacy functions (3)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `DP_INTERVAL_HIGH` | unknown | ❌ not supported | — |
| `DP_INTERVAL_LOW` | unknown | ❌ not supported | — |
| `ESTIMATE_REMAINING_DP_AGGREGATES` | unknown | ❌ not supported | — |

### Encryption functions (6)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `DECRYPT` | scalar | ✅ supported | `(ANY, ANY) → BINARY`<br>`(BINARY, VARCHAR) → BINARY`<br>`(BINARY, VARCHAR, VARCHAR) → BINARY`<br>`(BINARY, VARCHAR, VARCHAR, VARCHAR) → BINARY` |
| `DECRYPT_RAW` | scalar | ✅ supported | `(ANY) → BINARY`<br>`(BINARY, BINARY) → BINARY`<br>`(BINARY, BINARY, BINARY) → BINARY`<br>`(BINARY, BINARY, BINARY, BINARY, VARCHAR) → BINARY`<br>`(BINARY, BINARY, BINARY, BINARY, VARCHAR, BINARY) → BINARY` |
| `ENCRYPT` | scalar | ✅ supported | `(ANY, ANY) → BINARY`<br>`(BINARY, VARCHAR) → BINARY`<br>`(VARCHAR, VARCHAR) → BINARY`<br>`(ANY, ANY, ANY) → BINARY`<br>`(BINARY, VARCHAR, VARCHAR) → BINARY`<br>`(VARCHAR, VARCHAR, VARCHAR) → BINARY`<br>`(ANY, ANY, ANY, ANY) → BINARY`<br>`(BINARY, VARCHAR, VARCHAR, VARCHAR) → BINARY`<br>`(VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BINARY` |
| `ENCRYPT_RAW` | scalar | ✅ supported | `(ANY) → OBJECT`<br>`(BINARY, BINARY) → OBJECT`<br>`(BINARY, BINARY, BINARY, BINARY, VARCHAR) → OBJECT` |
| `TRY_DECRYPT` | scalar | ✅ supported | `(ANY, ANY) → BINARY`<br>`(BINARY, VARCHAR) → BINARY`<br>`(BINARY, VARCHAR, VARCHAR) → BINARY`<br>`(BINARY, VARCHAR, VARCHAR, VARCHAR) → BINARY` |
| `TRY_DECRYPT_RAW` | scalar | ✅ supported | `(ANY, ANY) → BINARY`<br>`(BINARY, BINARY) → BINARY`<br>`(BINARY, BINARY, BINARY) → BINARY`<br>`(BINARY, BINARY, BINARY, BINARY, VARCHAR) → BINARY`<br>`(BINARY, BINARY, BINARY, BINARY, VARCHAR, BINARY) → BINARY` |

### File functions (24)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `AI_TRANSCRIBE` | unknown | ❌ not supported | — |
| `BUILD_SCOPED_FILE_URL` | scalar | ✅ supported | `(VARCHAR, VARCHAR) → VARCHAR` |
| `BUILD_STAGE_FILE_URL` | scalar | ✅ supported | `(VARCHAR, VARCHAR) → VARCHAR` |
| `FL_GET_CONTENT_TYPE` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(FILE) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `FL_GET_ETAG` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(FILE) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `FL_GET_FILE_TYPE` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(FILE) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `FL_GET_LAST_MODIFIED` | scalar | ✅ supported | `(ANY) → TIMESTAMP_TZ`<br>`(FILE) → TIMESTAMP_TZ`<br>`(VARIANT) → TIMESTAMP_TZ` |
| `FL_GET_RELATIVE_PATH` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(FILE) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `FL_GET_SCOPED_FILE_URL` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(FILE) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `FL_GET_SIZE` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(FILE) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `FL_GET_STAGE` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(FILE) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `FL_GET_STAGE_FILE_URL` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(FILE) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `FL_IS_AUDIO` | scalar | ✅ supported | `(ANY) → BOOLEAN`<br>`(FILE) → BOOLEAN`<br>`(VARIANT) → BOOLEAN` |
| `FL_IS_COMPRESSED` | scalar | ✅ supported | `(ANY) → BOOLEAN`<br>`(FILE) → BOOLEAN`<br>`(VARIANT) → BOOLEAN` |
| `FL_IS_DOCUMENT` | scalar | ✅ supported | `(ANY) → BOOLEAN`<br>`(FILE) → BOOLEAN`<br>`(VARIANT) → BOOLEAN` |
| `FL_IS_IMAGE` | scalar | ✅ supported | `(ANY) → BOOLEAN`<br>`(FILE) → BOOLEAN`<br>`(VARIANT) → BOOLEAN` |
| `FL_IS_VIDEO` | scalar | ✅ supported | `(ANY) → BOOLEAN`<br>`(FILE) → BOOLEAN`<br>`(VARIANT) → BOOLEAN` |
| `GET_ABSOLUTE_PATH` | scalar | ✅ supported | `(VARCHAR, VARCHAR) → VARCHAR` |
| `GET_PRESIGNED_URL` | scalar | ✅ supported | `(VARCHAR, VARCHAR, NUMBER) → VARCHAR` |
| `GET_RELATIVE_PATH` | scalar | ✅ supported | `(VARCHAR, VARCHAR) → VARCHAR` |
| `GET_STAGE_LOCATION` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `PARSE_DOCUMENT` | unknown | ❌ not supported | — |
| `TO_FILE` | scalar | ✅ supported | `(ANY) → FILE`<br>`(FILE) → FILE`<br>`(NUMBER) → FILE`<br>`(VARCHAR) → FILE`<br>`(VARIANT) → FILE`<br>`(VARCHAR, VARCHAR) → FILE` |
| `TRY_TO_FILE` | scalar | ✅ supported | `(ANY) → FILE`<br>`(FILE) → FILE`<br>`(OBJECT) → FILE`<br>`(VARCHAR) → FILE`<br>`(VARIANT) → FILE`<br>`(VARCHAR, VARCHAR) → FILE` |

### Geospatial functions (101)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `H3_CELL_TO_BOUNDARY` | unknown | ❌ not supported | — |
| `H3_CELL_TO_CHILDREN` | unknown | ❌ not supported | — |
| `H3_CELL_TO_CHILDREN_STRING` | unknown | ❌ not supported | — |
| `H3_CELL_TO_PARENT` | unknown | ❌ not supported | — |
| `H3_CELL_TO_POINT` | unknown | ❌ not supported | — |
| `H3_COMPACT_CELLS` | unknown | ❌ not supported | — |
| `H3_COMPACT_CELLS_STRINGS` | unknown | ❌ not supported | — |
| `H3_COVERAGE` | unknown | ❌ not supported | — |
| `H3_COVERAGE_STRINGS` | unknown | ❌ not supported | — |
| `H3_GET_RESOLUTION` | unknown | ❌ not supported | — |
| `H3_GRID_DISK` | unknown | ❌ not supported | — |
| `H3_GRID_DISTANCE` | unknown | ❌ not supported | — |
| `H3_GRID_PATH` | unknown | ❌ not supported | — |
| `H3_INT_TO_STRING` | unknown | ❌ not supported | — |
| `H3_IS_PENTAGON` | unknown | ❌ not supported | — |
| `H3_IS_VALID_CELL` | unknown | ❌ not supported | — |
| `H3_LATLNG_TO_CELL` | unknown | ❌ not supported | — |
| `H3_LATLNG_TO_CELL_STRING` | unknown | ❌ not supported | — |
| `H3_POINT_TO_CELL` | unknown | ❌ not supported | — |
| `H3_POINT_TO_CELL_STRING` | unknown | ❌ not supported | — |
| `H3_POLYGON_TO_CELLS` | unknown | ❌ not supported | — |
| `H3_POLYGON_TO_CELLS_STRINGS` | unknown | ❌ not supported | — |
| `H3_STRING_TO_INT` | unknown | ❌ not supported | — |
| `H3_TRY_COVERAGE` | unknown | ❌ not supported | — |
| `H3_TRY_COVERAGE_STRINGS` | unknown | ❌ not supported | — |
| `H3_TRY_GRID_DISTANCE` | unknown | ❌ not supported | — |
| `H3_TRY_GRID_PATH` | unknown | ❌ not supported | — |
| `H3_TRY_POLYGON_TO_CELLS` | unknown | ❌ not supported | — |
| `H3_TRY_POLYGON_TO_CELLS_STRINGS` | unknown | ❌ not supported | — |
| `H3_UNCOMPACT_CELLS` | unknown | ❌ not supported | — |
| `H3_UNCOMPACT_CELLS_STRINGS` | unknown | ❌ not supported | — |
| `HAVERSINE` | scalar | ✅ supported | `(FLOAT, FLOAT, FLOAT, FLOAT) → FLOAT` |
| `ST_AREA` | unknown | ❌ not supported | — |
| `ST_ASBINARY` | unknown | ❌ not supported | — |
| `ST_ASEWKB` | unknown | ❌ not supported | — |
| `ST_ASEWKT` | unknown | ❌ not supported | — |
| `ST_ASGEOJSON` | unknown | ❌ not supported | — |
| `ST_ASTEXT` | unknown | ❌ not supported | — |
| `ST_ASWKB` | unknown | ❌ not supported | — |
| `ST_ASWKT` | unknown | ❌ not supported | — |
| `ST_AZIMUTH` | unknown | ❌ not supported | — |
| `ST_BUFFER` | unknown | ❌ not supported | — |
| `ST_CENTROID` | unknown | ❌ not supported | — |
| `ST_COLLECT` | unknown | ❌ not supported | — |
| `ST_CONTAINS` | unknown | ❌ not supported | — |
| `ST_COVEREDBY` | unknown | ❌ not supported | — |
| `ST_COVERS` | unknown | ❌ not supported | — |
| `ST_DIFFERENCE` | unknown | ❌ not supported | — |
| `ST_DIMENSION` | unknown | ❌ not supported | — |
| `ST_DISJOINT` | unknown | ❌ not supported | — |
| `ST_DISTANCE` | unknown | ❌ not supported | — |
| `ST_DWITHIN` | unknown | ❌ not supported | — |
| `ST_ENDPOINT` | unknown | ❌ not supported | — |
| `ST_ENVELOPE` | unknown | ❌ not supported | — |
| `ST_GEOGFROMGEOHASH` | unknown | ❌ not supported | — |
| `ST_GEOGPOINTFROMGEOHASH` | unknown | ❌ not supported | — |
| `ST_GEOGRAPHYFROMWKB` | unknown | ❌ not supported | — |
| `ST_GEOGRAPHYFROMWKT` | unknown | ❌ not supported | — |
| `ST_GEOHASH` | unknown | ❌ not supported | — |
| `ST_GEOMETRYFROMWKB` | unknown | ❌ not supported | — |
| `ST_GEOMETRYFROMWKT` | unknown | ❌ not supported | — |
| `ST_GEOMFROMGEOHASH` | unknown | ❌ not supported | — |
| `ST_GEOMPOINT` | unknown | ❌ not supported | — |
| `ST_GEOMPOINTFROMGEOHASH` | unknown | ❌ not supported | — |
| `ST_HAUSDORFFDISTANCE` | unknown | ❌ not supported | — |
| `ST_INTERPOLATE` | unknown | ❌ not supported | — |
| `ST_INTERSECTION` | unknown | ❌ not supported | — |
| `ST_INTERSECTION_AGG` | unknown | ❌ not supported | — |
| `ST_INTERSECTS` | unknown | ❌ not supported | — |
| `ST_ISVALID` | unknown | ❌ not supported | — |
| `ST_LENGTH` | unknown | ❌ not supported | — |
| `ST_MAKEGEOMPOINT` | unknown | ❌ not supported | — |
| `ST_MAKELINE` | unknown | ❌ not supported | — |
| `ST_MAKEPOINT` | unknown | ❌ not supported | — |
| `ST_MAKEPOLYGON` | unknown | ❌ not supported | — |
| `ST_MAKEPOLYGONORIENTED` | unknown | ❌ not supported | — |
| `ST_NPOINTS` | unknown | ❌ not supported | — |
| `ST_NUMPOINTS` | unknown | ❌ not supported | — |
| `ST_PERIMETER` | unknown | ❌ not supported | — |
| `ST_POINT` | unknown | ❌ not supported | — |
| `ST_POINTN` | unknown | ❌ not supported | — |
| `ST_POLYGON` | unknown | ❌ not supported | — |
| `ST_SETSRID` | unknown | ❌ not supported | — |
| `ST_SIMPLIFY` | unknown | ❌ not supported | — |
| `ST_SRID` | unknown | ❌ not supported | — |
| `ST_STARTPOINT` | unknown | ❌ not supported | — |
| `ST_SYMDIFFERENCE` | unknown | ❌ not supported | — |
| `ST_TRANSFORM` | unknown | ❌ not supported | — |
| `ST_UNION` | unknown | ❌ not supported | — |
| `ST_UNION_AGG` | unknown | ❌ not supported | — |
| `ST_WITHIN` | unknown | ❌ not supported | — |
| `ST_X` | unknown | ❌ not supported | — |
| `ST_XMAX` | unknown | ❌ not supported | — |
| `ST_XMIN` | unknown | ❌ not supported | — |
| `ST_Y` | unknown | ❌ not supported | — |
| `ST_YMAX` | unknown | ❌ not supported | — |
| `ST_YMIN` | unknown | ❌ not supported | — |
| `TO_GEOGRAPHY` | scalar | ✅ supported | `(ANY) → GEOGRAPHY`<br>`(GEOMETRY) → GEOGRAPHY`<br>`(VARCHAR) → GEOGRAPHY`<br>`(VARIANT) → GEOGRAPHY` |
| `TO_GEOMETRY` | scalar | ✅ supported | `(ANY) → GEOMETRY`<br>`(GEOGRAPHY) → GEOMETRY`<br>`(VARCHAR) → GEOMETRY`<br>`(VARIANT) → GEOMETRY` |
| `TRY_TO_GEOGRAPHY` | scalar | ✅ supported | `(ANY) → GEOGRAPHY`<br>`(GEOMETRY) → GEOGRAPHY`<br>`(VARCHAR) → GEOGRAPHY`<br>`(VARIANT) → GEOGRAPHY` |
| `TRY_TO_GEOMETRY` | scalar | ✅ supported | `(ANY) → GEOMETRY`<br>`(GEOGRAPHY) → GEOMETRY`<br>`(VARCHAR) → GEOMETRY`<br>`(VARIANT) → GEOMETRY` |

### Hash functions (1)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `HASH` | scalar | ✅ supported | `(ANY) → NUMBER` |

### Information Schema (61)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `ALERT_HISTORY` | unknown | ✅ supported | — |
| `APPLICATION_CALLBACK_HISTORY` | unknown | ❌ not supported | — |
| `APPLICATION_SPECIFICATION_STATUS_HISTORY` | unknown | ❌ not supported | — |
| `AUTOMATIC_CLUSTERING_HISTORY` | unknown | ❌ not supported | — |
| `AUTO_REFRESH_REGISTRATION_HISTORY` | unknown | ❌ not supported | — |
| `AVAILABLE_LISTINGS` | unknown | ❌ not supported | — |
| `AVAILABLE_LISTING_REFRESH_HISTORY` | unknown | ❌ not supported | — |
| `BIND_VALUES` | unknown | ❌ not supported | — |
| `COMPLETE_TASK_GRAPHS` | unknown | ❌ not supported | — |
| `COPY_HISTORY` | unknown | ❌ not supported | — |
| `CORTEX_SEARCH_REFRESH_HISTORY` | unknown | ❌ not supported | — |
| `CURRENT_TASK_GRAPHS` | unknown | 🟡 partial | — |
| `DATABASE_REFRESH_HISTORY` | unknown | ❌ not supported | — |
| `DATABASE_REFRESH_PROGRESS` | unknown | ❌ not supported | — |
| `DATABASE_REFRESH_PROGRESS_BY_JOB` | unknown | ❌ not supported | — |
| `DATABASE_REPLICATION_USAGE_HISTORY` | unknown | ❌ not supported | — |
| `DATABASE_STORAGE_USAGE_HISTORY` | unknown | ❌ not supported | — |
| `DATA_METRIC_FUNCTION_EXPECTATIONS` | unknown | ❌ not supported | — |
| `DATA_METRIC_FUNCTION_REFERENCES` | unknown | ✅ supported | — |
| `DATA_TRANSFER_HISTORY` | unknown | ❌ not supported | — |
| `DBT_PROJECT_EXECUTION_HISTORY` | unknown | ❌ not supported | — |
| `DYNAMIC_TABLES` | unknown | ✅ supported | — |
| `DYNAMIC_TABLE_GRAPH_HISTORY` | unknown | ❌ not supported | — |
| `DYNAMIC_TABLE_REFRESH_HISTORY` | unknown | ❌ not supported | — |
| `EXTERNAL_FUNCTIONS_HISTORY` | unknown | ❌ not supported | — |
| `EXTERNAL_TABLE_FILES` | unknown | ✅ supported | — |
| `EXTERNAL_TABLE_FILE_REGISTRATION_HISTORY` | unknown | ❌ not supported | — |
| `LISTING_REFRESH_HISTORY` | unknown | ❌ not supported | — |
| `LOGIN_HISTORY` | unknown | ❌ not supported | — |
| `LOGIN_HISTORY_BY_USER` | unknown | ❌ not supported | — |
| `MATERIALIZED_VIEW_REFRESH_HISTORY` | unknown | ❌ not supported | — |
| `NETWORK_RULE_REFERENCES` | unknown | ❌ not supported | — |
| `NOTIFICATION_HISTORY` | unknown | ❌ not supported | — |
| `ONLINE_FEATURE_TABLE_REFRESH_HISTORY` | unknown | ❌ not supported | — |
| `PIPE_USAGE_HISTORY` | unknown | ✅ supported | — |
| `POLICY_REFERENCES` | unknown | ✅ supported | — |
| `QUERY_ACCELERATION_HISTORY` | unknown | ❌ not supported | — |
| `QUERY_HISTORY` | unknown | ✅ supported | — |
| `QUERY_HISTORY_BY_SESSION` | unknown | ✅ supported | — |
| `QUERY_HISTORY_BY_USER` | unknown | ✅ supported | — |
| `QUERY_HISTORY_BY_WAREHOUSE` | unknown | ❌ not supported | — |
| `REPLICATION_GROUP_DANGLING_REFERENCES` | unknown | ❌ not supported | — |
| `REPLICATION_GROUP_REFRESH_HISTORY` | unknown | ❌ not supported | — |
| `REPLICATION_GROUP_REFRESH_HISTORY_ALL` | unknown | ❌ not supported | — |
| `REPLICATION_GROUP_REFRESH_PROGRESS` | unknown | ❌ not supported | — |
| `REPLICATION_GROUP_REFRESH_PROGRESS_ALL` | unknown | ❌ not supported | — |
| `REPLICATION_GROUP_REFRESH_PROGRESS_BY_JOB` | unknown | ❌ not supported | — |
| `REPLICATION_GROUP_USAGE_HISTORY` | unknown | ❌ not supported | — |
| `REPLICATION_USAGE_HISTORY` | unknown | ❌ not supported | — |
| `SEARCH_OPTIMIZATION_HISTORY` | unknown | ❌ not supported | — |
| `SERVERLESS_ALERT_HISTORY` | unknown | ❌ not supported | — |
| `SERVERLESS_TASK_HISTORY` | unknown | ❌ not supported | — |
| `STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY` | unknown | ❌ not supported | — |
| `STAGE_STORAGE_USAGE_HISTORY` | unknown | ❌ not supported | — |
| `TAG_REFERENCES` | unknown | ✅ supported | — |
| `TAG_REFERENCES_ALL_COLUMNS` | unknown | ✅ supported | — |
| `TASK_DEPENDENTS` | unknown | ❌ not supported | — |
| `TASK_HISTORY` | unknown | ✅ supported | — |
| `VALIDATE_PIPE_LOAD` | table | ✅ supported | `(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → TABLE` |
| `WAREHOUSE_LOAD_HISTORY` | unknown | ❌ not supported | — |
| `WAREHOUSE_METERING_HISTORY` | unknown | ❌ not supported | — |

### LOCAL schema (2)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `DATA_QUALITY_MONITORING_EXPECTATION_STATUS` | unknown | ❌ not supported | — |
| `DATA_QUALITY_MONITORING_RESULTS` | unknown | ❌ not supported | — |

### Metadata functions (2)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `GENERATE_COLUMN_DESCRIPTION` | scalar | ✅ supported | `(ARRAY, VARCHAR) → VARCHAR` |
| `GET_DDL` | scalar | ✅ supported | `(VARCHAR, VARCHAR, BOOLEAN) → VARCHAR` |

### Model monitor functions (3)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `MODEL_MONITOR_DRIFT_METRIC` | unknown | ❌ not supported | — |
| `MODEL_MONITOR_PERFORMANCE_METRIC` | unknown | ❌ not supported | — |
| `MODEL_MONITOR_STAT_METRIC` | unknown | ❌ not supported | — |

### Notification functions (6)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `APPLICATION_JSON` | unknown | ✅ supported | — |
| `EMAIL_INTEGRATION_CONFIG` | unknown | ✅ supported | — |
| `INTEGRATION` | unknown | ✅ supported | — |
| `SANITIZE_WEBHOOK_CONTENT` | unknown | ✅ supported | — |
| `TEXT_HTML` | unknown | ✅ supported | — |
| `TEXT_PLAIN` | unknown | ✅ supported | — |

### Numeric functions (37)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `ABS` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → NUMBER` |
| `ACOS` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `ACOSH` | scalar | ✅ supported | `(FLOAT) → FLOAT` |
| `ASIN` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `ASINH` | scalar | ✅ supported | `(FLOAT) → FLOAT` |
| `ATAN` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `ATAN2` | scalar | ✅ supported | `(FLOAT, FLOAT) → FLOAT` |
| `ATANH` | scalar | ✅ supported | `(FLOAT) → FLOAT` |
| `CBRT` | scalar | ✅ supported | `(FLOAT) → FLOAT` |
| `CEIL` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → NUMBER`<br>`(ANY, ANY) → NUMBER`<br>`(DECFLOAT, NUMBER) → DECFLOAT`<br>`(FLOAT, NUMBER) → FLOAT`<br>`(NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, NUMBER) → NUMBER` |
| `COS` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `COSH` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `COT` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `DEGREES` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `DIV0` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(FLOAT, FLOAT) → FLOAT`<br>`(NUMBER, NUMBER) → NUMBER` |
| `DIV0NULL` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(FLOAT, FLOAT) → FLOAT`<br>`(NUMBER, NUMBER) → NUMBER` |
| `EXP` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT` |
| `FACTORIAL` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(FLOAT) → NUMBER`<br>`(NUMBER) → NUMBER` |
| `FLOOR` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → NUMBER`<br>`(ANY, ANY) → NUMBER`<br>`(DECFLOAT, NUMBER) → DECFLOAT`<br>`(FLOAT, NUMBER) → FLOAT`<br>`(NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, NUMBER) → NUMBER` |
| `LN` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT` |
| `LOG` | scalar | ✅ supported | `(FLOAT, FLOAT) → FLOAT` |
| `MOD` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(DECFLOAT, DECFLOAT) → DECFLOAT`<br>`(FLOAT, FLOAT) → FLOAT`<br>`(NUMBER, NUMBER) → NUMBER` |
| `PI` | scalar | ✅ supported | `() → FLOAT` |
| `POW` | scalar | ✅ supported | `(ANY, ANY) → FLOAT`<br>`(DECFLOAT, DECFLOAT) → DECFLOAT`<br>`(FLOAT, FLOAT) → FLOAT` |
| `POWER` | scalar | ✅ supported | `(ANY, ANY) → FLOAT`<br>`(DECFLOAT, DECFLOAT) → DECFLOAT`<br>`(FLOAT, FLOAT) → FLOAT` |
| `RADIANS` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `ROUND` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → NUMBER`<br>`(ANY, ANY) → NUMBER`<br>`(DECFLOAT, NUMBER) → DECFLOAT`<br>`(FLOAT, NUMBER) → FLOAT`<br>`(NUMBER, NUMBER) → NUMBER`<br>`(ANY, ANY, ANY) → NUMBER`<br>`(FLOAT, NUMBER, VARCHAR) → FLOAT`<br>`(NUMBER, NUMBER, VARCHAR) → NUMBER` |
| `SIGN` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → NUMBER` |
| `SIN` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `SINH` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `SQRT` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT` |
| `SQUARE` | scalar | ✅ supported | `(FLOAT) → FLOAT` |
| `TAN` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `TANH` | scalar | ✅ supported | `(ANY) → FLOAT`<br>`(DECFLOAT) → FLOAT`<br>`(FLOAT) → FLOAT` |
| `TRUNC` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → NUMBER`<br>`(ANY, ANY) → NUMBER`<br>`(DATE, VARCHAR) → DATE`<br>`(DECFLOAT, NUMBER) → DECFLOAT`<br>`(FLOAT, NUMBER) → FLOAT`<br>`(NUMBER, NUMBER) → NUMBER`<br>`(NUMBER, VARCHAR) → NUMBER`<br>`(TIME, VARCHAR) → TIME`<br>`(TIMESTAMP_LTZ, VARCHAR) → TIMESTAMP_LTZ`<br>`(TIMESTAMP_NTZ, VARCHAR) → TIMESTAMP_NTZ`<br>`(TIMESTAMP_TZ, VARCHAR) → TIMESTAMP_TZ`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `TRUNCATE` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(DECFLOAT) → DECFLOAT`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → NUMBER`<br>`(ANY, ANY) → NUMBER`<br>`(DATE, VARCHAR) → DATE`<br>`(DECFLOAT, NUMBER) → DECFLOAT`<br>`(FLOAT, NUMBER) → FLOAT`<br>`(NUMBER, NUMBER) → NUMBER`<br>`(NUMBER, VARCHAR) → NUMBER`<br>`(TIME, VARCHAR) → TIME`<br>`(TIMESTAMP_LTZ, VARCHAR) → TIMESTAMP_LTZ`<br>`(TIMESTAMP_NTZ, VARCHAR) → TIMESTAMP_NTZ`<br>`(TIMESTAMP_TZ, VARCHAR) → TIMESTAMP_TZ`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `WIDTH_BUCKET` | scalar | ✅ supported | `(ANY, ANY, ANY, ANY) → NUMBER`<br>`(FLOAT, FLOAT, FLOAT, NUMBER) → NUMBER`<br>`(NUMBER, NUMBER, NUMBER, NUMBER) → NUMBER` |

### Organization user and organization user group functions (2)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `IS_ORGANIZATION_USER` | unknown | ❌ not supported | — |
| `IS_ORGANIZATION_USER_GROUP` | unknown | ❌ not supported | — |

### Other functions (26)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `APPROX_QUANTILE_25` | unknown | ✅ supported | — |
| `APPROX_QUANTILE_50` | unknown | ✅ supported | — |
| `APPROX_QUANTILE_99` | unknown | ✅ supported | — |
| `CASE_FORMAT_VIOLATION_COUNT` | unknown | ✅ supported | — |
| `CASE_FORMAT_VIOLATION_PERCENT` | unknown | ✅ supported | — |
| `FUTURE_TIMESTAMP_COUNT` | unknown | ✅ supported | — |
| `FUTURE_TIMESTAMP_PERCENT` | unknown | ✅ supported | — |
| `GENERATE_POSTGRES_ACCESS_TOKEN_FOR_USER` | unknown | ❌ not supported | — |
| `INVALID_JSON_COUNT` | unknown | ✅ supported | — |
| `INVALID_JSON_PERCENT` | unknown | ✅ supported | — |
| `INVALID_NUMERIC_TYPE_CAST_COUNT` | unknown | ✅ supported | — |
| `INVALID_NUMERIC_TYPE_CAST_PERCENT` | unknown | ✅ supported | — |
| `NEGATIVE_COUNT` | unknown | ✅ supported | — |
| `NEGATIVE_PERCENT` | unknown | ✅ supported | — |
| `REFERENTIAL_INTEGRITY_COUNT` | unknown | ✅ supported | — |
| `SCHEMA_CHANGE_COUNT` | unknown | ✅ supported | — |
| `SPECIAL_CHARACTER_COUNT` | unknown | ✅ supported | — |
| `SPECIAL_CHARACTER_PERCENT` | unknown | ✅ supported | — |
| `STRING_LENGTH_AVG` | unknown | ✅ supported | — |
| `STRING_LENGTH_MAX` | unknown | ✅ supported | — |
| `STRING_LENGTH_MIN` | unknown | ✅ supported | — |
| `UNTRIMMED_STRING_COUNT` | unknown | ✅ supported | — |
| `UNTRIMMED_STRING_PERCENT` | unknown | ✅ supported | — |
| `WEBHOOK_INTEGRATION_CONFIG` | unknown | ✅ supported | — |
| `ZERO_COUNT` | unknown | ✅ supported | — |
| `ZERO_PERCENT` | unknown | ✅ supported | — |

### Semi-structured and structured data functions (92)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `ARRAYS_OVERLAP` | scalar | ✅ supported | `(ARRAY, ARRAY) → BOOLEAN` |
| `ARRAYS_TO_OBJECT` | scalar | ✅ supported | `(ARRAY, ARRAY) → OBJECT` |
| `ARRAYS_ZIP` | scalar | ✅ supported | `(ANY) → ARRAY` |
| `ARRAY_APPEND` | scalar | ✅ supported | `(ARRAY, ANY) → ARRAY` |
| `ARRAY_CAT` | scalar | ✅ supported | `(ARRAY, ARRAY) → ARRAY` |
| `ARRAY_COMPACT` | scalar | ✅ supported | `(ARRAY) → ARRAY` |
| `ARRAY_CONSTRUCT` | scalar | ✅ supported | `() → ARRAY`<br>`(ANY) → ARRAY`<br>`(SNOWFLAKE_ANY[]) → ARRAY`<br>`(SNOWFLAKE_NULL[]) → ARRAY` |
| `ARRAY_CONSTRUCT_COMPACT` | scalar | ✅ supported | `() → ARRAY`<br>`(ANY) → ARRAY`<br>`(SNOWFLAKE_ANY[]) → ARRAY`<br>`(SNOWFLAKE_NULL[]) → ARRAY` |
| `ARRAY_CONSTRUCT_STRUCTURED` | scalar | ✅ supported | `(ANY) → ARRAY` |
| `ARRAY_CONTAINS` | scalar | ✅ supported | `(ANY, ARRAY) → BOOLEAN` |
| `ARRAY_DISTINCT` | scalar | ✅ supported | `(ARRAY) → ARRAY` |
| `ARRAY_EXCEPT` | scalar | ✅ supported | `(ARRAY, ARRAY) → ARRAY` |
| `ARRAY_FLATTEN` | scalar | ✅ supported | `(ARRAY) → ARRAY` |
| `ARRAY_GENERATE_RANGE` | scalar | ✅ supported | `(ANY, ANY) → ARRAY`<br>`(NUMBER, NUMBER) → ARRAY`<br>`(NUMBER, NUMBER, NUMBER) → ARRAY` |
| `ARRAY_INSERT` | scalar | ✅ supported | `(ARRAY, NUMBER, ANY) → ARRAY` |
| `ARRAY_INTERSECTION` | scalar | ✅ supported | `(ARRAY, ARRAY) → ARRAY` |
| `ARRAY_MAX` | scalar | ✅ supported | `(ARRAY) → VARIANT` |
| `ARRAY_MIN` | scalar | ✅ supported | `(ARRAY) → VARIANT` |
| `ARRAY_POSITION` | scalar | ✅ supported | `(ANY, ARRAY) → NUMBER` |
| `ARRAY_PREPEND` | scalar | ✅ supported | `(ARRAY, ANY) → ARRAY` |
| `ARRAY_REMOVE` | scalar | ✅ supported | `(ARRAY, ANY) → ARRAY` |
| `ARRAY_REMOVE_AT` | scalar | ✅ supported | `(ARRAY, NUMBER) → ARRAY` |
| `ARRAY_REVERSE` | scalar | ✅ supported | `(ARRAY) → ARRAY` |
| `ARRAY_SIZE` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(ARRAY) → NUMBER`<br>`(VARIANT) → NUMBER` |
| `ARRAY_SLICE` | scalar | ✅ supported | `(ANY, ANY, ANY) → ARRAY`<br>`(ARRAY, NUMBER, NUMBER) → ARRAY`<br>`(ARRAY, NUMBER, VARCHAR) → ARRAY`<br>`(ARRAY, VARCHAR, NUMBER) → ARRAY`<br>`(ARRAY, VARCHAR, VARCHAR) → ARRAY` |
| `ARRAY_SORT` | scalar | ✅ supported | `(ANY) → ARRAY`<br>`(ARRAY) → ARRAY`<br>`(ARRAY, BOOLEAN) → ARRAY`<br>`(ARRAY, BOOLEAN, BOOLEAN) → ARRAY` |
| `ARRAY_TO_STRING` | scalar | ✅ supported | `(ARRAY, VARCHAR) → VARCHAR` |
| `AS_ARRAY` | scalar | ✅ supported | `(VARIANT) → ARRAY` |
| `AS_BINARY` | scalar | ✅ supported | `(VARIANT) → BINARY` |
| `AS_BOOLEAN` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `AS_CHAR` | scalar | ✅ supported | `(VARIANT) → VARCHAR` |
| `AS_DATE` | scalar | ✅ supported | `(VARIANT) → DATE` |
| `AS_DECIMAL` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(VARIANT) → NUMBER`<br>`(VARIANT, NUMBER, NUMBER) → NUMBER` |
| `AS_DOUBLE` | scalar | ✅ supported | `(VARIANT) → FLOAT` |
| `AS_INTEGER` | scalar | ✅ supported | `(VARIANT) → NUMBER` |
| `AS_NUMBER` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(VARIANT) → NUMBER`<br>`(VARIANT, NUMBER, NUMBER) → NUMBER` |
| `AS_OBJECT` | scalar | ✅ supported | `(VARIANT) → OBJECT` |
| `AS_REAL` | scalar | ✅ supported | `(VARIANT) → FLOAT` |
| `AS_TIME` | scalar | ✅ supported | `(VARIANT) → TIME` |
| `AS_TIMESTAMP_LTZ` | scalar | ✅ supported | `(VARIANT) → TIMESTAMP_LTZ` |
| `AS_TIMESTAMP_NTZ` | scalar | ✅ supported | `(VARIANT) → TIMESTAMP_NTZ` |
| `AS_TIMESTAMP_TZ` | scalar | ✅ supported | `(VARIANT) → TIMESTAMP_TZ` |
| `AS_VARCHAR` | scalar | ✅ supported | `(VARIANT) → VARCHAR` |
| `CHECK_JSON` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `CHECK_XML` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `FILTER` | unknown | ✅ supported | — |
| `GET` | scalar | ✅ supported | `(ANY, ANY) → VARIANT`<br>`(ARRAY, NUMBER) → VARIANT`<br>`(ARRAY, VARCHAR) → VARIANT`<br>`(OBJECT, NUMBER) → VARIANT`<br>`(OBJECT, VARCHAR) → VARIANT`<br>`(VARIANT, NUMBER) → VARIANT`<br>`(VARIANT, VARCHAR) → VARIANT` |
| `GET_IGNORE_CASE` | scalar | ✅ supported | `(ANY, ANY) → VARIANT`<br>`(OBJECT, VARCHAR) → VARIANT`<br>`(VARIANT, VARCHAR) → VARIANT` |
| `GET_PATH` | scalar | ✅ supported | `(VARIANT, VARCHAR) → VARIANT` |
| `IS_ARRAY` | scalar | ✅ supported | `(ANY) → BOOLEAN`<br>`(ARRAY) → BOOLEAN`<br>`(OBJECT) → BOOLEAN`<br>`(VARIANT) → BOOLEAN` |
| `IS_BINARY` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_BOOLEAN` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_CHAR` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_DATE` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_DATE_VALUE` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_DECIMAL` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_DOUBLE` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_INTEGER` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_NULL_VALUE` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_OBJECT` | scalar | ✅ supported | `(ANY) → BOOLEAN`<br>`(ARRAY) → BOOLEAN`<br>`(OBJECT) → BOOLEAN`<br>`(VARIANT) → BOOLEAN` |
| `IS_REAL` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_TIME` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_TIMESTAMP_LTZ` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_TIMESTAMP_NTZ` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_TIMESTAMP_TZ` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `IS_VARCHAR` | scalar | ✅ supported | `(VARIANT) → BOOLEAN` |
| `JSON_EXTRACT_PATH_TEXT` | scalar | ✅ supported | `(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `MAP_CAT` | scalar | ✅ supported | `(OBJECT, OBJECT) → OBJECT` |
| `MAP_CONSTRUCT` | scalar | ✅ supported | `(ANY) → MAP` |
| `MAP_CONTAINS_KEY` | scalar | ✅ supported | `(VARCHAR, OBJECT) → BOOLEAN` |
| `MAP_DELETE` | scalar | ✅ supported | `(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT` |
| `MAP_ENTRIES` | scalar | ✅ supported | `(ANY) → ARRAY`<br>`(MAP) → ARRAY`<br>`(OBJECT) → ARRAY` |
| `MAP_INSERT` | scalar | ✅ supported | `(ANY, ANY, ANY) → OBJECT`<br>`(OBJECT, VARCHAR, ANY) → OBJECT`<br>`(ANY, ANY, ANY, ANY) → OBJECT`<br>`(OBJECT, VARCHAR, ANY, BOOLEAN) → OBJECT` |
| `MAP_KEYS` | scalar | ✅ supported | `(OBJECT) → ARRAY` |
| `MAP_PICK` | scalar | ✅ supported | `(ANY, ANY) → OBJECT`<br>`(OBJECT, ARRAY) → OBJECT`<br>`(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT` |
| `MAP_SIZE` | scalar | ✅ supported | `(OBJECT) → NUMBER` |
| `OBJECT_CONSTRUCT` | scalar | ✅ supported | `() → OBJECT`<br>`(ANY) → OBJECT`<br>`(SNOWFLAKE_ANY[]) → OBJECT`<br>`(SNOWFLAKE_NULL[]) → OBJECT` |
| `OBJECT_CONSTRUCT_KEEP_NULL` | scalar | ✅ supported | `() → OBJECT`<br>`(ANY) → OBJECT`<br>`(SNOWFLAKE_ANY[]) → OBJECT`<br>`(SNOWFLAKE_NULL[]) → OBJECT` |
| `OBJECT_CONSTRUCT_KEEP_NULL_STRUCTURED` | scalar | ✅ supported | `(ANY) → OBJECT` |
| `OBJECT_DELETE` | scalar | ✅ supported | `(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT` |
| `OBJECT_INSERT` | scalar | ✅ supported | `(ANY, ANY, ANY) → OBJECT`<br>`(OBJECT, VARCHAR, ANY) → OBJECT`<br>`(ANY, ANY, ANY, ANY) → OBJECT`<br>`(OBJECT, VARCHAR, ANY, BOOLEAN) → OBJECT` |
| `OBJECT_KEYS` | scalar | ✅ supported | `(ANY) → ARRAY`<br>`(OBJECT) → ARRAY`<br>`(VARIANT) → ARRAY` |
| `OBJECT_PICK` | scalar | ✅ supported | `(ANY, ANY) → OBJECT`<br>`(OBJECT, ARRAY) → OBJECT`<br>`(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT` |
| `PARSE_JSON` | scalar | ✅ supported | `(ANY) → VARIANT`<br>`(VARCHAR) → VARIANT`<br>`(VARCHAR, VARCHAR) → VARIANT` |
| `PARSE_XML` | scalar | ✅ supported | `(VARCHAR) → VARIANT` |
| `PROMPT` | unknown | ❌ not supported | — |
| `REDUCE` | unknown | ✅ supported | — |
| `STRIP_NULL_VALUE` | scalar | ✅ supported | `(VARIANT) → VARIANT` |
| `TRANSFORM` | unknown | ✅ supported | — |
| `TRY_PARSE_JSON` | scalar | ✅ supported | `(ANY) → VARIANT`<br>`(VARCHAR) → VARIANT`<br>`(VARCHAR, VARCHAR) → VARIANT` |
| `TYPEOF` | scalar | ✅ supported | `(VARIANT) → VARCHAR` |
| `XMLGET` | scalar | ✅ supported | `(ANY, ANY) → VARIANT`<br>`(VARIANT, VARCHAR) → VARIANT`<br>`(ANY, ANY, ANY) → VARIANT`<br>`(VARIANT, VARCHAR, NUMBER) → VARIANT` |

### String & binary functions (103)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `AGENT_RUN` | unknown | ❌ not supported | — |
| `AI_CLASSIFY` | unknown | ❌ not supported | — |
| `AI_COMPLETE` | unknown | ❌ not supported | — |
| `AI_COUNT_TOKENS` | unknown | ❌ not supported | — |
| `AI_EMBED` | unknown | ❌ not supported | — |
| `AI_EXTRACT` | unknown | ❌ not supported | — |
| `AI_FILTER` | unknown | ❌ not supported | — |
| `AI_MULTI_EMBED` | unknown | ❌ not supported | — |
| `AI_PARSE_DOCUMENT` | unknown | ❌ not supported | — |
| `AI_REDACT` | unknown | ❌ not supported | — |
| `AI_SENTIMENT` | unknown | ❌ not supported | — |
| `AI_SIMILARITY` | unknown | ❌ not supported | — |
| `AI_TRANSLATE` | unknown | ❌ not supported | — |
| `ASCII` | scalar | ✅ supported | `(VARCHAR) → NUMBER` |
| `BASE64_DECODE_BINARY` | scalar | ✅ supported | `(ANY) → BINARY`<br>`(VARCHAR) → BINARY`<br>`(VARCHAR, VARCHAR) → BINARY` |
| `BASE64_DECODE_STRING` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `BASE64_ENCODE` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER) → VARCHAR`<br>`(VARCHAR, NUMBER) → VARCHAR`<br>`(ANY, NUMBER, VARCHAR) → VARCHAR`<br>`(BINARY, NUMBER, VARCHAR) → VARCHAR`<br>`(VARCHAR, NUMBER, VARCHAR) → VARCHAR` |
| `BIT_LENGTH` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BINARY) → NUMBER`<br>`(VARCHAR) → NUMBER` |
| `CHAR` | scalar | ✅ supported | `(NUMBER) → VARCHAR` |
| `CHARINDEX` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(BINARY, BINARY) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(ANY, ANY, NUMBER) → NUMBER`<br>`(BINARY, BINARY, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER` |
| `CHR` | scalar | ✅ supported | `(NUMBER) → VARCHAR` |
| `CLASSIFY_TEXT` | unknown | ❌ not supported | — |
| `COLLATE` | syntax | ✅ supported | — |
| `COLLATION` | unknown | ❌ not supported | — |
| `COMPLETE` | unknown | ❌ not supported | — |
| `COMPRESS` | scalar | ✅ supported | `(ANY, VARCHAR) → BINARY`<br>`(BINARY, VARCHAR) → BINARY`<br>`(VARCHAR, VARCHAR) → BINARY` |
| `CONCAT` | scalar | ✅ supported | `(SNOWFLAKE_ANY[]) → VARCHAR`<br>`(SNOWFLAKE_BINARY[]) → BINARY`<br>`(SNOWFLAKE_NULL[]) → VARCHAR`<br>`(SNOWFLAKE_VARCHAR[]) → VARCHAR` |
| `CONCAT_WS` | scalar | ✅ supported | `(BINARY) → BINARY`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, SNOWFLAKE_ANY[]) → VARCHAR`<br>`(BINARY, SNOWFLAKE_BINARY[]) → BINARY`<br>`(VARCHAR, SNOWFLAKE_VARCHAR[]) → VARCHAR` |
| `CONTAINS` | scalar | ✅ supported | `(ANY, ANY) → BOOLEAN`<br>`(BINARY, BINARY) → BOOLEAN`<br>`(VARCHAR, VARCHAR) → BOOLEAN` |
| `COUNT_TOKENS` | unknown | ❌ not supported | — |
| `DATA_AGENT_RUN` | unknown | ❌ not supported | — |
| `DECOMPRESS_BINARY` | scalar | ✅ supported | `(BINARY, VARCHAR) → BINARY` |
| `DECOMPRESS_STRING` | scalar | ✅ supported | `(BINARY, VARCHAR) → VARCHAR` |
| `EDITDISTANCE` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(ANY, ANY, ANY) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER` |
| `EMBED_TEXT_1024` | unknown | ❌ not supported | — |
| `EMBED_TEXT_768` | unknown | ❌ not supported | — |
| `ENDSWITH` | scalar | ✅ supported | `(ANY, ANY) → BOOLEAN`<br>`(BINARY, BINARY) → BOOLEAN`<br>`(BINARY, VARCHAR) → BOOLEAN`<br>`(VARCHAR, BINARY) → BOOLEAN`<br>`(VARCHAR, VARCHAR) → BOOLEAN` |
| `ENTITY_SENTIMENT` | unknown | ❌ not supported | — |
| `EXTRACT_ANSWER` | unknown | ❌ not supported | — |
| `FINETUNE` | unknown | ❌ not supported | — |
| `HEX_DECODE_BINARY` | scalar | ✅ supported | `(VARCHAR) → BINARY` |
| `HEX_DECODE_STRING` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `HEX_ENCODE` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER) → VARCHAR`<br>`(VARCHAR, NUMBER) → VARCHAR` |
| `INITCAP` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `INSERT` | scalar | ✅ supported | `(VARCHAR, NUMBER, NUMBER, VARCHAR) → VARCHAR` |
| `JAROWINKLER_SIMILARITY` | scalar | ✅ supported | `(VARCHAR, VARCHAR) → NUMBER` |
| `LEFT` | scalar | ✅ supported | `(ANY, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER) → BINARY`<br>`(VARCHAR, NUMBER) → VARCHAR` |
| `LEN` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BINARY) → NUMBER`<br>`(VARCHAR) → NUMBER` |
| `LENGTH` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BINARY) → NUMBER`<br>`(VARCHAR) → NUMBER` |
| `LOWER` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `LPAD` | scalar | ✅ supported | `(ANY, ANY) → VARCHAR`<br>`(BINARY, NUMBER) → BINARY`<br>`(VARCHAR, NUMBER) → VARCHAR`<br>`(ANY, ANY, ANY) → VARCHAR`<br>`(BINARY, NUMBER, BINARY) → BINARY`<br>`(VARCHAR, NUMBER, VARCHAR) → VARCHAR` |
| `LTRIM` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `MD5` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(VARCHAR) → VARCHAR` |
| `MD5_BINARY` | scalar | ✅ supported | `(ANY) → BINARY`<br>`(BINARY) → BINARY`<br>`(VARCHAR) → BINARY` |
| `MD5_HEX` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(VARCHAR) → VARCHAR` |
| `MD5_NUMBER_LOWER64` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BINARY) → NUMBER`<br>`(VARCHAR) → NUMBER` |
| `MD5_NUMBER_UPPER64` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BINARY) → NUMBER`<br>`(VARCHAR) → NUMBER` |
| `OCTET_LENGTH` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BINARY) → NUMBER`<br>`(VARCHAR) → NUMBER` |
| `PARSE_IP` | scalar | ✅ supported | `(VARCHAR, VARCHAR) → OBJECT` |
| `PARSE_URL` | scalar | ✅ supported | `(ANY) → OBJECT`<br>`(BINARY) → OBJECT`<br>`(VARCHAR) → OBJECT`<br>`(ANY, ANY) → OBJECT`<br>`(VARCHAR, BOOLEAN) → OBJECT`<br>`(VARCHAR, NUMBER) → OBJECT`<br>`(VARCHAR, VARCHAR) → OBJECT`<br>`(VARCHAR, VARIANT) → OBJECT` |
| `POSITION` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(BINARY, BINARY) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(ANY, ANY, NUMBER) → NUMBER`<br>`(BINARY, BINARY, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER` |
| `REPEAT` | scalar | ✅ supported | `(ANY, ANY) → VARCHAR`<br>`(VARCHAR, ANY) → VARCHAR`<br>`(VARCHAR, NUMBER) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `REPLACE` | scalar | ✅ supported | `(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR`<br>`(ANY, ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR, VARCHAR) → VARCHAR` |
| `REVERSE` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → BINARY`<br>`(VARCHAR) → VARCHAR` |
| `RIGHT` | scalar | ✅ supported | `(ANY, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER) → BINARY`<br>`(VARCHAR, NUMBER) → VARCHAR` |
| `RPAD` | scalar | ✅ supported | `(ANY, ANY) → VARCHAR`<br>`(BINARY, NUMBER) → BINARY`<br>`(VARCHAR, NUMBER) → VARCHAR`<br>`(ANY, ANY, ANY) → VARCHAR`<br>`(BINARY, NUMBER, BINARY) → BINARY`<br>`(VARCHAR, NUMBER, VARCHAR) → VARCHAR` |
| `RTRIM` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `RTRIMMED_LENGTH` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(BINARY) → NUMBER`<br>`(VARCHAR) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER` |
| `SEARCH` | unknown | ❌ not supported | — |
| `SEARCH_IP` | unknown | ❌ not supported | — |
| `SEARCH_PREVIEW` | unknown | ❌ not supported | — |
| `SENTIMENT` | unknown | ❌ not supported | — |
| `SHA1` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `SHA1_BINARY` | scalar | ✅ supported | `(VARCHAR) → BINARY` |
| `SHA1_HEX` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `SHA2` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER) → VARCHAR`<br>`(VARCHAR, NUMBER) → VARCHAR` |
| `SHA2_BINARY` | scalar | ✅ supported | `(ANY) → BINARY`<br>`(BINARY) → BINARY`<br>`(VARCHAR) → BINARY`<br>`(ANY, NUMBER) → BINARY`<br>`(BINARY, NUMBER) → BINARY`<br>`(VARCHAR, NUMBER) → BINARY` |
| `SHA2_HEX` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER) → VARCHAR`<br>`(VARCHAR, NUMBER) → VARCHAR` |
| `SOUNDEX` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `SOUNDEX_P123` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `SPACE` | scalar | ✅ supported | `(NUMBER) → VARCHAR` |
| `SPLIT` | scalar | ✅ supported | `(VARCHAR, VARCHAR) → ARRAY` |
| `SPLIT_PART` | scalar | ✅ supported | `(VARCHAR, VARCHAR, NUMBER) → VARCHAR` |
| `SPLIT_TEXT_MARKDOWN_HEADER` | unknown | ❌ not supported | — |
| `SPLIT_TEXT_RECURSIVE_CHARACTER` | unknown | ❌ not supported | — |
| `SPLIT_TO_TABLE` | table | ✅ supported | `(VARCHAR, VARCHAR) → TABLE` |
| `STARTSWITH` | scalar | ✅ supported | `(ANY, ANY) → BOOLEAN`<br>`(BINARY, BINARY) → BOOLEAN`<br>`(BINARY, VARCHAR) → BOOLEAN`<br>`(VARCHAR, BINARY) → BOOLEAN`<br>`(VARCHAR, VARCHAR) → BOOLEAN` |
| `STRTOK` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR`<br>`(ANY, ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR, NUMBER) → VARCHAR` |
| `STRTOK_SPLIT_TO_TABLE` | table | ✅ supported | `(VARCHAR, VARCHAR) → TABLE` |
| `STRTOK_TO_ARRAY` | scalar | ✅ supported | `(ANY) → ARRAY`<br>`(VARCHAR) → ARRAY`<br>`(ANY, ANY) → ARRAY`<br>`(VARCHAR, VARCHAR) → ARRAY` |
| `SUBSTR` | scalar | ✅ supported | `(ANY, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER) → BINARY`<br>`(VARCHAR, NUMBER) → VARCHAR`<br>`(ANY, NUMBER, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER, NUMBER) → BINARY`<br>`(VARCHAR, NUMBER, NUMBER) → VARCHAR` |
| `SUBSTRING` | scalar | ✅ supported | `(ANY, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER) → BINARY`<br>`(VARCHAR, NUMBER) → VARCHAR`<br>`(ANY, NUMBER, NUMBER) → VARCHAR`<br>`(BINARY, NUMBER, NUMBER) → BINARY`<br>`(VARCHAR, NUMBER, NUMBER) → VARCHAR` |
| `SUMMARIZE` | unknown | ❌ not supported | — |
| `TRANSLATE` | scalar | ✅ supported | `(VARCHAR, VARCHAR, VARCHAR) → VARCHAR` |
| `TRIM` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `TRY_BASE64_DECODE_BINARY` | scalar | ✅ supported | `(ANY) → BINARY`<br>`(VARCHAR) → BINARY`<br>`(VARCHAR, VARCHAR) → BINARY` |
| `TRY_BASE64_DECODE_STRING` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |
| `TRY_COMPLETE` | unknown | ❌ not supported | — |
| `TRY_HEX_DECODE_BINARY` | scalar | ✅ supported | `(VARCHAR) → BINARY` |
| `TRY_HEX_DECODE_STRING` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `UNICODE` | scalar | ✅ supported | `(VARCHAR) → NUMBER` |
| `UPPER` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `UUID_STRING` | scalar | ✅ supported | `() → VARCHAR`<br>`(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |

### String functions (regular expressions) (8)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `REGEXP` | syntax | ✅ supported | — |
| `REGEXP_COUNT` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, VARCHAR) → NUMBER` |
| `REGEXP_INSTR` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(VARCHAR, VARCHAR) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER, NUMBER, VARCHAR) → NUMBER`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER, NUMBER, VARCHAR, NUMBER) → NUMBER` |
| `REGEXP_LIKE` | scalar | ✅ supported | `(ANY, ANY) → BOOLEAN`<br>`(VARCHAR, VARCHAR) → BOOLEAN`<br>`(VARCHAR, VARCHAR, VARCHAR) → BOOLEAN` |
| `REGEXP_REPLACE` | scalar | ✅ supported | `(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR`<br>`(VARCHAR, VARCHAR, VARCHAR) → VARCHAR`<br>`(VARCHAR, VARCHAR, VARCHAR, NUMBER) → VARCHAR`<br>`(VARCHAR, VARCHAR, VARCHAR, NUMBER, NUMBER) → VARCHAR`<br>`(VARCHAR, VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR) → VARCHAR` |
| `REGEXP_SUBSTR` | scalar | ✅ supported | `(ANY, ANY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR`<br>`(VARCHAR, VARCHAR, NUMBER) → VARCHAR`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER) → VARCHAR`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR) → VARCHAR`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR, NUMBER) → VARCHAR` |
| `REGEXP_SUBSTR_ALL` | scalar | ✅ supported | `(ANY, ANY) → ARRAY`<br>`(VARCHAR, VARCHAR) → ARRAY`<br>`(VARCHAR, VARCHAR, NUMBER) → ARRAY`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER) → ARRAY`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR) → ARRAY`<br>`(VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR, NUMBER) → ARRAY` |
| `RLIKE` | scalar | ✅ supported | `(ANY, ANY) → BOOLEAN`<br>`(VARCHAR, VARCHAR) → BOOLEAN`<br>`(VARCHAR, VARCHAR, VARCHAR) → BOOLEAN` |

### System functions (209)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `EXECUTE_AI_EVALUATION` | unknown | ❌ not supported | — |
| `EXPLAIN_JSON` | unknown | ❌ not supported | — |
| `EXTRACT_SEMANTIC_CATEGORIES` | unknown | ❌ not supported | — |
| `GET_ANACONDA_PACKAGES_REPODATA` | unknown | ❌ not supported | — |
| `GET_PYTHON_PROFILER_OUTPUT` | unknown | ❌ not supported | — |
| `GET_QUERY_OPERATOR_STATS` | unknown | ❌ not supported | — |
| `SHOW_PYTHON_PACKAGES_DEPENDENCIES` | unknown | ❌ not supported | — |
| `SYSTEM$ABORT_SESSION` | unknown | ❌ not supported | — |
| `SYSTEM$ABORT_TRANSACTION` | unknown | ❌ not supported | — |
| `SYSTEM$ACTIVATE_CMK_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$ACTIVATE_CMK_INFO_POSTGRES` | unknown | ❌ not supported | — |
| `SYSTEM$ADD_EVENT` | unknown | ❌ not supported | — |
| `SYSTEM$ADD_REFERENCE` | unknown | ❌ not supported | — |
| `SYSTEM$ALLOWLIST` | scalar | ✅ supported | `() → VARCHAR` |
| `SYSTEM$ALLOWLIST_PRIVATELINK` | unknown | ❌ not supported | — |
| `SYSTEM$APPLICATION_GET_LOG_LEVEL` | unknown | ❌ not supported | — |
| `SYSTEM$APPLICATION_GET_METRIC_LEVEL` | unknown | ❌ not supported | — |
| `SYSTEM$APPLICATION_GET_TRACE_LEVEL` | unknown | ❌ not supported | — |
| `SYSTEM$APP_COMPATIBILITY_CHECK` | unknown | ❌ not supported | — |
| `SYSTEM$AUTHORIZE_PRIVATELINK` | unknown | ❌ not supported | — |
| `SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS` | unknown | ❌ not supported | — |
| `SYSTEM$AUTO_REFRESH_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$BEGIN_DEBUG_APPLICATION` | unknown | ❌ not supported | — |
| `SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS` | unknown | ❌ not supported | — |
| `SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS_WITH_EXCEPTION` | unknown | ❌ not supported | — |
| `SYSTEM$CANCEL_ALL_QUERIES` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(NUMBER) → VARCHAR`<br>`(VARCHAR) → VARCHAR` |
| `SYSTEM$CANCEL_QUERY` | unknown | ✅ supported | — |
| `SYSTEM$CATALOG_LINK_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$CKE_HASH_FUNCTION` | unknown | ❌ not supported | — |
| `SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS` | unknown | ❌ not supported | — |
| `SYSTEM$CLIENT_VERSION_INFO` | scalar | ✅ supported | `() → VARCHAR` |
| `SYSTEM$CLIENT_VULNERABILITY_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$CLUSTERING_DEPTH` | unknown | ❌ not supported | — |
| `SYSTEM$CLUSTERING_INFORMATION` | unknown | ❌ not supported | — |
| `SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT` | unknown | ❌ not supported | — |
| `SYSTEM$CONVERT_PIPES_SQS_TO_SNS` | unknown | ❌ not supported | — |
| `SYSTEM$CREATE_BILLING_EVENT` | unknown | ❌ not supported | — |
| `SYSTEM$CREATE_BILLING_EVENTS` | unknown | ❌ not supported | — |
| `SYSTEM$CURRENT_USER_TASK_NAME` | unknown | ❌ not supported | — |
| `SYSTEM$DATA_METRIC_SCAN` | unknown | ✅ supported | — |
| `SYSTEM$DEACTIVATE_CMK_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$DECODE_PAT` | unknown | ❌ not supported | — |
| `SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT` | unknown | ❌ not supported | — |
| `SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT_TSS` | unknown | ❌ not supported | — |
| `SYSTEM$DEREGISTER_CMK_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$DEREGISTER_CMK_INFO_POSTGRES` | unknown | ❌ not supported | — |
| `SYSTEM$DESC_ICEBERG_ACCESS_IDENTITY` | unknown | ❌ not supported | — |
| `SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE` | unknown | ❌ not supported | — |
| `SYSTEM$DISABLE_DATABASE_REPLICATION` | unknown | ❌ not supported | — |
| `SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT` | unknown | ❌ not supported | — |
| `SYSTEM$DISABLE_PREVIEW_ACCESS` | unknown | ❌ not supported | — |
| `SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLY` | unknown | ❌ not supported | — |
| `SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE` | unknown | ❌ not supported | — |
| `SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT` | unknown | ❌ not supported | — |
| `SYSTEM$ENABLE_PREVIEW_ACCESS` | unknown | ❌ not supported | — |
| `SYSTEM$ENCODE_CKE_PRIMARY_KEY` | unknown | ❌ not supported | — |
| `SYSTEM$END_DEBUG_APPLICATION` | unknown | ❌ not supported | — |
| `SYSTEM$ENFORCE_PRIVATELINK_ACCESS_ONLY` | unknown | ❌ not supported | — |
| `SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS` | unknown | ❌ not supported | — |
| `SYSTEM$ESTIMATE_QUERY_ACCELERATION` | unknown | ❌ not supported | — |
| `SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS` | unknown | ❌ not supported | — |
| `SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS` | unknown | ✅ supported | — |
| `SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS_PERSIST_RESULT` | unknown | ✅ supported | — |
| `SYSTEM$EXPLAIN_JSON_TO_TEXT` | unknown | ❌ not supported | — |
| `SYSTEM$EXPLAIN_PLAN_JSON` | unknown | ❌ not supported | — |
| `SYSTEM$EXPORT_TDS_FROM_SEMANTIC_VIEW` | unknown | ❌ not supported | — |
| `SYSTEM$EXTERNAL_TABLE_PIPE_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$FINISH_OAUTH_FLOW` | unknown | ❌ not supported | — |
| `SYSTEM$GENERATE_SAML_CSR` | unknown | ❌ not supported | — |
| `SYSTEM$GENERATE_SCIM_ACCESS_TOKEN` | unknown | ❌ not supported | — |
| `SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDES` | unknown | ❌ not supported | — |
| `SYSTEM$GET_ALL_REFERENCES` | unknown | ❌ not supported | — |
| `SYSTEM$GET_AWS_SNS_IAM_POLICY` | unknown | ❌ not supported | — |
| `SYSTEM$GET_CATALOG_LINKED_DATABASE_CONFIG` | unknown | ❌ not supported | — |
| `SYSTEM$GET_CLASSIFICATION_RESULT` | unknown | ❌ not supported | — |
| `SYSTEM$GET_CMK_AKV_CONSENT_URL` | unknown | ❌ not supported | — |
| `SYSTEM$GET_CMK_CONFIG` | unknown | ❌ not supported | — |
| `SYSTEM$GET_CMK_CONFIG_POSTGRES` | unknown | ❌ not supported | — |
| `SYSTEM$GET_CMK_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$GET_CMK_INFO_POSTGRES` | unknown | ❌ not supported | — |
| `SYSTEM$GET_CMK_KMS_KEY_POLICY` | unknown | ❌ not supported | — |
| `SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCE` | unknown | ❌ not supported | — |
| `SYSTEM$GET_DBT_LOG` | unknown | ❌ not supported | — |
| `SYSTEM$GET_DEBUG_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND` | unknown | ❌ not supported | — |
| `SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT` | unknown | ❌ not supported | — |
| `SYSTEM$GET_DIRECTORY_TABLE_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMD` | unknown | ❌ not supported | — |
| `SYSTEM$GET_HASH_FOR_APPLICATION` | unknown | ❌ not supported | — |
| `SYSTEM$GET_ICEBERG_TABLE_INFORMATION` | unknown | ❌ not supported | — |
| `SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_LOGIN_FAILURE_DETAILS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_PREDECESSOR_RETURN_VALUE` | unknown | ❌ not supported | — |
| `SYSTEM$GET_PREVIEW_ACCESS_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_PRIVATELINK` | unknown | ❌ not supported | — |
| `SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_PRIVATELINK_CONFIG` | unknown | ❌ not supported | — |
| `SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_PURCHASE_ATTRIBUTES` | unknown | ❌ not supported | — |
| `SYSTEM$GET_REFERENCED_OBJECT_ID_HASH` | unknown | ❌ not supported | — |
| `SYSTEM$GET_RESULTSET_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_SERVICE_DNS_DOMAIN` | unknown | ❌ not supported | — |
| `SYSTEM$GET_SERVICE_LOGS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_SNOWFLAKE_EGRESS_IP_RANGES` | unknown | ❌ not supported | — |
| `SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$GET_STAGE_PRIVATELINK_AUTHORIZED_ENDPOINTS` | unknown | ❌ not supported | — |
| `SYSTEM$GET_TAG` | scalar | ✅ supported | `(VARCHAR, VARCHAR, VARCHAR) → VARCHAR` |
| `SYSTEM$GET_TAG_ALLOWED_VALUES` | unknown | ❌ not supported | — |
| `SYSTEM$GET_TAG_ON_CURRENT_COLUMN` | unknown | ❌ not supported | — |
| `SYSTEM$GET_TAG_ON_CURRENT_TABLE` | unknown | ❌ not supported | — |
| `SYSTEM$GET_TASK_GRAPH_CONFIG` | unknown | ❌ not supported | — |
| `SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER` | unknown | ❌ not supported | — |
| `SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT` | unknown | ❌ not supported | — |
| `SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT` | unknown | ❌ not supported | — |
| `SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$IS_APPLICATION_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLED` | unknown | ❌ not supported | — |
| `SYSTEM$IS_APPLICATION_AUTHORIZED_FOR_TELEMETRY_EVENT_SHARING` | unknown | ❌ not supported | — |
| `SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNT` | unknown | ❌ not supported | — |
| `SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDER` | unknown | ❌ not supported | — |
| `SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT` | unknown | ❌ not supported | — |
| `SYSTEM$IS_LISTING_PURCHASED` | unknown | ❌ not supported | — |
| `SYSTEM$IS_LISTING_TRIAL` | unknown | ❌ not supported | — |
| `SYSTEM$LAST_CHANGE_COMMIT_TIME` | unknown | ❌ not supported | — |
| `SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME` | unknown | ❌ not supported | — |
| `SYSTEM$LINK_ORGANIZATION_USER` | unknown | ❌ not supported | — |
| `SYSTEM$LINK_ORGANIZATION_USER_GROUP` | unknown | ❌ not supported | — |
| `SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES` | unknown | ❌ not supported | — |
| `SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOG` | unknown | ❌ not supported | — |
| `SYSTEM$LIST_NAMESPACES_FROM_CATALOG` | unknown | ❌ not supported | — |
| `SYSTEM$LOCATE_DBT_ARCHIVE` | unknown | ❌ not supported | — |
| `SYSTEM$LOCATE_DBT_ARTIFACTS` | unknown | ❌ not supported | — |
| `SYSTEM$LOG` | unknown | 🟡 partial | — |
| `SYSTEM$LOG_DEBUG` | unknown | ✅ supported | — |
| `SYSTEM$LOG_ERROR` | unknown | ✅ supported | — |
| `SYSTEM$LOG_FATAL` | unknown | ✅ supported | — |
| `SYSTEM$LOG_INFO` | unknown | ✅ supported | — |
| `SYSTEM$LOG_TRACE` | unknown | ✅ supported | — |
| `SYSTEM$LOG_WARN` | unknown | ✅ supported | — |
| `SYSTEM$MIGRATE_SAML_IDP_REGISTRATION` | unknown | ❌ not supported | — |
| `SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGS` | unknown | ❌ not supported | — |
| `SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGS` | unknown | ❌ not supported | — |
| `SYSTEM$OPT_OUT_MALICIOUS_IP_PROTECTION_BY_CATEGORY` | unknown | ❌ not supported | — |
| `SYSTEM$PIPE_FORCE_RESUME` | scalar | ✅ supported | `(VARCHAR, VARCHAR) → VARCHAR` |
| `SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNEL` | unknown | ❌ not supported | — |
| `SYSTEM$PIPE_STATUS` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `SYSTEM$PROVISION_PRIVATELINK_ENDPOINT` | unknown | ❌ not supported | — |
| `SYSTEM$PROVISION_PRIVATELINK_ENDPOINT_TSS` | unknown | ❌ not supported | — |
| `SYSTEM$QUERY_REFERENCE` | unknown | ❌ not supported | — |
| `SYSTEM$READ_OSI_YAML_FROM_SEMANTIC_VIEW` | unknown | ❌ not supported | — |
| `SYSTEM$READ_YAML_FROM_SEMANTIC_VIEW` | unknown | ❌ not supported | — |
| `SYSTEM$REFERENCE` | unknown | ❌ not supported | — |
| `SYSTEM$REGISTER_CMK_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$REGISTER_CMK_INFO_POSTGRES` | unknown | ❌ not supported | — |
| `SYSTEM$REGISTER_PRIVATELINK_ENDPOINT` | unknown | ❌ not supported | — |
| `SYSTEM$REMOVE_ALL_REFERENCES` | unknown | ❌ not supported | — |
| `SYSTEM$REMOVE_REFERENCE` | unknown | ❌ not supported | — |
| `SYSTEM$REPORT_HEALTH_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$RESOLVE_PYTHON_PACKAGES` | unknown | ❌ not supported | — |
| `SYSTEM$RESTORE_PRIVATELINK_ENDPOINT` | unknown | ❌ not supported | — |
| `SYSTEM$RESTORE_PRIVATELINK_ENDPOINT_TSS` | unknown | ❌ not supported | — |
| `SYSTEM$REVOKE_PRIVATELINK` | unknown | ❌ not supported | — |
| `SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS` | unknown | ❌ not supported | — |
| `SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESH` | unknown | ❌ not supported | — |
| `SYSTEM$SEND_NOTIFICATIONS_TO_CATALOG` | unknown | ❌ not supported | — |
| `SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS` | unknown | ❌ not supported | — |
| `SYSTEM$SET_CATALOG_INTEGRATION` | unknown | ❌ not supported | — |
| `SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND` | unknown | ❌ not supported | — |
| `SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT` | unknown | ❌ not supported | — |
| `SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION` | unknown | ❌ not supported | — |
| `SYSTEM$SET_PRIVATELINK_ENDPOINT_HOSTNAME` | unknown | ❌ not supported | — |
| `SYSTEM$SET_REFERENCE` | unknown | ❌ not supported | — |
| `SYSTEM$SET_RETURN_VALUE` | unknown | ❌ not supported | — |
| `SYSTEM$SET_ROW_TIMESTAMP_ON_ALL_SUPPORTED_TABLES` | unknown | ❌ not supported | — |
| `SYSTEM$SET_SPAN_ATTRIBUTES` | unknown | ❌ not supported | — |
| `SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES` | unknown | ❌ not supported | — |
| `SYSTEM$SHOW_BUDGETS_FOR_RESOURCE` | unknown | ❌ not supported | — |
| `SYSTEM$SHOW_BUDGETS_IN_ACCOUNT` | unknown | ❌ not supported | — |
| `SYSTEM$SHOW_EVENT_SHARING_ACCOUNTS` | unknown | ❌ not supported | — |
| `SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS` | unknown | ❌ not supported | — |
| `SYSTEM$SHOW_OAUTH_CLIENT_SECRETS` | unknown | ❌ not supported | — |
| `SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIES` | unknown | ❌ not supported | — |
| `SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKEN` | unknown | ❌ not supported | — |
| `SYSTEM$START_OAUTH_FLOW` | unknown | ❌ not supported | — |
| `SYSTEM$START_USER_EMAIL_VERIFICATION` | unknown | ❌ not supported | — |
| `SYSTEM$STREAM_GET_TABLE_TIMESTAMP` | unknown | ❌ not supported | — |
| `SYSTEM$STREAM_HAS_DATA` | unknown | ❌ not supported | — |
| `SYSTEM$SUPPORTED_DBT_VERSIONS` | unknown | ❌ not supported | — |
| `SYSTEM$TASK_DEPENDENTS_ENABLE` | scalar | ✅ supported | `(VARCHAR) → VARCHAR` |
| `SYSTEM$TASK_RUNTIME_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$TRIGGER_LISTING_REFRESH` | unknown | ❌ not supported | — |
| `SYSTEM$TYPEOF` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(ARRAY) → VARCHAR`<br>`(BINARY) → VARCHAR`<br>`(BOOLEAN) → VARCHAR`<br>`(DATE) → VARCHAR`<br>`(DECFLOAT) → VARCHAR`<br>`(FILE) → VARCHAR`<br>`(FLOAT) → VARCHAR`<br>`(NUMBER) → VARCHAR`<br>`(OBJECT) → VARCHAR`<br>`(SNOWFLAKE_UUID) → VARCHAR`<br>`(TIME) → VARCHAR`<br>`(TIMESTAMP_LTZ) → VARCHAR`<br>`(TIMESTAMP_NTZ) → VARCHAR`<br>`(TIMESTAMP_TZ) → VARCHAR`<br>`(VARCHAR) → VARCHAR`<br>`(VARIANT) → VARCHAR` |
| `SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS` | unknown | ❌ not supported | — |
| `SYSTEM$UNLINK_ORGANIZATION_USER` | unknown | ❌ not supported | — |
| `SYSTEM$UNLINK_ORGANIZATION_USER_GROUP` | unknown | ❌ not supported | — |
| `SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINT` | unknown | ❌ not supported | — |
| `SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND` | unknown | ❌ not supported | — |
| `SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT` | unknown | ❌ not supported | — |
| `SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGION` | unknown | ❌ not supported | — |
| `SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS` | unknown | ❌ not supported | — |
| `SYSTEM$VALIDATE_STORAGE_INTEGRATION` | unknown | ❌ not supported | — |
| `SYSTEM$VERIFY_CATALOG_INTEGRATION` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(VARCHAR) → VARCHAR` |
| `SYSTEM$VERIFY_CMK_INFO` | unknown | ❌ not supported | — |
| `SYSTEM$VERIFY_CMK_INFO_POSTGRES` | unknown | ❌ not supported | — |
| `SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN` | unknown | ❌ not supported | — |
| `SYSTEM$VERIFY_EXTERNAL_VOLUME` | unknown | ❌ not supported | — |
| `SYSTEM$WAIT` | scalar | ✅ supported | `(ANY) → VARCHAR`<br>`(NUMBER) → VARCHAR`<br>`(NUMBER, VARCHAR) → VARCHAR` |
| `SYSTEM$WAIT_FOR_SERVICES` | unknown | ❌ not supported | — |

### Table functions (21)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `CORTEX_SEARCH_BATCH` | unknown | ❌ not supported | — |
| `CORTEX_SEARCH_DATA_SCAN` | unknown | ❌ not supported | — |
| `CUMULATIVE_PRIVACY_LOSSES` | unknown | ❌ not supported | — |
| `FLATTEN` | table | ✅ supported | `(VARIANT, VARCHAR, BOOLEAN, BOOLEAN, VARCHAR) → TABLE` |
| `GENERATOR` | table | ✅ supported | `(NUMBER, NUMBER) → SETOF NUMBER` |
| `GET_AI_EVALUATION_DATA` | unknown | ❌ not supported | — |
| `GET_AI_OBSERVABILITY_LOGS` | unknown | ❌ not supported | — |
| `GET_AI_RECORD_TRACE` | unknown | ❌ not supported | — |
| `GET_CONTACTS` | unknown | ❌ not supported | — |
| `GET_JOB_HISTORY` | unknown | ❌ not supported | — |
| `GET_LINEAGE` | unknown | ❌ not supported | — |
| `GET_OBJECT_REFERENCES` | unknown | ❌ not supported | — |
| `ICEBERG_TABLE_FILES` | unknown | ❌ not supported | — |
| `ICEBERG_TABLE_SNAPSHOT_REFRESH_HISTORY` | unknown | ❌ not supported | — |
| `INFER_SCHEMA` | table | ✅ supported | `(VARCHAR, VARCHAR, ARRAY, BOOLEAN, NUMBER, NUMBER, VARCHAR, VARCHAR, BOOLEAN, VARCHAR, VARCHAR, NUMBER) → SETOF RECORD` |
| `REST_EVENT_HISTORY` | unknown | ❌ not supported | — |
| `RESULT_SCAN` | unknown | ✅ supported | — |
| `STORAGE_LIFECYCLE_POLICY_HISTORY` | unknown | ❌ not supported | — |
| `SYSTEM$STREAM_BACKLOG` | unknown | ❌ not supported | — |
| `TO_QUERY` | unknown | ❌ not supported | — |
| `VALIDATE` | unknown | ❌ not supported | — |

### Table functions (Tables) (1)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `APPLICATION_CONFIGURATION_VALUE_HISTORY` | unknown | ❌ not supported | — |

### Vector functions (10)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `VECTOR_AVG` | aggregate | ✅ supported | `(VECTOR)` |
| `VECTOR_COSINE_SIMILARITY` | scalar | ✅ supported | `(VECTOR, VECTOR) → FLOAT` |
| `VECTOR_INNER_PRODUCT` | scalar | ✅ supported | `(VECTOR, VECTOR) → FLOAT` |
| `VECTOR_L1_DISTANCE` | scalar | ✅ supported | `(VECTOR, VECTOR) → FLOAT` |
| `VECTOR_L2_DISTANCE` | scalar | ✅ supported | `(VECTOR, VECTOR) → FLOAT` |
| `VECTOR_MAX` | aggregate | ✅ supported | `(VECTOR)` |
| `VECTOR_MIN` | aggregate | ✅ supported | `(VECTOR)` |
| `VECTOR_NORMALIZE` | scalar | ✅ supported | `(ANY) → VECTOR`<br>`(VARCHAR) → VECTOR`<br>`(VARIANT) → VECTOR`<br>`(VECTOR) → VECTOR` |
| `VECTOR_SUM` | aggregate | ✅ supported | `(VECTOR)` |
| `VECTOR_TRUNCATE` | scalar | 🟡 partial | `(ANY, ANY) → VECTOR`<br>`(VARCHAR, NUMBER) → VECTOR`<br>`(VARIANT, NUMBER) → VECTOR`<br>`(VECTOR, NUMBER) → VECTOR` |

### Window function syntax and usage (8)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `DENSE_RANK` | window | ✅ supported | `() → NUMBER` |
| `FIRST_VALUE` | window | ✅ supported | `(ANY) → ANY` |
| `LAG` | window | ✅ supported | `(ANY) → ANY`<br>`(ANY) → VARCHAR`<br>`(ANY, NUMBER) → ANY`<br>`(ANY, NUMBER, ANY) → ANY` |
| `LAST_VALUE` | window | ✅ supported | `(ANY) → ANY` |
| `LEAD` | window | ✅ supported | `(ANY) → ANY`<br>`(ANY) → VARCHAR`<br>`(ANY, NUMBER) → ANY`<br>`(ANY, NUMBER, ANY) → ANY` |
| `NTH_VALUE` | window | ✅ supported | `(ANY, NUMBER) → ANY` |
| `NTILE` | window | ✅ supported | `(NUMBER) → NUMBER` |
| `ROW_NUMBER` | window | ✅ supported | `() → NUMBER` |

### Window functions (9)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `CONDITIONAL_CHANGE_EVENT` | window | ✅ supported | `(ANY) → NUMBER` |
| `CONDITIONAL_TRUE_EVENT` | unknown | ✅ supported | — |
| `CUME_DIST` | window | ✅ supported | `() → FLOAT` |
| `INTERPOLATE_BFILL` | window | ✅ supported | `(ANY) → ANY` |
| `INTERPOLATE_FFILL` | window | ✅ supported | `(ANY) → ANY` |
| `INTERPOLATE_LINEAR` | window | ✅ supported | `(ANY, ANY) → ANY` |
| `PERCENT_RANK` | window | ✅ supported | `() → FLOAT` |
| `RANK` | window | ✅ supported | `() → NUMBER` |
| `RATIO_TO_REPORT` | unknown | ✅ supported | — |

### Not in the SQL reference (bitwise) (5)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `BIT_NOT` | scalar | ✅ supported | `(NUMBER) → NUMBER` |
| `BIT_OR` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |
| `BIT_SHIFTLEFT` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |
| `BIT_SHIFTRIGHT` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |
| `BIT_XOR` | scalar | ✅ supported | `(NUMBER, NUMBER) → NUMBER` |

### Not in the SQL reference (context) (1)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `CURRENT_TIMESTAMP_LTZ` | scalar | ✅ supported | `() → TIMESTAMP_LTZ` |

### Not in the SQL reference (conversion) (1)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `BIT_AND` | scalar | ✅ supported | `(ANY, ANY) → NUMBER`<br>`(DECFLOAT, DECFLOAT) → NUMBER`<br>`(NUMBER, NUMBER) → NUMBER` |

### Not in the SQL reference (date) (8)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `TIMEFROMPARTS` | scalar | ✅ supported | `(ANY, ANY, ANY) → TIME`<br>`(NUMBER, NUMBER, NUMBER) → TIME`<br>`(NUMBER, NUMBER, NUMBER, NUMBER) → TIME` |
| `TIMESTAMPFROMPARTS` | scalar | ✅ supported | `(DATE, TIME) → TIMESTAMP_NTZ`<br>`(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ` |
| `TIMESTAMPLTZFROMPARTS` | scalar | ✅ supported | `(DATE, TIME) → TIMESTAMP_LTZ`<br>`(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_LTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_LTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_LTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_LTZ` |
| `TIMESTAMPNTZFROMPARTS` | scalar | ✅ supported | `(DATE, TIME) → TIMESTAMP_NTZ`<br>`(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_NTZ` |
| `TIMESTAMPTZFROMPARTS` | scalar | ✅ supported | `(DATE, TIME) → TIMESTAMP_TZ`<br>`(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_TZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_TZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_TZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_TZ` |
| `TIMESTAMP_LTZ_FROM_PARTS` | scalar | ✅ supported | `(DATE, TIME) → TIMESTAMP_LTZ`<br>`(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_LTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_LTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_LTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_LTZ` |
| `TIMESTAMP_NTZ_FROM_PARTS` | scalar | ✅ supported | `(DATE, TIME) → TIMESTAMP_NTZ`<br>`(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_NTZ` |
| `TIMESTAMP_TZ_FROM_PARTS` | scalar | ✅ supported | `(DATE, TIME) → TIMESTAMP_TZ`<br>`(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_TZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_TZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_TZ`<br>`(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_TZ` |

### Not in the SQL reference (math) (1)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `CEILING` | scalar | ✅ supported | `(ANY) → NUMBER`<br>`(FLOAT) → FLOAT`<br>`(NUMBER) → NUMBER`<br>`(ANY, ANY) → NUMBER`<br>`(FLOAT, NUMBER) → FLOAT`<br>`(NUMBER, NUMBER) → NUMBER`<br>`(VARCHAR, NUMBER) → NUMBER` |

### Not in the SQL reference (system) (5)

| Function | Kind | Status | Signatures |
|---|---|---|---|
| `SYSTEM$BOOTSTRAP_DATA_REQUEST` | scalar | ✅ supported | `() → VARCHAR`<br>`(ANY) → VARCHAR`<br>`(SNOWFLAKE_VARCHAR[]) → VARCHAR` |
| `SYSTEM$GET_ALERT_CONFIG` | scalar | ✅ supported | `() → VARCHAR`<br>`(ANY) → VARCHAR`<br>`(VARCHAR) → VARCHAR` |
| `SYSTEM$RETURN_CURRENT_ORG_NAME` | scalar | ✅ supported | `() → VARCHAR` |
| `SYSTEM$SEND_EMAIL` | scalar | ✅ supported | `(ANY, ANY, ANY, ANY) → BOOLEAN`<br>`(VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN`<br>`(VARCHAR, VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN` |
| `SYSTEM$SEND_SNOWFLAKE_NOTIFICATION` | scalar | ✅ supported | `(ANY, ANY) → VARCHAR`<br>`(ARRAY, ARRAY) → VARCHAR`<br>`(ARRAY, VARCHAR) → VARCHAR`<br>`(VARCHAR, ARRAY) → VARCHAR`<br>`(VARCHAR, VARCHAR) → VARCHAR` |