Preview — 8.40 Release Notes¶

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.

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)

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: