October 21-23, 2024 — 8.40 Release Notes¶

Trust Center: New Threat Intelligence scanner package¶

The Threat Intelligence scanner package is a new scanner package available in the Trust Center. This scanner package lets you discover risky users based on user type, authentication methods, authentication policies, and network policies used. This scanner package provides a risk severity for each risky user, to help you prioritize which users to address first.

For more information, see the following references:

• Threat Intelligence scanner package

• User TYPE properties

• ACCOUNTADMIN ADMIN_USER_TYPE property

Estimate the cost of Automatic Clustering — General availability¶

With this release, we are pleased to announce the general availability of the system function, SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS, which estimates the cost of enabling Automatic Clustering for a table and maintaining the table in a well-clustered state. It can also estimate the cost of changing the clustering key for a clustered table.

For more information, see SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS.

Snowflake REST APIs — General availability¶

With this release, we are pleased to announce the general availability of Snowflake REST APIs.

Snowflake REST APIs for resource management provide a set of endpoints that lets users programmatically interact with and control various resources within the Snowflake Data Cloud.

In this release, Snowflake REST APIs includes the following updates:

• Added the following new Snowflake resources:

  • Account

  • Alert

  • Catalog integration

  • Event table

  • External volume

  • Network policy

  • Notebook

  • Notification integration

  • Pipe

  • Procedure

  • Stream

  • User-defined function

  • View

• Added the following access control endpoints to replace the endpoints in the deprecated Grant API:

  • /api/v2/roles/{name}/grants

  • /api/v2/roles/{name}/grants:revoke

  • /api/v2/databases/{database}/database-roles/{name}/grants

  • /api/v2/databases/{database}/database-roles/{name}/grants:revoke

  • /api/v2/users/{name}/grants

  • /api/v2/users/{name}/grants:revoke

• Added support for PUT endpoints in the Service and Compute Pool APIs

• Deprecated the Grant API and various endpoints (see Deprecated features)

For more information, see Snowflake REST APIs.

Snowflake REST APIs¶

In this release, Snowflake REST APIs deprecated the following APIs and endpoints:

• Grant API

• Database API endpoints:

  • /api/v2/databases/{name}:from_share

• Table API endpoints:

  • /api/v2/databases/{database}/schemas/{schema}/tables/{name}:as_select

  • /api/v2/databases/{database}/schemas/{schema}/tables/{name}:using_template

  • /api/v2/databases/{database}/schemas/{schema}/tables/{name}:create_like

  • /api/v2/databases/{database}/schemas/{schema}/tables/{name}:suspend_recluster

  • /api/v2/databases/{database}/schemas/{schema}/tables/{name}:resume_recluster

  • /api/v2/databases/{database}/schemas/{schema}/tables/{name}:swapwith

• Task API endpoints:

  • /api/v2/databases/{database}/schemas/{schema}/tasks/{name}/current_graphs

  • /api/v2/databases/{database}/schemas/{schema}/tasks/{name}/complete_graphs

• Warehouse API:

  • /api/v2/warehouses/{name}:use

New SQL functions¶

The following function(s) are now available with this release:

Apache Iceberg™ tables: Catalog integration for Iceberg REST — General availability¶

With this release, we are pleased to announce the general availability of REST catalog integrations for externally managed Iceberg tables. This feature lets you connect Snowflake to Iceberg tables in a remote catalog that complies with the open source Apache Iceberg REST OpenAPI specification.

For more information, see Configure a catalog integration for Apache Iceberg™ REST catalogs.