Перейти к основному содержимому

Поддерживаемые функции Snowflake в dbt v2

dbt v2 может проверять соответствие аргументов функций Snowflake ожидаемым типам непосредственно в dbt platform, в CLI или с помощью расширения dbt для VS Code. Чтобы включить эту возможность, задайте static_analysis: strict в конфигурации проекта.

В следующей таблице перечислены все встроенные функции Snowflake и статус поддержки проверки типов для каждой из них. Используйте поиск и фильтры таблицы, чтобы найти нужные функции.

Обновляется еженедельно

Эта таблица еженедельно обновляется на основе справочника SQL-функций Snowflake, а затем сверяется со списком функций, поддерживаемых dbt v2. Если вы заметите несоответствие, будем рады вашему участию — создайте issue в репозитории dbt v1!

Function
Categoryv2 typechecking
TAG_REFERENCES_WITH_LINEAGEAccount Usage table✓
ACCUMULATEAggregate—
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_SUMAggregate—
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_AGENT_ACTIVATED (SYS_CONTEXT FUNCTION)Context—
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$CURRENT NAMESPACE)Context—
SYS_CONTEXT (SNOWFLAKE$ENVIRONMENT NAMESPACE)Context—
SYS_CONTEXT (SNOWFLAKE$ORGANIZATION NAMESPACE)Context—
SYS_CONTEXT (SNOWFLAKE$ORGANIZATION_SESSION NAMESPACE)Context—
SYS_CONTEXT (SNOWFLAKE$ORGANIZATION_SHARING 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_IPADDRESSConversion—
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_IPADDRESSConversion—
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—
ACCEPTED_VALUES_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
ACCURACY (SYSTEM DATA METRIC FUNCTION)Data metric—
ALL_SPACE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
ALL_SPACE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
APPROX_QUANTILE_20 (SYSTEM DATA METRIC FUNCTION)Data metric—
APPROX_QUANTILE_25 (SYSTEM DATA METRIC FUNCTION)Data metric—
APPROX_QUANTILE_40 (SYSTEM DATA METRIC FUNCTION)Data metric—
APPROX_QUANTILE_50 (SYSTEM DATA METRIC FUNCTION)Data metric—
APPROX_QUANTILE_60 (SYSTEM DATA METRIC FUNCTION)Data metric—
APPROX_QUANTILE_80 (SYSTEM DATA METRIC FUNCTION)Data metric—
APPROX_QUANTILE_95 (SYSTEM DATA METRIC FUNCTION)Data metric—
APPROX_QUANTILE_99 (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—
CASE_FORMAT_VIOLATION_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
CASE_FORMAT_VIOLATION_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
CONTAINS_SPACES_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
CONTAINS_SPACES_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—
DUPLICATE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
EMPTY_STRING_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
EMPTY_STRING_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
EXTREME_OUTLIER_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
EXTREME_OUTLIER_IQR_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
EXTREME_OUTLIER_IQR_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
EXTREME_OUTLIER_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
EXTREME_OUTLIER_ZSCORE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
EXTREME_OUTLIER_ZSCORE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
FALSE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
FALSE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
FRESHNESS (SYSTEM DATA METRIC FUNCTION)Data metric—
FUTURE_TIMESTAMP_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
FUTURE_TIMESTAMP_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
GEOMETRIC_MEAN (SYSTEM DATA METRIC FUNCTION)Data metric—
HARMONIC_MEAN (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_CA_POSTAL_CODE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_CA_POSTAL_CODE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_CA_SIN_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_CA_SIN_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_CH_OASI_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_CH_OASI_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_CUSIP_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_CUSIP_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_DE_POSTAL_CODE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_DE_POSTAL_CODE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_DE_TAX_ID_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_DE_TAX_ID_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_EMAIL_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_EMAIL_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_ES_DNI_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_ES_DNI_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_FIGI_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_FIGI_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_FR_INSEE_CODE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_FR_INSEE_CODE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_FR_POSTAL_CODE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_FR_POSTAL_CODE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_INTEGER_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_INTEGER_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_ISIN_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_ISIN_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_ISO8601_FORMAT_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_ISO8601_FORMAT_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_IT_FISCAL_CODE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_IT_FISCAL_CODE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_JSON_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_JSON_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_LATITUDE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_LATITUDE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_LEI_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_LEI_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_LONGITUDE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_LONGITUDE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_NL_BSN_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_NL_BSN_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_NUMERIC_TYPE_CAST_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_NUMERIC_TYPE_CAST_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_PERCENTAGE_RANGE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_PERCENTAGE_RANGE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_PERM_ID_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_PERM_ID_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_PL_PESEL_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_PL_PESEL_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_PROBABILITY_RANGE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_PROBABILITY_RANGE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_SEDOL_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_SEDOL_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_TIMESTAMP_STRING_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_TIMESTAMP_STRING_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_TR_ID_NO_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_TR_ID_NO_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_UK_NINO_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_UK_NINO_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_UK_POSTAL_CODE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_UK_POSTAL_CODE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_USA_PHONE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_USA_PHONE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_USA_STATE_CODE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_USA_STATE_CODE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_USA_ZIP_CODE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_USA_ZIP_CODE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_UUID_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
INVALID_UUID_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
KURTOSIS (SYSTEM DATA METRIC FUNCTION)Data metric✓
MAE (SYSTEM DATA METRIC FUNCTION)Data metric—
MAPE (SYSTEM DATA METRIC FUNCTION)Data metric—
MAX (SYSTEM DATA METRIC FUNCTION)Data metric✓
MEAN_ERROR (SYSTEM DATA METRIC FUNCTION)Data metric—
MEDIAN (SYSTEM DATA METRIC FUNCTION)Data metric✓
MIN (SYSTEM DATA METRIC FUNCTION)Data metric✓
NAN_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NAN_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NEGATIVE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NEGATIVE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_FRIDAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_FRIDAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_IN_FUTURE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_IN_FUTURE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_MONDAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_MONDAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_NULL_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_NULL_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_SATURDAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_SATURDAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_SUNDAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_SUNDAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_THURSDAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_THURSDAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_TODAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_TODAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_TUESDAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_TUESDAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_WEDNESDAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_WEDNESDAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_WEEKDAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_WEEKDAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_YESTERDAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NOT_YESTERDAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NULL_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NULL_KEYWORD_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
NULL_KEYWORD_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
NULL_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
OUTLIER_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
OUTLIER_IQR_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
OUTLIER_IQR_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
OUTLIER_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
OUTLIER_ZSCORE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
OUTLIER_ZSCORE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
R_SQUARED (SYSTEM DATA METRIC FUNCTION)Data metric—
REFERENTIAL_INTEGRITY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
RMSE (SYSTEM DATA METRIC FUNCTION)Data metric—
ROW_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROW_COUNT_DIFFERENCE (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_DAY_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_DAY_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_HOUR_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_HOUR_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_MONTH_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_MONTH_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_WEEK_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_WEEK_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_YEAR_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
ROWS_IN_PAST_YEAR_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
SCHEMA_CHANGE_ADD_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
SCHEMA_CHANGE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
SCHEMA_CHANGE_DROP_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
SCHEMA_CHANGE_TYPE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
SKEW (SYSTEM DATA METRIC FUNCTION)Data metric✓
SOURCE_TARGET_LAG (SYSTEM DATA METRIC FUNCTION)Data metric—
SPECIAL_CHARACTER_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
SPECIAL_CHARACTER_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
STDDEV (SYSTEM DATA METRIC FUNCTION)Data metric✓
STRING_LENGTH_AVG (SYSTEM DATA METRIC FUNCTION)Data metric—
STRING_LENGTH_MAX (SYSTEM DATA METRIC FUNCTION)Data metric—
STRING_LENGTH_MIN (SYSTEM DATA METRIC FUNCTION)Data metric—
STRING_LENGTH_STDDEV (SYSTEM DATA METRIC FUNCTION)Data metric—
SUM (SYSTEM DATA METRIC FUNCTION)Data metric✓
TABLE_SIZE_BYTES (SYSTEM DATA METRIC FUNCTION)Data metric—
TRUE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
TRUE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
UNIQUE_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
UNIQUE_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
UNIX_ZERO_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
UNIX_ZERO_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
UNTRIMMED_STRING_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
UNTRIMMED_STRING_PERCENT (SYSTEM DATA METRIC FUNCTION)Data metric—
VARIANCE (SYSTEM DATA METRIC FUNCTION)Data metric✓
ZERO_COUNT (SYSTEM DATA METRIC FUNCTION)Data metric—
ZERO_PERCENT (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_GRAPH_CHANGESInformation Schema—
TASK_HISTORYInformation Schema✓
VALIDATE_PIPE_LOADInformation Schema✓
WAREHOUSE_LOAD_HISTORYInformation Schema✓
WAREHOUSE_METERING_HISTORYInformation Schema✓
IPADDRESS_TRUNCIPADDRESS—
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—
PERIOD_BEGINPeriod—
PERIOD_CONSTRUCTPeriod—
PERIOD_CONTAINSPeriod—
PERIOD_ENDPeriod—
PERIOD_EQUALSPeriod—
PERIOD_IMMEDIATELY_PRECEDESPeriod—
PERIOD_IMMEDIATELY_SUCCEEDSPeriod—
PERIOD_INTERSECTPeriod—
PERIOD_LDIFFPeriod—
PERIOD_MEETSPeriod—
PERIOD_OVERLAPSPeriod—
PERIOD_PRECEDESPeriod—
PERIOD_RDIFFPeriod—
PERIOD_SUCCEEDSPeriod—
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_CONSTRUCT_STRUCTUREDSemi-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_REPEATSemi-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_CONSTRUCTSemi-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_CONSTRUCT_KEEP_NULL_STRUCTUREDSemi-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_COMPLETE (STRUCTURED OUTPUTS)String & binary✓
AI_COUNT_TOKENSString & binary✓
AI_EMBEDString & binary✓
AI_EXTRACTString & binary✓
AI_EXTRACT (DOCUMENT AI LEGACY MODELS)String & binary✓
AI_FILTERString & binary✓
AI_MULTI_EMBEDString & binary—
AI_PARSE_DOCUMENTString & binary✓
AI_REDACTString & binary✓
AI_SENTIMENTString & binary✓
AI_SIMILARITYString & binary✓
AI_SUMMARIZEString & 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✓
EVALUATE AN AI FUNCTION (AI_FUNCTION_EVALUATION)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✓
FORMAT_STRING_TEMPLATEString & 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✓
OPTIMIZE AN AI FUNCTION (AI_FUNCTION_OPTIMIZATION)String & 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✓
THREAD_MESSAGES (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_GRANTABLE_PRIVILEGESSystem—
EXPLAIN_JSONSystem—
EXPLAIN_PRIVILEGESSystem—
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$ACTIVATE_CMK_INFO_SNOWFLAKE_MANAGED_VOLUMESystem—
SYSTEM$ADD_EVENT (FOR SNOWFLAKE SCRIPTING)System—
SYSTEM$ADD_PRIVATELINK_ENDPOINT_HOSTNAMESystem—
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_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESSSystem—
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$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESSSystem—
SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_WITH_EXCEPTIONSystem—
SYSTEM$CANCEL_ALL_QUERIESSystem✓
SYSTEM$CANCEL_QUERYSystem✓
SYSTEM$CAST_MULTI_PARTY_APPROVAL_VOTESystem—
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$CREATE_EVALUATION_DATASETSystem—
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$DBT_GET_LAST_FAILED_RUN_TARGETSystem—
SYSTEM$DBT_GET_LAST_RUN_TARGETSystem—
SYSTEM$DBT_GET_LAST_SUCCESSFUL_RUN_TARGETSystem—
SYSTEM$DEACTIVATE_CMK_INFOSystem—
SYSTEM$DEACTIVATE_CMK_INFO_SNOWFLAKE_MANAGED_VOLUMESystem—
SYSTEM$DECODE_PATSystem—
SYSTEM$DEMIGRATE_DBT_PROJECTSystem—
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINTSystem—
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT_TSSSystem—
SYSTEM$DEREGISTER_CMK_INFOSystem—
SYSTEM$DEREGISTER_CMK_INFO_POSTGRESSystem—
SYSTEM$DEREGISTER_CMK_INFO_SNOWFLAKE_MANAGED_VOLUMESystem—
SYSTEM$DESC_ICEBERG_ACCESS_IDENTITYSystem—
SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLESystem—
SYSTEM$DISABLE_DATABASE_REPLICATIONSystem✓
SYSTEM$DISABLE_FEATURE_GROUPSSystem—
SYSTEM$DISABLE_FEATURE_GROUPS_PREVIEWSystem—
SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNTSystem—
SYSTEM$DISABLE_PREVIEW_ACCESSSystem—
SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLYSystem—
SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLESystem—
SYSTEM$ENABLE_FEATURE_GROUPSSystem—
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$EXECUTE_CATALOG_OPERATIONSystem—
SYSTEM$EXPLAIN_JSON_TO_TEXTSystem✓
SYSTEM$EXPLAIN_PLAN_JSONSystem✓
SYSTEM$EXPORT_TDS_FROM_SEMANTIC_VIEWSystem—
SYSTEM$EXTERNAL_TABLE_PIPE_STATUSSystem✓
SYSTEM$FETCH_EXTERNAL_SECRET_FROM_INTEGRATIONSystem—
SYSTEM$FINISH_OAUTH_FLOWSystem—
SYSTEM$GENERATE_SAML_CSRSystem✓
SYSTEM$GENERATE_SCIM_ACCESS_TOKENSystem—
SYSTEM$GET_ALERT_CONFIGSystem—
SYSTEM$GET_ALERT_TEMPLATESystem—
SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDESSystem—
SYSTEM$GET_ALL_REFERENCESSystem✓
SYSTEM$GET_APPLICATION_SERVICE_LOGSSystem—
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_CONFIG_SNOWFLAKE_MANAGED_VOLUMESystem—
SYSTEM$GET_CMK_INFOSystem—
SYSTEM$GET_CMK_INFO_POSTGRESSystem—
SYSTEM$GET_CMK_INFO_SNOWFLAKE_MANAGED_VOLUMESystem—
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_LISTING_URL_FOR_EXTERNAL_CONSUMERSystem—
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_SECURITY_INTEGRATIONS_FOR_API_PROVIDERSystem—
SYSTEM$GET_SERVICE_CALLER_TOKEN_EXPIRYSystem—
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_TABLE_ARCHIVE_METADATASystem—
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$GET_TZDB_VERSIONSystem—
SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETERSystem✓
SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNTSystem✓
SYSTEM$INGEST_REBIND_PIPESystem—
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$ISSUE_PER_ACCOUNT_APP_SERVICE_CERTIFICATESystem—
SYSTEM$ISSUE_PER_ACCOUNT_CERTIFICATESSystem—
SYSTEM$ISSUE_WORKLOAD_IDENTITY_FEDERATION_TOKENSystem—
SYSTEM$LAST_CHANGE_COMMIT_TIMESystem✓
SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAMESystem—
SYSTEM$LINK_ORGANIZATION_USERSystem—
SYSTEM$LINK_ORGANIZATION_USER_GROUPSystem—
SYSTEM$LIST_ALERT_TEMPLATESSystem—
SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURESSystem—
SYSTEM$LIST_EXTERNAL_SECRETSSystem—
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_DBT_PROJECTSystem—
SYSTEM$MIGRATE_LEGACY_EVENT_ROUTING_CONFIGURATIONSystem—
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$PARQUET_DIRECT_AUTO_REFRESH_STATUSSystem—
SYSTEM$PIPE_FORCE_RESUMESystem✓
SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNELSystem✓
SYSTEM$PIPE_STATUSSystem✓
SYSTEM$PREDECESSORS_STATESystem—
SYSTEM$PROVISION_PRIVATELINK_ENDPOINTSystem—
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT_TSSSystem—
SYSTEM$QUERY_REFERENCESystem✓
SYSTEM$READ_OSI_YAML_FROM_SEMANTIC_VIEWSystem—
SYSTEM$READ_OSSIE_YAML_FROM_SEMANTIC_VIEWSystem—
SYSTEM$READ_YAML_FROM_SEMANTIC_VIEWSystem—
SYSTEM$REFERENCESystem✓
SYSTEM$REGISTER_CMK_INFOSystem—
SYSTEM$REGISTER_CMK_INFO_POSTGRESSystem—
SYSTEM$REGISTER_CMK_INFO_SNOWFLAKE_MANAGED_VOLUMESystem—
SYSTEM$REGISTER_PRIVATELINK_ENDPOINTSystem—
SYSTEM$REGISTRY_LIST_IMAGES — DEPRECATEDSystem—
SYSTEM$REMOTE_APP_OPERATIONSystem—
SYSTEM$REMOVE_ALL_REFERENCESSystem✓
SYSTEM$REMOVE_PRIVATELINK_ENDPOINT_HOSTNAMESystem—
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_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESSSystem—
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_BUDGET_SHARED_RESOURCE_CANDIDATESSystem—
SYSTEM$SHOW_BUDGETS_FOR_RESOURCESystem—
SYSTEM$SHOW_BUDGETS_IN_ACCOUNTSystem—
SYSTEM$SHOW_DYNAMIC_TABLES_CREATED_FOR_RESHARINGSystem—
SYSTEM$SHOW_EVENT_SHARING_ACCOUNTSSystem—
SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUSSystem—
SYSTEM$SHOW_OAUTH_CLIENT_SECRETSSystem—
SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIESSystem—
SYSTEM$SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_STATUSSystem—
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$TAG_VALUE_CONTAINSSystem—
SYSTEM$TASK_COMPLETION_STATESystem—
SYSTEM$TASK_DEPENDENTS_ENABLESystem✓
SYSTEM$TASK_RUNTIME_INFOSystem✓
SYSTEM$TRIGGER_LISTING_REFRESHSystem—
SYSTEM$TYPEOFSystem✓
SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESSSystem—
SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESSSystem—
SYSTEM$UNLINK_ORGANIZATION_USERSystem—
SYSTEM$UNLINK_ORGANIZATION_USER_GROUPSystem—
SYSTEM$UNMANAGE_ENTITY_FROM_DCM_PROJECTSystem—
SYSTEM$UNMANAGE_FROM_DCM_PROJECTSystem—
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$UNVERIFY_DNS_DOMAINSystem—
SYSTEM$UPDATE_MULTI_PARTY_APPROVAL_JUSTIFICATIONSystem—
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_CMK_INFO_SNOWFLAKE_MANAGED_VOLUMESystem—
SYSTEM$VERIFY_DNS_DOMAINSystem—
SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKENSystem✓
SYSTEM$VERIFY_EXTERNAL_SECRET_INTEGRATIONSystem—
SYSTEM$VERIFY_EXTERNAL_VOLUMESystem—
SYSTEM$WAITSystem✓
SYSTEM$WAIT_FOR_OPENFLOW_CONNECTOR_STATUSSystem—
SYSTEM$WAIT_FOR_OPENFLOW_DEPLOYMENT_STATUSSystem—
SYSTEM$WAIT_FOR_OPENFLOW_RUNTIME_STATUSSystem—
SYSTEM$WAIT_FOR_SERVICESSystem—
SYSTEM$WAIT_FOR_STABLE_OPENFLOW_CONNECTORSSystem—
SYSTEM$WAIT_FOR_STABLE_OPENFLOW_DEPLOYMENTSSystem—
SYSTEM$WAIT_FOR_STABLE_OPENFLOW_RUNTIMESSystem—
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_BATCHTable—
CORTEX_SEARCH_DATA_SCANTable—
CUMULATIVE_PRIVACY_LOSSESTable—
ESTIMATE_HYBRID_TABLE_STORAGE_USAGETable—
FLATTENTable✓
GENERATORTable✓
GET_AI_EVALUATION_DATA (SNOWFLAKE.LOCAL)Table—
GET_AI_OBSERVABILITY_EVENTS (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✓
GET_TABLE_VERSION_REFSTable—
GET_TABLE_VERSIONSTable—
ICEBERG_TABLE_FILE_REGISTRATION_HISTORYTable—
ICEBERG_TABLE_FILESTable—
ICEBERG_TABLE_SNAPSHOT_REFRESH_HISTORYTable—
INFER_SCHEMATable✓
MY_BUDGET_SUMMARY (SNOWFLAKE.LOCAL)Table—
REPLICATION_GROUP_LAG_HISTORYTable—
REST_EVENT_HISTORYTable✓
RESULT_SCANTable✓
SEMANTIC_VIEW_MATERIALIZATION_REFRESH_HISTORYTable—
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✓

Нашли ошибку?

0