LocalStack for Snowflake — feature catalog

snowflake-next 0.1.0

What localstack/snowflake-next supports, generated for each build from the emulator itself and measured against everything Snowflake’s SQL reference lists (scraped 2026-09-05). Also as JSON and Markdown.

What supported / partial / not supported mean
StatusMeaning
✅ supportedWorks as in Snowflake.
🟡 partialWorks for common usage; some inputs or behaviors still differ from Snowflake.
❌ not supportedNot available yet.
555 of 973 documented · 57%587 supported14 partial418 not supported

Functions

Signatures use Snowflake type names; ANY accepts every Snowflake type. Names link to the Snowflake SQL reference.

Account Usage table functions (1)

FunctionKindStatusSignatures
TAG_REFERENCES_WITH_LINEAGEunknown❌ not supported—

Aggregate functions (82)

FunctionKindStatusSignatures
AGGunknown❌ not supported—
AI_AGGunknown❌ not supported—
AI_SUMMARIZE_AGGunknown❌ not supported—
ANY_VALUEaggregate✅ supported(ANY)
APPROXIMATE_JACCARD_INDEXaggregate✅ supported(OBJECT)
APPROXIMATE_SIMILARITYaggregate✅ supported(OBJECT)
APPROX_COUNT_DISTINCTaggregate✅ supported(ANY)(ANY, ANY)
APPROX_PERCENTILEaggregate✅ supported(FLOAT, FLOAT)
APPROX_PERCENTILE_ACCUMULATEaggregate✅ supported(FLOAT)
APPROX_PERCENTILE_COMBINEaggregate✅ supported(OBJECT)
APPROX_PERCENTILE_ESTIMATEscalar✅ supported(OBJECT, FLOAT) → FLOAT
APPROX_TOP_Kaggregate✅ supported(ANY, NUMBER)
APPROX_TOP_K_ACCUMULATEaggregate✅ supported(ANY, NUMBER)
APPROX_TOP_K_COMBINEaggregate✅ supported(OBJECT)
APPROX_TOP_K_ESTIMATEscalar✅ supported(OBJECT, NUMBER) → VARIANT
ARRAY_AGGaggregate✅ supported(ANY)
ARRAY_UNION_AGGaggregate✅ supported(ARRAY)
ARRAY_UNIQUE_AGGaggregate✅ supported(ANY)
AVGaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)(NUMBER)
BITAND_AGGaggregate✅ supported(NUMBER)
BITMAP_ABSOLUTE_POSITIONscalar✅ supported(NUMBER, NUMBER) → NUMBER
BITMAP_ANDscalar✅ supported(ANY, BINARY) → BINARY(BINARY, ANY) → BINARY(BINARY, BINARY) → BINARY(BINARY, NUMBER) → BINARY(BINARY, VARCHAR) → BINARY(BINARY, VARIANT) → BINARY(NUMBER, BINARY) → BINARY(VARCHAR, BINARY) → BINARY(VARIANT, BINARY) → BINARY
BITMAP_AND_AGGaggregate✅ supported(ANY)(BINARY)(NUMBER) → BINARY(VARCHAR) → BINARY(VARIANT) → BINARY
BITMAP_BIT_POSITIONscalar✅ supported(NUMBER) → NUMBER
BITMAP_BUCKET_NUMBERscalar✅ supported(NUMBER) → NUMBER
BITMAP_CONSTRUCT_AGGaggregate✅ supported(NUMBER)
BITMAP_COUNTscalar✅ supported(BINARY) → NUMBER
BITMAP_ORscalar✅ supported(ANY, BINARY) → BINARY(BINARY, ANY) → BINARY(BINARY, BINARY) → BINARY(BINARY, NUMBER) → BINARY(BINARY, VARCHAR) → BINARY(BINARY, VARIANT) → BINARY(NUMBER, BINARY) → BINARY(VARCHAR, BINARY) → BINARY(VARIANT, BINARY) → BINARY
BITMAP_OR_AGGaggregate✅ supported(BINARY)
BITMAP_TO_ARRAYscalar✅ supported(ANY) → ARRAY(BINARY) → ARRAY(NUMBER) → ARRAY(VARCHAR) → ARRAY(VARIANT) → ARRAY
BITOR_AGGaggregate✅ supported(NUMBER)
BITXOR_AGGaggregate✅ supported(NUMBER)
BOOLAND_AGGaggregate✅ supported(ANY)(BOOLEAN)(NUMBER)
BOOLOR_AGGaggregate✅ supported(ANY)(BOOLEAN)(NUMBER)(VARCHAR)
BOOLXOR_AGGaggregate✅ supported(ANY)(BOOLEAN)(NUMBER)(VARCHAR)
CORRaggregate✅ supported(FLOAT, FLOAT)
COUNTaggregate✅ supported(*)(ANY)
COUNT_IFaggregate✅ supported(BOOLEAN)
COVAR_POPaggregate✅ supported(FLOAT, FLOAT)
COVAR_SAMPaggregate✅ supported(FLOAT, FLOAT)
DATASKETCHES_HLLaggregate✅ supported(ANY)(ANY, ANY)
DATASKETCHES_HLL_ACCUMULATEaggregate✅ supported(ANY)
DATASKETCHES_HLL_COMBINEaggregate✅ supported(BINARY)
DATASKETCHES_HLL_ESTIMATEscalar✅ supported(BINARY) → FLOAT
GROUPINGunknown✅ supported—
GROUPING_IDunknown✅ supported—
HASH_AGGaggregate✅ supported(NUMBER)
HLLaggregate✅ supported(ANY)(ANY, ANY)
HLL_ACCUMULATEaggregate✅ supported(ANY)
HLL_COMBINEaggregate✅ supported(BINARY)
HLL_ESTIMATEscalar✅ supported(BINARY) → NUMBER
HLL_EXPORTscalar✅ supported(BINARY) → OBJECT
HLL_IMPORTscalar✅ supported(ANY) → BINARY(OBJECT) → BINARY(VARIANT) → BINARY
KURTOSISaggregate✅ supported(ANY)(FLOAT)(NUMBER)
LISTAGGaggregate✅ supported(VARCHAR, VARCHAR)
MAX_BYaggregate✅ supported(ANY, ANY)(ANY, ANY, NUMBER)
MEDIANunknown✅ supported—
MINHASHaggregate✅ supported(NUMBER, ANY)
MINHASH_COMBINEaggregate✅ supported(OBJECT)
MIN_BYaggregate✅ supported(ANY, ANY)(ANY, ANY, NUMBER)
MODEaggregate✅ supported(ANY)
OBJECT_AGGaggregate✅ supported(VARCHAR, VARIANT)
PERCENTILE_CONTaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)
PERCENTILE_DISCaggregate✅ supported(ANY)
REGR_AVGXaggregate✅ supported(FLOAT, FLOAT)
REGR_AVGYaggregate✅ supported(FLOAT, FLOAT)
REGR_COUNTaggregate✅ supported(FLOAT, FLOAT)
REGR_INTERCEPTaggregate✅ supported(FLOAT, FLOAT)
REGR_R2aggregate✅ supported(FLOAT, FLOAT)
REGR_SLOPEaggregate✅ supported(FLOAT, FLOAT)
REGR_SXXaggregate✅ supported(FLOAT, FLOAT)
REGR_SXYaggregate✅ supported(FLOAT, FLOAT)
REGR_SYYaggregate✅ supported(FLOAT, FLOAT)
SKEWaggregate✅ supported(ANY)(FLOAT)
STDDEV_POPaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)
STDDEV_SAMPaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)
SUMaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)(NUMBER)
VARIANCEaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)(NUMBER)
VARIANCE_POPaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)(NUMBER)
VARIANCE_SAMPaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)(NUMBER)
VAR_POPaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)(NUMBER)
VAR_SAMPaggregate✅ supported(ANY)(DECFLOAT)(FLOAT)(NUMBER)

Bitwise expression functions (7)

FunctionKindStatusSignatures
BITANDscalar✅ supported(ANY, ANY) → NUMBER(DECFLOAT, DECFLOAT) → NUMBER(NUMBER, NUMBER) → NUMBER
BITNOTscalar✅ supported(NUMBER) → NUMBER
BITORscalar✅ supported(NUMBER, NUMBER) → NUMBER
BITSHIFTLEFTscalar✅ supported(NUMBER, NUMBER) → NUMBER
BITSHIFTRIGHTscalar✅ supported(NUMBER, NUMBER) → NUMBER
BITXORscalar✅ supported(NUMBER, NUMBER) → NUMBER
GETBITscalar✅ supported(NUMBER, NUMBER) → NUMBER

Conditional expression functions (21)

FunctionKindStatusSignatures
BOOLANDscalar🟡 partial(ANY, ANY) → BOOLEAN(NUMBER, NUMBER) → BOOLEAN(NUMBER, VARCHAR) → BOOLEAN(VARCHAR, NUMBER) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN
BOOLNOTscalar🟡 partial(ANY) → BOOLEAN(NUMBER) → BOOLEAN(VARCHAR) → BOOLEAN
BOOLORscalar🟡 partial(ANY, ANY) → BOOLEAN(NUMBER, NUMBER) → BOOLEAN(NUMBER, VARCHAR) → BOOLEAN(VARCHAR, NUMBER) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN
BOOLXORscalar🟡 partial(ANY, ANY) → BOOLEAN(NUMBER, NUMBER) → BOOLEAN(NUMBER, VARCHAR) → BOOLEAN(VARCHAR, NUMBER) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN
CASEsyntax✅ supported—
COALESCEscalar✅ supported(ANY) → SNOWFLAKE_NULL
DECODEunknown✅ supported—
EQUAL_NULLunknown✅ supported—
GREATESTscalar✅ supported(ANY) → SNOWFLAKE_NULL
GREATEST_IGNORE_NULLSunknown✅ supported—
IFFunknown✅ supported—
IFNULLunknown✅ supported—
LEASTscalar✅ supported(ANY) → SNOWFLAKE_NULL
LEAST_IGNORE_NULLSunknown✅ supported—
NULLIFunknown✅ supported—
NULLIFZEROunknown✅ supported—
NVLunknown✅ supported—
NVL2unknown✅ supported—
REGR_VALXscalar✅ supported(ANY, ANY) → FLOAT(FLOAT, FLOAT) → FLOAT(NUMBER, FLOAT) → FLOAT(VARCHAR, FLOAT) → FLOAT(VARIANT, FLOAT) → FLOAT
REGR_VALYscalar✅ supported(ANY, ANY) → FLOAT(FLOAT, FLOAT) → FLOAT(FLOAT, NUMBER) → FLOAT(FLOAT, VARCHAR) → FLOAT(FLOAT, VARIANT) → FLOAT
ZEROIFNULLscalar✅ supported(ANY) → NUMBER(FLOAT) → FLOAT(NUMBER) → NUMBER(VARCHAR) → FLOAT(VARIANT) → FLOAT

Context functions (52)

FunctionKindStatusSignatures
ALL_USER_NAMESscalar✅ supported() → VARCHAR
CURRENT_ACCOUNTscalar✅ supported() → VARCHAR
CURRENT_ACCOUNT_NAMEscalar✅ supported() → VARCHAR
CURRENT_AVAILABLE_ROLESscalar🟡 partial() → VARCHAR
CURRENT_CLIENTscalar✅ supported() → VARCHAR
CURRENT_DATABASEscalar✅ supported() → VARCHAR
CURRENT_DATEscalar✅ supported() → DATE
CURRENT_IP_ADDRESSscalar✅ supported() → VARCHAR
CURRENT_ORGANIZATION_NAMEscalar✅ supported() → VARCHAR
CURRENT_ORGANIZATION_USERscalar✅ supported() → VARCHAR
CURRENT_REGIONscalar✅ supported() → VARCHAR
CURRENT_ROLEscalar✅ supported() → VARCHAR
CURRENT_ROLE_TYPEscalar✅ supported() → VARCHAR
CURRENT_SCHEMAscalar✅ supported() → VARCHAR
CURRENT_SCHEMASscalar✅ supported() → VARCHAR
CURRENT_SECONDARY_ROLESscalar🟡 partial() → VARCHAR
CURRENT_SESSIONscalar✅ supported() → VARCHAR
CURRENT_STATEMENTscalar✅ supported() → VARCHAR
CURRENT_TIMEscalar✅ supported() → TIME
CURRENT_TIMESTAMPscalar✅ supported() → TIMESTAMP_LTZ
CURRENT_TRANSACTIONscalar✅ supported() → VARCHAR
CURRENT_USERscalar✅ supported() → VARCHAR
CURRENT_VERSIONscalar✅ supported() → VARCHAR
CURRENT_WAREHOUSEscalar✅ supported() → VARCHAR
GETDATEscalar✅ supported() → TIMESTAMP_LTZ
GETVARIABLEscalar✅ supported(VARCHAR) → VARCHAR
GET_CONDITION_QUERY_UUIDunknown✅ supported—
GET_CONFIGURATION_VALUEunknown❌ not supported—
INVOKER_ROLEunknown❌ not supported—
INVOKER_SHAREunknown❌ not supported—
IS_APPLICATION_ROLE_ACTIVATEDunknown❌ not supported—
IS_APPLICATION_ROLE_IN_SESSIONunknown❌ not supported—
IS_CONFIGURATION_SETunknown❌ not supported—
IS_DATABASE_ROLE_ACTIVATEDunknown❌ not supported—
IS_DATABASE_ROLE_IN_SESSIONunknown❌ not supported—
IS_GRANTED_TO_INVOKER_ROLEunknown❌ not supported—
IS_GROUP_ACTIVATEDunknown❌ not supported—
IS_GROUP_IMPORTEDunknown❌ not supported—
IS_INSTANCE_ROLE_IN_SESSIONunknown❌ not supported—
IS_ORGANIZATION_USER_GROUP_IN_SESSIONunknown❌ not supported—
IS_ROLE_ACTIVATEDunknown❌ not supported—
IS_ROLE_IN_SESSIONunknown❌ not supported—
IS_USER_IMPORTEDunknown❌ not supported—
LAST_QUERY_IDscalar✅ supported(NUMBER) → VARCHAR
LAST_TRANSACTIONscalar✅ supported() → VARCHAR
LOCALTIMEscalar✅ supported() → TIME
LOCALTIMESTAMPscalar✅ supported() → TIMESTAMP_LTZ
POLICY_CONTEXTunknown❌ not supported—
SET_SYS_CONTEXTunknown❌ not supported—
SYSDATEscalar🟡 partial() → TIMESTAMP_NTZ
SYSTIMESTAMPunknown❌ not supported—
SYS_CONTEXTunknown❌ not supported—

