LocalStack for Snowflake — feature catalog
snowflake-next 0.2.0What supported / partial / not supported / deferred mean
| Status | Meaning |
|---|---|
| ✅ supported | Works as in Snowflake. |
| 🟡 partial | Works for common usage; some inputs, syntax options or behaviors are unverified or still differ from Snowflake. |
| ❌ not supported | Not available yet. |
| ⏸️ deferred | Not available, and deliberately not planned for the emulator. |
916 of 1223 documented · 75%847 supported107 partial295 not supported12 deferred
Functions
Signatures use Snowflake type names; ANY accepts every Snowflake type. Names link to the Snowflake SQL reference.
Account Usage table functions (1)
| Function | Kind | Status | Signatures |
|---|---|---|---|
TAG_REFERENCES_WITH_LINEAGE | unknown | ✅ supported | — |
Aggregate functions (78)
| Function | Kind | Status | Signatures |
|---|---|---|---|
ACCUMULATE | unknown | ✅ supported | — |
AGG | unknown | ✅ supported | — |
AI_AGG | unknown | ❌ not supported | — |
AI_SUMMARIZE_AGG | unknown | ❌ not supported | — |
ANY_VALUE | aggregate | 🟡 partial | (ANY) |
APPROXIMATE_JACCARD_INDEX | aggregate | 🟡 partial | (OBJECT) |
APPROXIMATE_SIMILARITY | aggregate | 🟡 partial | (OBJECT) |
APPROX_COUNT_DISTINCT | aggregate | 🟡 partial | (ANY)(ANY, ANY) |
APPROX_PERCENTILE | aggregate | 🟡 partial | (FLOAT, FLOAT) |
APPROX_PERCENTILE_ACCUMULATE | aggregate | ✅ supported | (FLOAT) |
APPROX_PERCENTILE_COMBINE | aggregate | ✅ supported | (OBJECT) |
APPROX_PERCENTILE_ESTIMATE | scalar | ✅ supported | (OBJECT, FLOAT) → FLOAT |
APPROX_TOP_K | aggregate | 🟡 partial | (ANY, NUMBER) |
APPROX_TOP_K_ACCUMULATE | aggregate | ✅ supported | (ANY, NUMBER) |
APPROX_TOP_K_COMBINE | aggregate | 🟡 partial | (OBJECT) |
APPROX_TOP_K_ESTIMATE | scalar | ✅ supported | (OBJECT, NUMBER) → VARIANT |
ARRAY_AGG | aggregate | 🟡 partial | (ANY) |
ARRAY_UNION_AGG | aggregate | 🟡 partial | (ARRAY) |
ARRAY_UNIQUE_AGG | aggregate | 🟡 partial | (ANY) |
AVG | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
BITAND_AGG | aggregate | ✅ supported | (NUMBER) |
BITMAP_ABSOLUTE_POSITION | scalar | ✅ supported | (NUMBER, NUMBER) → NUMBER |
BITMAP_AND | scalar | ✅ supported | (ANY, BINARY) → BINARY(BINARY, ANY) → BINARY(BINARY, BINARY) → BINARY(BINARY, BOOLEAN) → BINARY(BINARY, FLOAT) → BINARY(BINARY, NUMBER) → BINARY(BINARY, VARCHAR) → BINARY(BINARY, VARIANT) → BINARY(BOOLEAN, BINARY) → BINARY(FLOAT, BINARY) → BINARY(NUMBER, BINARY) → BINARY(VARCHAR, BINARY) → BINARY(VARIANT, BINARY) → BINARY |
BITMAP_AND_AGG | aggregate | ✅ supported | (ANY)(BINARY)(BOOLEAN) → BINARY(FLOAT) → BINARY(NUMBER) → BINARY(VARCHAR) → BINARY(VARIANT) → BINARY |
BITMAP_BIT_POSITION | scalar | ✅ supported | (NUMBER) → NUMBER |
BITMAP_BUCKET_NUMBER | scalar | ✅ supported | (NUMBER) → NUMBER |
BITMAP_CONSTRUCT_AGG | aggregate | ✅ supported | (NUMBER) |
BITMAP_COUNT | scalar | ✅ supported | (BINARY) → NUMBER |
BITMAP_OR | scalar | ✅ supported | (ANY, BINARY) → BINARY(BINARY, ANY) → BINARY(BINARY, BINARY) → BINARY(BINARY, BOOLEAN) → BINARY(BINARY, FLOAT) → BINARY(BINARY, NUMBER) → BINARY(BINARY, VARCHAR) → BINARY(BINARY, VARIANT) → BINARY(BOOLEAN, BINARY) → BINARY(FLOAT, BINARY) → BINARY(NUMBER, BINARY) → BINARY(VARCHAR, BINARY) → BINARY(VARIANT, BINARY) → BINARY |
BITMAP_OR_AGG | aggregate | ✅ supported | (BINARY) |
BITMAP_TO_ARRAY | scalar | 🟡 partial | (ANY) → ARRAY(BINARY) → ARRAY(BOOLEAN) → ARRAY(FLOAT) → ARRAY(NUMBER) → ARRAY(VARCHAR) → ARRAY(VARIANT) → ARRAY |
BITOR_AGG | aggregate | 🟡 partial | (NUMBER) |
BITXOR_AGG | aggregate | 🟡 partial | (NUMBER) |
BOOLAND_AGG | aggregate | 🟡 partial | (ANY)(BOOLEAN)(NUMBER)(VARCHAR)(VARIANT) |
BOOLOR_AGG | aggregate | 🟡 partial | (ANY)(BOOLEAN)(NUMBER)(VARCHAR)(VARIANT) |
BOOLXOR_AGG | aggregate | 🟡 partial | (ANY)(BOOLEAN)(NUMBER)(VARCHAR)(VARIANT) |
CORR | aggregate | 🟡 partial | (FLOAT, FLOAT) |
COUNT | aggregate | ✅ supported | (*)(ANY) |
COUNT_IF | aggregate | 🟡 partial | (BOOLEAN) |
COVAR_POP | aggregate | 🟡 partial | (FLOAT, FLOAT) |
COVAR_SAMP | aggregate | 🟡 partial | (FLOAT, FLOAT) |
DATASKETCHES_HLL | aggregate | 🟡 partial | (ANY)(ANY, ANY) |
DATASKETCHES_HLL_ACCUMULATE | aggregate | 🟡 partial | (ANY) |
DATASKETCHES_HLL_COMBINE | aggregate | 🟡 partial | (BINARY) |
DATASKETCHES_HLL_ESTIMATE | scalar | ✅ supported | (BINARY) → FLOAT |
GROUPING | unknown | 🟡 partial | — |
GROUPING_ID | unknown | ✅ supported | — |
HASH_AGG | aggregate | 🟡 partial | (NUMBER) |
HLL | aggregate | 🟡 partial | (ANY)(ANY, ANY) |
HLL_ACCUMULATE | aggregate | 🟡 partial | (ANY) |
HLL_COMBINE | aggregate | 🟡 partial | (BINARY) |
HLL_ESTIMATE | scalar | 🟡 partial | (BINARY) → NUMBER |
HLL_EXPORT | scalar | 🟡 partial | (BINARY) → OBJECT |
HLL_IMPORT | scalar | 🟡 partial | (ANY) → BINARY(OBJECT) → BINARY(VARIANT) → BINARY |
LISTAGG | aggregate | 🟡 partial | (VARCHAR, VARCHAR) |
MAX_BY | aggregate | ✅ supported | (ANY, ANY)(ANY, ANY, NUMBER) |
MINHASH | aggregate | 🟡 partial | (NUMBER, ANY) |
MINHASH_COMBINE | aggregate | 🟡 partial | (OBJECT) |
MIN_BY | aggregate | ✅ supported | (ANY, ANY)(ANY, ANY, NUMBER) |
MODE | aggregate | 🟡 partial | (ANY) |
OBJECT_AGG | aggregate | 🟡 partial | (VARCHAR, VARIANT) |
PERCENTILE_CONT | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
PERCENTILE_DISC | aggregate | 🟡 partial | (ANY) |
REGR_AVGX | aggregate | ✅ supported | (FLOAT, FLOAT) |
REGR_AVGY | aggregate | ✅ supported | (FLOAT, FLOAT) |
REGR_COUNT | aggregate | 🟡 partial | (FLOAT, FLOAT) |
REGR_INTERCEPT | aggregate | ✅ supported | (FLOAT, FLOAT) |
REGR_R2 | aggregate | ✅ supported | (FLOAT, FLOAT) |
REGR_SLOPE | aggregate | ✅ supported | (FLOAT, FLOAT) |
REGR_SXX | aggregate | ✅ supported | (FLOAT, FLOAT) |
REGR_SXY | aggregate | ✅ supported | (FLOAT, FLOAT) |
REGR_SYY | aggregate | 🟡 partial | (FLOAT, FLOAT) |
STDDEV_POP | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
STDDEV_SAMP | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
VARIANCE_POP | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
VARIANCE_SAMP | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
VAR_POP | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
VAR_SAMP | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
Bitwise expression functions (7)
| Function | Kind | Status | Signatures |
|---|---|---|---|
BITAND | scalar | 🟡 partial | (ANY, ANY) → NUMBER(DECFLOAT, DECFLOAT) → NUMBER(NUMBER, NUMBER) → NUMBER |
BITNOT | scalar | ✅ supported | (NUMBER) → NUMBER |
BITOR | scalar | 🟡 partial | (NUMBER, NUMBER) → NUMBER |
BITSHIFTLEFT | scalar | ✅ supported | (NUMBER, NUMBER) → NUMBER |
BITSHIFTRIGHT | scalar | ✅ supported | (NUMBER, NUMBER) → NUMBER |
BITXOR | scalar | 🟡 partial | (NUMBER, NUMBER) → NUMBER |
GETBIT | scalar | ✅ supported | (NUMBER, NUMBER) → NUMBER |
Conditional expression functions (21)
| Function | Kind | Status | Signatures |
|---|---|---|---|
BOOLAND | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(FLOAT, FLOAT) → BOOLEAN(FLOAT, NUMBER) → BOOLEAN(FLOAT, VARCHAR) → BOOLEAN(FLOAT, VARIANT) → BOOLEAN(NUMBER, FLOAT) → BOOLEAN(NUMBER, NUMBER) → BOOLEAN(NUMBER, VARCHAR) → BOOLEAN(NUMBER, VARIANT) → BOOLEAN(VARCHAR, FLOAT) → BOOLEAN(VARCHAR, NUMBER) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARIANT) → BOOLEAN(VARIANT, FLOAT) → BOOLEAN(VARIANT, NUMBER) → BOOLEAN(VARIANT, VARCHAR) → BOOLEAN(VARIANT, VARIANT) → BOOLEAN |
BOOLNOT | scalar | ✅ supported | (ANY) → BOOLEAN(FLOAT) → BOOLEAN(NUMBER) → BOOLEAN(VARCHAR) → BOOLEAN(VARIANT) → BOOLEAN |
BOOLOR | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(FLOAT, FLOAT) → BOOLEAN(FLOAT, NUMBER) → BOOLEAN(FLOAT, VARCHAR) → BOOLEAN(FLOAT, VARIANT) → BOOLEAN(NUMBER, FLOAT) → BOOLEAN(NUMBER, NUMBER) → BOOLEAN(NUMBER, VARCHAR) → BOOLEAN(NUMBER, VARIANT) → BOOLEAN(VARCHAR, FLOAT) → BOOLEAN(VARCHAR, NUMBER) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARIANT) → BOOLEAN(VARIANT, FLOAT) → BOOLEAN(VARIANT, NUMBER) → BOOLEAN(VARIANT, VARCHAR) → BOOLEAN(VARIANT, VARIANT) → BOOLEAN |
BOOLXOR | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(FLOAT, FLOAT) → BOOLEAN(FLOAT, NUMBER) → BOOLEAN(FLOAT, VARCHAR) → BOOLEAN(FLOAT, VARIANT) → BOOLEAN(NUMBER, FLOAT) → BOOLEAN(NUMBER, NUMBER) → BOOLEAN(NUMBER, VARCHAR) → BOOLEAN(NUMBER, VARIANT) → BOOLEAN(VARCHAR, FLOAT) → BOOLEAN(VARCHAR, NUMBER) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARIANT) → BOOLEAN(VARIANT, FLOAT) → BOOLEAN(VARIANT, NUMBER) → BOOLEAN(VARIANT, VARCHAR) → BOOLEAN(VARIANT, VARIANT) → BOOLEAN |
CASE | syntax | ✅ supported | — |
COALESCE | scalar | ✅ supported | (ANY) → SNOWFLAKE_NULL |
DECODE | unknown | ✅ supported | — |
EQUAL_NULL | unknown | ✅ supported | — |
GREATEST | scalar | ✅ supported | (ANY) → SNOWFLAKE_NULL |
GREATEST_IGNORE_NULLS | unknown | ✅ supported | — |
IFF | unknown | ✅ supported | — |
IFNULL | unknown | ✅ supported | — |
LEAST | scalar | ✅ supported | (ANY) → SNOWFLAKE_NULL |
LEAST_IGNORE_NULLS | unknown | ✅ supported | — |
NULLIF | unknown | ✅ supported | — |
NULLIFZERO | unknown | ✅ supported | — |
NVL | unknown | ✅ supported | — |
NVL2 | unknown | ✅ supported | — |
REGR_VALX | scalar | ✅ supported | (ANY, ANY) → FLOAT(BOOLEAN, FLOAT) → FLOAT(FLOAT, FLOAT) → FLOAT(NUMBER, FLOAT) → FLOAT(VARCHAR, FLOAT) → FLOAT(VARIANT, FLOAT) → FLOAT |
REGR_VALY | scalar | ✅ supported | (ANY, ANY) → FLOAT(FLOAT, BOOLEAN) → FLOAT(FLOAT, FLOAT) → FLOAT(FLOAT, NUMBER) → FLOAT(FLOAT, VARCHAR) → FLOAT(FLOAT, VARIANT) → FLOAT |
ZEROIFNULL | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → FLOAT(NUMBER) → NUMBER(VARCHAR) → FLOAT(VARIANT) → FLOAT |
Context functions (53)
| Function | Kind | Status | Signatures |
|---|---|---|---|
ALL_USER_NAMES | scalar | ✅ supported | () → VARCHAR |
CURRENT_ACCOUNT | scalar | ✅ supported | () → VARCHAR |
CURRENT_ACCOUNT_NAME | scalar | ✅ supported | () → VARCHAR |
CURRENT_AVAILABLE_ROLES | scalar | 🟡 partial | () → VARCHAR |
CURRENT_CLIENT | scalar | ✅ supported | () → VARCHAR |
CURRENT_DATABASE | scalar | ✅ supported | () → VARCHAR |
CURRENT_DATE | scalar | ✅ supported | () → DATE |
CURRENT_IP_ADDRESS | scalar | ✅ supported | () → VARCHAR |
CURRENT_ORGANIZATION_NAME | scalar | ✅ supported | () → VARCHAR |
CURRENT_ORGANIZATION_USER | scalar | ✅ supported | () → VARCHAR |
CURRENT_REGION | scalar | ✅ supported | () → VARCHAR |
CURRENT_ROLE | scalar | ✅ supported | () → VARCHAR |
CURRENT_ROLE_TYPE | scalar | ✅ supported | () → VARCHAR |
CURRENT_SCHEMA | scalar | ✅ supported | () → VARCHAR |
CURRENT_SCHEMAS | scalar | ✅ supported | () → VARCHAR |
CURRENT_SECONDARY_ROLES | scalar | 🟡 partial | () → VARCHAR |
CURRENT_SESSION | scalar | ✅ supported | () → VARCHAR |
CURRENT_STATEMENT | scalar | ✅ supported | () → VARCHAR |
CURRENT_TIME | scalar | ✅ supported | () → TIME |
CURRENT_TIMESTAMP | scalar | ✅ supported | () → TIMESTAMP_LTZ |
CURRENT_TRANSACTION | scalar | ✅ supported | () → VARCHAR |
CURRENT_USER | scalar | ✅ supported | () → VARCHAR |
CURRENT_VERSION | scalar | ✅ supported | () → VARCHAR |
CURRENT_WAREHOUSE | scalar | ✅ supported | () → VARCHAR |
GETDATE | scalar | ✅ supported | () → TIMESTAMP_LTZ |
GETVARIABLE | scalar | ✅ supported | (VARCHAR) → VARCHAR |
GET_CONDITION_QUERY_UUID | unknown | ✅ supported | — |
GET_CONFIGURATION_VALUE | unknown | ✅ supported | — |
INVOKER_ROLE | scalar | ✅ supported | () → VARCHAR |
INVOKER_SHARE | scalar | ✅ supported | () → VARCHAR |
IS_AGENT_ACTIVATED | unknown | ❌ not supported | — |
IS_APPLICATION_ROLE_ACTIVATED | unknown | ✅ supported | — |
IS_APPLICATION_ROLE_IN_SESSION | scalar | ✅ supported | (VARCHAR) → BOOLEAN |
IS_CONFIGURATION_SET | unknown | ✅ supported | — |
IS_DATABASE_ROLE_ACTIVATED | unknown | ✅ supported | — |
IS_DATABASE_ROLE_IN_SESSION | scalar | ✅ supported | (VARCHAR) → BOOLEAN |
IS_GRANTED_TO_INVOKER_ROLE | scalar | ✅ supported | (VARCHAR) → BOOLEAN |
IS_GROUP_ACTIVATED | unknown | ❌ not supported | — |
IS_GROUP_IMPORTED | unknown | ❌ not supported | — |
IS_INSTANCE_ROLE_IN_SESSION | unknown | ❌ not supported | — |
IS_ORGANIZATION_USER_GROUP_IN_SESSION | scalar | ✅ supported | (VARCHAR) → BOOLEAN |
IS_ROLE_ACTIVATED | unknown | ✅ supported | — |
IS_ROLE_IN_SESSION | scalar | ✅ supported | (VARCHAR) → BOOLEAN |
IS_USER_IMPORTED | unknown | ❌ not supported | — |
LAST_QUERY_ID | scalar | ✅ supported | (NUMBER) → VARCHAR |
LAST_TRANSACTION | scalar | ✅ supported | () → VARCHAR |
LOCALTIME | scalar | ✅ supported | () → TIME |
LOCALTIMESTAMP | scalar | ✅ supported | () → TIMESTAMP_LTZ |
POLICY_CONTEXT | unknown | ❌ not supported | — |
SET_SYS_CONTEXT | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR(ANY, ANY, ANY) → VARCHAR(VARCHAR, VARCHAR, VARCHAR) → VARCHAR |
SYSDATE | scalar | ✅ supported | () → TIMESTAMP_NTZ |
SYSTIMESTAMP | scalar | ✅ supported | () → TIMESTAMP_LTZ |
SYS_CONTEXT | scalar | ✅ supported | (ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(VARCHAR, VARCHAR, NUMBER) → VARCHAR |
Conversion functions (39)
| Function | Kind | Status | Signatures |
|---|---|---|---|
CAST | syntax | ✅ supported | — |
DATE | scalar | 🟡 partial | (ANY) → DATE(BOOLEAN) → DATE(FLOAT) → DATE(NUMBER) → DATE(TIMESTAMP_LTZ) → DATE(TIMESTAMP_NTZ) → DATE(TIMESTAMP_TZ) → DATE(VARCHAR) → DATE(VARIANT) → DATE(VARCHAR, VARCHAR) → DATE |
TIME | scalar | ✅ supported | (ANY) → TIME(BOOLEAN) → TIME(FLOAT) → TIME(NUMBER) → TIME(TIMESTAMP_LTZ) → TIME(TIMESTAMP_NTZ) → TIME(TIMESTAMP_TZ) → TIME(VARCHAR) → TIME(VARIANT) → TIME(VARCHAR, VARCHAR) → TIME |
TO_ARRAY | scalar | ✅ 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_BINARY | scalar | ✅ supported | (ANY) → BINARY(VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY |
TO_BOOLEAN | scalar | ✅ supported | (ANY) → BOOLEAN(BOOLEAN) → BOOLEAN(FLOAT) → BOOLEAN(NUMBER) → BOOLEAN(VARCHAR) → BOOLEAN(VARIANT) → BOOLEAN |
TO_CHAR | scalar | ✅ supported | (ANY) → VARCHAR(BINARY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(SNOWFLAKE_INTERVAL_DAY_TIME) → VARCHAR(SNOWFLAKE_INTERVAL_YEAR_MONTH) → 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_DATE | scalar | 🟡 partial | (ANY) → DATE(NUMBER) → DATE(TIMESTAMP_LTZ) → DATE(TIMESTAMP_NTZ) → DATE(TIMESTAMP_TZ) → DATE(VARCHAR) → DATE(VARIANT) → DATE(VARCHAR, VARCHAR) → DATE |
TO_DECFLOAT | scalar | ✅ supported | (ANY) → DECFLOAT(FLOAT) → DECFLOAT(NUMBER) → DECFLOAT(VARCHAR) → DECFLOAT(VARCHAR, VARCHAR) → DECFLOAT |
TO_DECIMAL | scalar | 🟡 partial | (ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(VARCHAR) → NUMBER(BOOLEAN, NUMBER) → NUMBER(BOOLEAN, VARCHAR) → NUMBER(FLOAT, NUMBER) → NUMBER(FLOAT, VARCHAR) → NUMBER(NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARIANT, NUMBER) → NUMBER(VARIANT, VARCHAR) → NUMBER(BOOLEAN, NUMBER, NUMBER) → NUMBER(BOOLEAN, VARCHAR, NUMBER) → NUMBER(FLOAT, NUMBER, NUMBER) → NUMBER(FLOAT, VARCHAR, NUMBER) → NUMBER(NUMBER, NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR, NUMBER) → NUMBER(VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARIANT, NUMBER, NUMBER) → NUMBER(VARIANT, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER |
TO_DOUBLE | scalar | ✅ supported | (ANY) → FLOAT(BOOLEAN) → FLOAT(FLOAT) → FLOAT(NUMBER) → FLOAT(VARCHAR) → FLOAT(VARCHAR, VARCHAR) → FLOAT |
TO_JSON | scalar | ✅ supported | (VARIANT) → VARCHAR |
TO_NUMBER | scalar | 🟡 partial | (ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(VARCHAR) → NUMBER(BOOLEAN, NUMBER) → NUMBER(BOOLEAN, VARCHAR) → NUMBER(FLOAT, NUMBER) → NUMBER(FLOAT, VARCHAR) → NUMBER(NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARIANT, NUMBER) → NUMBER(VARIANT, VARCHAR) → NUMBER(BOOLEAN, NUMBER, NUMBER) → NUMBER(BOOLEAN, VARCHAR, NUMBER) → NUMBER(FLOAT, NUMBER, NUMBER) → NUMBER(FLOAT, VARCHAR, NUMBER) → NUMBER(NUMBER, NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR, NUMBER) → NUMBER(VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARIANT, NUMBER, NUMBER) → NUMBER(VARIANT, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER |
TO_NUMERIC | scalar | 🟡 partial | (ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(VARCHAR) → NUMBER(BOOLEAN, NUMBER) → NUMBER(BOOLEAN, VARCHAR) → NUMBER(FLOAT, NUMBER) → NUMBER(FLOAT, VARCHAR) → NUMBER(NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARIANT, NUMBER) → NUMBER(VARIANT, VARCHAR) → NUMBER(BOOLEAN, NUMBER, NUMBER) → NUMBER(BOOLEAN, VARCHAR, NUMBER) → NUMBER(FLOAT, NUMBER, NUMBER) → NUMBER(FLOAT, VARCHAR, NUMBER) → NUMBER(NUMBER, NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR, NUMBER) → NUMBER(VARCHAR, NUMBER, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARIANT, NUMBER, NUMBER) → NUMBER(VARIANT, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, NUMBER) → NUMBER |
TO_OBJECT | scalar | ✅ supported | (ANY) → OBJECT(NUMBER) → OBJECT(OBJECT) → OBJECT(VARIANT) → OBJECT |
TO_TIME | scalar | ✅ supported | (ANY) → TIME(NUMBER) → TIME(TIMESTAMP_LTZ) → TIME(TIMESTAMP_NTZ) → TIME(TIMESTAMP_TZ) → TIME(VARCHAR) → TIME(VARIANT) → TIME(VARCHAR, VARCHAR) → TIME |
TO_TIMESTAMP | scalar | ✅ supported | (ANY) → TIMESTAMP_NTZ(NUMBER) → TIMESTAMP_NTZ(VARCHAR) → TIMESTAMP_NTZ(VARIANT) → TIMESTAMP_NTZ(VARCHAR, VARCHAR) → TIMESTAMP_NTZ |
TO_TIMESTAMP_LTZ | scalar | ✅ supported | (ANY) → TIMESTAMP_LTZ(NUMBER) → TIMESTAMP_LTZ(VARCHAR) → TIMESTAMP_LTZ(VARIANT) → TIMESTAMP_LTZ(VARCHAR, VARCHAR) → TIMESTAMP_LTZ |
TO_TIMESTAMP_NTZ | scalar | ✅ supported | (ANY) → TIMESTAMP_NTZ(NUMBER) → TIMESTAMP_NTZ(VARCHAR) → TIMESTAMP_NTZ(VARIANT) → TIMESTAMP_NTZ(VARCHAR, VARCHAR) → TIMESTAMP_NTZ |
TO_TIMESTAMP_TZ | scalar | ✅ supported | (ANY) → TIMESTAMP_TZ(NUMBER) → TIMESTAMP_TZ(VARCHAR) → TIMESTAMP_TZ(VARIANT) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → TIMESTAMP_TZ |
TO_UUID | scalar | ✅ supported | (ANY) → SNOWFLAKE_UUID(SNOWFLAKE_UUID) → SNOWFLAKE_UUID(VARCHAR) → SNOWFLAKE_UUID(VARIANT) → SNOWFLAKE_UUID |
TO_VARCHAR | scalar | ✅ supported | (ANY) → VARCHAR(BINARY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(SNOWFLAKE_INTERVAL_DAY_TIME) → VARCHAR(SNOWFLAKE_INTERVAL_YEAR_MONTH) → 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_VARIANT | scalar | ✅ 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_XML | scalar | ✅ supported | (VARIANT) → VARCHAR |
TRY_CAST | syntax | ✅ supported | — |
TRY_TO_BINARY | scalar | ✅ supported | (ANY) → BINARY(VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY |
TRY_TO_BOOLEAN | scalar | ✅ supported | (ANY) → BOOLEAN(BOOLEAN) → BOOLEAN(FLOAT) → BOOLEAN(NUMBER) → BOOLEAN(VARCHAR) → BOOLEAN |
TRY_TO_DATE | scalar | ✅ supported | (ANY) → DATE(VARCHAR) → DATE(VARIANT) → DATE(VARCHAR, VARCHAR) → DATE(VARIANT, VARCHAR) → DATE |
TRY_TO_DECFLOAT | scalar | 🟡 partial | (VARCHAR) → DECFLOAT |
TRY_TO_DECIMAL | scalar | ✅ 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_DOUBLE | scalar | ✅ supported | (ANY) → FLOAT(VARCHAR) → FLOAT(VARCHAR, VARCHAR) → FLOAT |
TRY_TO_NUMBER | scalar | ✅ 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_NUMERIC | scalar | ✅ 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_TIME | scalar | ✅ supported | (ANY) → TIME(VARCHAR) → TIME(VARIANT) → TIME(VARCHAR, VARCHAR) → TIME(VARIANT, VARCHAR) → TIME |
TRY_TO_TIMESTAMP | scalar | ✅ supported | (ANY) → TIMESTAMP_NTZ(VARCHAR) → TIMESTAMP_NTZ(VARIANT) → TIMESTAMP_NTZ(VARCHAR, VARCHAR) → TIMESTAMP_NTZ(VARIANT, VARCHAR) → TIMESTAMP_NTZ |
TRY_TO_TIMESTAMP_LTZ | scalar | ✅ supported | (ANY) → TIMESTAMP_LTZ(VARCHAR) → TIMESTAMP_LTZ(VARIANT) → TIMESTAMP_LTZ(VARCHAR, VARCHAR) → TIMESTAMP_LTZ(VARIANT, VARCHAR) → TIMESTAMP_LTZ |
TRY_TO_TIMESTAMP_NTZ | scalar | ✅ supported | (ANY) → TIMESTAMP_NTZ(VARCHAR) → TIMESTAMP_NTZ(VARIANT) → TIMESTAMP_NTZ(VARCHAR, VARCHAR) → TIMESTAMP_NTZ(VARIANT, VARCHAR) → TIMESTAMP_NTZ |
TRY_TO_TIMESTAMP_TZ | scalar | ✅ supported | (ANY) → TIMESTAMP_TZ(VARCHAR) → TIMESTAMP_TZ(VARIANT) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → TIMESTAMP_TZ(VARIANT, VARCHAR) → TIMESTAMP_TZ |
TRY_TO_UUID | scalar | ✅ supported | (ANY) → SNOWFLAKE_UUID(VARCHAR) → SNOWFLAKE_UUID(VARIANT) → SNOWFLAKE_UUID |
Data generation functions (9)
| Function | Kind | Status | Signatures |
|---|---|---|---|
NORMAL | scalar | ✅ supported | (FLOAT, FLOAT, FLOAT) → FLOAT |
RANDOM | scalar | ✅ supported | () → NUMBER(ANY) → NUMBER(NUMBER) → NUMBER |
RANDSTR | scalar | ✅ supported | (ANY, ANY) → VARCHAR(NUMBER, NUMBER) → VARCHAR |
SEQ1 | scalar | ✅ supported | () → NUMBER(ANY) → NUMBER(NUMBER) → NUMBER |
SEQ2 | scalar | ✅ supported | () → NUMBER(ANY) → NUMBER(NUMBER) → NUMBER |
SEQ4 | scalar | ✅ supported | () → NUMBER(ANY) → NUMBER(NUMBER) → NUMBER |
SEQ8 | scalar | ✅ supported | () → NUMBER(ANY) → NUMBER(NUMBER) → NUMBER |
UNIFORM | scalar | ✅ supported | (ANY, ANY, ANY) → NUMBER(FLOAT, FLOAT, FLOAT) → FLOAT(NUMBER, NUMBER, NUMBER) → NUMBER |
ZIPF | scalar | ✅ supported | (FLOAT, NUMBER, NUMBER) → NUMBER |
Data metric functions (189)
| Function | Kind | Status | Signatures |
|---|---|---|---|
ACCEPTED_VALUES | unknown | ✅ supported | — |
ACCURACY | unknown | ❌ not supported | — |
ALL_SPACE_COUNT | unknown | ✅ supported | — |
ALL_SPACE_PERCENT | unknown | ✅ supported | — |
APPROX_QUANTILE_20 | unknown | ✅ supported | — |
APPROX_QUANTILE_25 | unknown | ✅ supported | — |
APPROX_QUANTILE_40 | unknown | ✅ supported | — |
APPROX_QUANTILE_50 | unknown | ✅ supported | — |
APPROX_QUANTILE_60 | unknown | ✅ supported | — |
APPROX_QUANTILE_80 | unknown | ✅ supported | — |
APPROX_QUANTILE_95 | unknown | ✅ supported | — |
APPROX_QUANTILE_99 | unknown | ✅ supported | — |
BLANK_COUNT | unknown | ✅ supported | — |
BLANK_PERCENT | unknown | ✅ supported | — |
CASE_FORMAT_VIOLATION_COUNT | unknown | ✅ supported | — |
CASE_FORMAT_VIOLATION_PERCENT | unknown | ✅ supported | — |
CONTAINS_SPACES_COUNT | unknown | ✅ supported | — |
CONTAINS_SPACES_PERCENT | unknown | ✅ supported | — |
DATA_METRIC_SCHEDULED_TIME | unknown | ✅ supported | — |
DUPLICATE_COUNT | unknown | ✅ supported | — |
DUPLICATE_PERCENT | unknown | ✅ supported | — |
EMPTY_STRING_COUNT | unknown | ✅ supported | — |
EMPTY_STRING_PERCENT | unknown | ✅ supported | — |
EXTREME_OUTLIER_COUNT | unknown | ✅ supported | — |
EXTREME_OUTLIER_IQR_COUNT | unknown | ✅ supported | — |
EXTREME_OUTLIER_IQR_PERCENT | unknown | ✅ supported | — |
EXTREME_OUTLIER_PERCENT | unknown | ✅ supported | — |
EXTREME_OUTLIER_ZSCORE_COUNT | unknown | ✅ supported | — |
EXTREME_OUTLIER_ZSCORE_PERCENT | unknown | ✅ supported | — |
FALSE_COUNT | unknown | ✅ supported | — |
FALSE_PERCENT | unknown | ✅ supported | — |
FRESHNESS | unknown | ✅ supported | — |
FUTURE_TIMESTAMP_COUNT | unknown | ✅ supported | — |
FUTURE_TIMESTAMP_PERCENT | unknown | ✅ supported | — |
GEOMETRIC_MEAN | unknown | ✅ supported | — |
HARMONIC_MEAN | unknown | ✅ supported | — |
INVALID_CA_POSTAL_CODE_COUNT | unknown | ❌ not supported | — |
INVALID_CA_POSTAL_CODE_PERCENT | unknown | ❌ not supported | — |
INVALID_CA_SIN_COUNT | unknown | ✅ supported | — |
INVALID_CA_SIN_PERCENT | unknown | ✅ supported | — |
INVALID_CH_OASI_COUNT | unknown | ✅ supported | — |
INVALID_CH_OASI_PERCENT | unknown | ✅ supported | — |
INVALID_CUSIP_COUNT | unknown | ✅ supported | — |
INVALID_CUSIP_PERCENT | unknown | ✅ supported | — |
INVALID_DE_POSTAL_CODE_COUNT | unknown | ❌ not supported | — |
INVALID_DE_POSTAL_CODE_PERCENT | unknown | ❌ not supported | — |
INVALID_DE_TAX_ID_COUNT | unknown | ✅ supported | — |
INVALID_DE_TAX_ID_PERCENT | unknown | ✅ supported | — |
INVALID_EMAIL_COUNT | unknown | ✅ supported | — |
INVALID_EMAIL_PERCENT | unknown | ✅ supported | — |
INVALID_ES_DNI_COUNT | unknown | ❌ not supported | — |
INVALID_ES_DNI_PERCENT | unknown | ❌ not supported | — |
INVALID_FIGI_COUNT | unknown | ✅ supported | — |
INVALID_FIGI_PERCENT | unknown | ✅ supported | — |
INVALID_FR_INSEE_CODE_COUNT | unknown | ❌ not supported | — |
INVALID_FR_INSEE_CODE_PERCENT | unknown | ❌ not supported | — |
INVALID_FR_POSTAL_CODE_COUNT | unknown | ❌ not supported | — |
INVALID_FR_POSTAL_CODE_PERCENT | unknown | ❌ not supported | — |
INVALID_INTEGER_COUNT | unknown | ✅ supported | — |
INVALID_INTEGER_PERCENT | unknown | ✅ supported | — |
INVALID_ISIN_COUNT | unknown | ✅ supported | — |
INVALID_ISIN_PERCENT | unknown | ✅ supported | — |
INVALID_ISO8601_FORMAT_COUNT | unknown | ✅ supported | — |
INVALID_ISO8601_FORMAT_PERCENT | unknown | ✅ supported | — |
INVALID_IT_FISCAL_CODE_COUNT | unknown | ❌ not supported | — |
INVALID_IT_FISCAL_CODE_PERCENT | unknown | ❌ not supported | — |
INVALID_JSON_COUNT | unknown | ✅ supported | — |
INVALID_JSON_PERCENT | unknown | ✅ supported | — |
INVALID_LATITUDE_COUNT | unknown | ✅ supported | — |
INVALID_LATITUDE_PERCENT | unknown | ✅ supported | — |
INVALID_LEI_COUNT | unknown | ✅ supported | — |
INVALID_LEI_PERCENT | unknown | ✅ supported | — |
INVALID_LONGITUDE_COUNT | unknown | ✅ supported | — |
INVALID_LONGITUDE_PERCENT | unknown | ✅ supported | — |
INVALID_NL_BSN_COUNT | unknown | ✅ supported | — |
INVALID_NL_BSN_PERCENT | unknown | ✅ supported | — |
INVALID_NUMERIC_TYPE_CAST_COUNT | unknown | ✅ supported | — |
INVALID_NUMERIC_TYPE_CAST_PERCENT | unknown | ✅ supported | — |
INVALID_PERCENTAGE_RANGE_COUNT | unknown | ✅ supported | — |
INVALID_PERCENTAGE_RANGE_PERCENT | unknown | ✅ supported | — |
INVALID_PERM_ID_COUNT | unknown | ✅ supported | — |
INVALID_PERM_ID_PERCENT | unknown | ✅ supported | — |
INVALID_PL_PESEL_COUNT | unknown | ❌ not supported | — |
INVALID_PL_PESEL_PERCENT | unknown | ❌ not supported | — |
INVALID_PROBABILITY_RANGE_COUNT | unknown | ✅ supported | — |
INVALID_PROBABILITY_RANGE_PERCENT | unknown | ✅ supported | — |
INVALID_SEDOL_COUNT | unknown | ✅ supported | — |
INVALID_SEDOL_PERCENT | unknown | ✅ supported | — |
INVALID_TIMESTAMP_STRING_COUNT | unknown | ✅ supported | — |
INVALID_TIMESTAMP_STRING_PERCENT | unknown | ✅ supported | — |
INVALID_TR_ID_NO_COUNT | unknown | ❌ not supported | — |
INVALID_TR_ID_NO_PERCENT | unknown | ❌ not supported | — |
INVALID_UK_NINO_COUNT | unknown | ❌ not supported | — |
INVALID_UK_NINO_PERCENT | unknown | ❌ not supported | — |
INVALID_UK_POSTAL_CODE_COUNT | unknown | ❌ not supported | — |
INVALID_UK_POSTAL_CODE_PERCENT | unknown | ❌ not supported | — |
INVALID_USA_PHONE_COUNT | unknown | ✅ supported | — |
INVALID_USA_PHONE_PERCENT | unknown | ✅ supported | — |
INVALID_USA_STATE_CODE_COUNT | unknown | ✅ supported | — |
INVALID_USA_STATE_CODE_PERCENT | unknown | ✅ supported | — |
INVALID_USA_ZIP_CODE_COUNT | unknown | ✅ supported | — |
INVALID_USA_ZIP_CODE_PERCENT | unknown | ✅ supported | — |
INVALID_UUID_COUNT | unknown | ✅ supported | — |
INVALID_UUID_PERCENT | unknown | ✅ supported | — |
KURTOSIS | aggregate | ✅ supported | (ANY)(FLOAT)(NUMBER) |
MAE | unknown | ❌ not supported | — |
MAPE | unknown | ❌ not supported | — |
MAX | aggregate | 🟡 partial | (ANY)(ARRAY)(BINARY)(BOOLEAN)(DATE)(DECFLOAT)(FLOAT)(NUMBER)(OBJECT)(TIME)(TIMESTAMP_LTZ)(TIMESTAMP_NTZ)(TIMESTAMP_TZ)(VARCHAR)(VARIANT) |
MEAN_ERROR | unknown | ❌ not supported | — |
MEDIAN | unknown | 🟡 partial | — |
MIN | aggregate | 🟡 partial | (ANY)(ARRAY)(BOOLEAN)(DATE)(DECFLOAT)(FLOAT)(NUMBER)(OBJECT)(TIME)(TIMESTAMP_LTZ)(TIMESTAMP_NTZ)(TIMESTAMP_TZ)(VARCHAR)(VARIANT) |
NAN_COUNT | unknown | ✅ supported | — |
NAN_PERCENT | unknown | ✅ supported | — |
NEGATIVE_COUNT | unknown | ✅ supported | — |
NEGATIVE_PERCENT | unknown | ✅ supported | — |
NOT_FRIDAY_COUNT | unknown | ✅ supported | — |
NOT_FRIDAY_PERCENT | unknown | ✅ supported | — |
NOT_IN_FUTURE_COUNT | unknown | ✅ supported | — |
NOT_IN_FUTURE_PERCENT | unknown | ✅ supported | — |
NOT_MONDAY_COUNT | unknown | ✅ supported | — |
NOT_MONDAY_PERCENT | unknown | ✅ supported | — |
NOT_NULL_COUNT | unknown | ✅ supported | — |
NOT_NULL_PERCENT | unknown | ✅ supported | — |
NOT_SATURDAY_COUNT | unknown | ✅ supported | — |
NOT_SATURDAY_PERCENT | unknown | ✅ supported | — |
NOT_SUNDAY_COUNT | unknown | ✅ supported | — |
NOT_SUNDAY_PERCENT | unknown | ✅ supported | — |
NOT_THURSDAY_COUNT | unknown | ✅ supported | — |
NOT_THURSDAY_PERCENT | unknown | ✅ supported | — |
NOT_TODAY_COUNT | unknown | ✅ supported | — |
NOT_TODAY_PERCENT | unknown | ✅ supported | — |
NOT_TUESDAY_COUNT | unknown | ✅ supported | — |
NOT_TUESDAY_PERCENT | unknown | ✅ supported | — |
NOT_WEDNESDAY_COUNT | unknown | ✅ supported | — |
NOT_WEDNESDAY_PERCENT | unknown | ✅ supported | — |
NOT_WEEKDAY_COUNT | unknown | ✅ supported | — |
NOT_WEEKDAY_PERCENT | unknown | ✅ supported | — |
NOT_YESTERDAY_COUNT | unknown | ✅ supported | — |
NOT_YESTERDAY_PERCENT | unknown | ✅ supported | — |
NULL_COUNT | unknown | ✅ supported | — |
NULL_KEYWORD_COUNT | unknown | ✅ supported | — |
NULL_KEYWORD_PERCENT | unknown | ✅ supported | — |
NULL_PERCENT | unknown | ✅ supported | — |
OUTLIER_COUNT | unknown | ✅ supported | — |
OUTLIER_IQR_COUNT | unknown | ✅ supported | — |
OUTLIER_IQR_PERCENT | unknown | ✅ supported | — |
OUTLIER_PERCENT | unknown | ✅ supported | — |
OUTLIER_ZSCORE_COUNT | unknown | ✅ supported | — |
OUTLIER_ZSCORE_PERCENT | unknown | ✅ supported | — |
REFERENTIAL_INTEGRITY_COUNT | unknown | ✅ supported | — |
RMSE | unknown | ❌ not supported | — |
ROWS_IN_PAST_DAY_COUNT | unknown | ✅ supported | — |
ROWS_IN_PAST_DAY_PERCENT | unknown | ✅ supported | — |
ROWS_IN_PAST_HOUR_COUNT | unknown | ✅ supported | — |
ROWS_IN_PAST_HOUR_PERCENT | unknown | ✅ supported | — |
ROWS_IN_PAST_MONTH_COUNT | unknown | ✅ supported | — |
ROWS_IN_PAST_MONTH_PERCENT | unknown | ✅ supported | — |
ROWS_IN_PAST_WEEK_COUNT | unknown | ✅ supported | — |
ROWS_IN_PAST_WEEK_PERCENT | unknown | ✅ supported | — |
ROWS_IN_PAST_YEAR_COUNT | unknown | ✅ supported | — |
ROWS_IN_PAST_YEAR_PERCENT | unknown | ✅ supported | — |
ROW_COUNT | unknown | ✅ supported | — |
R_SQUARED | unknown | ❌ not supported | — |
SCHEMA_CHANGE_ADD_COUNT | unknown | ❌ not supported | — |
SCHEMA_CHANGE_COUNT | unknown | ✅ supported | — |
SCHEMA_CHANGE_DROP_COUNT | unknown | ❌ not supported | — |
SCHEMA_CHANGE_TYPE_COUNT | unknown | ❌ not supported | — |
SKEW | aggregate | ✅ supported | (ANY)(FLOAT) |
SOURCE_TARGET_LAG | unknown | ❌ not supported | — |
SPECIAL_CHARACTER_COUNT | unknown | ✅ supported | — |
SPECIAL_CHARACTER_PERCENT | unknown | ✅ supported | — |
STDDEV | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
STRING_LENGTH_AVG | unknown | ✅ supported | — |
STRING_LENGTH_MAX | unknown | ✅ supported | — |
STRING_LENGTH_MIN | unknown | ✅ supported | — |
STRING_LENGTH_STDDEV | unknown | ✅ supported | — |
SUM | aggregate | ✅ supported | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
TABLE_SIZE_BYTES | unknown | ❌ not supported | — |
TRUE_COUNT | unknown | ✅ supported | — |
TRUE_PERCENT | unknown | ✅ supported | — |
UNIQUE_COUNT | unknown | ✅ supported | — |
UNIQUE_PERCENT | unknown | ✅ supported | — |
UNIX_ZERO_COUNT | unknown | ✅ supported | — |
UNIX_ZERO_PERCENT | unknown | ✅ supported | — |
UNTRIMMED_STRING_COUNT | unknown | ✅ supported | — |
UNTRIMMED_STRING_PERCENT | unknown | ✅ supported | — |
VARIANCE | aggregate | 🟡 partial | (ANY)(DECFLOAT)(FLOAT)(NUMBER) |
ZERO_COUNT | unknown | ✅ supported | — |
ZERO_PERCENT | unknown | ✅ supported | — |
Date & time functions (39)
| Function | Kind | Status | Signatures |
|---|---|---|---|
ADD_MONTHS | scalar | ✅ supported | (ANY, ANY) → TIMESTAMP_NTZ(DATE, NUMBER) → DATE(TIMESTAMP_LTZ, NUMBER) → TIMESTAMP_LTZ(TIMESTAMP_NTZ, NUMBER) → TIMESTAMP_NTZ(TIMESTAMP_TZ, NUMBER) → TIMESTAMP_TZ |
CONVERT_TIMEZONE | scalar | ✅ 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 |
DATEADD | unknown | ✅ supported | — |
DATEDIFF | scalar | ✅ supported | (ANY, ANY, ANY) → NUMBER(VARCHAR, DATE, DATE) → NUMBER(VARCHAR, DATE, TIME) → NUMBER(VARCHAR, DATE, TIMESTAMP_LTZ) → NUMBER(VARCHAR, DATE, TIMESTAMP_NTZ) → NUMBER(VARCHAR, DATE, TIMESTAMP_TZ) → NUMBER(VARCHAR, DATE, VARCHAR) → NUMBER(VARCHAR, TIME, DATE) → NUMBER(VARCHAR, TIME, TIME) → NUMBER(VARCHAR, TIME, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIME, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIME, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIME, VARCHAR) → NUMBER(VARCHAR, TIMESTAMP_LTZ, DATE) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIMESTAMP_LTZ, VARCHAR) → NUMBER(VARCHAR, TIMESTAMP_NTZ, DATE) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIME) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, VARCHAR) → NUMBER(VARCHAR, TIMESTAMP_TZ, DATE) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIME) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, VARCHAR) → NUMBER(VARCHAR, VARCHAR, DATE) → NUMBER(VARCHAR, VARCHAR, TIME) → NUMBER(VARCHAR, VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, VARCHAR, TIMESTAMP_TZ) → NUMBER(VARCHAR, VARCHAR, VARCHAR) → NUMBER |
DATE_FROM_PARTS | scalar | ✅ supported | (NUMBER, NUMBER, NUMBER) → DATE |
DATE_PART | scalar | ✅ supported | (ANY, ANY) → NUMBER(VARCHAR, DATE) → NUMBER(VARCHAR, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ) → NUMBER |
DATE_TRUNC | scalar | ✅ supported | (ANY, ANY) → TIMESTAMP_NTZ(VARCHAR, DATE) → DATE(VARCHAR, FLOAT) → FLOAT(VARCHAR, NUMBER) → NUMBER(VARCHAR, TIME) → TIME(VARCHAR, TIMESTAMP_LTZ) → TIMESTAMP_LTZ(VARCHAR, TIMESTAMP_NTZ) → TIMESTAMP_NTZ(VARCHAR, TIMESTAMP_TZ) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → VARCHAR |
DAY | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
DAYNAME | scalar | ✅ supported | (ANY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
DAYOFMONTH | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
DAYOFWEEK | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
DAYOFWEEKISO | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
DAYOFYEAR | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
EXTRACT | scalar | ✅ supported | (ANY, ANY) → NUMBER(VARCHAR, DATE) → NUMBER(VARCHAR, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ) → NUMBER |
HOUR | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
LAST_DAY | scalar | ✅ 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_TIME | unknown | ✅ supported | — |
MINUTE | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
MONTH | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
MONTHNAME | scalar | ✅ supported | (ANY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
MONTHS_BETWEEN | scalar | ✅ supported | (ANY, ANY) → FLOAT(DATE, DATE) → FLOAT(DATE, TIMESTAMP_LTZ) → FLOAT(DATE, TIMESTAMP_NTZ) → FLOAT(DATE, TIMESTAMP_TZ) → FLOAT(DATE, VARCHAR) → FLOAT(TIMESTAMP_LTZ, DATE) → FLOAT(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → FLOAT(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → FLOAT(TIMESTAMP_LTZ, TIMESTAMP_TZ) → FLOAT(TIMESTAMP_LTZ, VARCHAR) → FLOAT(TIMESTAMP_NTZ, DATE) → FLOAT(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → FLOAT(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → FLOAT(TIMESTAMP_NTZ, TIMESTAMP_TZ) → FLOAT(TIMESTAMP_NTZ, VARCHAR) → FLOAT(TIMESTAMP_TZ, DATE) → FLOAT(TIMESTAMP_TZ, TIMESTAMP_LTZ) → FLOAT(TIMESTAMP_TZ, TIMESTAMP_NTZ) → FLOAT(TIMESTAMP_TZ, TIMESTAMP_TZ) → FLOAT(TIMESTAMP_TZ, VARCHAR) → FLOAT(VARCHAR, DATE) → FLOAT(VARCHAR, TIMESTAMP_LTZ) → FLOAT(VARCHAR, TIMESTAMP_NTZ) → FLOAT(VARCHAR, TIMESTAMP_TZ) → FLOAT(VARCHAR, VARCHAR) → FLOAT |
NEXT_DAY | scalar | ✅ supported | (ANY, ANY) → DATE(DATE, VARCHAR) → DATE(TIMESTAMP_LTZ, VARCHAR) → DATE(TIMESTAMP_NTZ, VARCHAR) → DATE(TIMESTAMP_TZ, VARCHAR) → DATE(VARCHAR, VARCHAR) → DATE |
PREVIOUS_DAY | scalar | ✅ supported | (ANY, ANY) → DATE(DATE, VARCHAR) → DATE(TIMESTAMP_LTZ, VARCHAR) → DATE(TIMESTAMP_NTZ, VARCHAR) → DATE(TIMESTAMP_TZ, VARCHAR) → DATE(VARCHAR, VARCHAR) → DATE |
QUARTER | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
SCHEDULED_TIME | unknown | ✅ supported | — |
SECOND | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(FLOAT) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
TIMEADD | unknown | ✅ supported | — |
TIMEDIFF | scalar | ✅ supported | (ANY, ANY, ANY) → NUMBER(VARCHAR, DATE, DATE) → NUMBER(VARCHAR, DATE, TIME) → NUMBER(VARCHAR, DATE, TIMESTAMP_LTZ) → NUMBER(VARCHAR, DATE, TIMESTAMP_NTZ) → NUMBER(VARCHAR, DATE, TIMESTAMP_TZ) → NUMBER(VARCHAR, DATE, VARCHAR) → NUMBER(VARCHAR, TIME, DATE) → NUMBER(VARCHAR, TIME, TIME) → NUMBER(VARCHAR, TIME, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIME, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIME, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIME, VARCHAR) → NUMBER(VARCHAR, TIMESTAMP_LTZ, DATE) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIMESTAMP_LTZ, VARCHAR) → NUMBER(VARCHAR, TIMESTAMP_NTZ, DATE) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIME) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, VARCHAR) → NUMBER(VARCHAR, TIMESTAMP_TZ, DATE) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIME) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, VARCHAR) → NUMBER(VARCHAR, VARCHAR, DATE) → NUMBER(VARCHAR, VARCHAR, TIME) → NUMBER(VARCHAR, VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, VARCHAR, TIMESTAMP_TZ) → NUMBER(VARCHAR, VARCHAR, VARCHAR) → NUMBER |
TIMESTAMPADD | unknown | ✅ supported | — |
TIMESTAMPDIFF | scalar | ✅ supported | (ANY, ANY, ANY) → NUMBER(VARCHAR, DATE, DATE) → NUMBER(VARCHAR, DATE, TIME) → NUMBER(VARCHAR, DATE, TIMESTAMP_LTZ) → NUMBER(VARCHAR, DATE, TIMESTAMP_NTZ) → NUMBER(VARCHAR, DATE, TIMESTAMP_TZ) → NUMBER(VARCHAR, DATE, VARCHAR) → NUMBER(VARCHAR, TIME, DATE) → NUMBER(VARCHAR, TIME, TIME) → NUMBER(VARCHAR, TIME, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIME, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIME, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIME, VARCHAR) → NUMBER(VARCHAR, TIMESTAMP_LTZ, DATE) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_LTZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIMESTAMP_LTZ, VARCHAR) → NUMBER(VARCHAR, TIMESTAMP_NTZ, DATE) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIME) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ, VARCHAR) → NUMBER(VARCHAR, TIMESTAMP_TZ, DATE) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIME) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER(VARCHAR, TIMESTAMP_TZ, VARCHAR) → NUMBER(VARCHAR, VARCHAR, DATE) → NUMBER(VARCHAR, VARCHAR, TIME) → NUMBER(VARCHAR, VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, VARCHAR, TIMESTAMP_TZ) → NUMBER(VARCHAR, VARCHAR, VARCHAR) → NUMBER |
TIMESTAMP_FROM_PARTS | scalar | ✅ 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 |
TIME_FROM_PARTS | scalar | ✅ supported | (ANY, ANY, ANY) → TIME(NUMBER, NUMBER, NUMBER) → TIME(NUMBER, NUMBER, NUMBER, NUMBER) → TIME |
TIME_SLICE | scalar | ✅ 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 |
WEEK | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
WEEKISO | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
WEEKOFYEAR | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
YEAR | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
YEAROFWEEK | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
YEAROFWEEKISO | scalar | ✅ supported | (ANY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
Differential privacy functions (3)
| Function | Kind | Status | Signatures |
|---|---|---|---|
DP_INTERVAL_HIGH | unknown | ❌ not supported | — |
DP_INTERVAL_LOW | unknown | ❌ not supported | — |
ESTIMATE_REMAINING_DP_AGGREGATES | unknown | ❌ not supported | — |
Encryption functions (6)
| Function | Kind | Status | Signatures |
|---|---|---|---|
DECRYPT | scalar | ✅ supported | (ANY, ANY) → BINARY(BINARY, VARCHAR) → BINARY(BINARY, VARCHAR, VARCHAR) → BINARY(BINARY, VARCHAR, VARCHAR, VARCHAR) → BINARY |
DECRYPT_RAW | scalar | ✅ supported | (ANY) → BINARY(BINARY, BINARY) → BINARY(BINARY, BINARY, BINARY) → BINARY(BINARY, BINARY, BINARY, BINARY, VARCHAR) → BINARY(BINARY, BINARY, BINARY, BINARY, VARCHAR, BINARY) → BINARY |
ENCRYPT | scalar | ✅ 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_RAW | scalar | ✅ supported | (ANY) → OBJECT(BINARY, BINARY) → OBJECT(BINARY, BINARY, BINARY, BINARY, VARCHAR) → OBJECT |
TRY_DECRYPT | scalar | ✅ supported | (ANY, ANY) → BINARY(BINARY, VARCHAR) → BINARY(BINARY, VARCHAR, VARCHAR) → BINARY(BINARY, VARCHAR, VARCHAR, VARCHAR) → BINARY |
TRY_DECRYPT_RAW | scalar | ✅ 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)
| Function | Kind | Status | Signatures |
|---|---|---|---|
AI_TRANSCRIBE | unknown | ❌ not supported | — |
BUILD_SCOPED_FILE_URL | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
BUILD_STAGE_FILE_URL | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
FL_GET_CONTENT_TYPE | scalar | ✅ supported | (ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR |
FL_GET_ETAG | scalar | ✅ supported | (ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR |
FL_GET_FILE_TYPE | scalar | ✅ supported | (ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR |
FL_GET_LAST_MODIFIED | scalar | ✅ supported | (ANY) → TIMESTAMP_TZ(FILE) → TIMESTAMP_TZ(VARIANT) → TIMESTAMP_TZ |
FL_GET_RELATIVE_PATH | scalar | ✅ supported | (ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR |
FL_GET_SCOPED_FILE_URL | scalar | ✅ supported | (ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR |
FL_GET_SIZE | scalar | ✅ supported | (ANY) → NUMBER(FILE) → NUMBER(VARIANT) → NUMBER |
FL_GET_STAGE | scalar | ✅ supported | (ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR |
FL_GET_STAGE_FILE_URL | scalar | ✅ supported | (ANY) → VARCHAR(FILE) → VARCHAR(VARIANT) → VARCHAR |
FL_IS_AUDIO | scalar | ✅ supported | (ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN |
FL_IS_COMPRESSED | scalar | ✅ supported | (ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN |
FL_IS_DOCUMENT | scalar | ✅ supported | (ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN |
FL_IS_IMAGE | scalar | ✅ supported | (ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN |
FL_IS_VIDEO | scalar | ✅ supported | (ANY) → BOOLEAN(FILE) → BOOLEAN(VARIANT) → BOOLEAN |
GET_ABSOLUTE_PATH | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
GET_PRESIGNED_URL | scalar | ✅ supported | (VARCHAR, VARCHAR, NUMBER) → VARCHAR |
GET_RELATIVE_PATH | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
GET_STAGE_LOCATION | scalar | ✅ supported | (VARCHAR) → VARCHAR |
PARSE_DOCUMENT | unknown | ❌ not supported | — |
TO_FILE | scalar | ✅ supported | (ANY) → FILE(BOOLEAN) → FILE(FILE) → FILE(FLOAT) → FILE(NUMBER) → FILE(VARCHAR) → FILE(VARIANT) → FILE(VARCHAR, VARCHAR) → FILE |
TRY_TO_FILE | scalar | ✅ supported | (ANY) → FILE(BOOLEAN) → FILE(FILE) → FILE(FLOAT) → FILE(NUMBER) → FILE(OBJECT) → FILE(VARCHAR) → FILE(VARIANT) → FILE(VARCHAR, VARCHAR) → FILE |
Geospatial functions (101)
| Function | Kind | Status | Signatures |
|---|---|---|---|
H3_CELL_TO_BOUNDARY | scalar | ✅ supported | (ANY) → GEOGRAPHY(ARRAY) → GEOGRAPHY(BOOLEAN) → GEOGRAPHY(DATE) → GEOGRAPHY(FLOAT) → GEOGRAPHY(NUMBER) → GEOGRAPHY(OBJECT) → GEOGRAPHY(TIME) → GEOGRAPHY(TIMESTAMP_LTZ) → GEOGRAPHY(TIMESTAMP_NTZ) → GEOGRAPHY(TIMESTAMP_TZ) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(VARIANT) → GEOGRAPHY |
H3_CELL_TO_CHILDREN | scalar | ✅ supported | (ANY, ANY) → ARRAY(ANY, FLOAT) → ARRAY(ANY, NUMBER) → ARRAY(ANY, VARCHAR) → ARRAY(ANY, VARIANT) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ANY) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(NUMBER, ANY) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ANY) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ANY) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_CELL_TO_CHILDREN_STRING | scalar | ✅ supported | (ANY, ANY) → ARRAY(ANY, FLOAT) → ARRAY(ANY, NUMBER) → ARRAY(ANY, VARCHAR) → ARRAY(ANY, VARIANT) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BOOLEAN, ANY) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ANY) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ANY) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(NUMBER, ANY) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ANY) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ANY) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ANY) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ANY) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ANY) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ANY) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_CELL_TO_PARENT | scalar | ✅ supported | (ANY, ANY) → NUMBER(ANY, FLOAT) → NUMBER(ANY, NUMBER) → NUMBER(ANY, VARCHAR) → NUMBER(ANY, VARIANT) → NUMBER(ARRAY, ARRAY) → NUMBER(ARRAY, BOOLEAN) → NUMBER(ARRAY, DATE) → NUMBER(ARRAY, FLOAT) → NUMBER(ARRAY, NUMBER) → NUMBER(ARRAY, OBJECT) → NUMBER(ARRAY, TIME) → NUMBER(ARRAY, TIMESTAMP_LTZ) → NUMBER(ARRAY, TIMESTAMP_NTZ) → NUMBER(ARRAY, TIMESTAMP_TZ) → NUMBER(ARRAY, VARCHAR) → NUMBER(ARRAY, VARIANT) → NUMBER(BOOLEAN, ANY) → VARCHAR(BOOLEAN, ARRAY) → NUMBER(BOOLEAN, BOOLEAN) → NUMBER(BOOLEAN, DATE) → NUMBER(BOOLEAN, FLOAT) → VARCHAR(BOOLEAN, NUMBER) → VARCHAR(BOOLEAN, OBJECT) → NUMBER(BOOLEAN, TIME) → NUMBER(BOOLEAN, TIMESTAMP_LTZ) → NUMBER(BOOLEAN, TIMESTAMP_NTZ) → NUMBER(BOOLEAN, TIMESTAMP_TZ) → NUMBER(BOOLEAN, VARCHAR) → VARCHAR(BOOLEAN, VARIANT) → VARCHAR(DATE, ANY) → VARCHAR(DATE, ARRAY) → NUMBER(DATE, BOOLEAN) → NUMBER(DATE, DATE) → NUMBER(DATE, FLOAT) → VARCHAR(DATE, NUMBER) → VARCHAR(DATE, OBJECT) → NUMBER(DATE, TIME) → NUMBER(DATE, TIMESTAMP_LTZ) → NUMBER(DATE, TIMESTAMP_NTZ) → NUMBER(DATE, TIMESTAMP_TZ) → NUMBER(DATE, VARCHAR) → VARCHAR(DATE, VARIANT) → VARCHAR(FLOAT, ANY) → VARCHAR(FLOAT, ARRAY) → NUMBER(FLOAT, BOOLEAN) → NUMBER(FLOAT, DATE) → NUMBER(FLOAT, FLOAT) → VARCHAR(FLOAT, NUMBER) → VARCHAR(FLOAT, OBJECT) → NUMBER(FLOAT, TIME) → NUMBER(FLOAT, TIMESTAMP_LTZ) → NUMBER(FLOAT, TIMESTAMP_NTZ) → NUMBER(FLOAT, TIMESTAMP_TZ) → NUMBER(FLOAT, VARCHAR) → VARCHAR(FLOAT, VARIANT) → VARCHAR(NUMBER, ANY) → NUMBER(NUMBER, ARRAY) → NUMBER(NUMBER, BOOLEAN) → NUMBER(NUMBER, DATE) → NUMBER(NUMBER, FLOAT) → NUMBER(NUMBER, NUMBER) → NUMBER(NUMBER, OBJECT) → NUMBER(NUMBER, TIME) → NUMBER(NUMBER, TIMESTAMP_LTZ) → NUMBER(NUMBER, TIMESTAMP_NTZ) → NUMBER(NUMBER, TIMESTAMP_TZ) → NUMBER(NUMBER, VARCHAR) → NUMBER(NUMBER, VARIANT) → NUMBER(OBJECT, ARRAY) → NUMBER(OBJECT, BOOLEAN) → NUMBER(OBJECT, DATE) → NUMBER(OBJECT, FLOAT) → NUMBER(OBJECT, NUMBER) → NUMBER(OBJECT, OBJECT) → NUMBER(OBJECT, TIME) → NUMBER(OBJECT, TIMESTAMP_LTZ) → NUMBER(OBJECT, TIMESTAMP_NTZ) → NUMBER(OBJECT, TIMESTAMP_TZ) → NUMBER(OBJECT, VARCHAR) → NUMBER(OBJECT, VARIANT) → NUMBER(TIME, ANY) → VARCHAR(TIME, ARRAY) → NUMBER(TIME, BOOLEAN) → NUMBER(TIME, DATE) → NUMBER(TIME, FLOAT) → VARCHAR(TIME, NUMBER) → VARCHAR(TIME, OBJECT) → NUMBER(TIME, TIME) → NUMBER(TIME, TIMESTAMP_LTZ) → NUMBER(TIME, TIMESTAMP_NTZ) → NUMBER(TIME, TIMESTAMP_TZ) → NUMBER(TIME, VARCHAR) → VARCHAR(TIME, VARIANT) → VARCHAR(TIMESTAMP_LTZ, ANY) → VARCHAR(TIMESTAMP_LTZ, ARRAY) → NUMBER(TIMESTAMP_LTZ, BOOLEAN) → NUMBER(TIMESTAMP_LTZ, DATE) → NUMBER(TIMESTAMP_LTZ, FLOAT) → VARCHAR(TIMESTAMP_LTZ, NUMBER) → VARCHAR(TIMESTAMP_LTZ, OBJECT) → NUMBER(TIMESTAMP_LTZ, TIME) → NUMBER(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_LTZ, TIMESTAMP_TZ) → NUMBER(TIMESTAMP_LTZ, VARCHAR) → VARCHAR(TIMESTAMP_LTZ, VARIANT) → VARCHAR(TIMESTAMP_NTZ, ANY) → VARCHAR(TIMESTAMP_NTZ, ARRAY) → NUMBER(TIMESTAMP_NTZ, BOOLEAN) → NUMBER(TIMESTAMP_NTZ, DATE) → NUMBER(TIMESTAMP_NTZ, FLOAT) → VARCHAR(TIMESTAMP_NTZ, NUMBER) → VARCHAR(TIMESTAMP_NTZ, OBJECT) → NUMBER(TIMESTAMP_NTZ, TIME) → NUMBER(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_NTZ, TIMESTAMP_TZ) → NUMBER(TIMESTAMP_NTZ, VARCHAR) → VARCHAR(TIMESTAMP_NTZ, VARIANT) → VARCHAR(TIMESTAMP_TZ, ANY) → VARCHAR(TIMESTAMP_TZ, ARRAY) → NUMBER(TIMESTAMP_TZ, BOOLEAN) → NUMBER(TIMESTAMP_TZ, DATE) → NUMBER(TIMESTAMP_TZ, FLOAT) → VARCHAR(TIMESTAMP_TZ, NUMBER) → VARCHAR(TIMESTAMP_TZ, OBJECT) → NUMBER(TIMESTAMP_TZ, TIME) → NUMBER(TIMESTAMP_TZ, TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_TZ, TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER(TIMESTAMP_TZ, VARCHAR) → VARCHAR(TIMESTAMP_TZ, VARIANT) → VARCHAR(VARCHAR, ANY) → VARCHAR(VARCHAR, ARRAY) → NUMBER(VARCHAR, BOOLEAN) → NUMBER(VARCHAR, DATE) → NUMBER(VARCHAR, FLOAT) → VARCHAR(VARCHAR, NUMBER) → VARCHAR(VARCHAR, OBJECT) → NUMBER(VARCHAR, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ) → NUMBER(VARCHAR, VARCHAR) → VARCHAR(VARCHAR, VARIANT) → VARCHAR(VARIANT, ANY) → VARCHAR(VARIANT, ARRAY) → NUMBER(VARIANT, BOOLEAN) → NUMBER(VARIANT, DATE) → NUMBER(VARIANT, FLOAT) → VARCHAR(VARIANT, NUMBER) → VARCHAR(VARIANT, OBJECT) → NUMBER(VARIANT, TIME) → NUMBER(VARIANT, TIMESTAMP_LTZ) → NUMBER(VARIANT, TIMESTAMP_NTZ) → NUMBER(VARIANT, TIMESTAMP_TZ) → NUMBER(VARIANT, VARCHAR) → VARCHAR(VARIANT, VARIANT) → VARCHAR |
H3_CELL_TO_POINT | scalar | ✅ supported | (ANY) → GEOGRAPHY(ARRAY) → GEOGRAPHY(BOOLEAN) → GEOGRAPHY(DATE) → GEOGRAPHY(FLOAT) → GEOGRAPHY(NUMBER) → GEOGRAPHY(OBJECT) → GEOGRAPHY(TIME) → GEOGRAPHY(TIMESTAMP_LTZ) → GEOGRAPHY(TIMESTAMP_NTZ) → GEOGRAPHY(TIMESTAMP_TZ) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(VARIANT) → GEOGRAPHY |
H3_COMPACT_CELLS | scalar | ✅ supported | (ANY) → ARRAY(ARRAY) → 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 |
H3_COMPACT_CELLS_STRINGS | scalar | ✅ supported | (ANY) → ARRAY(ARRAY) → 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 |
H3_COVERAGE | scalar | ✅ supported | (ANY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BINARY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, GEOGRAPHY) → ARRAY(ARRAY, GEOMETRY) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BINARY, ARRAY) → ARRAY(BINARY, BINARY) → ARRAY(BINARY, BOOLEAN) → ARRAY(BINARY, DATE) → ARRAY(BINARY, FLOAT) → ARRAY(BINARY, GEOGRAPHY) → ARRAY(BINARY, GEOMETRY) → ARRAY(BINARY, NUMBER) → ARRAY(BINARY, OBJECT) → ARRAY(BINARY, TIME) → ARRAY(BINARY, TIMESTAMP_LTZ) → ARRAY(BINARY, TIMESTAMP_NTZ) → ARRAY(BINARY, TIMESTAMP_TZ) → ARRAY(BINARY, VARCHAR) → ARRAY(BINARY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BINARY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, GEOGRAPHY) → ARRAY(BOOLEAN, GEOMETRY) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BINARY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, GEOGRAPHY) → ARRAY(DATE, GEOMETRY) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BINARY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, GEOGRAPHY) → ARRAY(FLOAT, GEOMETRY) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(GEOGRAPHY, ARRAY) → ARRAY(GEOGRAPHY, BINARY) → ARRAY(GEOGRAPHY, BOOLEAN) → ARRAY(GEOGRAPHY, DATE) → ARRAY(GEOGRAPHY, FLOAT) → ARRAY(GEOGRAPHY, GEOGRAPHY) → ARRAY(GEOGRAPHY, GEOMETRY) → ARRAY(GEOGRAPHY, NUMBER) → ARRAY(GEOGRAPHY, OBJECT) → ARRAY(GEOGRAPHY, TIME) → ARRAY(GEOGRAPHY, TIMESTAMP_LTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_NTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_TZ) → ARRAY(GEOGRAPHY, VARCHAR) → ARRAY(GEOGRAPHY, VARIANT) → ARRAY(GEOMETRY, ARRAY) → ARRAY(GEOMETRY, BINARY) → ARRAY(GEOMETRY, BOOLEAN) → ARRAY(GEOMETRY, DATE) → ARRAY(GEOMETRY, FLOAT) → ARRAY(GEOMETRY, GEOGRAPHY) → ARRAY(GEOMETRY, GEOMETRY) → ARRAY(GEOMETRY, NUMBER) → ARRAY(GEOMETRY, OBJECT) → ARRAY(GEOMETRY, TIME) → ARRAY(GEOMETRY, TIMESTAMP_LTZ) → ARRAY(GEOMETRY, TIMESTAMP_NTZ) → ARRAY(GEOMETRY, TIMESTAMP_TZ) → ARRAY(GEOMETRY, VARCHAR) → ARRAY(GEOMETRY, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BINARY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, GEOGRAPHY) → ARRAY(NUMBER, GEOMETRY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BINARY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, GEOGRAPHY) → ARRAY(OBJECT, GEOMETRY) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BINARY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, GEOGRAPHY) → ARRAY(TIME, GEOMETRY) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BINARY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_LTZ, GEOMETRY) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BINARY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_NTZ, GEOMETRY) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BINARY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, GEOGRAPHY) → ARRAY(TIMESTAMP_TZ, GEOMETRY) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BINARY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, GEOGRAPHY) → ARRAY(VARCHAR, GEOMETRY) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BINARY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, GEOGRAPHY) → ARRAY(VARIANT, GEOMETRY) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_COVERAGE_STRINGS | scalar | ✅ supported | (ANY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BINARY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, GEOGRAPHY) → ARRAY(ARRAY, GEOMETRY) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BINARY, ARRAY) → ARRAY(BINARY, BINARY) → ARRAY(BINARY, BOOLEAN) → ARRAY(BINARY, DATE) → ARRAY(BINARY, FLOAT) → ARRAY(BINARY, GEOGRAPHY) → ARRAY(BINARY, GEOMETRY) → ARRAY(BINARY, NUMBER) → ARRAY(BINARY, OBJECT) → ARRAY(BINARY, TIME) → ARRAY(BINARY, TIMESTAMP_LTZ) → ARRAY(BINARY, TIMESTAMP_NTZ) → ARRAY(BINARY, TIMESTAMP_TZ) → ARRAY(BINARY, VARCHAR) → ARRAY(BINARY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BINARY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, GEOGRAPHY) → ARRAY(BOOLEAN, GEOMETRY) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BINARY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, GEOGRAPHY) → ARRAY(DATE, GEOMETRY) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BINARY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, GEOGRAPHY) → ARRAY(FLOAT, GEOMETRY) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(GEOGRAPHY, ARRAY) → ARRAY(GEOGRAPHY, BINARY) → ARRAY(GEOGRAPHY, BOOLEAN) → ARRAY(GEOGRAPHY, DATE) → ARRAY(GEOGRAPHY, FLOAT) → ARRAY(GEOGRAPHY, GEOGRAPHY) → ARRAY(GEOGRAPHY, GEOMETRY) → ARRAY(GEOGRAPHY, NUMBER) → ARRAY(GEOGRAPHY, OBJECT) → ARRAY(GEOGRAPHY, TIME) → ARRAY(GEOGRAPHY, TIMESTAMP_LTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_NTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_TZ) → ARRAY(GEOGRAPHY, VARCHAR) → ARRAY(GEOGRAPHY, VARIANT) → ARRAY(GEOMETRY, ARRAY) → ARRAY(GEOMETRY, BINARY) → ARRAY(GEOMETRY, BOOLEAN) → ARRAY(GEOMETRY, DATE) → ARRAY(GEOMETRY, FLOAT) → ARRAY(GEOMETRY, GEOGRAPHY) → ARRAY(GEOMETRY, GEOMETRY) → ARRAY(GEOMETRY, NUMBER) → ARRAY(GEOMETRY, OBJECT) → ARRAY(GEOMETRY, TIME) → ARRAY(GEOMETRY, TIMESTAMP_LTZ) → ARRAY(GEOMETRY, TIMESTAMP_NTZ) → ARRAY(GEOMETRY, TIMESTAMP_TZ) → ARRAY(GEOMETRY, VARCHAR) → ARRAY(GEOMETRY, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BINARY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, GEOGRAPHY) → ARRAY(NUMBER, GEOMETRY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BINARY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, GEOGRAPHY) → ARRAY(OBJECT, GEOMETRY) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BINARY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, GEOGRAPHY) → ARRAY(TIME, GEOMETRY) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BINARY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_LTZ, GEOMETRY) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BINARY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_NTZ, GEOMETRY) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BINARY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, GEOGRAPHY) → ARRAY(TIMESTAMP_TZ, GEOMETRY) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BINARY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, GEOGRAPHY) → ARRAY(VARCHAR, GEOMETRY) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BINARY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, GEOGRAPHY) → ARRAY(VARIANT, GEOMETRY) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_GET_RESOLUTION | scalar | ✅ supported | (ANY) → NUMBER(ARRAY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(OBJECT) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
H3_GRID_DISK | scalar | ✅ supported | (ANY, ANY) → ARRAY(ANY, FLOAT) → ARRAY(ANY, NUMBER) → ARRAY(ANY, VARCHAR) → ARRAY(ANY, VARIANT) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BOOLEAN, ANY) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ANY) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ANY) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(NUMBER, ANY) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ANY) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ANY) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ANY) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ANY) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ANY) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ANY) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_GRID_DISTANCE | scalar | ✅ supported | (ANY, ANY) → NUMBER(ANY, BOOLEAN) → NUMBER(ANY, DATE) → NUMBER(ANY, FLOAT) → NUMBER(ANY, NUMBER) → NUMBER(ANY, TIME) → NUMBER(ANY, TIMESTAMP_LTZ) → NUMBER(ANY, TIMESTAMP_NTZ) → NUMBER(ANY, TIMESTAMP_TZ) → NUMBER(ANY, VARCHAR) → NUMBER(ANY, VARIANT) → NUMBER(ARRAY, ARRAY) → NUMBER(ARRAY, BOOLEAN) → NUMBER(ARRAY, DATE) → NUMBER(ARRAY, FLOAT) → NUMBER(ARRAY, NUMBER) → NUMBER(ARRAY, OBJECT) → NUMBER(ARRAY, TIME) → NUMBER(ARRAY, TIMESTAMP_LTZ) → NUMBER(ARRAY, TIMESTAMP_NTZ) → NUMBER(ARRAY, TIMESTAMP_TZ) → NUMBER(ARRAY, VARCHAR) → NUMBER(ARRAY, VARIANT) → NUMBER(BOOLEAN, ANY) → NUMBER(BOOLEAN, ARRAY) → NUMBER(BOOLEAN, BOOLEAN) → NUMBER(BOOLEAN, DATE) → NUMBER(BOOLEAN, FLOAT) → NUMBER(BOOLEAN, NUMBER) → NUMBER(BOOLEAN, OBJECT) → NUMBER(BOOLEAN, TIME) → NUMBER(BOOLEAN, TIMESTAMP_LTZ) → NUMBER(BOOLEAN, TIMESTAMP_NTZ) → NUMBER(BOOLEAN, TIMESTAMP_TZ) → NUMBER(BOOLEAN, VARCHAR) → NUMBER(BOOLEAN, VARIANT) → NUMBER(DATE, ANY) → NUMBER(DATE, ARRAY) → NUMBER(DATE, BOOLEAN) → NUMBER(DATE, DATE) → NUMBER(DATE, FLOAT) → NUMBER(DATE, NUMBER) → NUMBER(DATE, OBJECT) → NUMBER(DATE, TIME) → NUMBER(DATE, TIMESTAMP_LTZ) → NUMBER(DATE, TIMESTAMP_NTZ) → NUMBER(DATE, TIMESTAMP_TZ) → NUMBER(DATE, VARCHAR) → NUMBER(DATE, VARIANT) → NUMBER(FLOAT, ANY) → NUMBER(FLOAT, ARRAY) → NUMBER(FLOAT, BOOLEAN) → NUMBER(FLOAT, DATE) → NUMBER(FLOAT, FLOAT) → NUMBER(FLOAT, NUMBER) → NUMBER(FLOAT, OBJECT) → NUMBER(FLOAT, TIME) → NUMBER(FLOAT, TIMESTAMP_LTZ) → NUMBER(FLOAT, TIMESTAMP_NTZ) → NUMBER(FLOAT, TIMESTAMP_TZ) → NUMBER(FLOAT, VARCHAR) → NUMBER(FLOAT, VARIANT) → NUMBER(NUMBER, ANY) → NUMBER(NUMBER, ARRAY) → NUMBER(NUMBER, BOOLEAN) → NUMBER(NUMBER, DATE) → NUMBER(NUMBER, FLOAT) → NUMBER(NUMBER, NUMBER) → NUMBER(NUMBER, OBJECT) → NUMBER(NUMBER, TIME) → NUMBER(NUMBER, TIMESTAMP_LTZ) → NUMBER(NUMBER, TIMESTAMP_NTZ) → NUMBER(NUMBER, TIMESTAMP_TZ) → NUMBER(NUMBER, VARCHAR) → NUMBER(NUMBER, VARIANT) → NUMBER(OBJECT, ARRAY) → NUMBER(OBJECT, BOOLEAN) → NUMBER(OBJECT, DATE) → NUMBER(OBJECT, FLOAT) → NUMBER(OBJECT, NUMBER) → NUMBER(OBJECT, OBJECT) → NUMBER(OBJECT, TIME) → NUMBER(OBJECT, TIMESTAMP_LTZ) → NUMBER(OBJECT, TIMESTAMP_NTZ) → NUMBER(OBJECT, TIMESTAMP_TZ) → NUMBER(OBJECT, VARCHAR) → NUMBER(OBJECT, VARIANT) → NUMBER(TIME, ANY) → NUMBER(TIME, ARRAY) → NUMBER(TIME, BOOLEAN) → NUMBER(TIME, DATE) → NUMBER(TIME, FLOAT) → NUMBER(TIME, NUMBER) → NUMBER(TIME, OBJECT) → NUMBER(TIME, TIME) → NUMBER(TIME, TIMESTAMP_LTZ) → NUMBER(TIME, TIMESTAMP_NTZ) → NUMBER(TIME, TIMESTAMP_TZ) → NUMBER(TIME, VARCHAR) → NUMBER(TIME, VARIANT) → NUMBER(TIMESTAMP_LTZ, ANY) → NUMBER(TIMESTAMP_LTZ, ARRAY) → NUMBER(TIMESTAMP_LTZ, BOOLEAN) → NUMBER(TIMESTAMP_LTZ, DATE) → NUMBER(TIMESTAMP_LTZ, FLOAT) → NUMBER(TIMESTAMP_LTZ, NUMBER) → NUMBER(TIMESTAMP_LTZ, OBJECT) → NUMBER(TIMESTAMP_LTZ, TIME) → NUMBER(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_LTZ, TIMESTAMP_TZ) → NUMBER(TIMESTAMP_LTZ, VARCHAR) → NUMBER(TIMESTAMP_LTZ, VARIANT) → NUMBER(TIMESTAMP_NTZ, ANY) → NUMBER(TIMESTAMP_NTZ, ARRAY) → NUMBER(TIMESTAMP_NTZ, BOOLEAN) → NUMBER(TIMESTAMP_NTZ, DATE) → NUMBER(TIMESTAMP_NTZ, FLOAT) → NUMBER(TIMESTAMP_NTZ, NUMBER) → NUMBER(TIMESTAMP_NTZ, OBJECT) → NUMBER(TIMESTAMP_NTZ, TIME) → NUMBER(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_NTZ, TIMESTAMP_TZ) → NUMBER(TIMESTAMP_NTZ, VARCHAR) → NUMBER(TIMESTAMP_NTZ, VARIANT) → NUMBER(TIMESTAMP_TZ, ANY) → NUMBER(TIMESTAMP_TZ, ARRAY) → NUMBER(TIMESTAMP_TZ, BOOLEAN) → NUMBER(TIMESTAMP_TZ, DATE) → NUMBER(TIMESTAMP_TZ, FLOAT) → NUMBER(TIMESTAMP_TZ, NUMBER) → NUMBER(TIMESTAMP_TZ, OBJECT) → NUMBER(TIMESTAMP_TZ, TIME) → NUMBER(TIMESTAMP_TZ, TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_TZ, TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER(TIMESTAMP_TZ, VARCHAR) → NUMBER(TIMESTAMP_TZ, VARIANT) → NUMBER(VARCHAR, ANY) → NUMBER(VARCHAR, ARRAY) → NUMBER(VARCHAR, BOOLEAN) → NUMBER(VARCHAR, DATE) → NUMBER(VARCHAR, FLOAT) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, OBJECT) → NUMBER(VARCHAR, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARCHAR, VARIANT) → NUMBER(VARIANT, ANY) → NUMBER(VARIANT, ARRAY) → NUMBER(VARIANT, BOOLEAN) → NUMBER(VARIANT, DATE) → NUMBER(VARIANT, FLOAT) → NUMBER(VARIANT, NUMBER) → NUMBER(VARIANT, OBJECT) → NUMBER(VARIANT, TIME) → NUMBER(VARIANT, TIMESTAMP_LTZ) → NUMBER(VARIANT, TIMESTAMP_NTZ) → NUMBER(VARIANT, TIMESTAMP_TZ) → NUMBER(VARIANT, VARCHAR) → NUMBER(VARIANT, VARIANT) → NUMBER |
H3_GRID_PATH | scalar | ✅ supported | (ANY, ANY) → ARRAY(ANY, BOOLEAN) → ARRAY(ANY, DATE) → ARRAY(ANY, FLOAT) → ARRAY(ANY, NUMBER) → ARRAY(ANY, TIME) → ARRAY(ANY, TIMESTAMP_LTZ) → ARRAY(ANY, TIMESTAMP_NTZ) → ARRAY(ANY, TIMESTAMP_TZ) → ARRAY(ANY, VARCHAR) → ARRAY(ANY, VARIANT) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BOOLEAN, ANY) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ANY) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ANY) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(NUMBER, ANY) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ANY) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ANY) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ANY) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ANY) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ANY) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ANY) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_INT_TO_STRING | scalar | ✅ supported | (ANY) → VARCHAR(ARRAY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(OBJECT) → VARCHAR(TIME) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
H3_IS_PENTAGON | scalar | ✅ supported | (ANY) → BOOLEAN(ARRAY) → BOOLEAN(BOOLEAN) → BOOLEAN(DATE) → BOOLEAN(FLOAT) → BOOLEAN(NUMBER) → BOOLEAN(OBJECT) → BOOLEAN(TIME) → BOOLEAN(TIMESTAMP_LTZ) → BOOLEAN(TIMESTAMP_NTZ) → BOOLEAN(TIMESTAMP_TZ) → BOOLEAN(VARCHAR) → BOOLEAN(VARIANT) → BOOLEAN |
H3_IS_VALID_CELL | scalar | ✅ supported | (ANY) → BOOLEAN(ARRAY) → BOOLEAN(BOOLEAN) → BOOLEAN(DATE) → BOOLEAN(FLOAT) → BOOLEAN(NUMBER) → BOOLEAN(OBJECT) → BOOLEAN(TIME) → BOOLEAN(TIMESTAMP_LTZ) → BOOLEAN(TIMESTAMP_NTZ) → BOOLEAN(TIMESTAMP_TZ) → BOOLEAN(VARCHAR) → BOOLEAN(VARIANT) → BOOLEAN |
H3_LATLNG_TO_CELL | scalar | ✅ supported | (ANY, ANY, ANY) → NUMBER(ANY, ANY, FLOAT) → NUMBER(ANY, FLOAT, ANY) → NUMBER(ANY, FLOAT, FLOAT) → NUMBER(FLOAT, ANY, ANY) → NUMBER(FLOAT, ANY, FLOAT) → NUMBER(FLOAT, FLOAT, ANY) → NUMBER(FLOAT, FLOAT, FLOAT) → NUMBER |
H3_LATLNG_TO_CELL_STRING | scalar | ✅ supported | (ANY, ANY, ANY) → VARCHAR(ANY, ANY, FLOAT) → VARCHAR(ANY, FLOAT, ANY) → VARCHAR(ANY, FLOAT, FLOAT) → VARCHAR(FLOAT, ANY, ANY) → VARCHAR(FLOAT, ANY, FLOAT) → VARCHAR(FLOAT, FLOAT, ANY) → VARCHAR(FLOAT, FLOAT, FLOAT) → VARCHAR |
H3_POINT_TO_CELL | scalar | ✅ supported | (ANY, ANY) → NUMBER(ANY, FLOAT) → NUMBER(GEOGRAPHY, ANY) → NUMBER(GEOGRAPHY, FLOAT) → NUMBER |
H3_POINT_TO_CELL_STRING | scalar | ✅ supported | (ANY, ANY) → VARCHAR(ANY, FLOAT) → VARCHAR(GEOGRAPHY, ANY) → VARCHAR(GEOGRAPHY, FLOAT) → VARCHAR |
H3_POLYGON_TO_CELLS | scalar | ✅ supported | (ANY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BINARY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, GEOGRAPHY) → ARRAY(ARRAY, GEOMETRY) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BINARY, ARRAY) → ARRAY(BINARY, BINARY) → ARRAY(BINARY, BOOLEAN) → ARRAY(BINARY, DATE) → ARRAY(BINARY, FLOAT) → ARRAY(BINARY, GEOGRAPHY) → ARRAY(BINARY, GEOMETRY) → ARRAY(BINARY, NUMBER) → ARRAY(BINARY, OBJECT) → ARRAY(BINARY, TIME) → ARRAY(BINARY, TIMESTAMP_LTZ) → ARRAY(BINARY, TIMESTAMP_NTZ) → ARRAY(BINARY, TIMESTAMP_TZ) → ARRAY(BINARY, VARCHAR) → ARRAY(BINARY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BINARY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, GEOGRAPHY) → ARRAY(BOOLEAN, GEOMETRY) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BINARY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, GEOGRAPHY) → ARRAY(DATE, GEOMETRY) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BINARY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, GEOGRAPHY) → ARRAY(FLOAT, GEOMETRY) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(GEOGRAPHY, ARRAY) → ARRAY(GEOGRAPHY, BINARY) → ARRAY(GEOGRAPHY, BOOLEAN) → ARRAY(GEOGRAPHY, DATE) → ARRAY(GEOGRAPHY, FLOAT) → ARRAY(GEOGRAPHY, GEOGRAPHY) → ARRAY(GEOGRAPHY, GEOMETRY) → ARRAY(GEOGRAPHY, NUMBER) → ARRAY(GEOGRAPHY, OBJECT) → ARRAY(GEOGRAPHY, TIME) → ARRAY(GEOGRAPHY, TIMESTAMP_LTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_NTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_TZ) → ARRAY(GEOGRAPHY, VARCHAR) → ARRAY(GEOGRAPHY, VARIANT) → ARRAY(GEOMETRY, ARRAY) → ARRAY(GEOMETRY, BINARY) → ARRAY(GEOMETRY, BOOLEAN) → ARRAY(GEOMETRY, DATE) → ARRAY(GEOMETRY, FLOAT) → ARRAY(GEOMETRY, GEOGRAPHY) → ARRAY(GEOMETRY, GEOMETRY) → ARRAY(GEOMETRY, NUMBER) → ARRAY(GEOMETRY, OBJECT) → ARRAY(GEOMETRY, TIME) → ARRAY(GEOMETRY, TIMESTAMP_LTZ) → ARRAY(GEOMETRY, TIMESTAMP_NTZ) → ARRAY(GEOMETRY, TIMESTAMP_TZ) → ARRAY(GEOMETRY, VARCHAR) → ARRAY(GEOMETRY, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BINARY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, GEOGRAPHY) → ARRAY(NUMBER, GEOMETRY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BINARY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, GEOGRAPHY) → ARRAY(OBJECT, GEOMETRY) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BINARY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, GEOGRAPHY) → ARRAY(TIME, GEOMETRY) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BINARY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_LTZ, GEOMETRY) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BINARY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_NTZ, GEOMETRY) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BINARY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, GEOGRAPHY) → ARRAY(TIMESTAMP_TZ, GEOMETRY) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BINARY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, GEOGRAPHY) → ARRAY(VARCHAR, GEOMETRY) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BINARY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, GEOGRAPHY) → ARRAY(VARIANT, GEOMETRY) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_POLYGON_TO_CELLS_STRINGS | scalar | ✅ supported | (ANY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BINARY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, GEOGRAPHY) → ARRAY(ARRAY, GEOMETRY) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BINARY, ARRAY) → ARRAY(BINARY, BINARY) → ARRAY(BINARY, BOOLEAN) → ARRAY(BINARY, DATE) → ARRAY(BINARY, FLOAT) → ARRAY(BINARY, GEOGRAPHY) → ARRAY(BINARY, GEOMETRY) → ARRAY(BINARY, NUMBER) → ARRAY(BINARY, OBJECT) → ARRAY(BINARY, TIME) → ARRAY(BINARY, TIMESTAMP_LTZ) → ARRAY(BINARY, TIMESTAMP_NTZ) → ARRAY(BINARY, TIMESTAMP_TZ) → ARRAY(BINARY, VARCHAR) → ARRAY(BINARY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BINARY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, GEOGRAPHY) → ARRAY(BOOLEAN, GEOMETRY) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BINARY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, GEOGRAPHY) → ARRAY(DATE, GEOMETRY) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BINARY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, GEOGRAPHY) → ARRAY(FLOAT, GEOMETRY) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(GEOGRAPHY, ARRAY) → ARRAY(GEOGRAPHY, BINARY) → ARRAY(GEOGRAPHY, BOOLEAN) → ARRAY(GEOGRAPHY, DATE) → ARRAY(GEOGRAPHY, FLOAT) → ARRAY(GEOGRAPHY, GEOGRAPHY) → ARRAY(GEOGRAPHY, GEOMETRY) → ARRAY(GEOGRAPHY, NUMBER) → ARRAY(GEOGRAPHY, OBJECT) → ARRAY(GEOGRAPHY, TIME) → ARRAY(GEOGRAPHY, TIMESTAMP_LTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_NTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_TZ) → ARRAY(GEOGRAPHY, VARCHAR) → ARRAY(GEOGRAPHY, VARIANT) → ARRAY(GEOMETRY, ARRAY) → ARRAY(GEOMETRY, BINARY) → ARRAY(GEOMETRY, BOOLEAN) → ARRAY(GEOMETRY, DATE) → ARRAY(GEOMETRY, FLOAT) → ARRAY(GEOMETRY, GEOGRAPHY) → ARRAY(GEOMETRY, GEOMETRY) → ARRAY(GEOMETRY, NUMBER) → ARRAY(GEOMETRY, OBJECT) → ARRAY(GEOMETRY, TIME) → ARRAY(GEOMETRY, TIMESTAMP_LTZ) → ARRAY(GEOMETRY, TIMESTAMP_NTZ) → ARRAY(GEOMETRY, TIMESTAMP_TZ) → ARRAY(GEOMETRY, VARCHAR) → ARRAY(GEOMETRY, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BINARY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, GEOGRAPHY) → ARRAY(NUMBER, GEOMETRY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BINARY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, GEOGRAPHY) → ARRAY(OBJECT, GEOMETRY) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BINARY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, GEOGRAPHY) → ARRAY(TIME, GEOMETRY) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BINARY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_LTZ, GEOMETRY) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BINARY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_NTZ, GEOMETRY) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BINARY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, GEOGRAPHY) → ARRAY(TIMESTAMP_TZ, GEOMETRY) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BINARY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, GEOGRAPHY) → ARRAY(VARCHAR, GEOMETRY) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BINARY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, GEOGRAPHY) → ARRAY(VARIANT, GEOMETRY) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_STRING_TO_INT | scalar | ✅ supported | (ANY) → NUMBER(ARRAY) → NUMBER(BOOLEAN) → NUMBER(DATE) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER(OBJECT) → NUMBER(TIME) → NUMBER(TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ) → NUMBER(VARCHAR) → NUMBER(VARIANT) → NUMBER |
H3_TRY_COVERAGE | scalar | ✅ supported | (ANY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BINARY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, GEOGRAPHY) → ARRAY(ARRAY, GEOMETRY) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BINARY, ARRAY) → ARRAY(BINARY, BINARY) → ARRAY(BINARY, BOOLEAN) → ARRAY(BINARY, DATE) → ARRAY(BINARY, FLOAT) → ARRAY(BINARY, GEOGRAPHY) → ARRAY(BINARY, GEOMETRY) → ARRAY(BINARY, NUMBER) → ARRAY(BINARY, OBJECT) → ARRAY(BINARY, TIME) → ARRAY(BINARY, TIMESTAMP_LTZ) → ARRAY(BINARY, TIMESTAMP_NTZ) → ARRAY(BINARY, TIMESTAMP_TZ) → ARRAY(BINARY, VARCHAR) → ARRAY(BINARY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BINARY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, GEOGRAPHY) → ARRAY(BOOLEAN, GEOMETRY) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BINARY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, GEOGRAPHY) → ARRAY(DATE, GEOMETRY) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BINARY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, GEOGRAPHY) → ARRAY(FLOAT, GEOMETRY) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(GEOGRAPHY, ARRAY) → ARRAY(GEOGRAPHY, BINARY) → ARRAY(GEOGRAPHY, BOOLEAN) → ARRAY(GEOGRAPHY, DATE) → ARRAY(GEOGRAPHY, FLOAT) → ARRAY(GEOGRAPHY, GEOGRAPHY) → ARRAY(GEOGRAPHY, GEOMETRY) → ARRAY(GEOGRAPHY, NUMBER) → ARRAY(GEOGRAPHY, OBJECT) → ARRAY(GEOGRAPHY, TIME) → ARRAY(GEOGRAPHY, TIMESTAMP_LTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_NTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_TZ) → ARRAY(GEOGRAPHY, VARCHAR) → ARRAY(GEOGRAPHY, VARIANT) → ARRAY(GEOMETRY, ARRAY) → ARRAY(GEOMETRY, BINARY) → ARRAY(GEOMETRY, BOOLEAN) → ARRAY(GEOMETRY, DATE) → ARRAY(GEOMETRY, FLOAT) → ARRAY(GEOMETRY, GEOGRAPHY) → ARRAY(GEOMETRY, GEOMETRY) → ARRAY(GEOMETRY, NUMBER) → ARRAY(GEOMETRY, OBJECT) → ARRAY(GEOMETRY, TIME) → ARRAY(GEOMETRY, TIMESTAMP_LTZ) → ARRAY(GEOMETRY, TIMESTAMP_NTZ) → ARRAY(GEOMETRY, TIMESTAMP_TZ) → ARRAY(GEOMETRY, VARCHAR) → ARRAY(GEOMETRY, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BINARY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, GEOGRAPHY) → ARRAY(NUMBER, GEOMETRY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BINARY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, GEOGRAPHY) → ARRAY(OBJECT, GEOMETRY) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BINARY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, GEOGRAPHY) → ARRAY(TIME, GEOMETRY) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BINARY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_LTZ, GEOMETRY) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BINARY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_NTZ, GEOMETRY) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BINARY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, GEOGRAPHY) → ARRAY(TIMESTAMP_TZ, GEOMETRY) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BINARY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, GEOGRAPHY) → ARRAY(VARCHAR, GEOMETRY) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BINARY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, GEOGRAPHY) → ARRAY(VARIANT, GEOMETRY) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_TRY_COVERAGE_STRINGS | scalar | ✅ supported | (ANY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BINARY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, GEOGRAPHY) → ARRAY(ARRAY, GEOMETRY) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BINARY, ARRAY) → ARRAY(BINARY, BINARY) → ARRAY(BINARY, BOOLEAN) → ARRAY(BINARY, DATE) → ARRAY(BINARY, FLOAT) → ARRAY(BINARY, GEOGRAPHY) → ARRAY(BINARY, GEOMETRY) → ARRAY(BINARY, NUMBER) → ARRAY(BINARY, OBJECT) → ARRAY(BINARY, TIME) → ARRAY(BINARY, TIMESTAMP_LTZ) → ARRAY(BINARY, TIMESTAMP_NTZ) → ARRAY(BINARY, TIMESTAMP_TZ) → ARRAY(BINARY, VARCHAR) → ARRAY(BINARY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BINARY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, GEOGRAPHY) → ARRAY(BOOLEAN, GEOMETRY) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BINARY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, GEOGRAPHY) → ARRAY(DATE, GEOMETRY) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BINARY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, GEOGRAPHY) → ARRAY(FLOAT, GEOMETRY) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(GEOGRAPHY, ARRAY) → ARRAY(GEOGRAPHY, BINARY) → ARRAY(GEOGRAPHY, BOOLEAN) → ARRAY(GEOGRAPHY, DATE) → ARRAY(GEOGRAPHY, FLOAT) → ARRAY(GEOGRAPHY, GEOGRAPHY) → ARRAY(GEOGRAPHY, GEOMETRY) → ARRAY(GEOGRAPHY, NUMBER) → ARRAY(GEOGRAPHY, OBJECT) → ARRAY(GEOGRAPHY, TIME) → ARRAY(GEOGRAPHY, TIMESTAMP_LTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_NTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_TZ) → ARRAY(GEOGRAPHY, VARCHAR) → ARRAY(GEOGRAPHY, VARIANT) → ARRAY(GEOMETRY, ARRAY) → ARRAY(GEOMETRY, BINARY) → ARRAY(GEOMETRY, BOOLEAN) → ARRAY(GEOMETRY, DATE) → ARRAY(GEOMETRY, FLOAT) → ARRAY(GEOMETRY, GEOGRAPHY) → ARRAY(GEOMETRY, GEOMETRY) → ARRAY(GEOMETRY, NUMBER) → ARRAY(GEOMETRY, OBJECT) → ARRAY(GEOMETRY, TIME) → ARRAY(GEOMETRY, TIMESTAMP_LTZ) → ARRAY(GEOMETRY, TIMESTAMP_NTZ) → ARRAY(GEOMETRY, TIMESTAMP_TZ) → ARRAY(GEOMETRY, VARCHAR) → ARRAY(GEOMETRY, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BINARY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, GEOGRAPHY) → ARRAY(NUMBER, GEOMETRY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BINARY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, GEOGRAPHY) → ARRAY(OBJECT, GEOMETRY) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BINARY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, GEOGRAPHY) → ARRAY(TIME, GEOMETRY) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BINARY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_LTZ, GEOMETRY) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BINARY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_NTZ, GEOMETRY) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BINARY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, GEOGRAPHY) → ARRAY(TIMESTAMP_TZ, GEOMETRY) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BINARY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, GEOGRAPHY) → ARRAY(VARCHAR, GEOMETRY) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BINARY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, GEOGRAPHY) → ARRAY(VARIANT, GEOMETRY) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_TRY_GRID_DISTANCE | scalar | ✅ supported | (ANY, ANY) → NUMBER(ANY, BOOLEAN) → NUMBER(ANY, DATE) → NUMBER(ANY, FLOAT) → NUMBER(ANY, NUMBER) → NUMBER(ANY, TIME) → NUMBER(ANY, TIMESTAMP_LTZ) → NUMBER(ANY, TIMESTAMP_NTZ) → NUMBER(ANY, TIMESTAMP_TZ) → NUMBER(ANY, VARCHAR) → NUMBER(ANY, VARIANT) → NUMBER(ARRAY, ARRAY) → NUMBER(ARRAY, BOOLEAN) → NUMBER(ARRAY, DATE) → NUMBER(ARRAY, FLOAT) → NUMBER(ARRAY, NUMBER) → NUMBER(ARRAY, OBJECT) → NUMBER(ARRAY, TIME) → NUMBER(ARRAY, TIMESTAMP_LTZ) → NUMBER(ARRAY, TIMESTAMP_NTZ) → NUMBER(ARRAY, TIMESTAMP_TZ) → NUMBER(ARRAY, VARCHAR) → NUMBER(ARRAY, VARIANT) → NUMBER(BOOLEAN, ANY) → NUMBER(BOOLEAN, ARRAY) → NUMBER(BOOLEAN, BOOLEAN) → NUMBER(BOOLEAN, DATE) → NUMBER(BOOLEAN, FLOAT) → NUMBER(BOOLEAN, NUMBER) → NUMBER(BOOLEAN, OBJECT) → NUMBER(BOOLEAN, TIME) → NUMBER(BOOLEAN, TIMESTAMP_LTZ) → NUMBER(BOOLEAN, TIMESTAMP_NTZ) → NUMBER(BOOLEAN, TIMESTAMP_TZ) → NUMBER(BOOLEAN, VARCHAR) → NUMBER(BOOLEAN, VARIANT) → NUMBER(DATE, ANY) → NUMBER(DATE, ARRAY) → NUMBER(DATE, BOOLEAN) → NUMBER(DATE, DATE) → NUMBER(DATE, FLOAT) → NUMBER(DATE, NUMBER) → NUMBER(DATE, OBJECT) → NUMBER(DATE, TIME) → NUMBER(DATE, TIMESTAMP_LTZ) → NUMBER(DATE, TIMESTAMP_NTZ) → NUMBER(DATE, TIMESTAMP_TZ) → NUMBER(DATE, VARCHAR) → NUMBER(DATE, VARIANT) → NUMBER(FLOAT, ANY) → NUMBER(FLOAT, ARRAY) → NUMBER(FLOAT, BOOLEAN) → NUMBER(FLOAT, DATE) → NUMBER(FLOAT, FLOAT) → NUMBER(FLOAT, NUMBER) → NUMBER(FLOAT, OBJECT) → NUMBER(FLOAT, TIME) → NUMBER(FLOAT, TIMESTAMP_LTZ) → NUMBER(FLOAT, TIMESTAMP_NTZ) → NUMBER(FLOAT, TIMESTAMP_TZ) → NUMBER(FLOAT, VARCHAR) → NUMBER(FLOAT, VARIANT) → NUMBER(NUMBER, ANY) → NUMBER(NUMBER, ARRAY) → NUMBER(NUMBER, BOOLEAN) → NUMBER(NUMBER, DATE) → NUMBER(NUMBER, FLOAT) → NUMBER(NUMBER, NUMBER) → NUMBER(NUMBER, OBJECT) → NUMBER(NUMBER, TIME) → NUMBER(NUMBER, TIMESTAMP_LTZ) → NUMBER(NUMBER, TIMESTAMP_NTZ) → NUMBER(NUMBER, TIMESTAMP_TZ) → NUMBER(NUMBER, VARCHAR) → NUMBER(NUMBER, VARIANT) → NUMBER(OBJECT, ARRAY) → NUMBER(OBJECT, BOOLEAN) → NUMBER(OBJECT, DATE) → NUMBER(OBJECT, FLOAT) → NUMBER(OBJECT, NUMBER) → NUMBER(OBJECT, OBJECT) → NUMBER(OBJECT, TIME) → NUMBER(OBJECT, TIMESTAMP_LTZ) → NUMBER(OBJECT, TIMESTAMP_NTZ) → NUMBER(OBJECT, TIMESTAMP_TZ) → NUMBER(OBJECT, VARCHAR) → NUMBER(OBJECT, VARIANT) → NUMBER(TIME, ANY) → NUMBER(TIME, ARRAY) → NUMBER(TIME, BOOLEAN) → NUMBER(TIME, DATE) → NUMBER(TIME, FLOAT) → NUMBER(TIME, NUMBER) → NUMBER(TIME, OBJECT) → NUMBER(TIME, TIME) → NUMBER(TIME, TIMESTAMP_LTZ) → NUMBER(TIME, TIMESTAMP_NTZ) → NUMBER(TIME, TIMESTAMP_TZ) → NUMBER(TIME, VARCHAR) → NUMBER(TIME, VARIANT) → NUMBER(TIMESTAMP_LTZ, ANY) → NUMBER(TIMESTAMP_LTZ, ARRAY) → NUMBER(TIMESTAMP_LTZ, BOOLEAN) → NUMBER(TIMESTAMP_LTZ, DATE) → NUMBER(TIMESTAMP_LTZ, FLOAT) → NUMBER(TIMESTAMP_LTZ, NUMBER) → NUMBER(TIMESTAMP_LTZ, OBJECT) → NUMBER(TIMESTAMP_LTZ, TIME) → NUMBER(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_LTZ, TIMESTAMP_TZ) → NUMBER(TIMESTAMP_LTZ, VARCHAR) → NUMBER(TIMESTAMP_LTZ, VARIANT) → NUMBER(TIMESTAMP_NTZ, ANY) → NUMBER(TIMESTAMP_NTZ, ARRAY) → NUMBER(TIMESTAMP_NTZ, BOOLEAN) → NUMBER(TIMESTAMP_NTZ, DATE) → NUMBER(TIMESTAMP_NTZ, FLOAT) → NUMBER(TIMESTAMP_NTZ, NUMBER) → NUMBER(TIMESTAMP_NTZ, OBJECT) → NUMBER(TIMESTAMP_NTZ, TIME) → NUMBER(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_NTZ, TIMESTAMP_TZ) → NUMBER(TIMESTAMP_NTZ, VARCHAR) → NUMBER(TIMESTAMP_NTZ, VARIANT) → NUMBER(TIMESTAMP_TZ, ANY) → NUMBER(TIMESTAMP_TZ, ARRAY) → NUMBER(TIMESTAMP_TZ, BOOLEAN) → NUMBER(TIMESTAMP_TZ, DATE) → NUMBER(TIMESTAMP_TZ, FLOAT) → NUMBER(TIMESTAMP_TZ, NUMBER) → NUMBER(TIMESTAMP_TZ, OBJECT) → NUMBER(TIMESTAMP_TZ, TIME) → NUMBER(TIMESTAMP_TZ, TIMESTAMP_LTZ) → NUMBER(TIMESTAMP_TZ, TIMESTAMP_NTZ) → NUMBER(TIMESTAMP_TZ, TIMESTAMP_TZ) → NUMBER(TIMESTAMP_TZ, VARCHAR) → NUMBER(TIMESTAMP_TZ, VARIANT) → NUMBER(VARCHAR, ANY) → NUMBER(VARCHAR, ARRAY) → NUMBER(VARCHAR, BOOLEAN) → NUMBER(VARCHAR, DATE) → NUMBER(VARCHAR, FLOAT) → NUMBER(VARCHAR, NUMBER) → NUMBER(VARCHAR, OBJECT) → NUMBER(VARCHAR, TIME) → NUMBER(VARCHAR, TIMESTAMP_LTZ) → NUMBER(VARCHAR, TIMESTAMP_NTZ) → NUMBER(VARCHAR, TIMESTAMP_TZ) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARCHAR, VARIANT) → NUMBER(VARIANT, ANY) → NUMBER(VARIANT, ARRAY) → NUMBER(VARIANT, BOOLEAN) → NUMBER(VARIANT, DATE) → NUMBER(VARIANT, FLOAT) → NUMBER(VARIANT, NUMBER) → NUMBER(VARIANT, OBJECT) → NUMBER(VARIANT, TIME) → NUMBER(VARIANT, TIMESTAMP_LTZ) → NUMBER(VARIANT, TIMESTAMP_NTZ) → NUMBER(VARIANT, TIMESTAMP_TZ) → NUMBER(VARIANT, VARCHAR) → NUMBER(VARIANT, VARIANT) → NUMBER |
H3_TRY_GRID_PATH | scalar | ✅ supported | (ANY, ANY) → ARRAY(ANY, BOOLEAN) → ARRAY(ANY, DATE) → ARRAY(ANY, FLOAT) → ARRAY(ANY, NUMBER) → ARRAY(ANY, TIME) → ARRAY(ANY, TIMESTAMP_LTZ) → ARRAY(ANY, TIMESTAMP_NTZ) → ARRAY(ANY, TIMESTAMP_TZ) → ARRAY(ANY, VARCHAR) → ARRAY(ANY, VARIANT) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BOOLEAN, ANY) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ANY) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ANY) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(NUMBER, ANY) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ANY) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ANY) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ANY) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ANY) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ANY) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ANY) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_TRY_POLYGON_TO_CELLS | scalar | ✅ supported | (ANY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BINARY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, GEOGRAPHY) → ARRAY(ARRAY, GEOMETRY) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BINARY, ARRAY) → ARRAY(BINARY, BINARY) → ARRAY(BINARY, BOOLEAN) → ARRAY(BINARY, DATE) → ARRAY(BINARY, FLOAT) → ARRAY(BINARY, GEOGRAPHY) → ARRAY(BINARY, GEOMETRY) → ARRAY(BINARY, NUMBER) → ARRAY(BINARY, OBJECT) → ARRAY(BINARY, TIME) → ARRAY(BINARY, TIMESTAMP_LTZ) → ARRAY(BINARY, TIMESTAMP_NTZ) → ARRAY(BINARY, TIMESTAMP_TZ) → ARRAY(BINARY, VARCHAR) → ARRAY(BINARY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BINARY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, GEOGRAPHY) → ARRAY(BOOLEAN, GEOMETRY) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BINARY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, GEOGRAPHY) → ARRAY(DATE, GEOMETRY) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BINARY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, GEOGRAPHY) → ARRAY(FLOAT, GEOMETRY) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(GEOGRAPHY, ARRAY) → ARRAY(GEOGRAPHY, BINARY) → ARRAY(GEOGRAPHY, BOOLEAN) → ARRAY(GEOGRAPHY, DATE) → ARRAY(GEOGRAPHY, FLOAT) → ARRAY(GEOGRAPHY, GEOGRAPHY) → ARRAY(GEOGRAPHY, GEOMETRY) → ARRAY(GEOGRAPHY, NUMBER) → ARRAY(GEOGRAPHY, OBJECT) → ARRAY(GEOGRAPHY, TIME) → ARRAY(GEOGRAPHY, TIMESTAMP_LTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_NTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_TZ) → ARRAY(GEOGRAPHY, VARCHAR) → ARRAY(GEOGRAPHY, VARIANT) → ARRAY(GEOMETRY, ARRAY) → ARRAY(GEOMETRY, BINARY) → ARRAY(GEOMETRY, BOOLEAN) → ARRAY(GEOMETRY, DATE) → ARRAY(GEOMETRY, FLOAT) → ARRAY(GEOMETRY, GEOGRAPHY) → ARRAY(GEOMETRY, GEOMETRY) → ARRAY(GEOMETRY, NUMBER) → ARRAY(GEOMETRY, OBJECT) → ARRAY(GEOMETRY, TIME) → ARRAY(GEOMETRY, TIMESTAMP_LTZ) → ARRAY(GEOMETRY, TIMESTAMP_NTZ) → ARRAY(GEOMETRY, TIMESTAMP_TZ) → ARRAY(GEOMETRY, VARCHAR) → ARRAY(GEOMETRY, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BINARY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, GEOGRAPHY) → ARRAY(NUMBER, GEOMETRY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BINARY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, GEOGRAPHY) → ARRAY(OBJECT, GEOMETRY) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BINARY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, GEOGRAPHY) → ARRAY(TIME, GEOMETRY) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BINARY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_LTZ, GEOMETRY) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BINARY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_NTZ, GEOMETRY) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BINARY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, GEOGRAPHY) → ARRAY(TIMESTAMP_TZ, GEOMETRY) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BINARY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, GEOGRAPHY) → ARRAY(VARCHAR, GEOMETRY) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BINARY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, GEOGRAPHY) → ARRAY(VARIANT, GEOMETRY) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_TRY_POLYGON_TO_CELLS_STRINGS | scalar | ✅ supported | (ANY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BINARY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, GEOGRAPHY) → ARRAY(ARRAY, GEOMETRY) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BINARY, ARRAY) → ARRAY(BINARY, BINARY) → ARRAY(BINARY, BOOLEAN) → ARRAY(BINARY, DATE) → ARRAY(BINARY, FLOAT) → ARRAY(BINARY, GEOGRAPHY) → ARRAY(BINARY, GEOMETRY) → ARRAY(BINARY, NUMBER) → ARRAY(BINARY, OBJECT) → ARRAY(BINARY, TIME) → ARRAY(BINARY, TIMESTAMP_LTZ) → ARRAY(BINARY, TIMESTAMP_NTZ) → ARRAY(BINARY, TIMESTAMP_TZ) → ARRAY(BINARY, VARCHAR) → ARRAY(BINARY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BINARY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, GEOGRAPHY) → ARRAY(BOOLEAN, GEOMETRY) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BINARY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, GEOGRAPHY) → ARRAY(DATE, GEOMETRY) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BINARY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, GEOGRAPHY) → ARRAY(FLOAT, GEOMETRY) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(GEOGRAPHY, ARRAY) → ARRAY(GEOGRAPHY, BINARY) → ARRAY(GEOGRAPHY, BOOLEAN) → ARRAY(GEOGRAPHY, DATE) → ARRAY(GEOGRAPHY, FLOAT) → ARRAY(GEOGRAPHY, GEOGRAPHY) → ARRAY(GEOGRAPHY, GEOMETRY) → ARRAY(GEOGRAPHY, NUMBER) → ARRAY(GEOGRAPHY, OBJECT) → ARRAY(GEOGRAPHY, TIME) → ARRAY(GEOGRAPHY, TIMESTAMP_LTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_NTZ) → ARRAY(GEOGRAPHY, TIMESTAMP_TZ) → ARRAY(GEOGRAPHY, VARCHAR) → ARRAY(GEOGRAPHY, VARIANT) → ARRAY(GEOMETRY, ARRAY) → ARRAY(GEOMETRY, BINARY) → ARRAY(GEOMETRY, BOOLEAN) → ARRAY(GEOMETRY, DATE) → ARRAY(GEOMETRY, FLOAT) → ARRAY(GEOMETRY, GEOGRAPHY) → ARRAY(GEOMETRY, GEOMETRY) → ARRAY(GEOMETRY, NUMBER) → ARRAY(GEOMETRY, OBJECT) → ARRAY(GEOMETRY, TIME) → ARRAY(GEOMETRY, TIMESTAMP_LTZ) → ARRAY(GEOMETRY, TIMESTAMP_NTZ) → ARRAY(GEOMETRY, TIMESTAMP_TZ) → ARRAY(GEOMETRY, VARCHAR) → ARRAY(GEOMETRY, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BINARY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, GEOGRAPHY) → ARRAY(NUMBER, GEOMETRY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BINARY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, GEOGRAPHY) → ARRAY(OBJECT, GEOMETRY) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BINARY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, GEOGRAPHY) → ARRAY(TIME, GEOMETRY) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BINARY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_LTZ, GEOMETRY) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BINARY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, GEOGRAPHY) → ARRAY(TIMESTAMP_NTZ, GEOMETRY) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BINARY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, GEOGRAPHY) → ARRAY(TIMESTAMP_TZ, GEOMETRY) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BINARY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, GEOGRAPHY) → ARRAY(VARCHAR, GEOMETRY) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BINARY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, GEOGRAPHY) → ARRAY(VARIANT, GEOMETRY) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_UNCOMPACT_CELLS | scalar | ✅ supported | (ANY, ANY) → ARRAY(ANY, FLOAT) → ARRAY(ANY, NUMBER) → ARRAY(ANY, VARCHAR) → ARRAY(ANY, VARIANT) → ARRAY(ARRAY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ANY) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
H3_UNCOMPACT_CELLS_STRINGS | scalar | ✅ supported | (ANY, ANY) → ARRAY(ANY, FLOAT) → ARRAY(ANY, NUMBER) → ARRAY(ANY, VARCHAR) → ARRAY(ANY, VARIANT) → ARRAY(ARRAY, ANY) → ARRAY(ARRAY, ARRAY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, DATE) → ARRAY(ARRAY, FLOAT) → ARRAY(ARRAY, NUMBER) → ARRAY(ARRAY, OBJECT) → ARRAY(ARRAY, TIME) → ARRAY(ARRAY, TIMESTAMP_LTZ) → ARRAY(ARRAY, TIMESTAMP_NTZ) → ARRAY(ARRAY, TIMESTAMP_TZ) → ARRAY(ARRAY, VARCHAR) → ARRAY(ARRAY, VARIANT) → ARRAY(BOOLEAN, ARRAY) → ARRAY(BOOLEAN, BOOLEAN) → ARRAY(BOOLEAN, DATE) → ARRAY(BOOLEAN, FLOAT) → ARRAY(BOOLEAN, NUMBER) → ARRAY(BOOLEAN, OBJECT) → ARRAY(BOOLEAN, TIME) → ARRAY(BOOLEAN, TIMESTAMP_LTZ) → ARRAY(BOOLEAN, TIMESTAMP_NTZ) → ARRAY(BOOLEAN, TIMESTAMP_TZ) → ARRAY(BOOLEAN, VARCHAR) → ARRAY(BOOLEAN, VARIANT) → ARRAY(DATE, ARRAY) → ARRAY(DATE, BOOLEAN) → ARRAY(DATE, DATE) → ARRAY(DATE, FLOAT) → ARRAY(DATE, NUMBER) → ARRAY(DATE, OBJECT) → ARRAY(DATE, TIME) → ARRAY(DATE, TIMESTAMP_LTZ) → ARRAY(DATE, TIMESTAMP_NTZ) → ARRAY(DATE, TIMESTAMP_TZ) → ARRAY(DATE, VARCHAR) → ARRAY(DATE, VARIANT) → ARRAY(FLOAT, ARRAY) → ARRAY(FLOAT, BOOLEAN) → ARRAY(FLOAT, DATE) → ARRAY(FLOAT, FLOAT) → ARRAY(FLOAT, NUMBER) → ARRAY(FLOAT, OBJECT) → ARRAY(FLOAT, TIME) → ARRAY(FLOAT, TIMESTAMP_LTZ) → ARRAY(FLOAT, TIMESTAMP_NTZ) → ARRAY(FLOAT, TIMESTAMP_TZ) → ARRAY(FLOAT, VARCHAR) → ARRAY(FLOAT, VARIANT) → ARRAY(NUMBER, ARRAY) → ARRAY(NUMBER, BOOLEAN) → ARRAY(NUMBER, DATE) → ARRAY(NUMBER, FLOAT) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, OBJECT) → ARRAY(NUMBER, TIME) → ARRAY(NUMBER, TIMESTAMP_LTZ) → ARRAY(NUMBER, TIMESTAMP_NTZ) → ARRAY(NUMBER, TIMESTAMP_TZ) → ARRAY(NUMBER, VARCHAR) → ARRAY(NUMBER, VARIANT) → ARRAY(OBJECT, ARRAY) → ARRAY(OBJECT, BOOLEAN) → ARRAY(OBJECT, DATE) → ARRAY(OBJECT, FLOAT) → ARRAY(OBJECT, NUMBER) → ARRAY(OBJECT, OBJECT) → ARRAY(OBJECT, TIME) → ARRAY(OBJECT, TIMESTAMP_LTZ) → ARRAY(OBJECT, TIMESTAMP_NTZ) → ARRAY(OBJECT, TIMESTAMP_TZ) → ARRAY(OBJECT, VARCHAR) → ARRAY(OBJECT, VARIANT) → ARRAY(TIME, ARRAY) → ARRAY(TIME, BOOLEAN) → ARRAY(TIME, DATE) → ARRAY(TIME, FLOAT) → ARRAY(TIME, NUMBER) → ARRAY(TIME, OBJECT) → ARRAY(TIME, TIME) → ARRAY(TIME, TIMESTAMP_LTZ) → ARRAY(TIME, TIMESTAMP_NTZ) → ARRAY(TIME, TIMESTAMP_TZ) → ARRAY(TIME, VARCHAR) → ARRAY(TIME, VARIANT) → ARRAY(TIMESTAMP_LTZ, ARRAY) → ARRAY(TIMESTAMP_LTZ, BOOLEAN) → ARRAY(TIMESTAMP_LTZ, DATE) → ARRAY(TIMESTAMP_LTZ, FLOAT) → ARRAY(TIMESTAMP_LTZ, NUMBER) → ARRAY(TIMESTAMP_LTZ, OBJECT) → ARRAY(TIMESTAMP_LTZ, TIME) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_LTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_LTZ, VARCHAR) → ARRAY(TIMESTAMP_LTZ, VARIANT) → ARRAY(TIMESTAMP_NTZ, ARRAY) → ARRAY(TIMESTAMP_NTZ, BOOLEAN) → ARRAY(TIMESTAMP_NTZ, DATE) → ARRAY(TIMESTAMP_NTZ, FLOAT) → ARRAY(TIMESTAMP_NTZ, NUMBER) → ARRAY(TIMESTAMP_NTZ, OBJECT) → ARRAY(TIMESTAMP_NTZ, TIME) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_NTZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_NTZ, VARCHAR) → ARRAY(TIMESTAMP_NTZ, VARIANT) → ARRAY(TIMESTAMP_TZ, ARRAY) → ARRAY(TIMESTAMP_TZ, BOOLEAN) → ARRAY(TIMESTAMP_TZ, DATE) → ARRAY(TIMESTAMP_TZ, FLOAT) → ARRAY(TIMESTAMP_TZ, NUMBER) → ARRAY(TIMESTAMP_TZ, OBJECT) → ARRAY(TIMESTAMP_TZ, TIME) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_LTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_NTZ) → ARRAY(TIMESTAMP_TZ, TIMESTAMP_TZ) → ARRAY(TIMESTAMP_TZ, VARCHAR) → ARRAY(TIMESTAMP_TZ, VARIANT) → ARRAY(VARCHAR, ARRAY) → ARRAY(VARCHAR, BOOLEAN) → ARRAY(VARCHAR, DATE) → ARRAY(VARCHAR, FLOAT) → ARRAY(VARCHAR, NUMBER) → ARRAY(VARCHAR, OBJECT) → ARRAY(VARCHAR, TIME) → ARRAY(VARCHAR, TIMESTAMP_LTZ) → ARRAY(VARCHAR, TIMESTAMP_NTZ) → ARRAY(VARCHAR, TIMESTAMP_TZ) → ARRAY(VARCHAR, VARCHAR) → ARRAY(VARCHAR, VARIANT) → ARRAY(VARIANT, ANY) → ARRAY(VARIANT, ARRAY) → ARRAY(VARIANT, BOOLEAN) → ARRAY(VARIANT, DATE) → ARRAY(VARIANT, FLOAT) → ARRAY(VARIANT, NUMBER) → ARRAY(VARIANT, OBJECT) → ARRAY(VARIANT, TIME) → ARRAY(VARIANT, TIMESTAMP_LTZ) → ARRAY(VARIANT, TIMESTAMP_NTZ) → ARRAY(VARIANT, TIMESTAMP_TZ) → ARRAY(VARIANT, VARCHAR) → ARRAY(VARIANT, VARIANT) → ARRAY |
HAVERSINE | scalar | ✅ supported | (FLOAT, FLOAT, FLOAT, FLOAT) → FLOAT |
ST_AREA | scalar | ✅ supported | (ANY) → FLOAT(GEOGRAPHY) → FLOAT(GEOMETRY) → FLOAT |
ST_ASBINARY | scalar | ✅ supported | (ANY) → BINARY(GEOGRAPHY) → BINARY(GEOMETRY) → BINARY |
ST_ASEWKB | scalar | ✅ supported | (ANY) → BINARY(GEOGRAPHY) → BINARY(GEOMETRY) → BINARY |
ST_ASEWKT | scalar | ✅ supported | (ANY) → VARCHAR(GEOGRAPHY) → VARCHAR(GEOMETRY) → VARCHAR |
ST_ASGEOJSON | scalar | ✅ supported | (ANY) → OBJECT(GEOGRAPHY) → OBJECT(GEOMETRY) → OBJECT |
ST_ASTEXT | scalar | ✅ supported | (ANY) → VARCHAR(GEOGRAPHY) → VARCHAR(GEOMETRY) → VARCHAR |
ST_ASWKB | scalar | ✅ supported | (ANY) → BINARY(GEOGRAPHY) → BINARY(GEOMETRY) → BINARY |
ST_ASWKT | scalar | ✅ supported | (ANY) → VARCHAR(GEOGRAPHY) → VARCHAR(GEOMETRY) → VARCHAR |
ST_AZIMUTH | scalar | ✅ supported | (ANY, ANY) → FLOAT(GEOGRAPHY, GEOGRAPHY) → FLOAT(GEOMETRY, GEOMETRY) → FLOAT |
ST_BUFFER | scalar | ✅ supported | (ANY, ANY) → GEOMETRY(GEOMETRY, FLOAT) → GEOMETRY |
ST_CENTROID | scalar | ✅ supported | (ANY) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY(GEOMETRY) → GEOMETRY |
ST_COLLECT | aggregate | ✅ supported | (ANY)(GEOGRAPHY)(ANY, ANY) → GEOGRAPHY(GEOGRAPHY, GEOGRAPHY) → GEOGRAPHY |
ST_CONTAINS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(GEOGRAPHY, GEOGRAPHY) → BOOLEAN(GEOMETRY, GEOMETRY) → BOOLEAN |
ST_COVEREDBY | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(GEOGRAPHY, GEOGRAPHY) → BOOLEAN(GEOMETRY, GEOMETRY) → BOOLEAN |
ST_COVERS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(GEOGRAPHY, GEOGRAPHY) → BOOLEAN(GEOMETRY, GEOMETRY) → BOOLEAN |
ST_DIFFERENCE | scalar | ✅ supported | (ANY, ANY) → GEOGRAPHY(GEOGRAPHY, GEOGRAPHY) → GEOGRAPHY |
ST_DIMENSION | scalar | ✅ supported | (ANY) → NUMBER(GEOGRAPHY) → NUMBER(GEOMETRY) → NUMBER |
ST_DISJOINT | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(GEOGRAPHY, GEOGRAPHY) → BOOLEAN(GEOMETRY, GEOMETRY) → BOOLEAN |
ST_DISTANCE | scalar | ✅ supported | (ANY, ANY) → FLOAT(GEOGRAPHY, GEOGRAPHY) → FLOAT(GEOMETRY, GEOMETRY) → FLOAT |
ST_DWITHIN | scalar | ✅ supported | (ANY, ANY, ANY) → BOOLEAN(GEOGRAPHY, GEOGRAPHY, FLOAT) → BOOLEAN |
ST_ENDPOINT | scalar | ✅ supported | (ANY) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY(GEOMETRY) → GEOMETRY |
ST_ENVELOPE | scalar | ✅ supported | (ANY) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY(GEOMETRY) → GEOMETRY |
ST_GEOGFROMGEOHASH | scalar | ✅ supported | (ANY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(VARCHAR, NUMBER) → GEOGRAPHY |
ST_GEOGPOINTFROMGEOHASH | scalar | ✅ supported | (ANY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY |
ST_GEOGRAPHYFROMWKB | scalar | ✅ supported | (ANY) → GEOGRAPHY(BINARY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(BINARY, BOOLEAN) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOGRAPHYFROMWKT | scalar | ✅ supported | (ANY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOHASH | scalar | ✅ supported | (ANY) → VARCHAR(GEOGRAPHY) → VARCHAR(GEOMETRY) → VARCHAR(ANY, ANY) → VARCHAR(GEOGRAPHY, NUMBER) → VARCHAR(GEOMETRY, NUMBER) → VARCHAR |
ST_GEOMETRYFROMWKB | scalar | ✅ supported | (ANY) → GEOMETRY(BINARY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, BOOLEAN) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, FLOAT) → GEOMETRY(BINARY, NUMBER) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(BINARY, VARCHAR) → GEOMETRY(BINARY, VARIANT) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, BOOLEAN, BOOLEAN) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, FLOAT, BOOLEAN) → GEOMETRY(BINARY, NUMBER, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(BINARY, VARCHAR, BOOLEAN) → GEOMETRY(BINARY, VARIANT, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY(ANY, ANY, ANY, ANY) → GEOMETRY(BINARY, NUMBER, BOOLEAN, NUMBER) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN, NUMBER) → GEOMETRY |
ST_GEOMETRYFROMWKT | scalar | ✅ supported | (ANY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY |
ST_GEOMFROMGEOHASH | scalar | ✅ supported | (ANY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY |
ST_GEOMPOINT | scalar | ✅ supported | (ANY, ANY) → GEOMETRY(FLOAT, FLOAT) → GEOMETRY |
ST_GEOMPOINTFROMGEOHASH | scalar | ✅ supported | (ANY) → GEOMETRY(VARCHAR) → GEOMETRY |
ST_HAUSDORFFDISTANCE | scalar | ✅ supported | (ANY, ANY) → FLOAT(GEOGRAPHY, GEOGRAPHY) → FLOAT |
ST_INTERPOLATE | scalar | ✅ supported | (ANY) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(GEOGRAPHY, FLOAT) → GEOGRAPHY |
ST_INTERSECTION | scalar | ✅ supported | (ANY, ANY) → GEOGRAPHY(GEOGRAPHY, GEOGRAPHY) → GEOGRAPHY |
ST_INTERSECTION_AGG | aggregate | ✅ supported | (ANY)(GEOGRAPHY) |
ST_INTERSECTS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(GEOGRAPHY, GEOGRAPHY) → BOOLEAN(GEOMETRY, GEOMETRY) → BOOLEAN |
ST_ISVALID | scalar | ✅ supported | (ANY) → BOOLEAN(GEOGRAPHY) → BOOLEAN(GEOMETRY) → BOOLEAN |
ST_LENGTH | scalar | ✅ supported | (ANY) → FLOAT(GEOGRAPHY) → FLOAT(GEOMETRY) → FLOAT |
ST_MAKEGEOMPOINT | scalar | ✅ supported | (ANY, ANY) → GEOMETRY(FLOAT, FLOAT) → GEOMETRY |
ST_MAKELINE | scalar | ✅ supported | (ANY, ANY) → GEOGRAPHY(GEOGRAPHY, GEOGRAPHY) → GEOGRAPHY(GEOMETRY, GEOMETRY) → GEOMETRY |
ST_MAKEPOINT | scalar | ✅ supported | (ANY, ANY) → GEOGRAPHY(FLOAT, FLOAT) → GEOGRAPHY |
ST_MAKEPOLYGON | scalar | ✅ supported | (ANY) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY(GEOMETRY) → GEOMETRY |
ST_MAKEPOLYGONORIENTED | scalar | ✅ supported | (ANY) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY |
ST_NPOINTS | scalar | ✅ supported | (ANY) → NUMBER(GEOGRAPHY) → NUMBER(GEOMETRY) → NUMBER |
ST_NUMPOINTS | scalar | ✅ supported | (ANY) → NUMBER(GEOGRAPHY) → NUMBER(GEOMETRY) → NUMBER |
ST_PERIMETER | scalar | ✅ supported | (ANY) → FLOAT(GEOGRAPHY) → FLOAT(GEOMETRY) → FLOAT |
ST_POINT | scalar | ✅ supported | (ANY, ANY) → GEOGRAPHY(FLOAT, FLOAT) → GEOGRAPHY |
ST_POINTN | scalar | ✅ supported | (ANY, ANY) → GEOGRAPHY(GEOGRAPHY, NUMBER) → GEOGRAPHY(GEOMETRY, NUMBER) → GEOMETRY |
ST_POLYGON | scalar | ✅ supported | (ANY) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY(GEOMETRY) → GEOMETRY |
ST_SETSRID | scalar | ✅ supported | (ANY, ANY) → GEOMETRY(GEOMETRY, NUMBER) → GEOMETRY |
ST_SIMPLIFY | scalar | ✅ supported | (ANY, ANY) → GEOGRAPHY(GEOGRAPHY, FLOAT) → GEOGRAPHY(GEOMETRY, FLOAT) → GEOMETRY(ANY, ANY, ANY) → GEOGRAPHY(GEOGRAPHY, FLOAT, BOOLEAN) → GEOGRAPHY |
ST_SRID | scalar | ✅ supported | (ANY) → NUMBER(GEOGRAPHY) → NUMBER(GEOMETRY) → NUMBER |
ST_STARTPOINT | scalar | ✅ supported | (ANY) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY(GEOMETRY) → GEOMETRY |
ST_SYMDIFFERENCE | scalar | ✅ supported | (ANY, ANY) → GEOGRAPHY(GEOGRAPHY, GEOGRAPHY) → GEOGRAPHY |
ST_TRANSFORM | scalar | ✅ supported | (ANY, ANY) → GEOMETRY(GEOMETRY, NUMBER) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(GEOMETRY, NUMBER, NUMBER) → GEOMETRY |
ST_UNION | scalar | ✅ supported | (ANY, ANY) → GEOGRAPHY(GEOGRAPHY, GEOGRAPHY) → GEOGRAPHY |
ST_UNION_AGG | aggregate | ✅ supported | (ANY)(GEOGRAPHY) |
ST_WITHIN | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(GEOGRAPHY, GEOGRAPHY) → BOOLEAN(GEOMETRY, GEOMETRY) → BOOLEAN |
ST_X | scalar | ✅ supported | (ANY) → FLOAT(GEOGRAPHY) → FLOAT(GEOMETRY) → FLOAT |
ST_XMAX | scalar | ✅ supported | (ANY) → FLOAT(GEOGRAPHY) → FLOAT(GEOMETRY) → FLOAT |
ST_XMIN | scalar | ✅ supported | (ANY) → FLOAT(GEOGRAPHY) → FLOAT(GEOMETRY) → FLOAT |
ST_Y | scalar | ✅ supported | (ANY) → FLOAT(GEOGRAPHY) → FLOAT(GEOMETRY) → FLOAT |
ST_YMAX | scalar | ✅ supported | (ANY) → FLOAT(GEOGRAPHY) → FLOAT(GEOMETRY) → FLOAT |
ST_YMIN | scalar | ✅ supported | (ANY) → FLOAT(GEOGRAPHY) → FLOAT(GEOMETRY) → FLOAT |
TO_GEOGRAPHY | scalar | ✅ supported | (ANY) → GEOGRAPHY(BOOLEAN) → GEOGRAPHY(FLOAT) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY(GEOMETRY) → GEOGRAPHY(NUMBER) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(VARIANT) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
TO_GEOMETRY | scalar | 🟡 partial | (ANY) → GEOMETRY(BOOLEAN) → GEOMETRY(FLOAT) → GEOMETRY(GEOGRAPHY) → GEOMETRY(NUMBER) → GEOMETRY(VARCHAR) → GEOMETRY(VARIANT) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY |
TRY_TO_GEOGRAPHY | scalar | 🟡 partial | (ANY) → GEOGRAPHY(BOOLEAN) → GEOGRAPHY(FLOAT) → GEOGRAPHY(GEOGRAPHY) → GEOGRAPHY(GEOMETRY) → GEOGRAPHY(NUMBER) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(VARIANT) → GEOGRAPHY |
TRY_TO_GEOMETRY | scalar | 🟡 partial | (ANY) → GEOMETRY(BOOLEAN) → GEOMETRY(FLOAT) → GEOMETRY(GEOGRAPHY) → GEOMETRY(NUMBER) → GEOMETRY(VARCHAR) → GEOMETRY(VARIANT) → GEOMETRY |
Hash functions (1)
| Function | Kind | Status | Signatures |
|---|---|---|---|
HASH | scalar | ✅ supported | (ANY) → NUMBER |
Information Schema (61)
LOCAL schema (2)
| Function | Kind | Status | Signatures |
|---|---|---|---|
DATA_QUALITY_MONITORING_EXPECTATION_STATUS | unknown | ✅ supported | — |
DATA_QUALITY_MONITORING_RESULTS | unknown | ✅ supported | — |
Metadata functions (2)
| Function | Kind | Status | Signatures |
|---|---|---|---|
GENERATE_COLUMN_DESCRIPTION | scalar | ✅ supported | (ARRAY, VARCHAR) → VARCHAR |
GET_DDL | scalar | ✅ supported | (VARCHAR, VARCHAR, BOOLEAN) → VARCHAR |
Model monitor functions (3)
| Function | Kind | Status | Signatures |
|---|---|---|---|
MODEL_MONITOR_DRIFT_METRIC | unknown | ❌ not supported | — |
MODEL_MONITOR_PERFORMANCE_METRIC | unknown | ❌ not supported | — |
MODEL_MONITOR_STAT_METRIC | unknown | ❌ not supported | — |
Notification functions (6)
| Function | Kind | Status | Signatures |
|---|---|---|---|
APPLICATION_JSON | unknown | ✅ supported | — |
EMAIL_INTEGRATION_CONFIG | unknown | ✅ supported | — |
INTEGRATION | unknown | ✅ supported | — |
SANITIZE_WEBHOOK_CONTENT | unknown | ✅ supported | — |
TEXT_HTML | unknown | ✅ supported | — |
TEXT_PLAIN | unknown | ✅ supported | — |
Numeric functions (37)
| Function | Kind | Status | Signatures |
|---|---|---|---|
ABS | scalar | ✅ supported | (ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER |
ACOS | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
ACOSH | scalar | ✅ supported | (FLOAT) → FLOAT |
ASIN | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
ASINH | scalar | ✅ supported | (FLOAT) → FLOAT |
ATAN | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
ATAN2 | scalar | ✅ supported | (FLOAT, FLOAT) → FLOAT |
ATANH | scalar | ✅ supported | (FLOAT) → FLOAT |
CBRT | scalar | ✅ supported | (FLOAT) → FLOAT |
CEIL | scalar | ✅ supported | (ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(BOOLEAN, NUMBER) → NUMBER(DECFLOAT, NUMBER) → DECFLOAT(FLOAT, NUMBER) → FLOAT(NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER) → NUMBER |
COS | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
COSH | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
COT | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
DEGREES | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
DIV0 | scalar | ✅ supported | (ANY, ANY) → NUMBER(FLOAT, FLOAT) → FLOAT(NUMBER, NUMBER) → NUMBER |
DIV0NULL | scalar | ✅ supported | (ANY, ANY) → NUMBER(FLOAT, FLOAT) → FLOAT(NUMBER, NUMBER) → NUMBER |
EXP | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT |
FACTORIAL | scalar | ✅ supported | (ANY) → NUMBER(FLOAT) → NUMBER(NUMBER) → NUMBER |
FLOOR | scalar | ✅ supported | (ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(BOOLEAN, NUMBER) → NUMBER(DECFLOAT, NUMBER) → DECFLOAT(FLOAT, NUMBER) → FLOAT(NUMBER, NUMBER) → NUMBER(VARCHAR, NUMBER) → NUMBER |
LN | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT |
LOG | scalar | ✅ supported | (FLOAT, FLOAT) → FLOAT |
MOD | scalar | ✅ supported | (ANY, ANY) → NUMBER(DECFLOAT, DECFLOAT) → DECFLOAT(FLOAT, FLOAT) → FLOAT(NUMBER, NUMBER) → NUMBER |
PI | scalar | ✅ supported | () → FLOAT |
POW | scalar | ✅ supported | (ANY, ANY) → FLOAT(DECFLOAT, DECFLOAT) → DECFLOAT(FLOAT, FLOAT) → FLOAT |
POWER | scalar | ✅ supported | (ANY, ANY) → FLOAT(DECFLOAT, DECFLOAT) → DECFLOAT(FLOAT, FLOAT) → FLOAT |
RADIANS | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
ROUND | scalar | 🟡 partial | (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 |
SIGN | scalar | ✅ supported | (ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER |
SIN | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
SINH | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
SQRT | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT |
SQUARE | scalar | ✅ supported | (FLOAT) → FLOAT |
TAN | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
TANH | scalar | ✅ supported | (ANY) → FLOAT(DECFLOAT) → FLOAT(FLOAT) → FLOAT |
TRUNC | scalar | ✅ supported | (ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(DATE, VARCHAR) → DATE(DECFLOAT, NUMBER) → DECFLOAT(FLOAT, BOOLEAN) → FLOAT(FLOAT, DATE) → FLOAT(FLOAT, FLOAT) → FLOAT(FLOAT, NUMBER) → FLOAT(FLOAT, TIME) → FLOAT(FLOAT, TIMESTAMP_LTZ) → FLOAT(FLOAT, TIMESTAMP_NTZ) → FLOAT(FLOAT, TIMESTAMP_TZ) → FLOAT(FLOAT, VARCHAR) → FLOAT(FLOAT, VARIANT) → FLOAT(NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR) → NUMBER(NUMBER, VARIANT) → FLOAT(TIME, VARCHAR) → TIME(TIMESTAMP_LTZ, VARCHAR) → TIMESTAMP_LTZ(TIMESTAMP_NTZ, VARCHAR) → TIMESTAMP_NTZ(TIMESTAMP_TZ, VARCHAR) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → VARCHAR |
TRUNCATE | scalar | ✅ supported | (ANY) → NUMBER(DECFLOAT) → DECFLOAT(FLOAT) → FLOAT(NUMBER) → NUMBER(ANY, ANY) → NUMBER(DATE, VARCHAR) → DATE(DECFLOAT, NUMBER) → DECFLOAT(FLOAT, BOOLEAN) → FLOAT(FLOAT, DATE) → FLOAT(FLOAT, FLOAT) → FLOAT(FLOAT, NUMBER) → FLOAT(FLOAT, TIME) → FLOAT(FLOAT, TIMESTAMP_LTZ) → FLOAT(FLOAT, TIMESTAMP_NTZ) → FLOAT(FLOAT, TIMESTAMP_TZ) → FLOAT(FLOAT, VARCHAR) → FLOAT(FLOAT, VARIANT) → FLOAT(NUMBER, NUMBER) → NUMBER(NUMBER, VARCHAR) → NUMBER(NUMBER, VARIANT) → FLOAT(TIME, VARCHAR) → TIME(TIMESTAMP_LTZ, VARCHAR) → TIMESTAMP_LTZ(TIMESTAMP_NTZ, VARCHAR) → TIMESTAMP_NTZ(TIMESTAMP_TZ, VARCHAR) → TIMESTAMP_TZ(VARCHAR, VARCHAR) → VARCHAR |
WIDTH_BUCKET | scalar | ✅ supported | (ANY, ANY, ANY, ANY) → NUMBER(FLOAT, FLOAT, FLOAT, NUMBER) → NUMBER(NUMBER, NUMBER, NUMBER, NUMBER) → NUMBER |
Organization user and organization user group functions (2)
| Function | Kind | Status | Signatures |
|---|---|---|---|
IS_ORGANIZATION_USER | scalar | ✅ supported | (VARCHAR) → BOOLEAN |
IS_ORGANIZATION_USER_GROUP | scalar | ✅ supported | (VARCHAR) → BOOLEAN |
Other functions (1)
| Function | Kind | Status | Signatures |
|---|---|---|---|
WEBHOOK_INTEGRATION_CONFIG | unknown | ✅ supported | — |
Period functions (14)
| Function | Kind | Status | Signatures |
|---|---|---|---|
PERIOD_BEGIN | scalar | ✅ supported | (ANY) → DATE(SNOWFLAKE_PERIOD_DATE) → DATE(SNOWFLAKE_PERIOD_TIME) → TIME(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → TIMESTAMP_LTZ(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → TIMESTAMP_NTZ(SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → TIMESTAMP_TZ |
PERIOD_CONSTRUCT | scalar | ✅ supported | (ANY, ANY) → SNOWFLAKE_PERIOD_DATE(DATE, DATE) → SNOWFLAKE_PERIOD_DATE(DATE, TIMESTAMP_LTZ) → SNOWFLAKE_PERIOD_DATE(DATE, TIMESTAMP_NTZ) → SNOWFLAKE_PERIOD_DATE(DATE, TIMESTAMP_TZ) → SNOWFLAKE_PERIOD_DATE(TIME, TIME) → SNOWFLAKE_PERIOD_TIME(TIMESTAMP_LTZ, DATE) → SNOWFLAKE_PERIOD_TIMESTAMP_LTZ(TIMESTAMP_LTZ, TIMESTAMP_LTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_LTZ(TIMESTAMP_LTZ, TIMESTAMP_NTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_LTZ(TIMESTAMP_LTZ, TIMESTAMP_TZ) → SNOWFLAKE_PERIOD_TIMESTAMP_LTZ(TIMESTAMP_NTZ, DATE) → SNOWFLAKE_PERIOD_TIMESTAMP_NTZ(TIMESTAMP_NTZ, TIMESTAMP_LTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_NTZ(TIMESTAMP_NTZ, TIMESTAMP_NTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_NTZ(TIMESTAMP_NTZ, TIMESTAMP_TZ) → SNOWFLAKE_PERIOD_TIMESTAMP_NTZ(TIMESTAMP_TZ, DATE) → SNOWFLAKE_PERIOD_TIMESTAMP_TZ(TIMESTAMP_TZ, TIMESTAMP_LTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_TZ(TIMESTAMP_TZ, TIMESTAMP_NTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_TZ(TIMESTAMP_TZ, TIMESTAMP_TZ) → SNOWFLAKE_PERIOD_TIMESTAMP_TZ |
PERIOD_CONTAINS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(SNOWFLAKE_PERIOD_DATE, DATE) → BOOLEAN(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → BOOLEAN(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → BOOLEAN(SNOWFLAKE_PERIOD_TIME, TIME) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, TIMESTAMP_LTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, TIMESTAMP_NTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, TIMESTAMP_TZ) → BOOLEAN |
PERIOD_END | scalar | ✅ supported | (ANY) → DATE(SNOWFLAKE_PERIOD_DATE) → DATE(SNOWFLAKE_PERIOD_TIME) → TIME(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → TIMESTAMP_LTZ(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → TIMESTAMP_NTZ(SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → TIMESTAMP_TZ |
PERIOD_EQUALS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → BOOLEAN(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → BOOLEAN |
PERIOD_IMMEDIATELY_PRECEDES | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → BOOLEAN(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → BOOLEAN |
PERIOD_IMMEDIATELY_SUCCEEDS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → BOOLEAN(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → BOOLEAN |
PERIOD_INTERSECT | scalar | ✅ supported | (ANY, ANY) → SNOWFLAKE_PERIOD_DATE(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → SNOWFLAKE_PERIOD_DATE(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → SNOWFLAKE_PERIOD_TIME(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_LTZ(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_NTZ(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → SNOWFLAKE_PERIOD_TIMESTAMP_TZ |
PERIOD_LDIFF | scalar | ✅ supported | (ANY, ANY) → SNOWFLAKE_PERIOD_DATE(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → SNOWFLAKE_PERIOD_DATE(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → SNOWFLAKE_PERIOD_TIME(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_LTZ(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_NTZ(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → SNOWFLAKE_PERIOD_TIMESTAMP_TZ |
PERIOD_MEETS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → BOOLEAN(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → BOOLEAN |
PERIOD_OVERLAPS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → BOOLEAN(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → BOOLEAN |
PERIOD_PRECEDES | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → BOOLEAN(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → BOOLEAN |
PERIOD_RDIFF | scalar | ✅ supported | (ANY, ANY) → SNOWFLAKE_PERIOD_DATE(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → SNOWFLAKE_PERIOD_DATE(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → SNOWFLAKE_PERIOD_TIME(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_LTZ(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → SNOWFLAKE_PERIOD_TIMESTAMP_NTZ(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → SNOWFLAKE_PERIOD_TIMESTAMP_TZ |
PERIOD_SUCCEEDS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(SNOWFLAKE_PERIOD_DATE, SNOWFLAKE_PERIOD_DATE) → BOOLEAN(SNOWFLAKE_PERIOD_TIME, SNOWFLAKE_PERIOD_TIME) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ, SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ, SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → BOOLEAN(SNOWFLAKE_PERIOD_TIMESTAMP_TZ, SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → BOOLEAN |
Semi-structured and structured data functions (93)
| Function | Kind | Status | Signatures |
|---|---|---|---|
ARRAYS_OVERLAP | scalar | ✅ supported | (ARRAY, ARRAY) → BOOLEAN |
ARRAYS_TO_OBJECT | scalar | ✅ supported | (ARRAY, ARRAY) → OBJECT |
ARRAYS_ZIP | scalar | ✅ supported | (ANY) → ARRAY |
ARRAY_APPEND | scalar | ✅ supported | (ARRAY, ANY) → ARRAY |
ARRAY_CAT | scalar | ✅ supported | (ARRAY, ARRAY) → ARRAY |
ARRAY_COMPACT | scalar | ✅ supported | (ARRAY) → ARRAY |
ARRAY_CONSTRUCT | scalar | ✅ supported | () → ARRAY(ANY) → ARRAY(SNOWFLAKE_ANY[]) → ARRAY(SNOWFLAKE_NULL[]) → ARRAY |
ARRAY_CONSTRUCT_COMPACT | scalar | ✅ supported | () → ARRAY(ANY) → ARRAY(SNOWFLAKE_ANY[]) → ARRAY(SNOWFLAKE_NULL[]) → ARRAY |
ARRAY_CONSTRUCT_STRUCTURED | scalar | ✅ supported | (ANY) → ARRAY |
ARRAY_CONTAINS | scalar | ✅ supported | (ANY, ARRAY) → BOOLEAN |
ARRAY_DISTINCT | scalar | ✅ supported | (ARRAY) → ARRAY |
ARRAY_EXCEPT | scalar | ✅ supported | (ARRAY, ARRAY) → ARRAY |
ARRAY_FLATTEN | scalar | ✅ supported | (ARRAY) → ARRAY |
ARRAY_GENERATE_RANGE | scalar | ✅ supported | (ANY, ANY) → ARRAY(NUMBER, NUMBER) → ARRAY(NUMBER, NUMBER, NUMBER) → ARRAY |
ARRAY_INSERT | scalar | ✅ supported | (ARRAY, NUMBER, ANY) → ARRAY |
ARRAY_INTERSECTION | scalar | ✅ supported | (ARRAY, ARRAY) → ARRAY |
ARRAY_MAX | scalar | ✅ supported | (ARRAY) → VARIANT |
ARRAY_MIN | scalar | ✅ supported | (ARRAY) → VARIANT |
ARRAY_POSITION | scalar | ✅ supported | (ANY, ARRAY) → NUMBER |
ARRAY_PREPEND | scalar | ✅ supported | (ARRAY, ANY) → ARRAY |
ARRAY_REMOVE | scalar | ✅ supported | (ARRAY, ANY) → ARRAY |
ARRAY_REMOVE_AT | scalar | ✅ supported | (ARRAY, NUMBER) → ARRAY |
ARRAY_REPEAT | scalar | ✅ supported | (ANY, ANY) → ARRAY(ANY, DECFLOAT) → ARRAY(ANY, FLOAT) → ARRAY(ANY, NUMBER) → ARRAY(ANY, VARCHAR) → ARRAY(ANY, VARIANT) → ARRAY |
ARRAY_REVERSE | scalar | ✅ supported | (ARRAY) → ARRAY |
ARRAY_SIZE | scalar | ✅ supported | (ANY) → NUMBER(ARRAY) → NUMBER(SNOWFLAKE_STRUCT_ARRAY) → NUMBER(VARIANT) → NUMBER |
ARRAY_SLICE | scalar | ✅ supported | (ANY, ANY, ANY) → ARRAY(ARRAY, FLOAT, FLOAT) → ARRAY(ARRAY, FLOAT, NUMBER) → ARRAY(ARRAY, NUMBER, FLOAT) → ARRAY(ARRAY, NUMBER, NUMBER) → ARRAY(ARRAY, NUMBER, VARCHAR) → ARRAY(ARRAY, NUMBER, VARIANT) → ARRAY(ARRAY, VARCHAR, NUMBER) → ARRAY(ARRAY, VARCHAR, VARCHAR) → ARRAY(ARRAY, VARIANT, NUMBER) → ARRAY(ARRAY, VARIANT, VARIANT) → ARRAY |
ARRAY_SORT | scalar | ✅ supported | (ANY) → ARRAY(ARRAY) → ARRAY(ARRAY, BOOLEAN) → ARRAY(ARRAY, BOOLEAN, BOOLEAN) → ARRAY |
ARRAY_TO_STRING | scalar | ✅ supported | (ARRAY, VARCHAR) → VARCHAR |
AS_ARRAY | scalar | ✅ supported | (VARIANT) → ARRAY |
AS_BINARY | scalar | ✅ supported | (VARIANT) → BINARY |
AS_BOOLEAN | scalar | ✅ supported | (VARIANT) → BOOLEAN |
AS_CHAR | scalar | ✅ supported | (VARIANT) → VARCHAR |
AS_DATE | scalar | ✅ supported | (VARIANT) → DATE |
AS_DECIMAL | scalar | ✅ supported | (ANY) → NUMBER(VARIANT) → NUMBER(VARIANT, NUMBER, NUMBER) → NUMBER |
AS_DOUBLE | scalar | ✅ supported | (VARIANT) → FLOAT |
AS_INTEGER | scalar | ✅ supported | (VARIANT) → NUMBER |
AS_NUMBER | scalar | ✅ supported | (ANY) → NUMBER(VARIANT) → NUMBER(VARIANT, NUMBER, NUMBER) → NUMBER |
AS_OBJECT | scalar | ✅ supported | (VARIANT) → OBJECT |
AS_REAL | scalar | ✅ supported | (VARIANT) → FLOAT |
AS_TIME | scalar | ✅ supported | (VARIANT) → TIME |
AS_TIMESTAMP_LTZ | scalar | ✅ supported | (VARIANT) → TIMESTAMP_LTZ |
AS_TIMESTAMP_NTZ | scalar | ✅ supported | (VARIANT) → TIMESTAMP_NTZ |
AS_TIMESTAMP_TZ | scalar | ✅ supported | (VARIANT) → TIMESTAMP_TZ |
AS_VARCHAR | scalar | ✅ supported | (VARIANT) → VARCHAR |
CHECK_JSON | scalar | ✅ supported | (VARCHAR) → VARCHAR |
CHECK_XML | scalar | 🟡 partial | (VARCHAR) → VARCHAR |
FILTER | unknown | ✅ supported | — |
GET | scalar | ✅ supported | (ANY, ANY) → VARIANT(ARRAY, FLOAT) → VARIANT(ARRAY, NUMBER) → VARIANT(ARRAY, VARCHAR) → VARIANT(ARRAY, VARIANT) → VARIANT(OBJECT, NUMBER) → VARIANT(OBJECT, VARCHAR) → VARIANT(OBJECT, VARIANT) → VARIANT(VARIANT, FLOAT) → VARIANT(VARIANT, NUMBER) → VARIANT(VARIANT, VARCHAR) → VARIANT |
GET_IGNORE_CASE | scalar | ✅ supported | (ANY, ANY) → VARIANT(OBJECT, VARCHAR) → VARIANT(VARIANT, VARCHAR) → VARIANT |
GET_PATH | scalar | ✅ supported | (VARIANT, VARCHAR) → VARIANT |
IS_ARRAY | scalar | ✅ supported | (ANY) → BOOLEAN(ARRAY) → BOOLEAN(OBJECT) → BOOLEAN(VARIANT) → BOOLEAN |
IS_BINARY | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_BOOLEAN | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_CHAR | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_DATE | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_DATE_VALUE | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_DECIMAL | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_DOUBLE | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_INTEGER | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_NULL_VALUE | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_OBJECT | scalar | ✅ supported | (ANY) → BOOLEAN(ARRAY) → BOOLEAN(OBJECT) → BOOLEAN(VARIANT) → BOOLEAN |
IS_REAL | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_TIME | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_TIMESTAMP_LTZ | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_TIMESTAMP_NTZ | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_TIMESTAMP_TZ | scalar | ✅ supported | (VARIANT) → BOOLEAN |
IS_VARCHAR | scalar | ✅ supported | (VARIANT) → BOOLEAN |
JSON_EXTRACT_PATH_TEXT | scalar | ✅ supported | (ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
MAP_CAT | scalar | ✅ supported | (OBJECT, OBJECT) → OBJECT |
MAP_CONSTRUCT | scalar | ✅ supported | (ANY) → MAP |
MAP_CONTAINS_KEY | scalar | ✅ supported | (VARCHAR, OBJECT) → BOOLEAN |
MAP_DELETE | scalar | ✅ supported | (OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT |
MAP_ENTRIES | scalar | ✅ supported | (ANY) → ARRAY(MAP) → ARRAY(OBJECT) → ARRAY |
MAP_INSERT | scalar | ✅ supported | (ANY, ANY, ANY) → OBJECT(OBJECT, VARCHAR, ANY) → OBJECT(ANY, ANY, ANY, ANY) → OBJECT(OBJECT, VARCHAR, ANY, BOOLEAN) → OBJECT |
MAP_KEYS | scalar | ✅ supported | (OBJECT) → ARRAY |
MAP_PICK | scalar | ✅ supported | (ANY, ANY) → OBJECT(OBJECT, ARRAY) → OBJECT(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT(OBJECT, VARIANT) → OBJECT |
MAP_SIZE | scalar | ✅ supported | (OBJECT) → NUMBER |
OBJECT_CONSTRUCT | scalar | ✅ supported | () → OBJECT(ANY) → OBJECT(SNOWFLAKE_ANY[]) → OBJECT(SNOWFLAKE_NULL[]) → OBJECT |
OBJECT_CONSTRUCT_KEEP_NULL | scalar | ✅ supported | () → OBJECT(ANY) → OBJECT(SNOWFLAKE_ANY[]) → OBJECT(SNOWFLAKE_NULL[]) → OBJECT |
OBJECT_CONSTRUCT_KEEP_NULL_STRUCTURED | scalar | ✅ supported | (ANY) → OBJECT |
OBJECT_DELETE | scalar | ✅ supported | (OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT |
OBJECT_INSERT | scalar | ✅ supported | (ANY, ANY, ANY) → OBJECT(OBJECT, VARCHAR, ANY) → OBJECT(ANY, ANY, ANY, ANY) → OBJECT(OBJECT, VARCHAR, ANY, BOOLEAN) → OBJECT |
OBJECT_KEYS | scalar | ✅ supported | (ANY) → ARRAY(OBJECT) → ARRAY(VARIANT) → ARRAY |
OBJECT_PICK | scalar | 🟡 partial | (ANY, ANY) → OBJECT(OBJECT, ARRAY) → OBJECT(OBJECT, SNOWFLAKE_VARCHAR[]) → OBJECT(OBJECT, VARIANT) → OBJECT |
PARSE_JSON | scalar | ✅ supported | (ANY) → VARIANT(VARCHAR) → VARIANT(VARCHAR, VARCHAR) → VARIANT |
PARSE_XML | scalar | 🟡 partial | (VARCHAR) → VARIANT |
PROMPT | unknown | ❌ not supported | — |
REDUCE | unknown | ✅ supported | — |
STRIP_NULL_VALUE | scalar | ✅ supported | (VARIANT) → VARIANT |
TRANSFORM | unknown | ✅ supported | — |
TRY_PARSE_JSON | scalar | ✅ supported | (ANY) → VARIANT(VARCHAR) → VARIANT(VARCHAR, VARCHAR) → VARIANT |
TYPEOF | scalar | ✅ supported | (VARIANT) → VARCHAR |
XMLGET | scalar | ✅ supported | (ANY, ANY) → VARIANT(VARIANT, VARCHAR) → VARIANT(ANY, ANY, ANY) → VARIANT(VARIANT, VARCHAR, NUMBER) → VARIANT |
String & binary functions (107)
| Function | Kind | Status | Signatures |
|---|---|---|---|
AGENT_RUN | unknown | ❌ not supported | — |
AI_CLASSIFY | unknown | ❌ not supported | — |
AI_COMPLETE | unknown | ❌ not supported | — |
AI_COUNT_TOKENS | unknown | ❌ not supported | — |
AI_EMBED | unknown | ❌ not supported | — |
AI_EXTRACT | unknown | ❌ not supported | — |
AI_FILTER | unknown | ❌ not supported | — |
AI_FUNCTION_EVALUATION | unknown | ❌ not supported | — |
AI_FUNCTION_OPTIMIZATION | unknown | ❌ not supported | — |
AI_MULTI_EMBED | unknown | ❌ not supported | — |
AI_PARSE_DOCUMENT | unknown | ❌ not supported | — |
AI_REDACT | unknown | ❌ not supported | — |
AI_SENTIMENT | unknown | ❌ not supported | — |
AI_SIMILARITY | unknown | ❌ not supported | — |
AI_SUMMARIZE | unknown | ❌ not supported | — |
AI_TRANSLATE | unknown | ❌ not supported | — |
ASCII | scalar | ✅ supported | (VARCHAR) → NUMBER |
BASE64_DECODE_BINARY | scalar | ✅ supported | (ANY) → BINARY(VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY |
BASE64_DECODE_STRING | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
BASE64_ENCODE | scalar | ✅ 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_LENGTH | scalar | ✅ supported | (ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER |
CHAR | scalar | ✅ supported | (NUMBER) → VARCHAR |
CHARINDEX | scalar | 🟡 partial | (ANY, ANY) → NUMBER(BINARY, BINARY) → NUMBER(VARCHAR, VARCHAR) → NUMBER(ANY, ANY, NUMBER) → NUMBER(BINARY, BINARY, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER |
CHR | scalar | ✅ supported | (NUMBER) → VARCHAR |
CLASSIFY_TEXT | unknown | ❌ not supported | — |
COLLATE | syntax | ✅ supported | — |
COLLATION | scalar | ✅ supported | (VARCHAR) → VARCHAR |
COMPLETE | unknown | ❌ not supported | — |
COMPRESS | scalar | ✅ supported | (ANY, VARCHAR) → BINARY(BINARY, VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY |
CONCAT | scalar | ✅ supported | (SNOWFLAKE_ANY[]) → VARCHAR(SNOWFLAKE_BINARY[]) → BINARY(SNOWFLAKE_NULL[]) → VARCHAR(SNOWFLAKE_VARCHAR[]) → VARCHAR |
CONCAT_WS | scalar | ✅ supported | (BINARY) → BINARY(VARCHAR) → VARCHAR(ANY, SNOWFLAKE_ANY[]) → VARCHAR(BINARY, SNOWFLAKE_BINARY[]) → BINARY(VARCHAR, SNOWFLAKE_VARCHAR[]) → VARCHAR |
CONTAINS | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(BINARY, BINARY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN |
COUNT_TOKENS | unknown | ❌ not supported | — |
DATA_AGENT_RUN | unknown | ❌ not supported | — |
DECOMPRESS_BINARY | scalar | ✅ supported | (BINARY, VARCHAR) → BINARY |
DECOMPRESS_STRING | scalar | ✅ supported | (BINARY, VARCHAR) → VARCHAR |
EDITDISTANCE | scalar | ✅ supported | (ANY, ANY) → NUMBER(VARCHAR, VARCHAR) → NUMBER(ANY, ANY, ANY) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER |
EMBED_TEXT_1024 | unknown | ❌ not supported | — |
EMBED_TEXT_768 | unknown | ❌ not supported | — |
ENDSWITH | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(BINARY, BINARY) → BOOLEAN(BINARY, VARCHAR) → BOOLEAN(VARCHAR, BINARY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN |
ENTITY_SENTIMENT | unknown | ❌ not supported | — |
EXTRACT_ANSWER | unknown | ❌ not supported | — |
FINETUNE | unknown | ❌ not supported | — |
FORMAT_STRING_TEMPLATE | scalar | ✅ supported | (ANY) → VARCHAR |
HEX_DECODE_BINARY | scalar | ✅ supported | (VARCHAR) → BINARY |
HEX_DECODE_STRING | scalar | ✅ supported | (VARCHAR) → VARCHAR |
HEX_ENCODE | scalar | ✅ supported | (ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → VARCHAR(VARCHAR, NUMBER) → VARCHAR |
INITCAP | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
INSERT | scalar | ✅ supported | (VARCHAR, NUMBER, NUMBER, VARCHAR) → VARCHAR |
JAROWINKLER_SIMILARITY | scalar | ✅ supported | (VARCHAR, VARCHAR) → NUMBER |
LEFT | scalar | ✅ supported | (ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR |
LEN | scalar | ✅ supported | (ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER |
LENGTH | scalar | ✅ supported | (ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER |
LOWER | scalar | ✅ supported | (VARCHAR) → VARCHAR |
LPAD | scalar | ✅ supported | (ANY, ANY) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR(ANY, ANY, ANY) → VARCHAR(BINARY, NUMBER, BINARY) → BINARY(VARCHAR, NUMBER, VARCHAR) → VARCHAR |
LTRIM | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
MD5 | scalar | ✅ supported | (ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR |
MD5_BINARY | scalar | ✅ supported | (ANY) → BINARY(BINARY) → BINARY(VARCHAR) → BINARY |
MD5_HEX | scalar | ✅ supported | (ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR |
MD5_NUMBER_LOWER64 | scalar | ✅ supported | (ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER |
MD5_NUMBER_UPPER64 | scalar | ✅ supported | (ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER |
OCTET_LENGTH | scalar | ✅ supported | (ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER |
PARSE_IP | scalar | 🟡 partial | (VARCHAR, VARCHAR) → OBJECT |
PARSE_URL | scalar | 🟡 partial | (ANY) → OBJECT(BINARY) → OBJECT(VARCHAR) → OBJECT(ANY, ANY) → OBJECT(VARCHAR, BOOLEAN) → OBJECT(VARCHAR, FLOAT) → OBJECT(VARCHAR, NUMBER) → OBJECT(VARCHAR, VARCHAR) → OBJECT(VARCHAR, VARIANT) → OBJECT |
POSITION | scalar | ✅ supported | (ANY, ANY) → NUMBER(BINARY, BINARY) → NUMBER(VARCHAR, VARCHAR) → NUMBER(ANY, ANY, NUMBER) → NUMBER(BINARY, BINARY, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER |
REPEAT | scalar | ✅ supported | (ANY, ANY) → VARCHAR(VARCHAR, ANY) → VARCHAR(VARCHAR, FLOAT) → VARCHAR(VARCHAR, NUMBER) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(VARCHAR, VARIANT) → VARCHAR |
REPLACE | scalar | ✅ supported | (ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(ANY, ANY, ANY) → VARCHAR(VARCHAR, VARCHAR, VARCHAR) → VARCHAR |
REVERSE | scalar | ✅ supported | (ANY) → VARCHAR(BINARY) → BINARY(VARCHAR) → VARCHAR |
RIGHT | scalar | ✅ supported | (ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR |
RPAD | scalar | ✅ supported | (ANY, ANY) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR(ANY, ANY, ANY) → VARCHAR(BINARY, NUMBER, BINARY) → BINARY(VARCHAR, NUMBER, VARCHAR) → VARCHAR |
RTRIM | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
RTRIMMED_LENGTH | scalar | ✅ supported | (ANY) → NUMBER(BINARY) → NUMBER(VARCHAR) → NUMBER(VARCHAR, VARCHAR) → NUMBER |
SEARCH | scalar | ✅ supported | (ANY, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(ARRAY, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(BOOLEAN, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(FLOAT, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(MAP, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(NUMBER, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(OBJECT, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(VARIANT, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN |
SEARCH_IP | scalar | ✅ supported | (ANY, VARCHAR) → BOOLEAN(ARRAY, VARCHAR) → BOOLEAN(BOOLEAN, VARCHAR) → BOOLEAN(FLOAT, VARCHAR) → BOOLEAN(MAP, VARCHAR) → BOOLEAN(NUMBER, VARCHAR) → BOOLEAN(OBJECT, VARCHAR) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN(VARIANT, VARCHAR) → BOOLEAN |
SEARCH_PREVIEW | unknown | ❌ not supported | — |
SENTIMENT | unknown | ❌ not supported | — |
SHA1 | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SHA1_BINARY | scalar | ✅ supported | (VARCHAR) → BINARY |
SHA1_HEX | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SHA2 | scalar | ✅ supported | (ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → VARCHAR(VARCHAR, NUMBER) → VARCHAR |
SHA2_BINARY | scalar | ✅ supported | (ANY) → BINARY(BINARY) → BINARY(VARCHAR) → BINARY(ANY, NUMBER) → BINARY(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → BINARY |
SHA2_HEX | scalar | ✅ supported | (ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR(ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → VARCHAR(VARCHAR, NUMBER) → VARCHAR |
SOUNDEX | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SOUNDEX_P123 | scalar | ✅ supported | (ANY) → VARCHAR(BINARY) → VARCHAR(VARCHAR) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
SPACE | scalar | ✅ supported | (NUMBER) → VARCHAR |
SPLIT | scalar | ✅ supported | (VARCHAR, VARCHAR) → ARRAY |
SPLIT_PART | scalar | ✅ supported | (ANY, ANY, ANY) → VARCHAR(VARCHAR, VARCHAR, FLOAT) → VARCHAR(VARCHAR, VARCHAR, NUMBER) → VARCHAR |
SPLIT_TEXT_MARKDOWN_HEADER | unknown | ❌ not supported | — |
SPLIT_TEXT_RECURSIVE_CHARACTER | unknown | ❌ not supported | — |
SPLIT_TO_TABLE | table | ✅ supported | (VARCHAR, VARCHAR) → TABLE |
STARTSWITH | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(BINARY, BINARY) → BOOLEAN(BINARY, VARCHAR) → BOOLEAN(VARCHAR, BINARY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN |
STRTOK | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(ANY, ANY, ANY) → VARCHAR(VARCHAR, VARCHAR, NUMBER) → VARCHAR |
STRTOK_SPLIT_TO_TABLE | table | ✅ supported | (VARCHAR, VARCHAR) → TABLE |
STRTOK_TO_ARRAY | scalar | ✅ supported | (ANY) → ARRAY(VARCHAR) → ARRAY(ANY, ANY) → ARRAY(VARCHAR, VARCHAR) → ARRAY |
SUBSTR | scalar | ✅ supported | (ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR(ANY, NUMBER, NUMBER) → VARCHAR(BINARY, NUMBER, NUMBER) → BINARY(VARCHAR, NUMBER, NUMBER) → VARCHAR |
SUBSTRING | scalar | ✅ supported | (ANY, NUMBER) → VARCHAR(BINARY, NUMBER) → BINARY(VARCHAR, NUMBER) → VARCHAR(ANY, NUMBER, NUMBER) → VARCHAR(BINARY, NUMBER, NUMBER) → BINARY(VARCHAR, NUMBER, NUMBER) → VARCHAR |
THREAD_MESSAGES | unknown | ❌ not supported | — |
TRANSLATE | scalar | ✅ supported | (VARCHAR, VARCHAR, VARCHAR) → VARCHAR |
TRIM | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
TRY_BASE64_DECODE_BINARY | scalar | ✅ supported | (ANY) → BINARY(VARCHAR) → BINARY(VARCHAR, VARCHAR) → BINARY |
TRY_BASE64_DECODE_STRING | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
TRY_COMPLETE | unknown | ❌ not supported | — |
TRY_HEX_DECODE_BINARY | scalar | ✅ supported | (VARCHAR) → BINARY |
TRY_HEX_DECODE_STRING | scalar | ✅ supported | (VARCHAR) → VARCHAR |
UNICODE | scalar | ✅ supported | (VARCHAR) → NUMBER |
UPPER | scalar | ✅ supported | (VARCHAR) → VARCHAR |
UUID_STRING | scalar | ✅ supported | () → VARCHAR(ANY, ANY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
String functions (regular expressions) (8)
| Function | Kind | Status | Signatures |
|---|---|---|---|
REGEXP | syntax | ✅ supported | — |
REGEXP_COUNT | scalar | ✅ supported | (ANY, ANY) → NUMBER(VARCHAR, VARCHAR) → NUMBER(VARCHAR, VARCHAR, NUMBER) → NUMBER(VARCHAR, VARCHAR, NUMBER, VARCHAR) → NUMBER |
REGEXP_INSTR | scalar | ✅ 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_LIKE | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARCHAR, VARCHAR) → BOOLEAN |
REGEXP_REPLACE | scalar | ✅ 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_SUBSTR | scalar | ✅ 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_ALL | scalar | ✅ 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 |
RLIKE | scalar | ✅ supported | (ANY, ANY) → BOOLEAN(VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARCHAR, VARCHAR) → BOOLEAN |
System functions (262)
| Function | Kind | Status | Signatures |
|---|---|---|---|
EXECUTE_AI_EVALUATION | unknown | ❌ not supported | — |
EXPLAIN_GRANTABLE_PRIVILEGES | unknown | ❌ not supported | — |
EXPLAIN_JSON | unknown | ✅ supported | — |
EXPLAIN_PRIVILEGES | unknown | ❌ not supported | — |
EXTRACT_SEMANTIC_CATEGORIES | unknown | ⏸️ deferred | — |
GET_ANACONDA_PACKAGES_REPODATA | unknown | ⏸️ deferred | — |
GET_PYTHON_PROFILER_OUTPUT | unknown | ⏸️ deferred | — |
GET_QUERY_OPERATOR_STATS | table | ✅ supported | (%I) → TABLE(ANY) → TABLE(VARCHAR) → TABLE |
SHOW_PYTHON_PACKAGES_DEPENDENCIES | unknown | ⏸️ deferred | — |
SYSTEM$ABORT_SESSION | unknown | ✅ supported | — |
SYSTEM$ABORT_TRANSACTION | unknown | ✅ supported | — |
SYSTEM$ACTIVATE_CMK_INFO | unknown | ❌ not supported | — |
SYSTEM$ACTIVATE_CMK_INFO_POSTGRES | unknown | ❌ not supported | — |
SYSTEM$ADD_EVENT | unknown | ✅ supported | — |
SYSTEM$ADD_PRIVATELINK_ENDPOINT_HOSTNAME | unknown | ❌ not supported | — |
SYSTEM$ADD_REFERENCE | unknown | ❌ not supported | — |
SYSTEM$ALLOWLIST | scalar | ✅ supported | () → VARCHAR |
SYSTEM$ALLOWLIST_PRIVATELINK | unknown | ❌ not supported | — |
SYSTEM$APPLICATION_GET_LOG_LEVEL | unknown | ❌ not supported | — |
SYSTEM$APPLICATION_GET_METRIC_LEVEL | unknown | ❌ not supported | — |
SYSTEM$APPLICATION_GET_TRACE_LEVEL | unknown | ❌ not supported | — |
SYSTEM$APP_COMPATIBILITY_CHECK | unknown | ❌ not supported | — |
SYSTEM$AUTHORIZE_PRIVATELINK | unknown | ❌ not supported | — |
SYSTEM$AUTHORIZE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS | unknown | ❌ not supported | — |
SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS | unknown | ❌ not supported | — |
SYSTEM$AUTO_REFRESH_STATUS | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$BEGIN_DEBUG_APPLICATION | unknown | ❌ not supported | — |
SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS | unknown | ❌ not supported | — |
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS | unknown | ❌ not supported | — |
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS_WITH_EXCEPTION | unknown | ❌ not supported | — |
SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS | unknown | ❌ not supported | — |
SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_WITH_EXCEPTION | unknown | ❌ not supported | — |
SYSTEM$CANCEL_ALL_QUERIES | scalar | ✅ supported | (ANY) → VARCHAR(BOOLEAN) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
SYSTEM$CANCEL_QUERY | unknown | ✅ supported | — |
SYSTEM$CAST_MULTI_PARTY_APPROVAL_VOTE | unknown | ❌ not supported | — |
SYSTEM$CATALOG_LINK_STATUS | scalar | ✅ supported | (SNOWFLAKE_VARCHAR[]) → VARCHAR |
SYSTEM$CKE_HASH_FUNCTION | unknown | ❌ not supported | — |
SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS | unknown | ❌ not supported | — |
SYSTEM$CLIENT_VERSION_INFO | scalar | ✅ supported | () → VARCHAR |
SYSTEM$CLIENT_VULNERABILITY_INFO | unknown | ❌ not supported | — |
SYSTEM$CLUSTERING_DEPTH | scalar | ✅ supported | (VARCHAR, VARCHAR, VARCHAR, VARCHAR) → FLOAT |
SYSTEM$CLUSTERING_INFORMATION | scalar | 🟡 partial | (VARCHAR, VARCHAR, VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT | unknown | ❌ not supported | — |
SYSTEM$CONVERT_PIPES_SQS_TO_SNS | unknown | ❌ not supported | — |
SYSTEM$CREATE_BILLING_EVENT | unknown | ❌ not supported | — |
SYSTEM$CREATE_BILLING_EVENTS | unknown | ❌ not supported | — |
SYSTEM$CREATE_EVALUATION_DATASET | unknown | ❌ not supported | — |
SYSTEM$CURRENT_USER_TASK_NAME | scalar | ✅ supported | () → VARCHAR |
SYSTEM$DATA_METRIC_SCAN | unknown | 🟡 partial | — |
SYSTEM$DBT_GET_LAST_FAILED_RUN_TARGET | unknown | ❌ not supported | — |
SYSTEM$DBT_GET_LAST_RUN_TARGET | unknown | ❌ not supported | — |
SYSTEM$DBT_GET_LAST_SUCCESSFUL_RUN_TARGET | unknown | ❌ not supported | — |
SYSTEM$DEACTIVATE_CMK_INFO | unknown | ❌ not supported | — |
SYSTEM$DECODE_PAT | unknown | ⏸️ deferred | — |
SYSTEM$DEMIGRATE_DBT_PROJECT | unknown | ❌ not supported | — |
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT | unknown | ❌ not supported | — |
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT_TSS | unknown | ❌ not supported | — |
SYSTEM$DEREGISTER_CMK_INFO | unknown | ❌ not supported | — |
SYSTEM$DEREGISTER_CMK_INFO_POSTGRES | unknown | ❌ not supported | — |
SYSTEM$DESC_ICEBERG_ACCESS_IDENTITY | unknown | ❌ not supported | — |
SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE | unknown | ❌ not supported | — |
SYSTEM$DISABLE_DATABASE_REPLICATION | unknown | ❌ not supported | — |
SYSTEM$DISABLE_FEATURE_GROUPS | unknown | ❌ not supported | — |
SYSTEM$DISABLE_FEATURE_GROUPS_PREVIEW | unknown | ❌ not supported | — |
SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT | unknown | ❌ not supported | — |
SYSTEM$DISABLE_PREVIEW_ACCESS | unknown | ❌ not supported | — |
SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLY | unknown | ❌ not supported | — |
SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE | unknown | ❌ not supported | — |
SYSTEM$ENABLE_FEATURE_GROUPS | unknown | ❌ not supported | — |
SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT | unknown | ❌ not supported | — |
SYSTEM$ENABLE_PREVIEW_ACCESS | unknown | ❌ not supported | — |
SYSTEM$ENCODE_CKE_PRIMARY_KEY | unknown | ❌ not supported | — |
SYSTEM$END_DEBUG_APPLICATION | unknown | ❌ not supported | — |
SYSTEM$ENFORCE_PRIVATELINK_ACCESS_ONLY | unknown | ❌ not supported | — |
SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$ESTIMATE_QUERY_ACCELERATION | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS | unknown | 🟡 partial | — |
SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS_PERSIST_RESULT | unknown | 🟡 partial | — |
SYSTEM$EXECUTE_CATALOG_OPERATION | unknown | ❌ not supported | — |
SYSTEM$EXPLAIN_JSON_TO_TEXT | scalar | ✅ supported | (ANY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(TIME) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
SYSTEM$EXPLAIN_PLAN_JSON | unknown | ✅ supported | — |
SYSTEM$EXPORT_TDS_FROM_SEMANTIC_VIEW | unknown | ❌ not supported | — |
SYSTEM$EXTERNAL_TABLE_PIPE_STATUS | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$FETCH_EXTERNAL_SECRET_FROM_INTEGRATION | unknown | ❌ not supported | — |
SYSTEM$FINISH_OAUTH_FLOW | unknown | ❌ not supported | — |
SYSTEM$GENERATE_SAML_CSR | unknown | ❌ not supported | — |
SYSTEM$GENERATE_SCIM_ACCESS_TOKEN | unknown | ❌ not supported | — |
SYSTEM$GET_ALERT_CONFIG | scalar | ✅ supported | () → VARCHAR(ANY) → VARCHAR(VARCHAR) → VARCHAR |
SYSTEM$GET_ALERT_TEMPLATE | unknown | ❌ not supported | — |
SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDES | unknown | ❌ not supported | — |
SYSTEM$GET_ALL_REFERENCES | unknown | ❌ not supported | — |
SYSTEM$GET_APPLICATION_SERVICE_LOGS | scalar | ✅ supported | (VARCHAR, NUMBER, NUMBER) → VARCHAR |
SYSTEM$GET_AWS_SNS_IAM_POLICY | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$GET_CATALOG_LINKED_DATABASE_CONFIG | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$GET_CLASSIFICATION_RESULT | unknown | ⏸️ deferred | — |
SYSTEM$GET_CMK_AKV_CONSENT_URL | unknown | ❌ not supported | — |
SYSTEM$GET_CMK_CONFIG | unknown | ❌ not supported | — |
SYSTEM$GET_CMK_CONFIG_POSTGRES | unknown | ❌ not supported | — |
SYSTEM$GET_CMK_INFO | unknown | ❌ not supported | — |
SYSTEM$GET_CMK_INFO_POSTGRES | unknown | ❌ not supported | — |
SYSTEM$GET_CMK_KMS_KEY_POLICY | unknown | ❌ not supported | — |
SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCE | scalar | ✅ supported | () → VARCHAR |
SYSTEM$GET_DBT_LOG | unknown | ❌ not supported | — |
SYSTEM$GET_DEBUG_STATUS | unknown | ❌ not supported | — |
SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND | unknown | ❌ not supported | — |
SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT | unknown | ❌ not supported | — |
SYSTEM$GET_DIRECTORY_TABLE_STATUS | scalar | ✅ supported | () → VARCHAR(ANY) → VARCHAR(VARCHAR) → VARCHAR |
SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMD | unknown | ❌ not supported | — |
SYSTEM$GET_HASH_FOR_APPLICATION | unknown | ❌ not supported | — |
SYSTEM$GET_ICEBERG_TABLE_INFORMATION | scalar | ✅ supported | (VARCHAR, NUMBER) → VARCHAR |
SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPS | unknown | ❌ not supported | — |
SYSTEM$GET_LISTING_URL_FOR_EXTERNAL_CONSUMER | unknown | ❌ not supported | — |
SYSTEM$GET_LOGIN_FAILURE_DETAILS | unknown | ⏸️ deferred | — |
SYSTEM$GET_PREDECESSOR_RETURN_VALUE | scalar | ✅ supported | (ANY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(TIME) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
SYSTEM$GET_PREVIEW_ACCESS_STATUS | unknown | ❌ not supported | — |
SYSTEM$GET_PRIVATELINK | unknown | ❌ not supported | — |
SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS | unknown | ❌ not supported | — |
SYSTEM$GET_PRIVATELINK_CONFIG | unknown | ❌ not supported | — |
SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO | unknown | ❌ not supported | — |
SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS | unknown | ❌ not supported | — |
SYSTEM$GET_PURCHASE_ATTRIBUTES | unknown | ❌ not supported | — |
SYSTEM$GET_REFERENCED_OBJECT_ID_HASH | unknown | ❌ not supported | — |
SYSTEM$GET_RESULTSET_STATUS | unknown | ⏸️ deferred | — |
SYSTEM$GET_SECURITY_INTEGRATIONS_FOR_API_PROVIDER | unknown | ❌ not supported | — |
SYSTEM$GET_SERVICE_CALLER_TOKEN_EXPIRY | unknown | ❌ not supported | — |
SYSTEM$GET_SERVICE_DNS_DOMAIN | unknown | ❌ not supported | — |
SYSTEM$GET_SERVICE_LOGS | unknown | ❌ not supported | — |
SYSTEM$GET_SNOWFLAKE_EGRESS_IP_RANGES | unknown | ❌ not supported | — |
SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO | scalar | ✅ supported | () → VARCHAR |
SYSTEM$GET_STAGE_PRIVATELINK_AUTHORIZED_ENDPOINTS | unknown | ❌ not supported | — |
SYSTEM$GET_TABLE_ARCHIVE_METADATA | unknown | ❌ not supported | — |
SYSTEM$GET_TAG | scalar | ✅ supported | (VARCHAR, VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$GET_TAG_ALLOWED_VALUES | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$GET_TAG_ON_CURRENT_COLUMN | scalar | ✅ supported | (VARCHAR, VARCHAR, VARCHAR, VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$GET_TAG_ON_CURRENT_TABLE | scalar | ✅ supported | (VARCHAR, VARCHAR, VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$GET_TASK_GRAPH_CONFIG | scalar | ✅ supported | () → VARCHAR(ANY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(TIME) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
SYSTEM$GET_TZDB_VERSION | unknown | ❌ not supported | — |
SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER | unknown | ❌ not supported | — |
SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT | unknown | ❌ not supported | — |
SYSTEM$INGEST_REBIND_PIPE | unknown | ❌ not supported | — |
SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT | unknown | ❌ not supported | — |
SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS | unknown | ❌ not supported | — |
SYSTEM$ISSUE_PER_ACCOUNT_APP_SERVICE_CERTIFICATE | unknown | ❌ not supported | — |
SYSTEM$ISSUE_PER_ACCOUNT_CERTIFICATES | unknown | ❌ not supported | — |
SYSTEM$ISSUE_WORKLOAD_IDENTITY_FEDERATION_TOKEN | unknown | ❌ not supported | — |
SYSTEM$IS_APPLICATION_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLED | unknown | ❌ not supported | — |
SYSTEM$IS_APPLICATION_AUTHORIZED_FOR_TELEMETRY_EVENT_SHARING | unknown | ❌ not supported | — |
SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNT | unknown | ❌ not supported | — |
SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDER | unknown | ❌ not supported | — |
SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT | unknown | ❌ not supported | — |
SYSTEM$IS_LISTING_PURCHASED | unknown | ❌ not supported | — |
SYSTEM$IS_LISTING_TRIAL | unknown | ❌ not supported | — |
SYSTEM$LAST_CHANGE_COMMIT_TIME | unknown | ⏸️ deferred | — |
SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME | unknown | ❌ not supported | — |
SYSTEM$LINK_ORGANIZATION_USER | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$LINK_ORGANIZATION_USER_GROUP | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$LIST_ALERT_TEMPLATES | unknown | ❌ not supported | — |
SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES | unknown | ❌ not supported | — |
SYSTEM$LIST_EXTERNAL_SECRETS | unknown | ❌ not supported | — |
SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOG | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(VARCHAR, VARCHAR, NUMBER) → VARCHAR(VARCHAR, VARCHAR, NUMBER, VARCHAR) → VARCHAR |
SYSTEM$LIST_NAMESPACES_FROM_CATALOG | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR(VARCHAR, VARCHAR, NUMBER) → VARCHAR(VARCHAR, VARCHAR, NUMBER, VARCHAR) → VARCHAR |
SYSTEM$LOCATE_DBT_ARCHIVE | unknown | ❌ not supported | — |
SYSTEM$LOCATE_DBT_ARTIFACTS | unknown | ❌ not supported | — |
SYSTEM$LOG | unknown | ✅ supported | — |
SYSTEM$LOG_DEBUG | unknown | ✅ supported | — |
SYSTEM$LOG_ERROR | unknown | ✅ supported | — |
SYSTEM$LOG_FATAL | unknown | ✅ supported | — |
SYSTEM$LOG_INFO | unknown | ✅ supported | — |
SYSTEM$LOG_TRACE | unknown | ✅ supported | — |
SYSTEM$LOG_WARN | unknown | ✅ supported | — |
SYSTEM$MIGRATE_DBT_PROJECT | unknown | ❌ not supported | — |
SYSTEM$MIGRATE_LEGACY_EVENT_ROUTING_CONFIGURATION | unknown | ❌ not supported | — |
SYSTEM$MIGRATE_SAML_IDP_REGISTRATION | unknown | ❌ not supported | — |
SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGS | unknown | ❌ not supported | — |
SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGS | unknown | ❌ not supported | — |
SYSTEM$OPT_OUT_MALICIOUS_IP_PROTECTION_BY_CATEGORY | unknown | ❌ not supported | — |
SYSTEM$PARQUET_DIRECT_AUTO_REFRESH_STATUS | unknown | ❌ not supported | — |
SYSTEM$PIPE_FORCE_RESUME | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNEL | unknown | ❌ not supported | — |
SYSTEM$PIPE_STATUS | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT | unknown | ❌ not supported | — |
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT_TSS | unknown | ❌ not supported | — |
SYSTEM$QUERY_REFERENCE | unknown | ❌ not supported | — |
SYSTEM$READ_OSI_YAML_FROM_SEMANTIC_VIEW | unknown | ❌ not supported | — |
SYSTEM$READ_OSSIE_YAML_FROM_SEMANTIC_VIEW | unknown | ❌ not supported | — |
SYSTEM$READ_YAML_FROM_SEMANTIC_VIEW | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$REFERENCE | unknown | ❌ not supported | — |
SYSTEM$REGISTER_CMK_INFO | unknown | ❌ not supported | — |
SYSTEM$REGISTER_CMK_INFO_POSTGRES | unknown | ❌ not supported | — |
SYSTEM$REGISTER_PRIVATELINK_ENDPOINT | unknown | ❌ not supported | — |
SYSTEM$REMOTE_APP_OPERATION | unknown | ❌ not supported | — |
SYSTEM$REMOVE_ALL_REFERENCES | unknown | ❌ not supported | — |
SYSTEM$REMOVE_PRIVATELINK_ENDPOINT_HOSTNAME | unknown | ❌ not supported | — |
SYSTEM$REMOVE_REFERENCE | unknown | ❌ not supported | — |
SYSTEM$REPORT_HEALTH_STATUS | unknown | ❌ not supported | — |
SYSTEM$RESOLVE_PYTHON_PACKAGES | unknown | ⏸️ deferred | — |
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT | unknown | ❌ not supported | — |
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT_TSS | unknown | ❌ not supported | — |
SYSTEM$REVOKE_PRIVATELINK | unknown | ❌ not supported | — |
SYSTEM$REVOKE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS | unknown | ❌ not supported | — |
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS | unknown | ❌ not supported | — |
SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESH | unknown | ❌ not supported | — |
SYSTEM$SEND_NOTIFICATIONS_TO_CATALOG | unknown | ⏸️ deferred | — |
SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS | unknown | ❌ not supported | — |
SYSTEM$SET_CATALOG_INTEGRATION | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND | unknown | ❌ not supported | — |
SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT | unknown | ❌ not supported | — |
SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION | unknown | ❌ not supported | — |
SYSTEM$SET_PRIVATELINK_ENDPOINT_HOSTNAME | unknown | ❌ not supported | — |
SYSTEM$SET_REFERENCE | unknown | ❌ not supported | — |
SYSTEM$SET_RETURN_VALUE | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$SET_ROW_TIMESTAMP_ON_ALL_SUPPORTED_TABLES | unknown | ❌ not supported | — |
SYSTEM$SET_SPAN_ATTRIBUTES | unknown | ✅ supported | — |
SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES | unknown | ❌ not supported | — |
SYSTEM$SHOW_BUDGETS_FOR_RESOURCE | unknown | ❌ not supported | — |
SYSTEM$SHOW_BUDGETS_IN_ACCOUNT | scalar | ✅ supported | () → VARCHAR |
SYSTEM$SHOW_BUDGET_SHARED_RESOURCE_CANDIDATES | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR |
SYSTEM$SHOW_DYNAMIC_TABLES_CREATED_FOR_RESHARING | unknown | ❌ not supported | — |
SYSTEM$SHOW_EVENT_SHARING_ACCOUNTS | unknown | ❌ not supported | — |
SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS | unknown | ❌ not supported | — |
SYSTEM$SHOW_OAUTH_CLIENT_SECRETS | unknown | ❌ not supported | — |
SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIES | unknown | ❌ not supported | — |
SYSTEM$SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_STATUS | unknown | ❌ not supported | — |
SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKEN | unknown | ❌ not supported | — |
SYSTEM$START_OAUTH_FLOW | unknown | ❌ not supported | — |
SYSTEM$START_USER_EMAIL_VERIFICATION | unknown | ❌ not supported | — |
SYSTEM$STREAM_GET_TABLE_TIMESTAMP | unknown | ⏸️ deferred | — |
SYSTEM$STREAM_HAS_DATA | scalar | ✅ supported | (VARCHAR) → BOOLEAN |
SYSTEM$SUPPORTED_DBT_VERSIONS | unknown | ❌ not supported | — |
SYSTEM$TAG_VALUE_CONTAINS | scalar | ✅ supported | (VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN |
SYSTEM$TASK_DEPENDENTS_ENABLE | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$TASK_RUNTIME_INFO | scalar | ✅ supported | (ANY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(FLOAT) → VARCHAR(NUMBER) → VARCHAR(TIME) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
SYSTEM$TRIGGER_LISTING_REFRESH | unknown | ❌ not supported | — |
SYSTEM$TYPEOF | scalar | ✅ supported | (ANY) → VARCHAR(ARRAY) → VARCHAR(BINARY) → VARCHAR(BOOLEAN) → VARCHAR(DATE) → VARCHAR(DECFLOAT) → VARCHAR(FILE) → VARCHAR(FLOAT) → VARCHAR(GEOGRAPHY) → VARCHAR(GEOMETRY) → VARCHAR(NUMBER) → VARCHAR(OBJECT) → VARCHAR(SNOWFLAKE_INTERVAL_DAY_TIME) → VARCHAR(SNOWFLAKE_INTERVAL_YEAR_MONTH) → VARCHAR(SNOWFLAKE_PERIOD_DATE) → VARCHAR(SNOWFLAKE_PERIOD_TIME) → VARCHAR(SNOWFLAKE_PERIOD_TIMESTAMP_LTZ) → VARCHAR(SNOWFLAKE_PERIOD_TIMESTAMP_NTZ) → VARCHAR(SNOWFLAKE_PERIOD_TIMESTAMP_TZ) → VARCHAR(SNOWFLAKE_UUID) → VARCHAR(TIME) → VARCHAR(TIMESTAMP_LTZ) → VARCHAR(TIMESTAMP_NTZ) → VARCHAR(TIMESTAMP_TZ) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS | unknown | ❌ not supported | — |
SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS | unknown | ❌ not supported | — |
SYSTEM$UNLINK_ORGANIZATION_USER | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$UNLINK_ORGANIZATION_USER_GROUP | scalar | ✅ supported | (VARCHAR) → VARCHAR |
SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINT | unknown | ❌ not supported | — |
SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND | unknown | ❌ not supported | — |
SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT | unknown | ❌ not supported | — |
SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGION | unknown | ❌ not supported | — |
SYSTEM$UNVERIFY_DNS_DOMAIN | unknown | ❌ not supported | — |
SYSTEM$UPDATE_MULTI_PARTY_APPROVAL_JUSTIFICATION | unknown | ❌ not supported | — |
SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS | scalar | ✅ supported | (%I) → VARCHAR(ANY) → VARCHAR(VARCHAR) → VARCHAR(VARIANT) → VARCHAR |
SYSTEM$VALIDATE_STORAGE_INTEGRATION | scalar | ✅ supported | (VARCHAR, VARCHAR, VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$VERIFY_CATALOG_INTEGRATION | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR |
SYSTEM$VERIFY_CMK_INFO | unknown | ❌ not supported | — |
SYSTEM$VERIFY_CMK_INFO_POSTGRES | unknown | ❌ not supported | — |
SYSTEM$VERIFY_DNS_DOMAIN | unknown | ❌ not supported | — |
SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN | unknown | ❌ not supported | — |
SYSTEM$VERIFY_EXTERNAL_SECRET_INTEGRATION | unknown | ❌ not supported | — |
SYSTEM$VERIFY_EXTERNAL_VOLUME | scalar | ✅ supported | (ANY) → VARCHAR(VARCHAR) → VARCHAR |
SYSTEM$WAIT | scalar | ✅ supported | (ANY) → VARCHAR(NUMBER) → VARCHAR(NUMBER, VARCHAR) → VARCHAR |
SYSTEM$WAIT_FOR_OPENFLOW_CONNECTOR_STATUS | unknown | ❌ not supported | — |
SYSTEM$WAIT_FOR_OPENFLOW_DEPLOYMENT_STATUS | unknown | ❌ not supported | — |
SYSTEM$WAIT_FOR_OPENFLOW_RUNTIME_STATUS | unknown | ❌ not supported | — |
SYSTEM$WAIT_FOR_SERVICES | unknown | ❌ not supported | — |
SYSTEM$WAIT_FOR_STABLE_OPENFLOW_CONNECTORS | unknown | ❌ not supported | — |
SYSTEM$WAIT_FOR_STABLE_OPENFLOW_DEPLOYMENTS | unknown | ❌ not supported | — |
SYSTEM$WAIT_FOR_STABLE_OPENFLOW_RUNTIMES | unknown | ❌ not supported | — |
Table functions (26)
| Function | Kind | Status | Signatures |
|---|---|---|---|
CORTEX_SEARCH_BATCH | unknown | ❌ not supported | — |
CORTEX_SEARCH_DATA_SCAN | unknown | ❌ not supported | — |
CUMULATIVE_PRIVACY_LOSSES | unknown | ❌ not supported | — |
ESTIMATE_HYBRID_TABLE_STORAGE_USAGE | unknown | ❌ not supported | — |
FLATTEN | table | 🟡 partial | (VARIANT, VARCHAR, BOOLEAN, BOOLEAN, VARCHAR) → TABLE |
GENERATOR | table | ✅ supported | (NUMBER, NUMBER) → SETOF NUMBER |
GET_AI_EVALUATION_DATA | unknown | ❌ not supported | — |
GET_AI_OBSERVABILITY_EVENTS | unknown | ❌ not supported | — |
GET_AI_OBSERVABILITY_LOGS | unknown | ❌ not supported | — |
GET_AI_RECORD_TRACE | unknown | ❌ not supported | — |
GET_CONTACTS | table | 🟡 partial | (VARCHAR, VARCHAR) → TABLE |
GET_JOB_HISTORY | unknown | ❌ not supported | — |
GET_LINEAGE | unknown | ❌ not supported | — |
GET_OBJECT_REFERENCES | table | ✅ supported | (VARCHAR, VARCHAR, VARCHAR) → SETOF __SNOWFLAKE$OBJECT_REFERENCE_ROW |
ICEBERG_TABLE_FILES | unknown | ✅ supported | — |
ICEBERG_TABLE_FILE_REGISTRATION_HISTORY | unknown | ❌ not supported | — |
ICEBERG_TABLE_SNAPSHOT_REFRESH_HISTORY | unknown | ✅ supported | — |
INFER_SCHEMA | table | 🟡 partial | (VARCHAR, VARCHAR, ARRAY, BOOLEAN, NUMBER, NUMBER, VARCHAR, VARCHAR, BOOLEAN, VARCHAR, VARCHAR, NUMBER) → SETOF RECORD |
REPLICATION_GROUP_LAG_HISTORY | unknown | ❌ not supported | — |
REST_EVENT_HISTORY | unknown | 🟡 partial | — |
RESULT_SCAN | unknown | ✅ supported | — |
SEMANTIC_VIEW_MATERIALIZATION_REFRESH_HISTORY | unknown | ❌ not supported | — |
STORAGE_LIFECYCLE_POLICY_HISTORY | unknown | ✅ supported | — |
SYSTEM$STREAM_BACKLOG | table | ✅ supported | (VARCHAR) → TABLE |
TO_QUERY | unknown | ✅ supported | — |
VALIDATE | table | ✅ supported | (VARCHAR, VARCHAR) → TABLE |
Table functions (Tables) (1)
| Function | Kind | Status | Signatures |
|---|---|---|---|
APPLICATION_CONFIGURATION_VALUE_HISTORY | unknown | ❌ not supported | — |
Vector functions (10)
| Function | Kind | Status | Signatures |
|---|---|---|---|
VECTOR_AVG | aggregate | ✅ supported | (VECTOR) |
VECTOR_COSINE_SIMILARITY | scalar | ✅ supported | (VECTOR, VECTOR) → FLOAT |
VECTOR_INNER_PRODUCT | scalar | ✅ supported | (VECTOR, VECTOR) → FLOAT |
VECTOR_L1_DISTANCE | scalar | ✅ supported | (VECTOR, VECTOR) → FLOAT |
VECTOR_L2_DISTANCE | scalar | ✅ supported | (VECTOR, VECTOR) → FLOAT |
VECTOR_MAX | aggregate | ✅ supported | (VECTOR) |
VECTOR_MIN | aggregate | ✅ supported | (VECTOR) |
VECTOR_NORMALIZE | scalar | ✅ supported | (ANY) → VECTOR(BOOLEAN) → VECTOR(FLOAT) → VECTOR(NUMBER) → VECTOR(VARCHAR) → VECTOR(VARIANT) → VECTOR(VECTOR) → VECTOR |
VECTOR_SUM | aggregate | ✅ supported | (VECTOR) |
VECTOR_TRUNCATE | scalar | 🟡 partial | (ANY, ANY) → VECTOR(BOOLEAN, NUMBER) → VECTOR(FLOAT, NUMBER) → VECTOR(VARCHAR, NUMBER) → VECTOR(VARIANT, NUMBER) → VECTOR(VECTOR, NUMBER) → VECTOR |
Window function syntax and usage (8)
| Function | Kind | Status | Signatures |
|---|---|---|---|
DENSE_RANK | window | 🟡 partial | () → NUMBER |
FIRST_VALUE | window | 🟡 partial | (ANY) → ANY |
LAG | window | 🟡 partial | (ANY) → ANY(ANY) → VARCHAR(ANY, NUMBER) → ANY(ANY, NUMBER, ANY) → ANY |
LAST_VALUE | window | 🟡 partial | (ANY) → ANY |
LEAD | window | 🟡 partial | (ANY) → ANY(ANY) → VARCHAR(ANY, NUMBER) → ANY(ANY, NUMBER, ANY) → ANY |
NTH_VALUE | window | 🟡 partial | (ANY, NUMBER) → ANY |
NTILE | window | 🟡 partial | (NUMBER) → NUMBER |
ROW_NUMBER | window | 🟡 partial | () → NUMBER |
Window functions (9)
| Function | Kind | Status | Signatures |
|---|---|---|---|
CONDITIONAL_CHANGE_EVENT | window | 🟡 partial | (ANY) → NUMBER |
CONDITIONAL_TRUE_EVENT | unknown | 🟡 partial | — |
CUME_DIST | window | 🟡 partial | () → FLOAT |
INTERPOLATE_BFILL | window | 🟡 partial | (ANY) → ANY |
INTERPOLATE_FFILL | window | 🟡 partial | (ANY) → ANY |
INTERPOLATE_LINEAR | window | 🟡 partial | (ANY, ANY) → ANY |
PERCENT_RANK | window | 🟡 partial | () → FLOAT |
RANK | window | 🟡 partial | () → NUMBER |
RATIO_TO_REPORT | unknown | 🟡 partial | — |
Not in the SQL reference (bitwise) (5)
| Function | Kind | Status | Signatures |
|---|---|---|---|
BIT_NOT | scalar | ✅ supported | (NUMBER) → NUMBER |
BIT_OR | scalar | ✅ supported | (NUMBER, NUMBER) → NUMBER |
BIT_SHIFTLEFT | scalar | ✅ supported | (NUMBER, NUMBER) → NUMBER |
BIT_SHIFTRIGHT | scalar | ✅ supported | (NUMBER, NUMBER) → NUMBER |
BIT_XOR | scalar | ✅ supported | (NUMBER, NUMBER) → NUMBER |
Not in the SQL reference (context) (1)
| Function | Kind | Status | Signatures |
|---|---|---|---|
CURRENT_TIMESTAMP_LTZ | scalar | ✅ supported | () → TIMESTAMP_LTZ |
Not in the SQL reference (conversion) (17)
| Function | Kind | Status | Signatures |
|---|---|---|---|
BIT_AND | scalar | ✅ supported | (ANY, ANY) → NUMBER(DECFLOAT, DECFLOAT) → NUMBER(NUMBER, NUMBER) → NUMBER |
ST_GEOGFROMEWKB | scalar | ✅ supported | (ANY) → GEOGRAPHY(BINARY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(BINARY, BOOLEAN) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOGFROMEWKT | scalar | ✅ supported | (ANY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOGFROMTEXT | scalar | ✅ supported | (ANY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOGFROMWKB | scalar | ✅ supported | (ANY) → GEOGRAPHY(BINARY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(BINARY, BOOLEAN) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOGFROMWKT | scalar | ✅ supported | (ANY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOGRAPHYFROMEWKB | scalar | ✅ supported | (ANY) → GEOGRAPHY(BINARY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(BINARY, BOOLEAN) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOGRAPHYFROMEWKT | scalar | ✅ supported | (ANY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOGRAPHYFROMTEXT | scalar | ✅ supported | (ANY) → GEOGRAPHY(VARCHAR) → GEOGRAPHY(ANY, ANY) → GEOGRAPHY(VARCHAR, BOOLEAN) → GEOGRAPHY |
ST_GEOMETRYFROMEWKB | scalar | ✅ supported | (ANY) → GEOMETRY(BINARY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, BOOLEAN) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, FLOAT) → GEOMETRY(BINARY, NUMBER) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(BINARY, VARCHAR) → GEOMETRY(BINARY, VARIANT) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, BOOLEAN, BOOLEAN) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, FLOAT, BOOLEAN) → GEOMETRY(BINARY, NUMBER, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(BINARY, VARCHAR, BOOLEAN) → GEOMETRY(BINARY, VARIANT, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY(ANY, ANY, ANY, ANY) → GEOMETRY(BINARY, NUMBER, BOOLEAN, NUMBER) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN, NUMBER) → GEOMETRY |
ST_GEOMETRYFROMEWKT | scalar | ✅ supported | (ANY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY |
ST_GEOMETRYFROMTEXT | scalar | ✅ supported | (ANY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY |
ST_GEOMFROMEWKB | scalar | ✅ supported | (ANY) → GEOMETRY(BINARY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, BOOLEAN) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, FLOAT) → GEOMETRY(BINARY, NUMBER) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(BINARY, VARCHAR) → GEOMETRY(BINARY, VARIANT) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, BOOLEAN, BOOLEAN) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, FLOAT, BOOLEAN) → GEOMETRY(BINARY, NUMBER, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(BINARY, VARCHAR, BOOLEAN) → GEOMETRY(BINARY, VARIANT, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY(ANY, ANY, ANY, ANY) → GEOMETRY(BINARY, NUMBER, BOOLEAN, NUMBER) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN, NUMBER) → GEOMETRY |
ST_GEOMFROMEWKT | scalar | ✅ supported | (ANY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY |
ST_GEOMFROMTEXT | scalar | ✅ supported | (ANY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY |
ST_GEOMFROMWKB | scalar | ✅ supported | (ANY) → GEOMETRY(BINARY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, BOOLEAN) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, FLOAT) → GEOMETRY(BINARY, NUMBER) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(BINARY, VARCHAR) → GEOMETRY(BINARY, VARIANT) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, BOOLEAN, BOOLEAN) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, FLOAT, BOOLEAN) → GEOMETRY(BINARY, NUMBER, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(BINARY, VARCHAR, BOOLEAN) → GEOMETRY(BINARY, VARIANT, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY(ANY, ANY, ANY, ANY) → GEOMETRY(BINARY, NUMBER, BOOLEAN, NUMBER) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN, NUMBER) → GEOMETRY |
ST_GEOMFROMWKT | scalar | ✅ supported | (ANY) → GEOMETRY(VARCHAR) → GEOMETRY(ANY, ANY) → GEOMETRY(BINARY, DATE) → GEOMETRY(BINARY, TIME) → GEOMETRY(BINARY, TIMESTAMP_LTZ) → GEOMETRY(BINARY, TIMESTAMP_NTZ) → GEOMETRY(BINARY, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, DATE) → GEOMETRY(VARCHAR, FLOAT) → GEOMETRY(VARCHAR, NUMBER) → GEOMETRY(VARCHAR, TIME) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ) → GEOMETRY(VARCHAR, TIMESTAMP_TZ) → GEOMETRY(VARCHAR, VARCHAR) → GEOMETRY(VARCHAR, VARIANT) → GEOMETRY(ANY, ANY, ANY) → GEOMETRY(BINARY, DATE, BOOLEAN) → GEOMETRY(BINARY, TIME, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(BINARY, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, BOOLEAN, BOOLEAN) → GEOMETRY(VARCHAR, DATE, BOOLEAN) → GEOMETRY(VARCHAR, FLOAT, BOOLEAN) → GEOMETRY(VARCHAR, NUMBER, BOOLEAN) → GEOMETRY(VARCHAR, TIME, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_LTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_NTZ, BOOLEAN) → GEOMETRY(VARCHAR, TIMESTAMP_TZ, BOOLEAN) → GEOMETRY(VARCHAR, VARCHAR, BOOLEAN) → GEOMETRY(VARCHAR, VARIANT, BOOLEAN) → GEOMETRY |
Not in the SQL reference (date) (8)
| Function | Kind | Status | Signatures |
|---|---|---|---|
TIMEFROMPARTS | scalar | ✅ supported | (ANY, ANY, ANY) → TIME(NUMBER, NUMBER, NUMBER) → TIME(NUMBER, NUMBER, NUMBER, NUMBER) → TIME |
TIMESTAMPFROMPARTS | scalar | ✅ 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 |
TIMESTAMPLTZFROMPARTS | scalar | ✅ 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 |
TIMESTAMPNTZFROMPARTS | scalar | ✅ 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 |
TIMESTAMPTZFROMPARTS | scalar | ✅ 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_PARTS | scalar | ✅ 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_PARTS | scalar | ✅ 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_PARTS | scalar | ✅ 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 (system) (7)
| Function | Kind | Status | Signatures |
|---|---|---|---|
GENERATE_POSTGRES_ACCESS_TOKEN_FOR_USER | scalar | ✅ supported | (VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$ARE_ANACONDA_TERMS_ACKNOWLEDGED | scalar | ✅ supported | () → BOOLEAN |
SYSTEM$BOOTSTRAP_DATA_REQUEST | scalar | ✅ supported | () → VARCHAR(ANY) → VARCHAR(SNOWFLAKE_VARCHAR[]) → VARCHAR |
SYSTEM$GET_DEFAULT_PYTHON_ARTIFACT_REPOSITORY | scalar | ✅ supported | (VARCHAR, VARCHAR, VARCHAR) → VARCHAR |
SYSTEM$RETURN_CURRENT_ORG_NAME | scalar | ✅ supported | () → VARCHAR |
SYSTEM$SEND_EMAIL | scalar | ✅ supported | (ANY, ANY, ANY, ANY) → BOOLEAN(VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN(VARCHAR, VARCHAR, VARCHAR, VARCHAR, VARCHAR) → BOOLEAN |
SYSTEM$SEND_SNOWFLAKE_NOTIFICATION | scalar | ✅ supported | (ANY, ANY) → VARCHAR(ARRAY, ARRAY) → VARCHAR(ARRAY, VARCHAR) → VARCHAR(VARCHAR, ARRAY) → VARCHAR(VARCHAR, VARCHAR) → VARCHAR |
344 of 647 documented · 53%237 supported151 partial292 not supported11 deferred
SQL statements
39 of 39 documented · 100%45 supported9 partial0 not supported0 deferred
Query features
| Feature | Status |
|---|---|
| ASOF JOIN | 🟡 partial |
| AT | BEFORE | ✅ supported |
| CHANGES | 🟡 partial |
| CONNECT BY | ✅ supported |
| FOR UPDATE | ✅ supported |
| FROM | 🟡 partial |
| GROUP BY | ✅ supported |
| GROUP BY CUBE | ✅ supported |
| GROUP BY GROUPING SETS | ✅ supported |
| GROUP BY ROLLUP | ✅ supported |
| HAVING | ✅ supported |
| INTO | ✅ supported |
| JOIN | 🟡 partial |
| LATERAL | ✅ supported |
| LIMIT / FETCH | 🟡 partial |
| MATCH_RECOGNIZE | ✅ supported |
| ORDER BY | ✅ supported |
| PIVOT | 🟡 partial |
| QUALIFY | ✅ supported |
| RESAMPLE | ✅ supported |
| SAMPLE / TABLESAMPLE | ✅ supported |
| SEMANTIC_VIEW | 🟡 partial |
| TOP <N> | ✅ supported |
| UNPIVOT | 🟡 partial |
| VALUES | ✅ supported |
| WHERE | ✅ supported |
| WITH | 🟡 partial |
| : | ✅ 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) | ✅ supported |
| 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 supported0 deferred
Data types
| Type | Synonyms | Status |
|---|---|---|
ARRAY | — | ✅ supported |
BINARY | VARBINARY | ✅ supported |
BOOLEAN | — | ✅ supported |
DATE | — | ✅ supported |
DECFLOAT | — | ✅ supported |
FILE | — | ✅ supported |
FLOAT | FLOAT4, FLOAT8, DOUBLE, DOUBLE PRECISION, REAL | ✅ supported |
GEOGRAPHY | — | ✅ supported |
GEOMETRY | — | ✅ supported |
MAP | — | ✅ supported |
NUMBER | DECIMAL, NUMERIC, INT, INTEGER, BIGINT, SMALLINT, TINYINT, BYTEINT | ✅ supported |
OBJECT | — | ✅ supported |
TIME | — | ✅ supported |
TIMESTAMP_LTZ | — | ✅ supported |
TIMESTAMP_NTZ | TIMESTAMP, DATETIME | ✅ supported |
TIMESTAMP_TZ | — | ✅ supported |
VARCHAR | STRING, TEXT, CHAR, CHARACTER, NCHAR, NVARCHAR, NVARCHAR2, CHAR VARYING, NCHAR VARYING | ✅ supported |
VARIANT | — | ✅ supported |
VECTOR | — | ✅ supported |
270 of 400 documented · 68%270 supported0 partial149 not supported0 deferred