Skip to main content

Supported Snowflake functions in dbt Fusion

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

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

Refreshed weekly

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

Function
CategoryFusion typechecking
TAG_REFERENCES_WITH_LINEAGEAccount Usage table
AGGAggregate
AI_AGGAggregate
AI_SUMMARIZE_AGGAggregate
ANY_VALUEAggregate
APPROX_COUNT_DISTINCTAggregate
APPROX_PERCENTILEAggregate
APPROX_PERCENTILE_ACCUMULATEAggregate
APPROX_PERCENTILE_COMBINEAggregate
APPROX_PERCENTILE_ESTIMATEAggregate
APPROX_TOP_KAggregate
APPROX_TOP_K_ACCUMULATEAggregate
APPROX_TOP_K_COMBINEAggregate
APPROX_TOP_K_ESTIMATEAggregate
APPROXIMATE_JACCARD_INDEXAggregate
APPROXIMATE_SIMILARITYAggregate
ARRAY_AGGAggregate
ARRAY_UNION_AGGAggregate
ARRAY_UNIQUE_AGGAggregate
AVGAggregate
BITAND_AGGAggregate
BITMAP_ABSOLUTE_POSITIONAggregate
BITMAP_ANDAggregate
BITMAP_AND_AGGAggregate
BITMAP_BIT_POSITIONAggregate
BITMAP_BUCKET_NUMBERAggregate
BITMAP_CONSTRUCT_AGGAggregate
BITMAP_COUNTAggregate
BITMAP_ORAggregate
BITMAP_OR_AGGAggregate
BITMAP_TO_ARRAYAggregate
BITOR_AGGAggregate
BITXOR_AGGAggregate
BOOLAND_AGGAggregate
BOOLOR_AGGAggregate
BOOLXOR_AGGAggregate
CORRAggregate
COUNTAggregate
COUNT_IFAggregate
COVAR_POPAggregate
COVAR_SAMPAggregate
DATASKETCHES_HLLAggregate
DATASKETCHES_HLL_ACCUMULATEAggregate
DATASKETCHES_HLL_COMBINEAggregate
DATASKETCHES_HLL_ESTIMATEAggregate
GROUPINGAggregate
GROUPING_IDAggregate
HASH_AGGAggregate
HLLAggregate
HLL_ACCUMULATEAggregate
HLL_COMBINEAggregate
HLL_ESTIMATEAggregate
HLL_EXPORTAggregate
HLL_IMPORTAggregate
KURTOSISAggregate
LISTAGGAggregate
MAXAggregate
MAX_BYAggregate
MEDIANAggregate
MINAggregate
MIN_BYAggregate
MINHASHAggregate
MINHASH_COMBINEAggregate
MODEAggregate
OBJECT_AGGAggregate
PERCENTILE_CONTAggregate
PERCENTILE_DISCAggregate
REGR_AVGXAggregate
REGR_AVGYAggregate
REGR_COUNTAggregate
REGR_INTERCEPTAggregate
REGR_R2Aggregate
REGR_SLOPEAggregate
REGR_SXXAggregate
REGR_SXYAggregate
REGR_SYYAggregate
SKEWAggregate
STDDEV_POPAggregate
STDDEV, STDDEV_SAMPAggregate
SUMAggregate
VAR_POPAggregate
VAR_SAMPAggregate
VARIANCE , VARIANCE_SAMPAggregate
VARIANCE_POPAggregate
BITANDBitwise expression
BITNOTBitwise expression
BITORBitwise expression
BITSHIFTLEFTBitwise expression
BITSHIFTRIGHTBitwise expression
BITXORBitwise expression
GETBITBitwise expression
[ NOT ] BETWEENConditional expression
[ NOT ] EQUAL_NULLConditional expression
[ NOT ] INConditional expression
BOOLANDConditional expression
BOOLNOTConditional expression
BOOLORConditional expression
BOOLXORConditional expression
CASEConditional expression
COALESCEConditional expression
DECODEConditional expression
GREATESTConditional expression
GREATEST_IGNORE_NULLSConditional expression
IFFConditional expression
IFNULLConditional expression
IS [ NOT ] DISTINCT FROMConditional expression
IS [ NOT ] NULLConditional expression
IS_NULL_VALUEConditional expression
LEASTConditional expression
LEAST_IGNORE_NULLSConditional expression
NULLIFConditional expression
NULLIFZEROConditional expression
NVLConditional expression
NVL2Conditional expression
REGR_VALXConditional expression
REGR_VALYConditional expression
ZEROIFNULLConditional expression
ALL_USER_NAMESContext
CURRENT_ACCOUNTContext
CURRENT_ACCOUNT_NAMEContext
CURRENT_AVAILABLE_ROLESContext
CURRENT_CLIENTContext
CURRENT_DATABASEContext
CURRENT_DATEContext
CURRENT_IP_ADDRESSContext
CURRENT_ORGANIZATION_NAMEContext
CURRENT_ORGANIZATION_USERContext
CURRENT_REGIONContext
CURRENT_ROLEContext
CURRENT_ROLE_TYPEContext
CURRENT_SCHEMAContext
CURRENT_SCHEMASContext
CURRENT_SECONDARY_ROLESContext
CURRENT_SESSIONContext
CURRENT_STATEMENTContext
CURRENT_TIMEContext
CURRENT_TIMESTAMPContext
CURRENT_TRANSACTIONContext
CURRENT_USERContext
CURRENT_VERSIONContext
CURRENT_WAREHOUSEContext
GET_CONDITION_QUERY_UUIDContext
GET_CONFIGURATION_VALUE (SYS_CONTEXT FUNCTION)Context
GETDATEContext
GETVARIABLEContext
INVOKER_ROLEContext
INVOKER_SHAREContext
IS_APPLICATION_ROLE_ACTIVATED (SYS_CONTEXT FUNCTION)Context
IS_APPLICATION_ROLE_IN_SESSIONContext
IS_CONFIGURATION_SET (SYS_CONTEXT FUNCTION)Context
IS_DATABASE_ROLE_ACTIVATED (SYS_CONTEXT FUNCTION)Context
IS_DATABASE_ROLE_IN_SESSIONContext
IS_GRANTED_TO_INVOKER_ROLEContext
IS_GROUP_ACTIVATED (SYS_CONTEXT FUNCTION)Context
IS_GROUP_IMPORTED (SYS_CONTEXT FUNCTION)Context
IS_INSTANCE_ROLE_IN_SESSIONContext
IS_ORGANIZATION_USER_GROUP_IN_SESSIONContext
IS_ROLE_ACTIVATED (SYS_CONTEXT FUNCTION)Context
IS_ROLE_IN_SESSIONContext
IS_USER_IMPORTED (SYS_CONTEXT FUNCTION)Context
LAST_QUERY_IDContext
LAST_TRANSACTIONContext
LOCALTIMEContext
LOCALTIMESTAMPContext
POLICY_CONTEXTContext
SET_SYS_CONTEXTContext
SYS_CONTEXTContext
SYS_CONTEXT (SNOWFLAKE$APPLICATION NAMESPACE)Context
SYS_CONTEXT (SNOWFLAKE$ENVIRONMENT NAMESPACE)Context
SYS_CONTEXT (SNOWFLAKE$ORGANIZATION NAMESPACE)Context
SYS_CONTEXT (SNOWFLAKE$ORGANIZATION_SESSION NAMESPACE)Context
SYS_CONTEXT (SNOWFLAKE$SESSION NAMESPACE)Context
SYS_CONTEXT (SNOWFLAKE$SESSION_ATTRIBUTES NAMESPACE)Context
SYSDATEContext
SYSTIMESTAMPContext
CAST , ::Conversion
TO_ARRAYConversion
TO_BINARYConversion
TO_BOOLEANConversion
TO_CHAR , TO_VARCHARConversion
TO_DATE , DATEConversion
TO_DECFLOATConversion
TO_DECIMAL , TO_NUMBER , TO_NUMERICConversion
TO_DOUBLEConversion
TO_JSONConversion
TO_OBJECTConversion
TO_TIME , TIMEConversion
TO_TIMESTAMP / TO_TIMESTAMP_*Conversion
TO_UUIDConversion
TO_VARIANTConversion
TO_XMLConversion
TRY_CASTConversion
TRY_TO_BINARYConversion
TRY_TO_BOOLEANConversion
TRY_TO_DATEConversion
TRY_TO_DECFLOATConversion
TRY_TO_DECIMAL, TRY_TO_NUMBER, TRY_TO_NUMERICConversion
TRY_TO_DOUBLEConversion
TRY_TO_TIMEConversion
TRY_TO_TIMESTAMP / TRY_TO_TIMESTAMP_*Conversion
TRY_TO_UUIDConversion
NORMALData generation
RANDOMData generation
RANDSTRData generation
SEQ1 / SEQ2 / SEQ4 / SEQ8Data generation
UNIFORMData generation
ZIPFData generation
ACCEPTED_VALUES (SYSTEM DATA METRIC FUNCTION)Data metric
AVG (SYSTEM DATA METRIC FUNCTION)Data metric
BLANK_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric
BLANK_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric
DATA_METRIC_SCHEDULED_TIME (SYSTEM DATA METRIC FUNCTION)Data metric
DUPLICATE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric
FRESHNESS (SYSTEM DATA METRIC FUNCTION)Data metric
MAX (SYSTEM DATA METRIC FUNCTION)Data metric
MIN (SYSTEM DATA METRIC FUNCTION)Data metric
NULL_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric
NULL_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric
ROW_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric
STDDEV (SYSTEM DATA METRIC FUNCTION)Data metric
UNIQUE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric
ADD_MONTHSDate & time
CONVERT_TIMEZONEDate & time
DATE_FROM_PARTSDate & time
DATE_PARTDate & time
DATE_TRUNCDate & time
DATEADDDate & time
DATEDIFFDate & time
DAYNAMEDate & time
EXTRACTDate & time
HOUR / MINUTE / SECONDDate & time
LAST_DAYDate & time
LAST_SUCCESSFUL_SCHEDULED_TIMEDate & time
MONTHNAMEDate & time
MONTHS_BETWEENDate & time
NEXT_DAYDate & time
PREVIOUS_DAYDate & time
SCHEDULED_TIMEDate & time
TIME_FROM_PARTSDate & time
TIME_SLICEDate & time
TIMEADDDate & time
TIMEDIFFDate & time
TIMESTAMP_FROM_PARTSDate & time
TIMESTAMPADDDate & time
TIMESTAMPDIFFDate & time
TRUNCATE, TRUNCDate & time
YEAR* / DAY* / WEEK* / MONTH / QUARTERDate & time
DP_INTERVAL_HIGHDifferential privacy
DP_INTERVAL_LOWDifferential privacy
ESTIMATE_REMAINING_DP_AGGREGATESDifferential privacy
DECRYPTEncryption
DECRYPT_RAWEncryption
ENCRYPTEncryption
ENCRYPT_RAWEncryption
TRY_DECRYPTEncryption
TRY_DECRYPT_RAWEncryption
AI_TRANSCRIBEFile
BUILD_SCOPED_FILE_URLFile
BUILD_STAGE_FILE_URLFile
FL_GET_CONTENT_TYPEFile
FL_GET_ETAGFile
FL_GET_FILE_TYPEFile
FL_GET_LAST_MODIFIEDFile
FL_GET_RELATIVE_PATHFile
FL_GET_SCOPED_FILE_URLFile
FL_GET_SIZEFile
FL_GET_STAGEFile
FL_GET_STAGE_FILE_URLFile
FL_IS_AUDIOFile
FL_IS_COMPRESSEDFile
FL_IS_DOCUMENTFile
FL_IS_IMAGEFile
FL_IS_VIDEOFile
GET_ABSOLUTE_PATHFile
GET_PRESIGNED_URLFile
GET_RELATIVE_PATHFile
GET_STAGE_LOCATIONFile
PARSE_DOCUMENT (SNOWFLAKE.CORTEX)File
TO_FILEFile
TRY_TO_FILEFile
GENERATE_POSTGRES_ACCESS_TOKEN_FOR_USERGenerates a short-lived access token for a Snowflake user to use as a password when logging into a Snowflake Postgres instance that has the AUTHENTICATION_AUTHORITY attribute set to POSTGRES_OR_SNOWFLAKE.
H3_CELL_TO_BOUNDARYGeospatial
H3_CELL_TO_CHILDRENGeospatial
H3_CELL_TO_CHILDREN_STRINGGeospatial
H3_CELL_TO_PARENTGeospatial
H3_CELL_TO_POINTGeospatial
H3_COMPACT_CELLSGeospatial
H3_COMPACT_CELLS_STRINGSGeospatial
H3_COVERAGEGeospatial
H3_COVERAGE_STRINGSGeospatial
H3_GET_RESOLUTIONGeospatial
H3_GRID_DISKGeospatial
H3_GRID_DISTANCEGeospatial
H3_GRID_PATHGeospatial
H3_INT_TO_STRINGGeospatial
H3_IS_PENTAGONGeospatial
H3_IS_VALID_CELLGeospatial
H3_LATLNG_TO_CELLGeospatial
H3_LATLNG_TO_CELL_STRINGGeospatial
H3_POINT_TO_CELLGeospatial
H3_POINT_TO_CELL_STRINGGeospatial
H3_POLYGON_TO_CELLSGeospatial
H3_POLYGON_TO_CELLS_STRINGSGeospatial
H3_STRING_TO_INTGeospatial
H3_TRY_COVERAGEGeospatial
H3_TRY_COVERAGE_STRINGSGeospatial
H3_TRY_GRID_DISTANCEGeospatial
H3_TRY_GRID_PATHGeospatial
H3_TRY_POLYGON_TO_CELLSGeospatial
H3_TRY_POLYGON_TO_CELLS_STRINGSGeospatial
H3_UNCOMPACT_CELLSGeospatial
H3_UNCOMPACT_CELLS_STRINGSGeospatial
HAVERSINEGeospatial
ST_AREAGeospatial
ST_ASEWKBGeospatial
ST_ASEWKTGeospatial
ST_ASGEOJSONGeospatial
ST_ASWKB , ST_ASBINARYGeospatial
ST_ASWKT , ST_ASTEXTGeospatial
ST_AZIMUTHGeospatial
ST_BUFFERGeospatial
ST_CENTROIDGeospatial
ST_COLLECTGeospatial
ST_CONTAINSGeospatial
ST_COVEREDBYGeospatial
ST_COVERSGeospatial
ST_DIFFERENCEGeospatial
ST_DIMENSIONGeospatial
ST_DISJOINTGeospatial
ST_DISTANCEGeospatial
ST_DWITHINGeospatial
ST_ENDPOINTGeospatial
ST_ENVELOPEGeospatial
ST_GEOGFROMGEOHASHGeospatial
ST_GEOGPOINTFROMGEOHASHGeospatial
ST_GEOGRAPHYFROMWKBGeospatial
ST_GEOGRAPHYFROMWKTGeospatial
ST_GEOHASHGeospatial
ST_GEOMETRYFROMWKBGeospatial
ST_GEOMETRYFROMWKTGeospatial
ST_GEOMFROMGEOHASHGeospatial
ST_GEOMPOINTFROMGEOHASHGeospatial
ST_HAUSDORFFDISTANCEGeospatial
ST_INTERPOLATEGeospatial
ST_INTERSECTIONGeospatial
ST_INTERSECTION_AGGGeospatial
ST_INTERSECTSGeospatial
ST_ISVALIDGeospatial
ST_LENGTHGeospatial
ST_MAKEGEOMPOINT , ST_GEOMPOINTGeospatial
ST_MAKELINEGeospatial
ST_MAKEPOINT , ST_POINTGeospatial
ST_MAKEPOLYGON , ST_POLYGONGeospatial
ST_MAKEPOLYGONORIENTEDGeospatial
ST_NPOINTS , ST_NUMPOINTSGeospatial
ST_PERIMETERGeospatial
ST_POINTNGeospatial
ST_SETSRIDGeospatial
ST_SIMPLIFYGeospatial
ST_SRIDGeospatial
ST_STARTPOINTGeospatial
ST_SYMDIFFERENCEGeospatial
ST_TRANSFORMGeospatial
ST_UNIONGeospatial
ST_UNION_AGGGeospatial
ST_WITHINGeospatial
ST_XGeospatial
ST_XMAXGeospatial
ST_XMINGeospatial
ST_YGeospatial
ST_YMAXGeospatial
ST_YMINGeospatial
TO_GEOGRAPHYGeospatial
TO_GEOMETRYGeospatial
TRY_TO_GEOGRAPHYGeospatial
TRY_TO_GEOMETRYGeospatial
HASHHash
ALERT_HISTORYInformation Schema
APPLICATION_CALLBACK_HISTORYInformation Schema
APPLICATION_SPECIFICATION_STATUS_HISTORYInformation Schema
AUTO_REFRESH_REGISTRATION_HISTORYInformation Schema
AUTOMATIC_CLUSTERING_HISTORYInformation Schema
AVAILABLE_LISTING_REFRESH_HISTORYInformation Schema
AVAILABLE_LISTINGSInformation Schema
BIND_VALUESInformation Schema
COMPLETE_TASK_GRAPHSInformation Schema
COPY_HISTORYInformation Schema
CORTEX_SEARCH_REFRESH_HISTORYInformation Schema
CURRENT_TASK_GRAPHSInformation Schema
DATA_METRIC_FUNCTION_EXPECTATIONSInformation Schema
DATA_METRIC_FUNCTION_REFERENCESInformation Schema
DATA_TRANSFER_HISTORYInformation Schema
DATABASE_REFRESH_HISTORYInformation Schema
DATABASE_REFRESH_PROGRESS , DATABASE_REFRESH_PROGRESS_BY_JOBInformation Schema
DATABASE_REPLICATION_USAGE_HISTORYInformation Schema
DATABASE_STORAGE_USAGE_HISTORYInformation Schema
DBT_PROJECT_EXECUTION_HISTORYInformation Schema
DYNAMIC_TABLE_GRAPH_HISTORYInformation Schema
DYNAMIC_TABLE_REFRESH_HISTORYInformation Schema
DYNAMIC_TABLESInformation Schema
EXTERNAL_FUNCTIONS_HISTORYInformation Schema
EXTERNAL_TABLE_FILE_REGISTRATION_HISTORYInformation Schema
EXTERNAL_TABLE_FILESInformation Schema
LISTING_REFRESH_HISTORYInformation Schema
LOGIN_HISTORY , LOGIN_HISTORY_BY_USERInformation Schema
MATERIALIZED_VIEW_REFRESH_HISTORYInformation Schema
NETWORK_RULE_REFERENCESInformation Schema
NOTIFICATION_HISTORYInformation Schema
ONLINE_FEATURE_TABLE_REFRESH_HISTORYInformation Schema
PIPE_USAGE_HISTORYInformation Schema
POLICY_REFERENCESInformation Schema
QUERY_ACCELERATION_HISTORYInformation Schema
QUERY_HISTORY , QUERY_HISTORY_BY_*Information Schema
REPLICATION_GROUP_DANGLING_REFERENCESInformation Schema
REPLICATION_GROUP_REFRESH_HISTORY, REPLICATION_GROUP_REFRESH_HISTORY_ALLInformation Schema
REPLICATION_GROUP_REFRESH_PROGRESS, REPLICATION_GROUP_REFRESH_PROGRESS_BY_JOB, REPLICATION_GROUP_REFRESH_PROGRESS_ALLInformation Schema
REPLICATION_GROUP_USAGE_HISTORYInformation Schema
REPLICATION_USAGE_HISTORYInformation Schema
SEARCH_OPTIMIZATION_HISTORYInformation Schema
SERVERLESS_ALERT_HISTORYInformation Schema
SERVERLESS_TASK_HISTORYInformation Schema
STAGE_DIRECTORY_FILE_REGISTRATION_HISTORYInformation Schema
STAGE_STORAGE_USAGE_HISTORYInformation Schema
TAG_REFERENCESInformation Schema
TAG_REFERENCES_ALL_COLUMNSInformation Schema
TASK_DEPENDENTSInformation Schema
TASK_HISTORYInformation Schema
VALIDATE_PIPE_LOADInformation Schema
WAREHOUSE_LOAD_HISTORYInformation Schema
WAREHOUSE_METERING_HISTORYInformation Schema
DATA_QUALITY_MONITORING_EXPECTATION_STATUSLOCAL schema
DATA_QUALITY_MONITORING_RESULTSLOCAL schema
GENERATE_COLUMN_DESCRIPTIONMetadata
GET_DDLMetadata
MODEL_MONITOR_DRIFT_METRICModel monitor
MODEL_MONITOR_PERFORMANCE_METRICModel monitor
MODEL_MONITOR_STAT_METRICModel monitor
APPLICATION_JSONNotification
EMAIL_INTEGRATION_CONFIGNotification
INTEGRATIONNotification
SANITIZE_WEBHOOK_CONTENTNotification
TEXT_HTMLNotification
TEXT_PLAINNotification
ABSNumeric
ACOSNumeric
ACOSHNumeric
ASINNumeric
ASINHNumeric
ATANNumeric
ATAN2Numeric
ATANHNumeric
CBRTNumeric
CEILNumeric
COSNumeric
COSHNumeric
COTNumeric
DEGREESNumeric
DIV0Numeric
DIV0NULLNumeric
EXPNumeric
FACTORIALNumeric
FLOORNumeric
LNNumeric
LOGNumeric
MODNumeric
PINumeric
POW, POWERNumeric
RADIANSNumeric
ROUNDNumeric
SIGNNumeric
SINNumeric
SINHNumeric
SQRTNumeric
SQUARENumeric
TANNumeric
TANHNumeric
TRUNCATE , TRUNCNumeric
WIDTH_BUCKETNumeric
IS_ORGANIZATION_USEROrganization user and organization user group
IS_ORGANIZATION_USER_GROUPOrganization user and organization user group
ARRAY_APPENDSemi-structured and structured data
ARRAY_CATSemi-structured and structured data
ARRAY_COMPACTSemi-structured and structured data
ARRAY_CONSTRUCTSemi-structured and structured data
ARRAY_CONSTRUCT_COMPACTSemi-structured and structured data
ARRAY_CONTAINSSemi-structured and structured data
ARRAY_DISTINCTSemi-structured and structured data
ARRAY_EXCEPTSemi-structured and structured data
ARRAY_FLATTENSemi-structured and structured data
ARRAY_GENERATE_RANGESemi-structured and structured data
ARRAY_INSERTSemi-structured and structured data
ARRAY_INTERSECTIONSemi-structured and structured data
ARRAY_MAXSemi-structured and structured data
ARRAY_MINSemi-structured and structured data
ARRAY_POSITIONSemi-structured and structured data
ARRAY_PREPENDSemi-structured and structured data
ARRAY_REMOVESemi-structured and structured data
ARRAY_REMOVE_ATSemi-structured and structured data
ARRAY_REVERSESemi-structured and structured data
ARRAY_SIZESemi-structured and structured data
ARRAY_SLICESemi-structured and structured data
ARRAY_SORTSemi-structured and structured data
ARRAY_TO_STRINGSemi-structured and structured data
ARRAYS_OVERLAPSemi-structured and structured data
ARRAYS_TO_OBJECTSemi-structured and structured data
ARRAYS_ZIPSemi-structured and structured data
AS_<OBJECT_TYPE>Semi-structured and structured data
AS_ARRAYSemi-structured and structured data
AS_BINARYSemi-structured and structured data
AS_BOOLEANSemi-structured and structured data
AS_CHAR , AS_VARCHARSemi-structured and structured data
AS_DATESemi-structured and structured data
AS_DECIMAL , AS_NUMBERSemi-structured and structured data
AS_DOUBLE , AS_REALSemi-structured and structured data
AS_INTEGERSemi-structured and structured data
AS_OBJECTSemi-structured and structured data
AS_TIMESemi-structured and structured data
AS_TIMESTAMP_*Semi-structured and structured data
CHECK_JSONSemi-structured and structured data
CHECK_XMLSemi-structured and structured data
FILTERSemi-structured and structured data
GETSemi-structured and structured data
GET_IGNORE_CASESemi-structured and structured data
GET_PATH , :Semi-structured and structured data
IS_<OBJECT_TYPE>Semi-structured and structured data
IS_ARRAYSemi-structured and structured data
IS_BINARYSemi-structured and structured data
IS_BOOLEANSemi-structured and structured data
IS_CHAR , IS_VARCHARSemi-structured and structured data
IS_DATE , IS_DATE_VALUESemi-structured and structured data
IS_DECIMALSemi-structured and structured data
IS_DOUBLE , IS_REALSemi-structured and structured data
IS_INTEGERSemi-structured and structured data
IS_OBJECTSemi-structured and structured data
IS_TIMESemi-structured and structured data
IS_TIMESTAMP_*Semi-structured and structured data
JSON_EXTRACT_PATH_TEXTSemi-structured and structured data
MAP_CATSemi-structured and structured data
MAP_CONTAINS_KEYSemi-structured and structured data
MAP_DELETESemi-structured and structured data
MAP_ENTRIESSemi-structured and structured data
MAP_INSERTSemi-structured and structured data
MAP_KEYSSemi-structured and structured data
MAP_PICKSemi-structured and structured data
MAP_SIZESemi-structured and structured data
OBJECT_CONSTRUCTSemi-structured and structured data
OBJECT_CONSTRUCT_KEEP_NULLSemi-structured and structured data
OBJECT_DELETESemi-structured and structured data
OBJECT_INSERTSemi-structured and structured data
OBJECT_KEYSSemi-structured and structured data
OBJECT_PICKSemi-structured and structured data
PARSE_JSONSemi-structured and structured data
PARSE_XMLSemi-structured and structured data
PROMPTSemi-structured and structured data
REDUCESemi-structured and structured data
STRIP_NULL_VALUESemi-structured and structured data
TRANSFORMSemi-structured and structured data
TRY_PARSE_JSONSemi-structured and structured data
TYPEOFSemi-structured and structured data
XMLGETSemi-structured and structured data
<SERVICE_NAME>!SPCS_WAIT_FORSnowpark Container Services
[ NOT ] ILIKEString & binary
[ NOT ] LIKEString & binary
AGENT_RUN (SNOWFLAKE.CORTEX)String & binary
AI_CLASSIFYString & binary
AI_COMPLETEString & binary
AI_COMPLETE (PROMPT OBJECT)String & binary
AI_COMPLETE (SINGLE IMAGE)String & binary
AI_COMPLETE (SINGLE STRING)String & binary
AI_COUNT_TOKENSString & binary
AI_EMBEDString & binary
AI_EXTRACTString & binary
AI_EXTRACT (DOCUMENT AI LEGACY MODELS)String & binary
AI_FILTERString & binary
AI_PARSE_DOCUMENTString & binary
AI_REDACTString & binary
AI_SENTIMENTString & binary
AI_SIMILARITYString & binary
AI_TRANSLATEString & binary
ASCIIString & binary
BASE64_DECODE_BINARYString & binary
BASE64_DECODE_STRINGString & binary
BASE64_ENCODEString & binary
BIT_LENGTHString & binary
CHARINDEXString & binary
CHR , CHARString & binary
CLASSIFY_TEXT (SNOWFLAKE.CORTEX)String & binary
COLLATEString & binary
COLLATIONString & binary
COMPLETE (SNOWFLAKE.CORTEX)String & binary
COMPLETE (SNOWFLAKE.CORTEX) (MULTIMODAL)String & binary
COMPRESSString & binary
CONCAT , ||String & binary
CONCAT_WSString & binary
CONTAINSString & binary
COUNT_TOKENS (SNOWFLAKE.CORTEX)String & binary
DATA_AGENT_RUN (SNOWFLAKE.CORTEX)String & binary
DECOMPRESS_BINARYString & binary
DECOMPRESS_STRINGString & binary
EDITDISTANCEString & binary
EMBED_TEXT_1024 (SNOWFLAKE.CORTEX)String & binary
EMBED_TEXT_768 (SNOWFLAKE.CORTEX)String & binary
ENDSWITHString & binary
ENTITY_SENTIMENT (SNOWFLAKE.CORTEX)String & binary
EXTRACT_ANSWER (SNOWFLAKE.CORTEX)String & binary
FINETUNE (‘CANCEL’) (SNOWFLAKE.CORTEX)String & binary
FINETUNE (‘CREATE’) (SNOWFLAKE.CORTEX)String & binary
FINETUNE (‘DESCRIBE’) (SNOWFLAKE.CORTEX)String & binary
FINETUNE (‘SHOW’) (SNOWFLAKE.CORTEX)String & binary
FINETUNE (SNOWFLAKE.CORTEX)String & binary
HEX_DECODE_BINARYString & binary
HEX_DECODE_STRINGString & binary
HEX_ENCODEString & binary
ILIKE ANYString & binary
INITCAPString & binary
INSERTString & binary
JAROWINKLER_SIMILARITYString & binary
LEFTString & binary
LENGTH, LENString & binary
LIKE ALLString & binary
LIKE ANYString & binary
LOWERString & binary
LPADString & binary
LTRIMString & binary
MD5 , MD5_HEXString & binary
MD5_BINARYString & binary
MD5_NUMBER — OBSOLETEDString & binary
MD5_NUMBER_LOWER64String & binary
MD5_NUMBER_UPPER64String & binary
OCTET_LENGTHString & binary
PARSE_IPString & binary
PARSE_URLString & binary
POSITIONString & binary
REPEATString & binary
REPLACEString & binary
REVERSEString & binary
RIGHTString & binary
RPADString & binary
RTRIMString & binary
RTRIMMED_LENGTHString & binary
SEARCHString & binary
SEARCH_IPString & binary
SEARCH_PREVIEW (SNOWFLAKE.CORTEX)String & binary
SENTIMENT (SNOWFLAKE.CORTEX)String & binary
SHA1 , SHA1_HEXString & binary
SHA1_BINARYString & binary
SHA2 , SHA2_HEXString & binary
SHA2_BINARYString & binary
SOUNDEXString & binary
SOUNDEX_P123String & binary
SPACEString & binary
SPLITString & binary
SPLIT_PARTString & binary
SPLIT_TEXT_MARKDOWN_HEADER (SNOWFLAKE.CORTEX)String & binary
SPLIT_TEXT_RECURSIVE_CHARACTER (SNOWFLAKE.CORTEX)String & binary
SPLIT_TO_TABLEString & binary
STARTSWITHString & binary
STRTOKString & binary
STRTOK_SPLIT_TO_TABLEString & binary
STRTOK_TO_ARRAYString & binary
SUBSTR , SUBSTRINGString & binary
SUMMARIZE (SNOWFLAKE.CORTEX)String & binary
TRANSLATEString & binary
TRANSLATE (SNOWFLAKE.CORTEX)String & binary
TRIMString & binary
TRY_BASE64_DECODE_BINARYString & binary
TRY_BASE64_DECODE_STRINGString & binary
TRY_COMPLETE (SNOWFLAKE.CORTEX)String & binary
TRY_HEX_DECODE_BINARYString & binary
TRY_HEX_DECODE_STRINGString & binary
UNICODEString & binary
UPPERString & binary
UUID_STRINGString & binary
[ NOT ] REGEXPString functions (regular expressions)
[ NOT ] RLIKEString functions (regular expressions)
REGEXP_COUNTString functions (regular expressions)
REGEXP_INSTRString functions (regular expressions)
REGEXP_LIKEString functions (regular expressions)
REGEXP_REPLACEString functions (regular expressions)
REGEXP_SUBSTRString functions (regular expressions)
REGEXP_SUBSTR_ALLString functions (regular expressions)
EXECUTE_AI_EVALUATIONSystem
EXPLAIN_JSONSystem
EXTRACT_SEMANTIC_CATEGORIESSystem
GET_ANACONDA_PACKAGES_REPODATASystem
GET_PYTHON_PROFILER_OUTPUT (SNOWFLAKE.CORE)System
GET_QUERY_OPERATOR_STATSSystem
SHOW_PYTHON_PACKAGES_DEPENDENCIESSystem
SYSTEM$ABORT_SESSIONSystem
SYSTEM$ABORT_TRANSACTIONSystem
SYSTEM$ACTIVATE_CMK_INFOSystem
SYSTEM$ACTIVATE_CMK_INFO_POSTGRESSystem
SYSTEM$ADD_EVENT (FOR SNOWFLAKE SCRIPTING)System
SYSTEM$ADD_REFERENCESystem
SYSTEM$ALLOWLISTSystem
SYSTEM$ALLOWLIST_PRIVATELINKSystem
SYSTEM$APP_COMPATIBILITY_CHECKSystem
SYSTEM$APPLICATION_GET_LOG_LEVELSystem
SYSTEM$APPLICATION_GET_METRIC_LEVELSystem
SYSTEM$APPLICATION_GET_TRACE_LEVELSystem
SYSTEM$AUTHORIZE_PRIVATELINKSystem
SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESSSystem
SYSTEM$AUTO_REFRESH_STATUSSystem
SYSTEM$BEGIN_DEBUG_APPLICATIONSystem
SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUSSystem
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESSSystem
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS_WITH_EXCEPTIONSystem
SYSTEM$CANCEL_ALL_QUERIESSystem
SYSTEM$CANCEL_QUERYSystem
SYSTEM$CATALOG_LINK_STATUSSystem
SYSTEM$CKE_HASH_FUNCTIONSystem
SYSTEM$CLEANUP_DATABASE_ROLE_GRANTSSystem
SYSTEM$CLIENT_VERSION_INFOSystem
SYSTEM$CLIENT_VULNERABILITY_INFOSystem
SYSTEM$CLUSTERING_DEPTHSystem
SYSTEM$CLUSTERING_INFORMATIONSystem
SYSTEM$CLUSTERING_RATIO — DEPRECATEDSystem
SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNTSystem
SYSTEM$CONVERT_PIPES_SQS_TO_SNSSystem
SYSTEM$CREATE_BILLING_EVENTSystem
SYSTEM$CREATE_BILLING_EVENTSSystem
SYSTEM$CURRENT_USER_TASK_NAMESystem
SYSTEM$DATA_METRIC_SCANSystem
SYSTEM$DATABASE_REFRESH_HISTORY — DEPRECATEDSystem
SYSTEM$DATABASE_REFRESH_PROGRESS , SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB — DEPRECATEDSystem
SYSTEM$DEACTIVATE_CMK_INFOSystem
SYSTEM$DECODE_PATSystem
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINTSystem
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT_TSSSystem
SYSTEM$DEREGISTER_CMK_INFOSystem
SYSTEM$DEREGISTER_CMK_INFO_POSTGRESSystem
SYSTEM$DESC_ICEBERG_ACCESS_IDENTITYSystem
SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLESystem
SYSTEM$DISABLE_DATABASE_REPLICATIONSystem
SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNTSystem
SYSTEM$DISABLE_PREVIEW_ACCESSSystem
SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLYSystem
SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLESystem
SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNTSystem
SYSTEM$ENABLE_PREVIEW_ACCESSSystem
SYSTEM$ENCODE_CKE_PRIMARY_KEYSystem
SYSTEM$END_DEBUG_APPLICATIONSystem
SYSTEM$ENFORCE_PRIVATELINK_ACCESS_ONLYSystem
SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTSSystem
SYSTEM$ESTIMATE_QUERY_ACCELERATIONSystem
SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTSSystem
SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONSSystem
SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS_PERSIST_RESULTSystem
SYSTEM$EXPLAIN_JSON_TO_TEXTSystem
SYSTEM$EXPLAIN_PLAN_JSONSystem
SYSTEM$EXPORT_TDS_FROM_SEMANTIC_VIEWSystem
SYSTEM$EXTERNAL_TABLE_PIPE_STATUSSystem
SYSTEM$FINISH_OAUTH_FLOWSystem
SYSTEM$GENERATE_SAML_CSRSystem
SYSTEM$GENERATE_SCIM_ACCESS_TOKENSystem
SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDESSystem
SYSTEM$GET_ALL_REFERENCESSystem
SYSTEM$GET_AWS_SNS_IAM_POLICYSystem
SYSTEM$GET_CATALOG_LINKED_DATABASE_CONFIGSystem
SYSTEM$GET_CLASSIFICATION_RESULTSystem
SYSTEM$GET_CMK_AKV_CONSENT_URLSystem
SYSTEM$GET_CMK_CONFIGSystem
SYSTEM$GET_CMK_CONFIG_POSTGRESSystem
SYSTEM$GET_CMK_INFOSystem
SYSTEM$GET_CMK_INFO_POSTGRESSystem
SYSTEM$GET_CMK_KMS_KEY_POLICYSystem
SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCESystem
SYSTEM$GET_DBT_LOGSystem
SYSTEM$GET_DEBUG_STATUSSystem
SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMANDSystem
SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECTSystem
SYSTEM$GET_DIRECTORY_TABLE_STATUSSystem
SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMDSystem
SYSTEM$GET_HASH_FOR_APPLICATIONSystem
SYSTEM$GET_ICEBERG_TABLE_INFORMATIONSystem
SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPSSystem
SYSTEM$GET_LOGIN_FAILURE_DETAILSSystem
SYSTEM$GET_PREDECESSOR_RETURN_VALUESystem
SYSTEM$GET_PREVIEW_ACCESS_STATUSSystem
SYSTEM$GET_PRIVATELINKSystem
SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTSSystem
SYSTEM$GET_PRIVATELINK_CONFIGSystem
SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONSSystem
SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFOSystem
SYSTEM$GET_PURCHASE_ATTRIBUTESSystem
SYSTEM$GET_REFERENCED_OBJECT_ID_HASHSystem
SYSTEM$GET_RESULTSET_STATUSSystem
SYSTEM$GET_SERVICE_DNS_DOMAINSystem
SYSTEM$GET_SERVICE_LOGSSystem
SYSTEM$GET_SERVICE_STATUS — DEPRECATEDSystem
SYSTEM$GET_SNOWFLAKE_EGRESS_IP_RANGESSystem
SYSTEM$GET_SNOWFLAKE_PLATFORM_INFOSystem
SYSTEM$GET_STAGE_PRIVATELINK_AUTHORIZED_ENDPOINTSSystem
SYSTEM$GET_TAGSystem
SYSTEM$GET_TAG_ALLOWED_VALUESSystem
SYSTEM$GET_TAG_ON_CURRENT_COLUMNSystem
SYSTEM$GET_TAG_ON_CURRENT_TABLESystem
SYSTEM$GET_TASK_GRAPH_CONFIGSystem
SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETERSystem
SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNTSystem
SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNTSystem
SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUSSystem
SYSTEM$IS_APPLICATION_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLEDSystem
SYSTEM$IS_APPLICATION_AUTHORIZED_FOR_TELEMETRY_EVENT_SHARINGSystem
SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNTSystem
SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDERSystem
SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNTSystem
SYSTEM$IS_LISTING_PURCHASEDSystem
SYSTEM$IS_LISTING_TRIALSystem
SYSTEM$LAST_CHANGE_COMMIT_TIMESystem
SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAMESystem
SYSTEM$LINK_ORGANIZATION_USERSystem
SYSTEM$LINK_ORGANIZATION_USER_GROUPSystem
SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURESSystem
SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOGSystem
SYSTEM$LIST_NAMESPACES_FROM_CATALOGSystem
SYSTEM$LOCATE_DBT_ARCHIVESystem
SYSTEM$LOCATE_DBT_ARTIFACTSSystem
SYSTEM$LOG, SYSTEM$LOG_<LEVEL> (FOR SNOWFLAKE SCRIPTING)System
SYSTEM$MIGRATE_SAML_IDP_REGISTRATIONSystem
SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGSSystem
SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGSSystem
SYSTEM$OPT_OUT_MALICIOUS_IP_PROTECTION_BY_CATEGORYSystem
SYSTEM$PIPE_FORCE_RESUMESystem
SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNELSystem
SYSTEM$PIPE_STATUSSystem
SYSTEM$PROVISION_PRIVATELINK_ENDPOINTSystem
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT_TSSSystem
SYSTEM$QUERY_REFERENCESystem
SYSTEM$READ_YAML_FROM_SEMANTIC_VIEWSystem
SYSTEM$REFERENCESystem
SYSTEM$REGISTER_CMK_INFOSystem
SYSTEM$REGISTER_CMK_INFO_POSTGRESSystem
SYSTEM$REGISTER_PRIVATELINK_ENDPOINTSystem
SYSTEM$REGISTRY_LIST_IMAGES — DEPRECATEDSystem
SYSTEM$REMOVE_ALL_REFERENCESSystem
SYSTEM$REMOVE_REFERENCESystem
SYSTEM$REPORT_HEALTH_STATUSSystem
SYSTEM$RESOLVE_PYTHON_PACKAGESSystem
SYSTEM$RESTORE_PRIVATELINK_ENDPOINTSystem
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT_TSSSystem
SYSTEM$REVOKE_PRIVATELINKSystem
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESSSystem
SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESHSystem
SYSTEM$SEND_NOTIFICATIONS_TO_CATALOGSystem
SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESSSystem
SYSTEM$SET_CATALOG_INTEGRATIONSystem
SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMANDSystem
SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECTSystem
SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGIONSystem
SYSTEM$SET_PRIVATELINK_ENDPOINT_HOSTNAMESystem
SYSTEM$SET_REFERENCESystem
SYSTEM$SET_RETURN_VALUESystem
SYSTEM$SET_ROW_TIMESTAMP_ON_ALL_SUPPORTED_TABLESSystem
SYSTEM$SET_SPAN_ATTRIBUTES (FOR SNOWFLAKE SCRIPTING)System
SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLESSystem
SYSTEM$SHOW_BUDGETS_FOR_RESOURCESystem
SYSTEM$SHOW_BUDGETS_IN_ACCOUNTSystem
SYSTEM$SHOW_EVENT_SHARING_ACCOUNTSSystem
SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUSSystem
SYSTEM$SHOW_OAUTH_CLIENT_SECRETSSystem
SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIESSystem
SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKENSystem
SYSTEM$START_OAUTH_FLOWSystem
SYSTEM$START_USER_EMAIL_VERIFICATIONSystem
SYSTEM$STREAM_GET_TABLE_TIMESTAMPSystem
SYSTEM$STREAM_HAS_DATASystem
SYSTEM$SUPPORTED_DBT_VERSIONSSystem
SYSTEM$TASK_DEPENDENTS_ENABLESystem
SYSTEM$TASK_RUNTIME_INFOSystem
SYSTEM$TRIGGER_LISTING_REFRESHSystem
SYSTEM$TYPEOFSystem
SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESSSystem
SYSTEM$UNLINK_ORGANIZATION_USERSystem
SYSTEM$UNLINK_ORGANIZATION_USER_GROUPSystem
SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINTSystem
SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMANDSystem
SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECTSystem
SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGIONSystem
SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONSSystem
SYSTEM$VALIDATE_STORAGE_INTEGRATIONSystem
SYSTEM$VERIFY_CATALOG_INTEGRATIONSystem
SYSTEM$VERIFY_CMK_INFOSystem
SYSTEM$VERIFY_CMK_INFO_POSTGRESSystem
SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKENSystem
SYSTEM$VERIFY_EXTERNAL_VOLUMESystem
SYSTEM$WAITSystem
SYSTEM$WAIT_FOR_SERVICESSystem
SYSTEM$WHITELIST — DEPRECATEDSystem
SYSTEM$WHITELIST_PRIVATELINK — DEPRECATEDSystem
<SERVICE_NAME>!SPCS_CANCEL_JOBTable
<SERVICE_NAME>!SPCS_GET_EVENTSTable
<SERVICE_NAME>!SPCS_GET_LOGSTable
<SERVICE_NAME>!SPCS_GET_METRICSTable
APPLICATION_CONFIGURATION_VALUE_HISTORYTable
CORTEX_SEARCH_DATA_SCANTable
CUMULATIVE_PRIVACY_LOSSESTable
FLATTENTable
GENERATORTable
GET_AI_EVALUATION_DATA (SNOWFLAKE.LOCAL)Table
GET_AI_OBSERVABILITY_LOGS (SNOWFLAKE.LOCAL)Table
GET_AI_RECORD_TRACE (SNOWFLAKE.LOCAL)Table
GET_CONTACTSTable
GET_JOB_HISTORYTable
GET_LINEAGE (SNOWFLAKE.CORE)Table
GET_OBJECT_REFERENCESTable
ICEBERG_TABLE_FILESTable
ICEBERG_TABLE_SNAPSHOT_REFRESH_HISTORYTable
INFER_SCHEMATable
REST_EVENT_HISTORYTable
RESULT_SCANTable
STORAGE_LIFECYCLE_POLICY_HISTORYTable
SYSTEM$STREAM_BACKLOGTable
TO_QUERYTable
VALIDATETable
VECTOR_AVGVector
VECTOR_COSINE_SIMILARITYVector
VECTOR_INNER_PRODUCTVector
VECTOR_L1_DISTANCEVector
VECTOR_L2_DISTANCEVector
VECTOR_MAXVector
VECTOR_MINVector
VECTOR_NORMALIZEVector
VECTOR_SUMVector
VECTOR_TRUNCATEVector
CONDITIONAL_CHANGE_EVENTWindow
CONDITIONAL_TRUE_EVENTWindow
CUME_DISTWindow
INTERPOLATE_BFILL, INTERPOLATE_FFILL, INTERPOLATE_LINEARWindow
PERCENT_RANKWindow
RANKWindow
RATIO_TO_REPORTWindow
DENSE_RANKWindow function syntax and usage
FIRST_VALUEWindow function syntax and usage
LAGWindow function syntax and usage
LAST_VALUEWindow function syntax and usage
LEADWindow function syntax and usage
NTH_VALUEWindow function syntax and usage
NTILEWindow function syntax and usage
ROW_NUMBERWindow function syntax and usage
Loading table...

Was this page helpful?

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

0