Conversion functions (39)

FunctionKindStatusSignatures
CASTsyntax🟡 partial—
DATEscalar✅ supported(ANY) → DATE(NUMBER) → DATE(TIMESTAMP_LTZ) → DATE(TIMESTAMP_NTZ) → DATE(TIMESTAMP_TZ) → DATE(VARCHAR) → DATE(VARIANT) → DATE(VARCHAR, VARCHAR) → DATE
TIMEscalar✅ supported(ANY) → TIME(NUMBER) → TIME(TIMESTAMP_LTZ) → TIME(TIMESTAMP_NTZ) → TIME(TIMESTAMP_TZ) → TIME(VARCHAR) → TIME(VARIANT) → TIME(VARCHAR, VARCHAR) → TIME
TO_ARRAYscalar✅ supported(ANY) → ARRAY(ARRAY) → ARRAY(BINARY) → ARRAY(BOOLEAN) → ARRAY(DATE) → ARRAY(FLOAT) → ARRAY(NUMBER) → ARRAY(OBJECT) → ARRAY(TIME) → ARRAY(TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ) → ARRAY(VARCHAR) → ARRAY(VARIANT) → ARRAY
TO_BINARYscalar✅ supported(ANY) → BINARY(VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY
TO_BOOLEANscalar✅ supported(ANY) → BOOLEAN(BOOLEAN) → BOOLEAN(FLOAT) → BOOLEAN(NUMBER) → BOOLEAN(VARCHAR) → BOOLEAN(VARIANT) → BOOLEAN
TO_CHARscalar✅ supported(ANY) → VARCHAR(BINARY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(SNOWFLAKE_UUID) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR(BINARY, VARCHAR) → VARCHAR(DATE, VARCHAR) → VARCHAR(FLOAT, VARCHAR) → VARCHAR(NUMBER, VARCHAR) → VARCHAR(TIMESTAMP_LTZ, VARCHAR) → VARCHAR(TIMESTAMP_NTZ, VARCHAR) → VARCHAR(TIMESTAMP_TZ, VARCHAR) → VARCHAR
TO_DATEscalar✅ supported(ANY) → DATE(NUMBER) → DATE(TIMESTAMP_LTZ) → DATE(TIMESTAMP_NTZ) → DATE(TIMESTAMP_TZ) → DATE(VARCHAR) → DATE(VARIANT) → DATE(VARCHAR, VARCHAR) → DATE
TO_DECFLOATscalar✅ supported(ANY) → DECFLOAT(FLOAT) → DECFLOAT(NUMBER) → DECFLOAT(VARCHAR) → DECFLOAT(VARCHAR, VARCHAR) → DECFLOAT
TO_DECIMALscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(VARCHAR) → NUMBER(BOOLEAN, NUMBER) → NUMBER(NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR) → NUMBER(BOOLEAN, NUMBER, NUMBER) → NUMBER(NUMBER, NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER
TO_DOUBLEscalar✅ supported(ANY) → FLOAT(BOOLEAN) → FLOAT(FLOAT) → FLOAT(NUMBER) → FLOAT(VARCHAR) → FLOAT(VARCHAR, VARCHAR) → FLOAT
TO_JSONscalar✅ supported(VARIANT) → VARCHAR
TO_NUMBERscalar🟡 partial(ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(VARCHAR) → NUMBER(BOOLEAN, NUMBER) → NUMBER(NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR) → NUMBER(BOOLEAN, NUMBER, NUMBER) → NUMBER(NUMBER, NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER
TO_NUMERICscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(VARCHAR) → NUMBER(BOOLEAN, NUMBER) → NUMBER(NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR) → NUMBER(BOOLEAN, NUMBER, NUMBER) → NUMBER(NUMBER, NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER
TO_OBJECTscalar✅ supported(ANY) → OBJECT(NUMBER) → OBJECT(OBJECT) → OBJECT(VARIANT) → OBJECT
TO_TIMEscalar✅ supported(ANY) → TIME(NUMBER) → TIME(TIMESTAMP_LTZ) → TIME(TIMESTAMP_NTZ) → TIME(TIMESTAMP_TZ) → TIME(VARCHAR) → TIME(VARIANT) → TIME(VARCHAR, VARCHAR) → TIME
TO_TIMESTAMPscalar✅ supported(ANY) → TIMESTAMP_NTZ(NUMBER) → TIMESTAMP_NTZ(VARCHAR) → TIMESTAMP_NTZ(VARIANT) → TIMESTAMP_NTZ(VARCHAR, VARCHAR) → TIMESTAMP_NTZ
TO_TIMESTAMP_LTZscalar✅ supported(ANY) → TIMESTAMP_LTZ(NUMBER) → TIMESTAMP_LTZ(VARCHAR) → TIMESTAMP_LTZ(VARIANT) → TIMESTAMP_LTZ(VARCHAR, VARCHAR) → TIMESTAMP_LTZ
TO_TIMESTAMP_NTZscalar✅ supported(ANY) → TIMESTAMP_NTZ(NUMBER) → TIMESTAMP_NTZ(VARCHAR) → TIMESTAMP_NTZ(VARIANT) → TIMESTAMP_NTZ(VARCHAR, VARCHAR) → TIMESTAMP_NTZ
TO_TIMESTAMP_TZscalar✅ supported(ANY) → TIMESTAMP_TZ(NUMBER) → TIMESTAMP_TZ(VARCHAR) → TIMESTAMP_TZ(VARIANT) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → TIMESTAMP_TZ
TO_UUIDscalar✅ supported(ANY) → SNOWFLAKE_UUID(SNOWFLAKE_UUID) → SNOWFLAKE_UUID(VARCHAR) → SNOWFLAKE_UUID(VARIANT) → SNOWFLAKE_UUID
TO_VARCHARscalar✅ supported(ANY) → VARCHAR(BINARY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(SNOWFLAKE_UUID) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR(BINARY, VARCHAR) → VARCHAR(DATE, VARCHAR) → VARCHAR(FLOAT, VARCHAR) → VARCHAR(NUMBER, VARCHAR) → VARCHAR(TIMESTAMP_LTZ, VARCHAR) → VARCHAR(TIMESTAMP_NTZ, VARCHAR) → VARCHAR(TIMESTAMP_TZ, VARCHAR) → VARCHAR
TO_VARIANTscalar✅ supported(ANY) → VARIANT(ARRAY) → VARIANT(BINARY) → VARIANT(BOOLEAN) → VARIANT(DATE) → VARIANT(DECFLOAT) → VARIANT(FLOAT) → VARIANT(NUMBER) → VARIANT(OBJECT) → VARIANT(SNOWFLAKE_UUID) → VARIANT(TIME) → VARIANT(TIMESTAMP_LTZ) → VARIANT(TIMESTAMP_NTZ) → VARIANT(TIMESTAMP_TZ) → VARIANT(VARCHAR) → VARIANT(VARIANT) → VARIANT
TO_XMLscalar✅ supported(VARIANT) → VARCHAR
TRY_CASTsyntax✅ supported—
TRY_TO_BINARYscalar✅ supported(ANY) → BINARY(VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY
TRY_TO_BOOLEANscalar✅ supported(ANY) → BOOLEAN(BOOLEAN) → BOOLEAN(FLOAT) → BOOLEAN(NUMBER) → BOOLEAN(VARCHAR) → BOOLEAN
TRY_TO_DATEscalar✅ supported(ANY) → DATE(VARCHAR) → DATE(VARIANT) → DATE(VARCHAR, VARCHAR) → DATE(VARIANT, VARCHAR) → DATE
TRY_TO_DECFLOATscalar✅ supported(VARCHAR) → DECFLOAT
TRY_TO_DECIMALscalar✅ supported(ANY) → NUMBER(VARCHAR) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER
TRY_TO_DOUBLEscalar✅ supported(ANY) → FLOAT(VARCHAR) → FLOAT(VARCHAR, VARCHAR) → FLOAT
TRY_TO_NUMBERscalar✅ supported(ANY) → NUMBER(VARCHAR) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER
TRY_TO_NUMERICscalar✅ supported(ANY) → NUMBER(VARCHAR) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER
TRY_TO_TIMEscalar✅ supported(ANY) → TIME(VARCHAR) → TIME(VARIANT) → TIME(VARCHAR, VARCHAR) → TIME(VARIANT, VARCHAR) → TIME
TRY_TO_TIMESTAMPscalar✅ supported(ANY) → TIMESTAMP_NTZ(VARCHAR) → TIMESTAMP_NTZ(VARIANT) → TIMESTAMP_NTZ(VARCHAR, VARCHAR) → TIMESTAMP_NTZ(VARIANT, VARCHAR) → TIMESTAMP_NTZ
TRY_TO_TIMESTAMP_LTZscalar✅ supported(ANY) → TIMESTAMP_LTZ(VARCHAR) → TIMESTAMP_LTZ(VARIANT) → TIMESTAMP_LTZ(VARCHAR, VARCHAR) → TIMESTAMP_LTZ(VARIANT, VARCHAR) → TIMESTAMP_LTZ
TRY_TO_TIMESTAMP_NTZscalar✅ supported(ANY) → TIMESTAMP_NTZ(VARCHAR) → TIMESTAMP_NTZ(VARIANT) → TIMESTAMP_NTZ(VARCHAR, VARCHAR) → TIMESTAMP_NTZ(VARIANT, VARCHAR) → TIMESTAMP_NTZ
TRY_TO_TIMESTAMP_TZscalar✅ supported(ANY) → TIMESTAMP_TZ(VARCHAR) → TIMESTAMP_TZ(VARIANT) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → TIMESTAMP_TZ(VARIANT, VARCHAR) → TIMESTAMP_TZ
TRY_TO_UUIDscalar✅ supported(ANY) → SNOWFLAKE_UUID(VARCHAR) → SNOWFLAKE_UUID(VARIANT) → SNOWFLAKE_UUID

Data generation functions (9)

FunctionKindStatusSignatures
NORMALscalar✅ supported(FLOAT, FLOAT, FLOAT) → FLOAT
RANDOMscalar✅ supported() → NUMBER(ANY) → NUMBER(NUMBER) → NUMBER
RANDSTRscalar✅ supported(ANY, ANY) → VARCHAR(NUMBER, NUMBER) → VARCHAR
SEQ1scalar✅ supported() → NUMBER
SEQ2scalar✅ supported() → NUMBER
SEQ4scalar✅ supported() → NUMBER
SEQ8scalar✅ supported() → NUMBER
UNIFORMscalar✅ supported(ANY, ANY, ANY) → NUMBER(FLOAT, FLOAT, FLOAT) → FLOAT(NUMBER, NUMBER, NUMBER) → NUMBER
ZIPFscalar✅ supported(FLOAT, NUMBER, NUMBER) → NUMBER

Data metric functions (13)

FunctionKindStatusSignatures
ACCEPTED_VALUESunknown✅ supported—
BLANK_COUNTunknown✅ supported—
BLANK_PERCENTunknown✅ supported—
DATA_METRIC_SCHEDULED_TIMEunknown✅ supported—
DUPLICATE_COUNTunknown✅ supported—
FRESHNESSunknown✅ supported—
MAXaggregate✅ supported(ANY)(DATE)(DECFLOAT)(FLOAT)(NUMBER)(TIME)(TIMESTAMP_LTZ)(TIMESTAMP_NTZ)(TIMESTAMP_TZ)(VARCHAR)
MINaggregate✅ supported(ANY)(DATE)(DECFLOAT)(FLOAT)(NUMBER)(TIME)(TIMESTAMP_LTZ)(TIMESTAMP_NTZ)(TIMESTAMP_TZ)(VARCHAR)
NULL_COUNTunknown✅ supported—
NULL_PERCENTunknown✅ supported—
ROW_COUNTunknown✅ supported—
STDDEVaggregate🟡 partial(ANY)(DECFLOAT)(FLOAT)
UNIQUE_COUNTunknown✅ supported—

Date & time functions (39)

FunctionKindStatusSignatures
ADD_MONTHSscalar✅ supported(ANY, ANY) → TIMESTAMP_NTZ(DATE, NUMBER) → DATE(TIMESTAMP_LTZ, NUMBER) → TIMESTAMP_LTZ(TIMESTAMP_NTZ, NUMBER) → TIMESTAMP_NTZ(TIMESTAMP_TZ, NUMBER) → TIMESTAMP_TZ
CONVERT_TIMEZONEscalar✅ supported(ANY, ANY) → TIMESTAMP_TZ(VARCHAR, TIMESTAMP_LTZ) → TIMESTAMP_TZ(VARCHAR, TIMESTAMP_NTZ) → TIMESTAMP_TZ(VARCHAR, TIMESTAMP_TZ) → TIMESTAMP_TZ(ANY, ANY, ANY) → TIMESTAMP_NTZ(VARCHAR, VARCHAR, TIMESTAMP_NTZ) → TIMESTAMP_NTZ
DATEADDunknown✅ supported—
DATEDIFFscalar✅ supported(ANY, ANY, ANY) → NUMBER(VARCHAR, DATE, DATE) → NUMBER(VARCHAR, TIME, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, VARCHAR, VARCHAR) → NUMBER
DATE_FROM_PARTSscalar✅ supported(NUMBER, NUMBER, NUMBER) → DATE
DATE_PARTscalar✅ supported(ANY, ANY) → NUMBER(VARCHAR, DATE) → NUMBER(VARCHAR, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ) → NUMBER
DATE_TRUNCscalar✅ supported(ANY, ANY) → TIMESTAMP_NTZ(VARCHAR, DATE) → DATE(VARCHAR, NUMBER) → NUMBER(VARCHAR, TIME) → TIME(VARCHAR, TIMESTAMP_LTZ) → TIMESTAMP_LTZ(VARCHAR, TIMESTAMP_NTZ) → TIMESTAMP_NTZ(VARCHAR, TIMESTAMP_TZ) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → VARCHAR
DAYscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
DAYNAMEscalar✅ supported(ANY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR
DAYOFMONTHscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
DAYOFWEEKscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
DAYOFWEEKISOscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
DAYOFYEARscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
EXTRACTscalar✅ supported(ANY, ANY) → NUMBER(VARCHAR, DATE) → NUMBER(VARCHAR, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ) → NUMBER
HOURscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
LAST_DAYscalar✅ supported(ANY) → DATE(DATE) → DATE(TIMESTAMP_LTZ) → DATE(TIMESTAMP_NTZ) → DATE(TIMESTAMP_TZ) → DATE(ANY, ANY) → DATE(DATE, VARCHAR) → DATE(TIMESTAMP_LTZ, VARCHAR) → DATE(TIMESTAMP_NTZ, VARCHAR) → DATE(TIMESTAMP_TZ, VARCHAR) → DATE
LAST_SUCCESSFUL_SCHEDULED_TIMEunknown✅ supported—
MINUTEscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
MONTHscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
MONTHNAMEscalar✅ supported(ANY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR
MONTHS_BETWEENscalar✅ supported(ANY, ANY) → FLOAT(DATE, DATE) → FLOAT(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → FLOAT(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → FLOAT(TIMESTAMP_TZ, TIMESTAMP_TZ) → FLOAT
NEXT_DAYscalar✅ supported(ANY, ANY) → DATE(DATE, VARCHAR) → DATE(TIMESTAMP_LTZ, VARCHAR) → DATE(TIMESTAMP_NTZ, VARCHAR) → DATE(TIMESTAMP_TZ, VARCHAR) → DATE(VARCHAR, VARCHAR) → DATE
PREVIOUS_DAYscalar✅ supported(ANY, ANY) → DATE(DATE, VARCHAR) → DATE(TIMESTAMP_LTZ, VARCHAR) → DATE(TIMESTAMP_NTZ, VARCHAR) → DATE(TIMESTAMP_TZ, VARCHAR) → DATE(VARCHAR, VARCHAR) → DATE
QUARTERscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
SCHEDULED_TIMEunknown✅ supported—
SECONDscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
TIMEADDunknown✅ supported—
TIMEDIFFscalar✅ supported(ANY, ANY, ANY) → NUMBER(VARCHAR, DATE, DATE) → NUMBER(VARCHAR, TIME, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, VARCHAR, VARCHAR) → NUMBER
TIMESTAMPADDunknown✅ supported—
TIMESTAMPDIFFscalar✅ supported(ANY, ANY, ANY) → NUMBER(VARCHAR, DATE, DATE) → NUMBER(VARCHAR, TIME, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, VARCHAR, VARCHAR) → NUMBER
TIMESTAMP_FROM_PARTSscalar🟡 partial(DATE, TIME) → TIMESTAMP_NTZ(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ
TIME_FROM_PARTSscalar✅ supported(ANY, ANY, ANY) → TIME(NUMBER, NUMBER, NUMBER) → TIME(NUMBER, NUMBER, NUMBER, NUMBER) → TIME
TIME_SLICEscalar✅ supported(ANY, NUMBER, VARCHAR) → DATE(DATE, NUMBER, VARCHAR) → DATE(TIMESTAMP_LTZ, NUMBER, VARCHAR) → TIMESTAMP_NTZ(TIMESTAMP_NTZ, NUMBER, VARCHAR) → TIMESTAMP_NTZ(TIMESTAMP_TZ, NUMBER, VARCHAR) → TIMESTAMP_NTZ(ANY, NUMBER, VARCHAR, VARCHAR) → DATE(DATE, NUMBER, VARCHAR, VARCHAR) → DATE(TIMESTAMP_LTZ, NUMBER, VARCHAR, VARCHAR) → TIMESTAMP_NTZ(TIMESTAMP_NTZ, NUMBER, VARCHAR, VARCHAR) → TIMESTAMP_NTZ(TIMESTAMP_TZ, NUMBER, VARCHAR, VARCHAR) → TIMESTAMP_NTZ
WEEKscalar✅ supported(ANY) → NUMBER(DATE) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
WEEKISOscalar✅ supported(ANY) → NUMBER(DATE) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
WEEKOFYEARscalar✅ supported(ANY) → NUMBER(DATE) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
YEARscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
YEAROFWEEKscalar✅ supported(ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER
YEAROFWEEKISOscalar✅ supported(ANY) → NUMBER(DATE) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER

Differential privacy functions (3)

FunctionKindStatusSignatures
DP_INTERVAL_HIGHunknown❌ not supported—
DP_INTERVAL_LOWunknown❌ not supported—
ESTIMATE_REMAINING_DP_AGGREGATESunknown❌ not supported—

Encryption functions (6)

FunctionKindStatusSignatures
DECRYPTscalar✅ supported(ANY, ANY) → BINARY(BINARY, VARCHAR) → BINARY(BINARY, VARCHAR, VARCHAR) → BINARY(BINARY, VARCHAR, VARCHAR, VARCHAR) → BINARY
DECRYPT_RAWscalar✅ supported(ANY) → BINARY(BINARY, BINARY) → BINARY(BINARY, BINARY, BINARY) → BINARY(BINARY, BINARY, BINARY, BINARY, VARCHAR) → BINARY(BINARY, BINARY, BINARY, BINARY, VARCHAR, BINARY) → BINARY
ENCRYPTscalar✅ supported(ANY, ANY) → BINARY(BINARY, VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY(ANY, ANY, ANY) → BINARY(BINARY, VARCHAR, VARCHAR) → BINARY(VARCHAR, VARCHAR, VARCHAR) → BINARY(ANY, ANY, ANY, ANY) → BINARY(BINARY, VARCHAR, VARCHAR, VARCHAR) → BINARY(VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BINARY
ENCRYPT_RAWscalar✅ supported(ANY) → OBJECT(BINARY, BINARY) → OBJECT(BINARY, BINARY, BINARY, BINARY, VARCHAR) → OBJECT
TRY_DECRYPTscalar✅ supported(ANY, ANY) → BINARY(BINARY, VARCHAR) → BINARY(BINARY, VARCHAR, VARCHAR) → BINARY(BINARY, VARCHAR, VARCHAR, VARCHAR) → BINARY
TRY_DECRYPT_RAWscalar✅ supported(ANY, ANY) → BINARY(BINARY, BINARY) → BINARY(BINARY, BINARY, BINARY) → BINARY(BINARY, BINARY, BINARY, BINARY, VARCHAR) → BINARY(BINARY, BINARY, BINARY, BINARY, VARCHAR, BINARY) → BINARY

File functions (24)

FunctionKindStatusSignatures
AI_TRANSCRIBEunknown❌ not supported—
BUILD_SCOPED_FILE_URLscalar✅ supported(VARCHAR, VARCHAR) → VARCHAR
BUILD_STAGE_FILE_URLscalar✅ supported(VARCHAR, VARCHAR) → VARCHAR
FL_GET_CONTENT_TYPEscalar✅ supported(ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR
FL_GET_ETAGscalar✅ supported(ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR
FL_GET_FILE_TYPEscalar✅ supported(ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR
FL_GET_LAST_MODIFIEDscalar✅ supported(ANY) → TIMESTAMP_TZ(FILE) → TIMESTAMP_TZ(VARIANT) → TIMESTAMP_TZ
FL_GET_RELATIVE_PATHscalar✅ supported(ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR
FL_GET_SCOPED_FILE_URLscalar✅ supported(ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR
FL_GET_SIZEscalar✅ supported(ANY) → NUMBER(FILE) → NUMBER(VARIANT) → NUMBER
FL_GET_STAGEscalar✅ supported(ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR
FL_GET_STAGE_FILE_URLscalar✅ supported(ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR
FL_IS_AUDIOscalar✅ supported(ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN
FL_IS_COMPRESSEDscalar✅ supported(ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN
FL_IS_DOCUMENTscalar✅ supported(ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN
FL_IS_IMAGEscalar✅ supported(ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN
FL_IS_VIDEOscalar✅ supported(ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN
GET_ABSOLUTE_PATHscalar✅ supported(VARCHAR, VARCHAR) → VARCHAR
GET_PRESIGNED_URLscalar✅ supported(VARCHAR, VARCHAR, NUMBER) → VARCHAR
GET_RELATIVE_PATHscalar✅ supported(VARCHAR, VARCHAR) → VARCHAR
GET_STAGE_LOCATIONscalar✅ supported(VARCHAR) → VARCHAR
PARSE_DOCUMENTunknown❌ not supported—
TO_FILEscalar✅ supported(ANY) → FILE(FILE) → FILE(NUMBER) → FILE(VARCHAR) → FILE(VARIANT) → FILE(VARCHAR, VARCHAR) → FILE
TRY_TO_FILEscalar✅ supported(ANY) → FILE(FILE) → FILE(OBJECT) → FILE(VARCHAR) → FILE(VARIANT) → FILE(VARCHAR, VARCHAR) → FILE

Geospatial functions (101)

FunctionKindStatusSignatures
H3_CELL_TO_BOUNDARYunknown❌ not supported—
H3_CELL_TO_CHILDRENunknown❌ not supported—
H3_CELL_TO_CHILDREN_STRINGunknown❌ not supported—
H3_CELL_TO_PARENTunknown❌ not supported—
H3_CELL_TO_POINTunknown❌ not supported—
H3_COMPACT_CELLSunknown❌ not supported—
H3_COMPACT_CELLS_STRINGSunknown❌ not supported—
H3_COVERAGEunknown❌ not supported—
H3_COVERAGE_STRINGSunknown❌ not supported—
H3_GET_RESOLUTIONunknown❌ not supported—
H3_GRID_DISKunknown❌ not supported—
H3_GRID_DISTANCEunknown❌ not supported—
H3_GRID_PATHunknown❌ not supported—
H3_INT_TO_STRINGunknown❌ not supported—
H3_IS_PENTAGONunknown❌ not supported—
H3_IS_VALID_CELLunknown❌ not supported—
H3_LATLNG_TO_CELLunknown❌ not supported—
H3_LATLNG_TO_CELL_STRINGunknown❌ not supported—
H3_POINT_TO_CELLunknown❌ not supported—
H3_POINT_TO_CELL_STRINGunknown❌ not supported—
H3_POLYGON_TO_CELLSunknown❌ not supported—
H3_POLYGON_TO_CELLS_STRINGSunknown❌ not supported—
H3_STRING_TO_INTunknown❌ not supported—
H3_TRY_COVERAGEunknown❌ not supported—
H3_TRY_COVERAGE_STRINGSunknown❌ not supported—
H3_TRY_GRID_DISTANCEunknown❌ not supported—
H3_TRY_GRID_PATHunknown❌ not supported—
H3_TRY_POLYGON_TO_CELLSunknown❌ not supported—
H3_TRY_POLYGON_TO_CELLS_STRINGSunknown❌ not supported—
H3_UNCOMPACT_CELLSunknown❌ not supported—
H3_UNCOMPACT_CELLS_STRINGSunknown❌ not supported—
HAVERSINEscalar✅ supported(FLOAT, FLOAT, FLOAT, FLOAT) → FLOAT
ST_AREAunknown❌ not supported—
ST_ASBINARYunknown❌ not supported—
ST_ASEWKBunknown❌ not supported—
ST_ASEWKTunknown❌ not supported—
ST_ASGEOJSONunknown❌ not supported—
ST_ASTEXTunknown❌ not supported—
ST_ASWKBunknown❌ not supported—
ST_ASWKTunknown❌ not supported—
ST_AZIMUTHunknown❌ not supported—
ST_BUFFERunknown❌ not supported—
ST_CENTROIDunknown❌ not supported—
ST_COLLECTunknown❌ not supported—
ST_CONTAINSunknown❌ not supported—
ST_COVEREDBYunknown❌ not supported—
ST_COVERSunknown❌ not supported—
ST_DIFFERENCEunknown❌ not supported—
ST_DIMENSIONunknown❌ not supported—
ST_DISJOINTunknown❌ not supported—
ST_DISTANCEunknown❌ not supported—
ST_DWITHINunknown❌ not supported—
ST_ENDPOINTunknown❌ not supported—
ST_ENVELOPEunknown❌ not supported—
ST_GEOGFROMGEOHASHunknown❌ not supported—
ST_GEOGPOINTFROMGEOHASHunknown❌ not supported—
ST_GEOGRAPHYFROMWKBunknown❌ not supported—
ST_GEOGRAPHYFROMWKTunknown❌ not supported—
ST_GEOHASHunknown❌ not supported—
ST_GEOMETRYFROMWKBunknown❌ not supported—
ST_GEOMETRYFROMWKTunknown❌ not supported—
ST_GEOMFROMGEOHASHunknown❌ not supported—
ST_GEOMPOINTunknown❌ not supported—
ST_GEOMPOINTFROMGEOHASHunknown❌ not supported—
ST_HAUSDORFFDISTANCEunknown❌ not supported—
ST_INTERPOLATEunknown❌ not supported—
ST_INTERSECTIONunknown❌ not supported—
ST_INTERSECTION_AGGunknown❌ not supported—
ST_INTERSECTSunknown❌ not supported—
ST_ISVALIDunknown❌ not supported—
ST_LENGTHunknown❌ not supported—
ST_MAKEGEOMPOINTunknown❌ not supported—
ST_MAKELINEunknown❌ not supported—
ST_MAKEPOINTunknown❌ not supported—
ST_MAKEPOLYGONunknown❌ not supported—
ST_MAKEPOLYGONORIENTEDunknown❌ not supported—
ST_NPOINTSunknown❌ not supported—
ST_NUMPOINTSunknown❌ not supported—
ST_PERIMETERunknown❌ not supported—
ST_POINTunknown❌ not supported—
ST_POINTNunknown❌ not supported—
ST_POLYGONunknown❌ not supported—
ST_SETSRIDunknown❌ not supported—
ST_SIMPLIFYunknown❌ not supported—
ST_SRIDunknown❌ not supported—
ST_STARTPOINTunknown❌ not supported—
ST_SYMDIFFERENCEunknown❌ not supported—
ST_TRANSFORMunknown❌ not supported—
ST_UNIONunknown❌ not supported—
ST_UNION_AGGunknown❌ not supported—
ST_WITHINunknown❌ not supported—
ST_Xunknown❌ not supported—
ST_XMAXunknown❌ not supported—
ST_XMINunknown❌ not supported—
ST_Yunknown❌ not supported—
ST_YMAXunknown❌ not supported—
ST_YMINunknown❌ not supported—
TO_GEOGRAPHYscalar✅ supported(ANY) → GEOGRAPHY(GEOMETRY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(VARIANT) → GEOGRAPHY
TO_GEOMETRYscalar✅ supported(ANY) → GEOMETRY(GEOGRAPHY) → GEOMETRY(VARCHAR) → GEOMETRY(VARIANT) → GEOMETRY
TRY_TO_GEOGRAPHYscalar✅ supported(ANY) → GEOGRAPHY(GEOMETRY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(VARIANT) → GEOGRAPHY
TRY_TO_GEOMETRYscalar✅ supported(ANY) → GEOMETRY(GEOGRAPHY) → GEOMETRY(VARCHAR) → GEOMETRY(VARIANT) → GEOMETRY

Hash functions (1)

FunctionKindStatusSignatures
HASHscalar✅ supported(ANY) → NUMBER

Information Schema (61)

FunctionKindStatusSignatures
ALERT_HISTORYunknown✅ supported—
APPLICATION_CALLBACK_HISTORYunknown❌ not supported—
APPLICATION_SPECIFICATION_STATUS_HISTORYunknown❌ not supported—
AUTOMATIC_CLUSTERING_HISTORYunknown❌ not supported—
AUTO_REFRESH_REGISTRATION_HISTORYunknown❌ not supported—
AVAILABLE_LISTINGSunknown❌ not supported—
AVAILABLE_LISTING_REFRESH_HISTORYunknown❌ not supported—
BIND_VALUESunknown❌ not supported—
COMPLETE_TASK_GRAPHSunknown❌ not supported—
COPY_HISTORYunknown❌ not supported—
CORTEX_SEARCH_REFRESH_HISTORYunknown❌ not supported—
CURRENT_TASK_GRAPHSunknown🟡 partial—
DATABASE_REFRESH_HISTORYunknown❌ not supported—
DATABASE_REFRESH_PROGRESSunknown❌ not supported—
DATABASE_REFRESH_PROGRESS_BY_JOBunknown❌ not supported—
DATABASE_REPLICATION_USAGE_HISTORYunknown❌ not supported—
DATABASE_STORAGE_USAGE_HISTORYunknown❌ not supported—
DATA_METRIC_FUNCTION_EXPECTATIONSunknown❌ not supported—
DATA_METRIC_FUNCTION_REFERENCESunknown✅ supported—
DATA_TRANSFER_HISTORYunknown❌ not supported—
DBT_PROJECT_EXECUTION_HISTORYunknown❌ not supported—
DYNAMIC_TABLESunknown✅ supported—
DYNAMIC_TABLE_GRAPH_HISTORYunknown❌ not supported—
DYNAMIC_TABLE_REFRESH_HISTORYunknown❌ not supported—
EXTERNAL_FUNCTIONS_HISTORYunknown❌ not supported—
EXTERNAL_TABLE_FILESunknown✅ supported—
EXTERNAL_TABLE_FILE_REGISTRATION_HISTORYunknown❌ not supported—
LISTING_REFRESH_HISTORYunknown❌ not supported—
LOGIN_HISTORYunknown❌ not supported—
LOGIN_HISTORY_BY_USERunknown❌ not supported—
MATERIALIZED_VIEW_REFRESH_HISTORYunknown❌ not supported—
NETWORK_RULE_REFERENCESunknown❌ not supported—
NOTIFICATION_HISTORYunknown❌ not supported—
ONLINE_FEATURE_TABLE_REFRESH_HISTORYunknown❌ not supported—
PIPE_USAGE_HISTORYunknown✅ supported—
POLICY_REFERENCESunknown✅ supported—
QUERY_ACCELERATION_HISTORYunknown❌ not supported—
QUERY_HISTORYunknown✅ supported—
QUERY_HISTORY_BY_SESSIONunknown✅ supported—
QUERY_HISTORY_BY_USERunknown✅ supported—
QUERY_HISTORY_BY_WAREHOUSEunknown❌ not supported—
REPLICATION_GROUP_DANGLING_REFERENCESunknown❌ not supported—
REPLICATION_GROUP_REFRESH_HISTORYunknown❌ not supported—
REPLICATION_GROUP_REFRESH_HISTORY_ALLunknown❌ not supported—
REPLICATION_GROUP_REFRESH_PROGRESSunknown❌ not supported—
REPLICATION_GROUP_REFRESH_PROGRESS_ALLunknown❌ not supported—
REPLICATION_GROUP_REFRESH_PROGRESS_BY_JOBunknown❌ not supported—
REPLICATION_GROUP_USAGE_HISTORYunknown❌ not supported—
REPLICATION_USAGE_HISTORYunknown❌ not supported—
SEARCH_OPTIMIZATION_HISTORYunknown❌ not supported—
SERVERLESS_ALERT_HISTORYunknown❌ not supported—
SERVERLESS_TASK_HISTORYunknown❌ not supported—
STAGE_DIRECTORY_FILE_REGISTRATION_HISTORYunknown❌ not supported—
STAGE_STORAGE_USAGE_HISTORYunknown❌ not supported—
TAG_REFERENCESunknown✅ supported—
TAG_REFERENCES_ALL_COLUMNSunknown✅ supported—
TASK_DEPENDENTSunknown❌ not supported—
TASK_HISTORYunknown✅ supported—
VALIDATE_PIPE_LOADtable✅ supported(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → TABLE
WAREHOUSE_LOAD_HISTORYunknown❌ not supported—
WAREHOUSE_METERING_HISTORYunknown❌ not supported—

LOCAL schema (2)

FunctionKindStatusSignatures
DATA_QUALITY_MONITORING_EXPECTATION_STATUSunknown❌ not supported—
DATA_QUALITY_MONITORING_RESULTSunknown❌ not supported—

Metadata functions (2)

FunctionKindStatusSignatures
GENERATE_COLUMN_DESCRIPTIONscalar✅ supported(ARRAY, VARCHAR) → VARCHAR
GET_DDLscalar✅ supported(VARCHAR, VARCHAR, BOOLEAN) → VARCHAR

Model monitor functions (3)

FunctionKindStatusSignatures
MODEL_MONITOR_DRIFT_METRICunknown❌ not supported—
MODEL_MONITOR_PERFORMANCE_METRICunknown❌ not supported—
MODEL_MONITOR_STAT_METRICunknown❌ not supported—

Notification functions (6)

FunctionKindStatusSignatures
APPLICATION_JSONunknown✅ supported—
EMAIL_INTEGRATION_CONFIGunknown✅ supported—
INTEGRATIONunknown✅ supported—
SANITIZE_WEBHOOK_CONTENTunknown✅ supported—
TEXT_HTMLunknown✅ supported—
TEXT_PLAINunknown✅ supported—

Numeric functions (37)

FunctionKindStatusSignatures
ABSscalar✅ supported(ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER
ACOSscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
ACOSHscalar✅ supported(FLOAT) → FLOAT
ASINscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
ASINHscalar✅ supported(FLOAT) → FLOAT
ATANscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
ATAN2scalar✅ supported(FLOAT, FLOAT) → FLOAT
ATANHscalar✅ supported(FLOAT) → FLOAT
CBRTscalar✅ supported(FLOAT) → FLOAT
CEILscalar✅ supported(ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(DECFLOAT, NUMBER) → DECFLOAT(FLOAT, NUMBER) → FLOAT(NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER) → NUMBER
COSscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
COSHscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
COTscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
DEGREESscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
DIV0scalar✅ supported(ANY, ANY) → NUMBER(FLOAT, FLOAT) → FLOAT(NUMBER, NUMBER) → NUMBER
DIV0NULLscalar✅ supported(ANY, ANY) → NUMBER(FLOAT, FLOAT) → FLOAT(NUMBER, NUMBER) → NUMBER
EXPscalar✅ supported(ANY) → FLOAT(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT
FACTORIALscalar✅ supported(ANY) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER
FLOORscalar✅ supported(ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(DECFLOAT, NUMBER) → DECFLOAT(FLOAT, NUMBER) → FLOAT(NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER) → NUMBER
LNscalar✅ supported(ANY) → FLOAT(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT
LOGscalar✅ supported(FLOAT, FLOAT) → FLOAT
MODscalar✅ supported(ANY, ANY) → NUMBER(DECFLOAT, DECFLOAT) → DECFLOAT(FLOAT, FLOAT) → FLOAT(NUMBER, NUMBER) → NUMBER
PIscalar✅ supported() → FLOAT
POWscalar✅ supported(ANY, ANY) → FLOAT(DECFLOAT, DECFLOAT) → DECFLOAT(FLOAT, FLOAT) → FLOAT
POWERscalar✅ supported(ANY, ANY) → FLOAT(DECFLOAT, DECFLOAT) → DECFLOAT(FLOAT, FLOAT) → FLOAT
RADIANSscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
ROUNDscalar✅ supported(ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(DECFLOAT, NUMBER) → DECFLOAT(FLOAT, NUMBER) → FLOAT(NUMBER, NUMBER) → NUMBER(ANY, ANY, ANY) → NUMBER(FLOAT, NUMBER, VARCHAR) → FLOAT(NUMBER, NUMBER, VARCHAR) → NUMBER
SIGNscalar✅ supported(ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER
SINscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
SINHscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
SQRTscalar✅ supported(ANY) → FLOAT(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT
SQUAREscalar✅ supported(FLOAT) → FLOAT
TANscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
TANHscalar✅ supported(ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT
TRUNCscalar✅ supported(ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(DATE, VARCHAR) → DATE(DECFLOAT, NUMBER) → DECFLOAT(FLOAT, NUMBER) → FLOAT(NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR) → NUMBER(TIME, VARCHAR) → TIME(TIMESTAMP_LTZ, VARCHAR) → TIMESTAMP_LTZ(TIMESTAMP_NTZ, VARCHAR) → TIMESTAMP_NTZ(TIMESTAMP_TZ, VARCHAR) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → VARCHAR
TRUNCATEscalar✅ supported(ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(DATE, VARCHAR) → DATE(DECFLOAT, NUMBER) → DECFLOAT(FLOAT, NUMBER) → FLOAT(NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR) → NUMBER(TIME, VARCHAR) → TIME(TIMESTAMP_LTZ, VARCHAR) → TIMESTAMP_LTZ(TIMESTAMP_NTZ, VARCHAR) → TIMESTAMP_NTZ(TIMESTAMP_TZ, VARCHAR) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → VARCHAR
WIDTH_BUCKETscalar✅ supported(ANY, ANY, ANY, ANY) → NUMBER(FLOAT, FLOAT, FLOAT, NUMBER) → NUMBER(NUMBER, NUMBER, NUMBER, NUMBER) → NUMBER

Organization user and organization user group functions (2)

FunctionKindStatusSignatures
IS_ORGANIZATION_USERunknown❌ not supported—
IS_ORGANIZATION_USER_GROUPunknown❌ not supported—

Other functions (26)

FunctionKindStatusSignatures
APPROX_QUANTILE_25unknown✅ supported—
APPROX_QUANTILE_50unknown✅ supported—
APPROX_QUANTILE_99unknown✅ supported—
CASE_FORMAT_VIOLATION_COUNTunknown✅ supported—
CASE_FORMAT_VIOLATION_PERCENTunknown✅ supported—
FUTURE_TIMESTAMP_COUNTunknown✅ supported—
FUTURE_TIMESTAMP_PERCENTunknown✅ supported—
GENERATE_POSTGRES_ACCESS_TOKEN_FOR_USERunknown❌ not supported—
INVALID_JSON_COUNTunknown✅ supported—
INVALID_JSON_PERCENTunknown✅ supported—
INVALID_NUMERIC_TYPE_CAST_COUNTunknown✅ supported—
INVALID_NUMERIC_TYPE_CAST_PERCENTunknown✅ supported—
NEGATIVE_COUNTunknown✅ supported—
NEGATIVE_PERCENTunknown✅ supported—
REFERENTIAL_INTEGRITY_COUNTunknown✅ supported—
SCHEMA_CHANGE_COUNTunknown✅ supported—
SPECIAL_CHARACTER_COUNTunknown✅ supported—
SPECIAL_CHARACTER_PERCENTunknown✅ supported—
STRING_LENGTH_AVGunknown✅ supported—
STRING_LENGTH_MAXunknown✅ supported—
STRING_LENGTH_MINunknown✅ supported—
UNTRIMMED_STRING_COUNTunknown✅ supported—
UNTRIMMED_STRING_PERCENTunknown✅ supported—
WEBHOOK_INTEGRATION_CONFIGunknown✅ supported—
ZERO_COUNTunknown✅ supported—
ZERO_PERCENTunknown✅ supported—

Semi-structured and structured data functions (92)

FunctionKindStatusSignatures
ARRAYS_OVERLAPscalar✅ supported(ARRAY, ARRAY) → BOOLEAN
ARRAYS_TO_OBJECTscalar✅ supported(ARRAY, ARRAY) → OBJECT
ARRAYS_ZIPscalar✅ supported(ANY) → ARRAY
ARRAY_APPENDscalar✅ supported(ARRAY, ANY) → ARRAY
ARRAY_CATscalar✅ supported(ARRAY, ARRAY) → ARRAY
ARRAY_COMPACTscalar✅ supported(ARRAY) → ARRAY
ARRAY_CONSTRUCTscalar✅ supported() → ARRAY(ANY) → ARRAY(SNOWFLAKE_ANY[]) → ARRAY(SNOWFLAKE_NULL[]) → ARRAY
ARRAY_CONSTRUCT_COMPACTscalar✅ supported() → ARRAY(ANY) → ARRAY(SNOWFLAKE_ANY[]) → ARRAY(SNOWFLAKE_NULL[]) → ARRAY
ARRAY_CONSTRUCT_STRUCTUREDscalar✅ supported(ANY) → ARRAY
ARRAY_CONTAINSscalar✅ supported(ANY, ARRAY) → BOOLEAN
ARRAY_DISTINCTscalar✅ supported(ARRAY) → ARRAY
ARRAY_EXCEPTscalar✅ supported(ARRAY, ARRAY) → ARRAY
ARRAY_FLATTENscalar✅ supported(ARRAY) → ARRAY
ARRAY_GENERATE_RANGEscalar✅ supported(ANY, ANY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, NUMBER, NUMBER) → ARRAY
ARRAY_INSERTscalar✅ supported(ARRAY, NUMBER, ANY) → ARRAY
ARRAY_INTERSECTIONscalar✅ supported(ARRAY, ARRAY) → ARRAY
ARRAY_MAXscalar✅ supported(ARRAY) → VARIANT
ARRAY_MINscalar✅ supported(ARRAY) → VARIANT
ARRAY_POSITIONscalar✅ supported(ANY, ARRAY) → NUMBER
ARRAY_PREPENDscalar✅ supported(ARRAY, ANY) → ARRAY
ARRAY_REMOVEscalar✅ supported(ARRAY, ANY) → ARRAY
ARRAY_REMOVE_ATscalar✅ supported(ARRAY, NUMBER) → ARRAY
ARRAY_REVERSEscalar✅ supported(ARRAY) → ARRAY
ARRAY_SIZEscalar✅ supported(ANY) → NUMBER(ARRAY) → NUMBER(VARIANT) → NUMBER
ARRAY_SLICEscalar✅ supported(ANY, ANY, ANY) → ARRAY(ARRAY, NUMBER, NUMBER) → ARRAY(ARRAY, NUMBER, VARCHAR) → ARRAY(ARRAY, VARCHAR, NUMBER) → ARRAY(ARRAY, VARCHAR, VARCHAR) → ARRAY
ARRAY_SORTscalar✅ supported(ANY) → ARRAY(ARRAY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, BOOLEAN, BOOLEAN) → ARRAY
ARRAY_TO_STRINGscalar✅ supported(ARRAY, VARCHAR) → VARCHAR
AS_ARRAYscalar✅ supported(VARIANT) → ARRAY
AS_BINARYscalar✅ supported(VARIANT) → BINARY
AS_BOOLEANscalar✅ supported(VARIANT) → BOOLEAN
AS_CHARscalar✅ supported(VARIANT) → VARCHAR
AS_DATEscalar✅ supported(VARIANT) → DATE
AS_DECIMALscalar✅ supported(ANY) → NUMBER(VARIANT) → NUMBER(VARIANT, NUMBER, NUMBER) → NUMBER
AS_DOUBLEscalar✅ supported(VARIANT) → FLOAT
AS_INTEGERscalar✅ supported(VARIANT) → NUMBER
AS_NUMBERscalar✅ supported(ANY) → NUMBER(VARIANT) → NUMBER(VARIANT, NUMBER, NUMBER) → NUMBER
AS_OBJECTscalar✅ supported(VARIANT) → OBJECT
AS_REALscalar✅ supported(VARIANT) → FLOAT
AS_TIMEscalar✅ supported(VARIANT) → TIME
AS_TIMESTAMP_LTZscalar✅ supported(VARIANT) → TIMESTAMP_LTZ
AS_TIMESTAMP_NTZscalar✅ supported(VARIANT) → TIMESTAMP_NTZ
AS_TIMESTAMP_TZscalar✅ supported(VARIANT) → TIMESTAMP_TZ
AS_VARCHARscalar✅ supported(VARIANT) → VARCHAR
CHECK_JSONscalar✅ supported(VARCHAR) → VARCHAR
CHECK_XMLscalar✅ supported(VARCHAR) → VARCHAR
FILTERunknown✅ supported—
GETscalar✅ supported(ANY, ANY) → VARIANT(ARRAY, NUMBER) → VARIANT(ARRAY, VARCHAR) → VARIANT(OBJECT, NUMBER) → VARIANT(OBJECT, VARCHAR) → VARIANT(VARIANT, NUMBER) → VARIANT(VARIANT, VARCHAR) → VARIANT
GET_IGNORE_CASEscalar✅ supported(ANY, ANY) → VARIANT(OBJECT, VARCHAR) → VARIANT(VARIANT, VARCHAR) → VARIANT
GET_PATHscalar✅ supported(VARIANT, VARCHAR) → VARIANT
IS_ARRAYscalar✅ supported(ANY) → BOOLEAN(ARRAY) → BOOLEAN(OBJECT) → BOOLEAN(VARIANT) → BOOLEAN
IS_BINARYscalar✅ supported(VARIANT) → BOOLEAN
IS_BOOLEANscalar✅ supported(VARIANT) → BOOLEAN
IS_CHARscalar✅ supported(VARIANT) → BOOLEAN
IS_DATEscalar✅ supported(VARIANT) → BOOLEAN
IS_DATE_VALUEscalar✅ supported(VARIANT) → BOOLEAN
IS_DECIMALscalar✅ supported(VARIANT) → BOOLEAN
IS_DOUBLEscalar✅ supported(VARIANT) → BOOLEAN
IS_INTEGERscalar✅ supported(VARIANT) → BOOLEAN
IS_NULL_VALUEscalar✅ supported(VARIANT) → BOOLEAN
IS_OBJECTscalar✅ supported(ANY) → BOOLEAN(ARRAY) → BOOLEAN(OBJECT) → BOOLEAN(VARIANT) → BOOLEAN
IS_REALscalar✅ supported(VARIANT) → BOOLEAN
IS_TIMEscalar✅ supported(VARIANT) → BOOLEAN
IS_TIMESTAMP_LTZscalar✅ supported(VARIANT) → BOOLEAN
IS_TIMESTAMP_NTZscalar✅ supported(VARIANT) → BOOLEAN
IS_TIMESTAMP_TZscalar✅ supported(VARIANT) → BOOLEAN
IS_VARCHARscalar✅ supported(VARIANT) → BOOLEAN
JSON_EXTRACT_PATH_TEXTscalar✅ supported(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
MAP_CATscalar✅ supported(OBJECT, OBJECT) → OBJECT
MAP_CONSTRUCTscalar✅ supported(ANY) → MAP
MAP_CONTAINS_KEYscalar✅ supported(VARCHAR, OBJECT) → BOOLEAN
MAP_DELETEscalar✅ supported(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT
MAP_ENTRIESscalar✅ supported(ANY) → ARRAY(MAP) → ARRAY(OBJECT) → ARRAY
MAP_INSERTscalar✅ supported(ANY, ANY, ANY) → OBJECT(OBJECT, VARCHAR, ANY) → OBJECT(ANY, ANY, ANY, ANY) → OBJECT(OBJECT, VARCHAR, ANY, BOOLEAN) → OBJECT
MAP_KEYSscalar✅ supported(OBJECT) → ARRAY
MAP_PICKscalar✅ supported(ANY, ANY) → OBJECT(OBJECT, ARRAY) → OBJECT(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT
MAP_SIZEscalar✅ supported(OBJECT) → NUMBER
OBJECT_CONSTRUCTscalar✅ supported() → OBJECT(ANY) → OBJECT(SNOWFLAKE_ANY[]) → OBJECT(SNOWFLAKE_NULL[]) → OBJECT
OBJECT_CONSTRUCT_KEEP_NULLscalar✅ supported() → OBJECT(ANY) → OBJECT(SNOWFLAKE_ANY[]) → OBJECT(SNOWFLAKE_NULL[]) → OBJECT
OBJECT_CONSTRUCT_KEEP_NULL_STRUCTUREDscalar✅ supported(ANY) → OBJECT
OBJECT_DELETEscalar✅ supported(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT
OBJECT_INSERTscalar✅ supported(ANY, ANY, ANY) → OBJECT(OBJECT, VARCHAR, ANY) → OBJECT(ANY, ANY, ANY, ANY) → OBJECT(OBJECT, VARCHAR, ANY, BOOLEAN) → OBJECT
OBJECT_KEYSscalar✅ supported(ANY) → ARRAY(OBJECT) → ARRAY(VARIANT) → ARRAY
OBJECT_PICKscalar✅ supported(ANY, ANY) → OBJECT(OBJECT, ARRAY) → OBJECT(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT
PARSE_JSONscalar✅ supported(ANY) → VARIANT(VARCHAR) → VARIANT(VARCHAR, VARCHAR) → VARIANT
PARSE_XMLscalar✅ supported(VARCHAR) → VARIANT
PROMPTunknown❌ not supported—
REDUCEunknown✅ supported—
STRIP_NULL_VALUEscalar✅ supported(VARIANT) → VARIANT
TRANSFORMunknown✅ supported—
TRY_PARSE_JSONscalar✅ supported(ANY) → VARIANT(VARCHAR) → VARIANT(VARCHAR, VARCHAR) → VARIANT
TYPEOFscalar✅ supported(VARIANT) → VARCHAR
XMLGETscalar✅ supported(ANY, ANY) → VARIANT(VARIANT, VARCHAR) → VARIANT(ANY, ANY, ANY) → VARIANT(VARIANT, VARCHAR, NUMBER) → VARIANT

String & binary functions (103)

FunctionKindStatusSignatures
AGENT_RUNunknown❌ not supported—
AI_CLASSIFYunknown❌ not supported—
AI_COMPLETEunknown❌ not supported—
AI_COUNT_TOKENSunknown❌ not supported—
AI_EMBEDunknown❌ not supported—
AI_EXTRACTunknown❌ not supported—
AI_FILTERunknown❌ not supported—
AI_MULTI_EMBEDunknown❌ not supported—
AI_PARSE_DOCUMENTunknown❌ not supported—
AI_REDACTunknown❌ not supported—
AI_SENTIMENTunknown❌ not supported—
AI_SIMILARITYunknown❌ not supported—
AI_TRANSLATEunknown❌ not supported—
ASCIIscalar✅ supported(VARCHAR) → NUMBER
BASE64_DECODE_BINARYscalar✅ supported(ANY) → BINARY(VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY
BASE64_DECODE_STRINGscalar✅ supported(ANY) → VARCHAR(VARCHAR) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
BASE64_ENCODEscalar✅ supported(ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → VARCHAR(VARCHAR, NUMBER) → VARCHAR(ANY, NUMBER, VARCHAR) → VARCHAR(BINARY, NUMBER, VARCHAR) → VARCHAR(VARCHAR, NUMBER, VARCHAR) → VARCHAR
BIT_LENGTHscalar✅ supported(ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER
CHARscalar✅ supported(NUMBER) → VARCHAR
CHARINDEXscalar✅ supported(ANY, ANY) → NUMBER(BINARY, BINARY) → NUMBER(VARCHAR, VARCHAR) → NUMBER(ANY, ANY, NUMBER) → NUMBER(BINARY, BINARY, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER
CHRscalar✅ supported(NUMBER) → VARCHAR
CLASSIFY_TEXTunknown❌ not supported—
COLLATEsyntax✅ supported—
COLLATIONunknown❌ not supported—
COMPLETEunknown❌ not supported—
COMPRESSscalar✅ supported(ANY, VARCHAR) → BINARY(BINARY, VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY
CONCATscalar✅ supported(SNOWFLAKE_ANY[]) → VARCHAR(SNOWFLAKE_BINARY[]) → BINARY(SNOWFLAKE_NULL[]) → VARCHAR(SNOWFLAKE_VARCHAR[]) → VARCHAR
CONCAT_WSscalar✅ supported(BINARY) → BINARY(VARCHAR) → VARCHAR(ANY, SNOWFLAKE_ANY[]) → VARCHAR(BINARY, SNOWFLAKE_BINARY[]) → BINARY(VARCHAR, SNOWFLAKE_VARCHAR[]) → VARCHAR
CONTAINSscalar✅ supported(ANY, ANY) → BOOLEAN(BINARY, BINARY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN
COUNT_TOKENSunknown❌ not supported—
DATA_AGENT_RUNunknown❌ not supported—
DECOMPRESS_BINARYscalar✅ supported(BINARY, VARCHAR) → BINARY
DECOMPRESS_STRINGscalar✅ supported(BINARY, VARCHAR) → VARCHAR
EDITDISTANCEscalar✅ supported(ANY, ANY) → NUMBER(VARCHAR, VARCHAR) → NUMBER(ANY, ANY, ANY) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER
EMBED_TEXT_1024unknown❌ not supported—
EMBED_TEXT_768unknown❌ not supported—
ENDSWITHscalar✅ supported(ANY, ANY) → BOOLEAN(BINARY, BINARY) → BOOLEAN(BINARY, VARCHAR) → BOOLEAN(VARCHAR, BINARY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN
ENTITY_SENTIMENTunknown❌ not supported—
EXTRACT_ANSWERunknown❌ not supported—
FINETUNEunknown❌ not supported—
HEX_DECODE_BINARYscalar✅ supported(VARCHAR) → BINARY
HEX_DECODE_STRINGscalar✅ supported(VARCHAR) → VARCHAR
HEX_ENCODEscalar✅ supported(ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → VARCHAR(VARCHAR, NUMBER) → VARCHAR
INITCAPscalar✅ supported(ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
INSERTscalar✅ supported(VARCHAR, NUMBER, NUMBER, VARCHAR) → VARCHAR
JAROWINKLER_SIMILARITYscalar✅ supported(VARCHAR, VARCHAR) → NUMBER
LEFTscalar✅ supported(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR
LENscalar✅ supported(ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER
LENGTHscalar✅ supported(ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER
LOWERscalar✅ supported(VARCHAR) → VARCHAR
LPADscalar✅ supported(ANY, ANY) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR(ANY, ANY, ANY) → VARCHAR(BINARY, NUMBER, BINARY) → BINARY(VARCHAR, NUMBER, VARCHAR) → VARCHAR
LTRIMscalar✅ supported(ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
MD5scalar✅ supported(ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR
MD5_BINARYscalar✅ supported(ANY) → BINARY(BINARY) → BINARY(VARCHAR) → BINARY
MD5_HEXscalar✅ supported(ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR
MD5_NUMBER_LOWER64scalar✅ supported(ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER
MD5_NUMBER_UPPER64scalar✅ supported(ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER
OCTET_LENGTHscalar✅ supported(ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER
PARSE_IPscalar✅ supported(VARCHAR, VARCHAR) → OBJECT
PARSE_URLscalar✅ supported(ANY) → OBJECT(BINARY) → OBJECT(VARCHAR) → OBJECT(ANY, ANY) → OBJECT(VARCHAR, BOOLEAN) → OBJECT(VARCHAR, NUMBER) → OBJECT(VARCHAR, VARCHAR) → OBJECT(VARCHAR, VARIANT) → OBJECT
POSITIONscalar✅ supported(ANY, ANY) → NUMBER(BINARY, BINARY) → NUMBER(VARCHAR, VARCHAR) → NUMBER(ANY, ANY, NUMBER) → NUMBER(BINARY, BINARY, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER
REPEATscalar✅ supported(ANY, ANY) → VARCHAR(VARCHAR, ANY) → VARCHAR(VARCHAR, NUMBER) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
REPLACEscalar✅ supported(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(ANY, ANY, ANY) → VARCHAR(VARCHAR, VARCHAR, VARCHAR) → VARCHAR
REVERSEscalar✅ supported(ANY) → VARCHAR(BINARY) → BINARY(VARCHAR) → VARCHAR
RIGHTscalar✅ supported(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR
RPADscalar✅ supported(ANY, ANY) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR(ANY, ANY, ANY) → VARCHAR(BINARY, NUMBER, BINARY) → BINARY(VARCHAR, NUMBER, VARCHAR) → VARCHAR
RTRIMscalar✅ supported(ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
RTRIMMED_LENGTHscalar✅ supported(ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER(VARCHAR, VARCHAR) → NUMBER
SEARCHunknown❌ not supported—
SEARCH_IPunknown❌ not supported—
SEARCH_PREVIEWunknown❌ not supported—
SENTIMENTunknown❌ not supported—
SHA1scalar✅ supported(VARCHAR) → VARCHAR
SHA1_BINARYscalar✅ supported(VARCHAR) → BINARY
SHA1_HEXscalar✅ supported(VARCHAR) → VARCHAR
SHA2scalar✅ supported(ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → VARCHAR(VARCHAR, NUMBER) → VARCHAR
SHA2_BINARYscalar✅ supported(ANY) → BINARY(BINARY) → BINARY(VARCHAR) → BINARY(ANY, NUMBER) → BINARY(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → BINARY
SHA2_HEXscalar✅ supported(ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → VARCHAR(VARCHAR, NUMBER) → VARCHAR
SOUNDEXscalar✅ supported(VARCHAR) → VARCHAR
SOUNDEX_P123scalar✅ supported(ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
SPACEscalar✅ supported(NUMBER) → VARCHAR
SPLITscalar✅ supported(VARCHAR, VARCHAR) → ARRAY
SPLIT_PARTscalar✅ supported(VARCHAR, VARCHAR, NUMBER) → VARCHAR
SPLIT_TEXT_MARKDOWN_HEADERunknown❌ not supported—
SPLIT_TEXT_RECURSIVE_CHARACTERunknown❌ not supported—
SPLIT_TO_TABLEtable✅ supported(VARCHAR, VARCHAR) → TABLE
STARTSWITHscalar✅ supported(ANY, ANY) → BOOLEAN(BINARY, BINARY) → BOOLEAN(BINARY, VARCHAR) → BOOLEAN(VARCHAR, BINARY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN
STRTOKscalar✅ supported(ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(ANY, ANY, ANY) → VARCHAR(VARCHAR, VARCHAR, NUMBER) → VARCHAR
STRTOK_SPLIT_TO_TABLEtable✅ supported(VARCHAR, VARCHAR) → TABLE
STRTOK_TO_ARRAYscalar✅ supported(ANY) → ARRAY(VARCHAR) → ARRAY(ANY, ANY) → ARRAY(VARCHAR, VARCHAR) → ARRAY
SUBSTRscalar✅ supported(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR(ANY, NUMBER, NUMBER) → VARCHAR(BINARY, NUMBER, NUMBER) → BINARY(VARCHAR, NUMBER, NUMBER) → VARCHAR
SUBSTRINGscalar✅ supported(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR(ANY, NUMBER, NUMBER) → VARCHAR(BINARY, NUMBER, NUMBER) → BINARY(VARCHAR, NUMBER, NUMBER) → VARCHAR
SUMMARIZEunknown❌ not supported—
TRANSLATEscalar✅ supported(VARCHAR, VARCHAR, VARCHAR) → VARCHAR
TRIMscalar✅ supported(ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
TRY_BASE64_DECODE_BINARYscalar✅ supported(ANY) → BINARY(VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY
TRY_BASE64_DECODE_STRINGscalar✅ supported(ANY) → VARCHAR(VARCHAR) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
TRY_COMPLETEunknown❌ not supported—
TRY_HEX_DECODE_BINARYscalar✅ supported(VARCHAR) → BINARY
TRY_HEX_DECODE_STRINGscalar✅ supported(VARCHAR) → VARCHAR
UNICODEscalar✅ supported(VARCHAR) → NUMBER
UPPERscalar✅ supported(VARCHAR) → VARCHAR
UUID_STRINGscalar✅ supported() → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR

String functions (regular expressions) (8)

FunctionKindStatusSignatures
REGEXPsyntax✅ supported—
REGEXP_COUNTscalar✅ supported(ANY, ANY) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, VARCHAR) → NUMBER
REGEXP_INSTRscalar✅ supported(ANY, ANY) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER, NUMBER, VARCHAR) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER, NUMBER, VARCHAR, NUMBER) → NUMBER
REGEXP_LIKEscalar✅ supported(ANY, ANY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARCHAR, VARCHAR) → BOOLEAN
REGEXP_REPLACEscalar✅ supported(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(VARCHAR, VARCHAR, VARCHAR) → VARCHAR(VARCHAR, VARCHAR, VARCHAR, NUMBER) → VARCHAR(VARCHAR, VARCHAR, VARCHAR, NUMBER, NUMBER) → VARCHAR(VARCHAR, VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR) → VARCHAR
REGEXP_SUBSTRscalar✅ supported(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(VARCHAR, VARCHAR, NUMBER) → VARCHAR(VARCHAR, VARCHAR, NUMBER, NUMBER) → VARCHAR(VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR) → VARCHAR(VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR, NUMBER) → VARCHAR
REGEXP_SUBSTR_ALLscalar✅ supported(ANY, ANY) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARCHAR, NUMBER) → ARRAY(VARCHAR, VARCHAR, NUMBER, NUMBER) → ARRAY(VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR) → ARRAY(VARCHAR, VARCHAR, NUMBER, NUMBER, VARCHAR, NUMBER) → ARRAY
RLIKEscalar✅ supported(ANY, ANY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARCHAR, VARCHAR) → BOOLEAN

System functions (209)

FunctionKindStatusSignatures
EXECUTE_AI_EVALUATIONunknown❌ not supported—
EXPLAIN_JSONunknown❌ not supported—
EXTRACT_SEMANTIC_CATEGORIESunknown❌ not supported—
GET_ANACONDA_PACKAGES_REPODATAunknown❌ not supported—
GET_PYTHON_PROFILER_OUTPUTunknown❌ not supported—
GET_QUERY_OPERATOR_STATSunknown❌ not supported—
SHOW_PYTHON_PACKAGES_DEPENDENCIESunknown❌ not supported—
SYSTEM$ABORT_SESSIONunknown❌ not supported—
SYSTEM$ABORT_TRANSACTIONunknown❌ not supported—
SYSTEM$ACTIVATE_CMK_INFOunknown❌ not supported—
SYSTEM$ACTIVATE_CMK_INFO_POSTGRESunknown❌ not supported—
SYSTEM$ADD_EVENTunknown❌ not supported—
SYSTEM$ADD_REFERENCEunknown❌ not supported—
SYSTEM$ALLOWLISTscalar✅ supported() → VARCHAR
SYSTEM$ALLOWLIST_PRIVATELINKunknown❌ not supported—
SYSTEM$APPLICATION_GET_LOG_LEVELunknown❌ not supported—
SYSTEM$APPLICATION_GET_METRIC_LEVELunknown❌ not supported—
SYSTEM$APPLICATION_GET_TRACE_LEVELunknown❌ not supported—
SYSTEM$APP_COMPATIBILITY_CHECKunknown❌ not supported—
SYSTEM$AUTHORIZE_PRIVATELINKunknown❌ not supported—
SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESSunknown❌ not supported—
SYSTEM$AUTO_REFRESH_STATUSunknown❌ not supported—
SYSTEM$BEGIN_DEBUG_APPLICATIONunknown❌ not supported—
SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUSunknown❌ not supported—
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESSunknown❌ not supported—
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS_WITH_EXCEPTIONunknown❌ not supported—
SYSTEM$CANCEL_ALL_QUERIESscalar✅ supported(ANY) → VARCHAR(NUMBER) → VARCHAR(VARCHAR) → VARCHAR
SYSTEM$CANCEL_QUERYunknown✅ supported—
SYSTEM$CATALOG_LINK_STATUSunknown❌ not supported—
SYSTEM$CKE_HASH_FUNCTIONunknown❌ not supported—
SYSTEM$CLEANUP_DATABASE_ROLE_GRANTSunknown❌ not supported—
SYSTEM$CLIENT_VERSION_INFOscalar✅ supported() → VARCHAR
SYSTEM$CLIENT_VULNERABILITY_INFOunknown❌ not supported—
SYSTEM$CLUSTERING_DEPTHunknown❌ not supported—
SYSTEM$CLUSTERING_INFORMATIONunknown❌ not supported—
SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNTunknown❌ not supported—
SYSTEM$CONVERT_PIPES_SQS_TO_SNSunknown❌ not supported—
SYSTEM$CREATE_BILLING_EVENTunknown❌ not supported—
SYSTEM$CREATE_BILLING_EVENTSunknown❌ not supported—
SYSTEM$CURRENT_USER_TASK_NAMEunknown❌ not supported—
SYSTEM$DATA_METRIC_SCANunknown✅ supported—
SYSTEM$DEACTIVATE_CMK_INFOunknown❌ not supported—
SYSTEM$DECODE_PATunknown❌ not supported—
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINTunknown❌ not supported—
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT_TSSunknown❌ not supported—
SYSTEM$DEREGISTER_CMK_INFOunknown❌ not supported—
SYSTEM$DEREGISTER_CMK_INFO_POSTGRESunknown❌ not supported—
SYSTEM$DESC_ICEBERG_ACCESS_IDENTITYunknown❌ not supported—
SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLEunknown❌ not supported—
SYSTEM$DISABLE_DATABASE_REPLICATIONunknown❌ not supported—
SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNTunknown❌ not supported—
SYSTEM$DISABLE_PREVIEW_ACCESSunknown❌ not supported—
SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLYunknown❌ not supported—
SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLEunknown❌ not supported—
SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNTunknown❌ not supported—
SYSTEM$ENABLE_PREVIEW_ACCESSunknown❌ not supported—
SYSTEM$ENCODE_CKE_PRIMARY_KEYunknown❌ not supported—
SYSTEM$END_DEBUG_APPLICATIONunknown❌ not supported—
SYSTEM$ENFORCE_PRIVATELINK_ACCESS_ONLYunknown❌ not supported—
SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTSunknown❌ not supported—
SYSTEM$ESTIMATE_QUERY_ACCELERATIONunknown❌ not supported—
SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTSunknown❌ not supported—
SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONSunknown✅ supported—
SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS_PERSIST_RESULTunknown✅ supported—
SYSTEM$EXPLAIN_JSON_TO_TEXTunknown❌ not supported—
SYSTEM$EXPLAIN_PLAN_JSONunknown❌ not supported—
SYSTEM$EXPORT_TDS_FROM_SEMANTIC_VIEWunknown❌ not supported—
SYSTEM$EXTERNAL_TABLE_PIPE_STATUSunknown❌ not supported—
SYSTEM$FINISH_OAUTH_FLOWunknown❌ not supported—
SYSTEM$GENERATE_SAML_CSRunknown❌ not supported—
SYSTEM$GENERATE_SCIM_ACCESS_TOKENunknown❌ not supported—
SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDESunknown❌ not supported—
SYSTEM$GET_ALL_REFERENCESunknown❌ not supported—
SYSTEM$GET_AWS_SNS_IAM_POLICYunknown❌ not supported—
SYSTEM$GET_CATALOG_LINKED_DATABASE_CONFIGunknown❌ not supported—
SYSTEM$GET_CLASSIFICATION_RESULTunknown❌ not supported—
SYSTEM$GET_CMK_AKV_CONSENT_URLunknown❌ not supported—
SYSTEM$GET_CMK_CONFIGunknown❌ not supported—
SYSTEM$GET_CMK_CONFIG_POSTGRESunknown❌ not supported—
SYSTEM$GET_CMK_INFOunknown❌ not supported—
SYSTEM$GET_CMK_INFO_POSTGRESunknown❌ not supported—
SYSTEM$GET_CMK_KMS_KEY_POLICYunknown❌ not supported—
SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCEunknown❌ not supported—
SYSTEM$GET_DBT_LOGunknown❌ not supported—
SYSTEM$GET_DEBUG_STATUSunknown❌ not supported—
SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMANDunknown❌ not supported—
SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECTunknown❌ not supported—
SYSTEM$GET_DIRECTORY_TABLE_STATUSunknown❌ not supported—
SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMDunknown❌ not supported—
SYSTEM$GET_HASH_FOR_APPLICATIONunknown❌ not supported—
SYSTEM$GET_ICEBERG_TABLE_INFORMATIONunknown❌ not supported—
SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPSunknown❌ not supported—
SYSTEM$GET_LOGIN_FAILURE_DETAILSunknown❌ not supported—
SYSTEM$GET_PREDECESSOR_RETURN_VALUEunknown❌ not supported—
SYSTEM$GET_PREVIEW_ACCESS_STATUSunknown❌ not supported—
SYSTEM$GET_PRIVATELINKunknown❌ not supported—
SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTSunknown❌ not supported—
SYSTEM$GET_PRIVATELINK_CONFIGunknown❌ not supported—
SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFOunknown❌ not supported—
SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONSunknown❌ not supported—
SYSTEM$GET_PURCHASE_ATTRIBUTESunknown❌ not supported—
SYSTEM$GET_REFERENCED_OBJECT_ID_HASHunknown❌ not supported—
SYSTEM$GET_RESULTSET_STATUSunknown❌ not supported—
SYSTEM$GET_SERVICE_DNS_DOMAINunknown❌ not supported—
SYSTEM$GET_SERVICE_LOGSunknown❌ not supported—
SYSTEM$GET_SNOWFLAKE_EGRESS_IP_RANGESunknown❌ not supported—
SYSTEM$GET_SNOWFLAKE_PLATFORM_INFOunknown❌ not supported—
SYSTEM$GET_STAGE_PRIVATELINK_AUTHORIZED_ENDPOINTSunknown❌ not supported—
SYSTEM$GET_TAGscalar✅ supported(VARCHAR, VARCHAR, VARCHAR) → VARCHAR
SYSTEM$GET_TAG_ALLOWED_VALUESunknown❌ not supported—
SYSTEM$GET_TAG_ON_CURRENT_COLUMNunknown❌ not supported—
SYSTEM$GET_TAG_ON_CURRENT_TABLEunknown❌ not supported—
SYSTEM$GET_TASK_GRAPH_CONFIGunknown❌ not supported—
SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETERunknown❌ not supported—
SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNTunknown❌ not supported—
SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNTunknown❌ not supported—
SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUSunknown❌ not supported—
SYSTEM$IS_APPLICATION_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLEDunknown❌ not supported—
SYSTEM$IS_APPLICATION_AUTHORIZED_FOR_TELEMETRY_EVENT_SHARINGunknown❌ not supported—
SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNTunknown❌ not supported—
SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDERunknown❌ not supported—
SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNTunknown❌ not supported—
SYSTEM$IS_LISTING_PURCHASEDunknown❌ not supported—
SYSTEM$IS_LISTING_TRIALunknown❌ not supported—
SYSTEM$LAST_CHANGE_COMMIT_TIMEunknown❌ not supported—
SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAMEunknown❌ not supported—
SYSTEM$LINK_ORGANIZATION_USERunknown❌ not supported—
SYSTEM$LINK_ORGANIZATION_USER_GROUPunknown❌ not supported—
SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURESunknown❌ not supported—
SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOGunknown❌ not supported—
SYSTEM$LIST_NAMESPACES_FROM_CATALOGunknown❌ not supported—
SYSTEM$LOCATE_DBT_ARCHIVEunknown❌ not supported—
SYSTEM$LOCATE_DBT_ARTIFACTSunknown❌ not supported—
SYSTEM$LOGunknown🟡 partial—
SYSTEM$LOG_DEBUGunknown✅ supported—
SYSTEM$LOG_ERRORunknown✅ supported—
SYSTEM$LOG_FATALunknown✅ supported—
SYSTEM$LOG_INFOunknown✅ supported—
SYSTEM$LOG_TRACEunknown✅ supported—
SYSTEM$LOG_WARNunknown✅ supported—
SYSTEM$MIGRATE_SAML_IDP_REGISTRATIONunknown❌ not supported—
SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGSunknown❌ not supported—
SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGSunknown❌ not supported—
SYSTEM$OPT_OUT_MALICIOUS_IP_PROTECTION_BY_CATEGORYunknown❌ not supported—
SYSTEM$PIPE_FORCE_RESUMEscalar✅ supported(VARCHAR, VARCHAR) → VARCHAR
SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNELunknown❌ not supported—
SYSTEM$PIPE_STATUSscalar✅ supported(VARCHAR) → VARCHAR
SYSTEM$PROVISION_PRIVATELINK_ENDPOINTunknown❌ not supported—
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT_TSSunknown❌ not supported—
SYSTEM$QUERY_REFERENCEunknown❌ not supported—
SYSTEM$READ_OSI_YAML_FROM_SEMANTIC_VIEWunknown❌ not supported—
SYSTEM$READ_YAML_FROM_SEMANTIC_VIEWunknown❌ not supported—
SYSTEM$REFERENCEunknown❌ not supported—
SYSTEM$REGISTER_CMK_INFOunknown❌ not supported—
SYSTEM$REGISTER_CMK_INFO_POSTGRESunknown❌ not supported—
SYSTEM$REGISTER_PRIVATELINK_ENDPOINTunknown❌ not supported—
SYSTEM$REMOVE_ALL_REFERENCESunknown❌ not supported—
SYSTEM$REMOVE_REFERENCEunknown❌ not supported—
SYSTEM$REPORT_HEALTH_STATUSunknown❌ not supported—
SYSTEM$RESOLVE_PYTHON_PACKAGESunknown❌ not supported—
SYSTEM$RESTORE_PRIVATELINK_ENDPOINTunknown❌ not supported—
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT_TSSunknown❌ not supported—
SYSTEM$REVOKE_PRIVATELINKunknown❌ not supported—
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESSunknown❌ not supported—
SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESHunknown❌ not supported—
SYSTEM$SEND_NOTIFICATIONS_TO_CATALOGunknown❌ not supported—
SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESSunknown❌ not supported—
SYSTEM$SET_CATALOG_INTEGRATIONunknown❌ not supported—
SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMANDunknown❌ not supported—
SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECTunknown❌ not supported—
SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGIONunknown❌ not supported—
SYSTEM$SET_PRIVATELINK_ENDPOINT_HOSTNAMEunknown❌ not supported—
SYSTEM$SET_REFERENCEunknown❌ not supported—
SYSTEM$SET_RETURN_VALUEunknown❌ not supported—
SYSTEM$SET_ROW_TIMESTAMP_ON_ALL_SUPPORTED_TABLESunknown❌ not supported—
SYSTEM$SET_SPAN_ATTRIBUTESunknown❌ not supported—
SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLESunknown❌ not supported—
SYSTEM$SHOW_BUDGETS_FOR_RESOURCEunknown❌ not supported—
SYSTEM$SHOW_BUDGETS_IN_ACCOUNTunknown❌ not supported—
SYSTEM$SHOW_EVENT_SHARING_ACCOUNTSunknown❌ not supported—
SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUSunknown❌ not supported—
SYSTEM$SHOW_OAUTH_CLIENT_SECRETSunknown❌ not supported—
SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIESunknown❌ not supported—
SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKENunknown❌ not supported—
SYSTEM$START_OAUTH_FLOWunknown❌ not supported—
SYSTEM$START_USER_EMAIL_VERIFICATIONunknown❌ not supported—
SYSTEM$STREAM_GET_TABLE_TIMESTAMPunknown❌ not supported—
SYSTEM$STREAM_HAS_DATAunknown❌ not supported—
SYSTEM$SUPPORTED_DBT_VERSIONSunknown❌ not supported—
SYSTEM$TASK_DEPENDENTS_ENABLEscalar✅ supported(VARCHAR) → VARCHAR
SYSTEM$TASK_RUNTIME_INFOunknown❌ not supported—
SYSTEM$TRIGGER_LISTING_REFRESHunknown❌ not supported—
SYSTEM$TYPEOFscalar✅ supported(ANY) → VARCHAR(ARRAY) → VARCHAR(BINARY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(DECFLOAT) → VARCHAR(FILE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(OBJECT) → VARCHAR(SNOWFLAKE_UUID) → VARCHAR(TIME) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR
SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESSunknown❌ not supported—
SYSTEM$UNLINK_ORGANIZATION_USERunknown❌ not supported—
SYSTEM$UNLINK_ORGANIZATION_USER_GROUPunknown❌ not supported—
SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINTunknown❌ not supported—
SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMANDunknown❌ not supported—
SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECTunknown❌ not supported—
SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGIONunknown❌ not supported—
SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONSunknown❌ not supported—
SYSTEM$VALIDATE_STORAGE_INTEGRATIONunknown❌ not supported—
SYSTEM$VERIFY_CATALOG_INTEGRATIONscalar✅ supported(ANY) → VARCHAR(VARCHAR) → VARCHAR
SYSTEM$VERIFY_CMK_INFOunknown❌ not supported—
SYSTEM$VERIFY_CMK_INFO_POSTGRESunknown❌ not supported—
SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKENunknown❌ not supported—
SYSTEM$VERIFY_EXTERNAL_VOLUMEunknown❌ not supported—
SYSTEM$WAITscalar✅ supported(ANY) → VARCHAR(NUMBER) → VARCHAR(NUMBER, VARCHAR) → VARCHAR
SYSTEM$WAIT_FOR_SERVICESunknown❌ not supported—

Table functions (21)

FunctionKindStatusSignatures
CORTEX_SEARCH_BATCHunknown❌ not supported—
CORTEX_SEARCH_DATA_SCANunknown❌ not supported—
CUMULATIVE_PRIVACY_LOSSESunknown❌ not supported—
FLATTENtable✅ supported(VARIANT, VARCHAR, BOOLEAN, BOOLEAN, VARCHAR) → TABLE
GENERATORtable✅ supported(NUMBER, NUMBER) → SETOF NUMBER
GET_AI_EVALUATION_DATAunknown❌ not supported—
GET_AI_OBSERVABILITY_LOGSunknown❌ not supported—
GET_AI_RECORD_TRACEunknown❌ not supported—
GET_CONTACTSunknown❌ not supported—
GET_JOB_HISTORYunknown❌ not supported—
GET_LINEAGEunknown❌ not supported—
GET_OBJECT_REFERENCESunknown❌ not supported—
ICEBERG_TABLE_FILESunknown❌ not supported—
ICEBERG_TABLE_SNAPSHOT_REFRESH_HISTORYunknown❌ not supported—
INFER_SCHEMAtable✅ supported(VARCHAR, VARCHAR, ARRAY, BOOLEAN, NUMBER, NUMBER, VARCHAR, VARCHAR, BOOLEAN, VARCHAR, VARCHAR, NUMBER) → SETOF RECORD
REST_EVENT_HISTORYunknown❌ not supported—
RESULT_SCANunknown✅ supported—
STORAGE_LIFECYCLE_POLICY_HISTORYunknown❌ not supported—
SYSTEM$STREAM_BACKLOGunknown❌ not supported—
TO_QUERYunknown❌ not supported—
VALIDATEunknown❌ not supported—

Table functions (Tables) (1)

FunctionKindStatusSignatures
APPLICATION_CONFIGURATION_VALUE_HISTORYunknown❌ not supported—

Vector functions (10)

FunctionKindStatusSignatures
VECTOR_AVGaggregate✅ supported(VECTOR)
VECTOR_COSINE_SIMILARITYscalar✅ supported(VECTOR, VECTOR) → FLOAT
VECTOR_INNER_PRODUCTscalar✅ supported(VECTOR, VECTOR) → FLOAT
VECTOR_L1_DISTANCEscalar✅ supported(VECTOR, VECTOR) → FLOAT
VECTOR_L2_DISTANCEscalar✅ supported(VECTOR, VECTOR) → FLOAT
VECTOR_MAXaggregate✅ supported(VECTOR)
VECTOR_MINaggregate✅ supported(VECTOR)
VECTOR_NORMALIZEscalar✅ supported(ANY) → VECTOR(VARCHAR) → VECTOR(VARIANT) → VECTOR(VECTOR) → VECTOR
VECTOR_SUMaggregate✅ supported(VECTOR)
VECTOR_TRUNCATEscalar🟡 partial(ANY, ANY) → VECTOR(VARCHAR, NUMBER) → VECTOR(VARIANT, NUMBER) → VECTOR(VECTOR, NUMBER) → VECTOR

Window function syntax and usage (8)

FunctionKindStatusSignatures
DENSE_RANKwindow✅ supported() → NUMBER
FIRST_VALUEwindow✅ supported(ANY) → ANY
LAGwindow✅ supported(ANY) → ANY(ANY) → VARCHAR(ANY, NUMBER) → ANY(ANY, NUMBER, ANY) → ANY
LAST_VALUEwindow✅ supported(ANY) → ANY
LEADwindow✅ supported(ANY) → ANY(ANY) → VARCHAR(ANY, NUMBER) → ANY(ANY, NUMBER, ANY) → ANY
NTH_VALUEwindow✅ supported(ANY, NUMBER) → ANY
NTILEwindow✅ supported(NUMBER) → NUMBER
ROW_NUMBERwindow✅ supported() → NUMBER

Window functions (9)

FunctionKindStatusSignatures
CONDITIONAL_CHANGE_EVENTwindow✅ supported(ANY) → NUMBER
CONDITIONAL_TRUE_EVENTunknown✅ supported—
CUME_DISTwindow✅ supported() → FLOAT
INTERPOLATE_BFILLwindow✅ supported(ANY) → ANY
INTERPOLATE_FFILLwindow✅ supported(ANY) → ANY
INTERPOLATE_LINEARwindow✅ supported(ANY, ANY) → ANY
PERCENT_RANKwindow✅ supported() → FLOAT
RANKwindow✅ supported() → NUMBER
RATIO_TO_REPORTunknown✅ supported—

Not in the SQL reference (bitwise) (5)

FunctionKindStatusSignatures
BIT_NOTscalar✅ supported(NUMBER) → NUMBER
BIT_ORscalar✅ supported(NUMBER, NUMBER) → NUMBER
BIT_SHIFTLEFTscalar✅ supported(NUMBER, NUMBER) → NUMBER
BIT_SHIFTRIGHTscalar✅ supported(NUMBER, NUMBER) → NUMBER
BIT_XORscalar✅ supported(NUMBER, NUMBER) → NUMBER

Not in the SQL reference (context) (1)

FunctionKindStatusSignatures
CURRENT_TIMESTAMP_LTZscalar✅ supported() → TIMESTAMP_LTZ

Not in the SQL reference (conversion) (1)

FunctionKindStatusSignatures
BIT_ANDscalar✅ supported(ANY, ANY) → NUMBER(DECFLOAT, DECFLOAT) → NUMBER(NUMBER, NUMBER) → NUMBER

Not in the SQL reference (date) (8)

FunctionKindStatusSignatures
TIMEFROMPARTSscalar✅ supported(ANY, ANY, ANY) → TIME(NUMBER, NUMBER, NUMBER) → TIME(NUMBER, NUMBER, NUMBER, NUMBER) → TIME
TIMESTAMPFROMPARTSscalar✅ supported(DATE, TIME) → TIMESTAMP_NTZ(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ
TIMESTAMPLTZFROMPARTSscalar✅ supported(DATE, TIME) → TIMESTAMP_LTZ(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_LTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_LTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_LTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_LTZ
TIMESTAMPNTZFROMPARTSscalar✅ supported(DATE, TIME) → TIMESTAMP_NTZ(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_NTZ
TIMESTAMPTZFROMPARTSscalar✅ supported(DATE, TIME) → TIMESTAMP_TZ(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_TZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_TZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_TZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_TZ
TIMESTAMP_LTZ_FROM_PARTSscalar✅ supported(DATE, TIME) → TIMESTAMP_LTZ(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_LTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_LTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_LTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_LTZ
TIMESTAMP_NTZ_FROM_PARTSscalar✅ supported(DATE, TIME) → TIMESTAMP_NTZ(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_NTZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_NTZ
TIMESTAMP_TZ_FROM_PARTSscalar✅ supported(DATE, TIME) → TIMESTAMP_TZ(ANY, ANY, ANY, ANY, ANY, ANY) → TIMESTAMP_TZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_TZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER) → TIMESTAMP_TZ(NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, VARCHAR) → TIMESTAMP_TZ

Not in the SQL reference (math) (1)

FunctionKindStatusSignatures
CEILINGscalar✅ supported(ANY) → NUMBER(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(FLOAT, NUMBER) → FLOAT(NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER) → NUMBER

Not in the SQL reference (system) (5)

FunctionKindStatusSignatures
SYSTEM$BOOTSTRAP_DATA_REQUESTscalar✅ supported() → VARCHAR(ANY) → VARCHAR(SNOWFLAKE_VARCHAR[]) → VARCHAR
SYSTEM$GET_ALERT_CONFIGscalar✅ supported() → VARCHAR(ANY) → VARCHAR(VARCHAR) → VARCHAR
SYSTEM$RETURN_CURRENT_ORG_NAMEscalar✅ supported() → VARCHAR
SYSTEM$SEND_EMAILscalar✅ supported(ANY, ANY, ANY, ANY) → BOOLEAN(VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN
SYSTEM$SEND_SNOWFLAKE_NOTIFICATIONscalar✅ supported(ANY, ANY) → VARCHAR(ARRAY, ARRAY) → VARCHAR(ARRAY, VARCHAR) → VARCHAR(VARCHAR, ARRAY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR
233 of 571 documented · 41%224 supported18 partial338 not supported

SQL statements

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

Query features

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

Data types

TypeSynonymsStatus
ARRAY—✅ supported
BINARYVARBINARY✅ supported
BOOLEAN—✅ supported
DATE—✅ supported
DECFLOAT—✅ supported
FILE—✅ supported
FLOATFLOAT4, FLOAT8, DOUBLE, DOUBLE PRECISION, REAL✅ supported
GEOGRAPHY—✅ supported
GEOMETRY—✅ supported
MAP—✅ supported
NUMBERDECIMAL, NUMERIC, INT, INTEGER, BIGINT, SMALLINT, TINYINT, BYTEINT✅ supported
OBJECT—✅ supported
TIME—✅ supported
TIMESTAMP_LTZ—✅ supported
TIMESTAMP_NTZTIMESTAMP, DATETIME✅ supported
TIMESTAMP_TZ—✅ supported
VARCHARSTRING, TEXT, CHAR, CHARACTER, NCHAR, NVARCHAR, NVARCHAR2, CHAR VARYING, NCHAR VARYING✅ supported
VARIANT—✅ supported
VECTOR—✅ supported