10.8 Release Notes: Preview¶

User-defined types¶

With this release, you can define user-defined types, which are new data types that are based on existing Snowflake data types. User-defined types can simplify schema maintenance and improve data quality. You can define a user-defined type once, and then use it in multiple objects.

For example, you can define a data type named age that corresponds to NUMBER(3,0) or a data type named address that is a structured OBJECT type with fields for the street address, city, state, and postal code.

CKE document access history¶

Providers can now track which documents are being accessed in their Cortex Knowledge Extensions (CKEs) using access history data in the LISTING_ACCESS_HISTORY view.

Two new system functions help providers map hashed document IDs back to their original primary key columns:

• SYSTEM$ENCODE_CKE_PRIMARY_KEY:

  Transform and anonymize the primary key from the set of selected columns.

• SYSTEM$CKE_HASH_FUNCTION:

  Hash the primary key.