Preview — 8.40 Release Notes¶
Attention
Content in this page is available in advance of the pending completion of the 8.40 release. The release is scheduled to complete on October 22 (subject to change).
Features, updates, or behavior changes described in this page might not become available in your account(s) until the completion of the release.
For updates to these release notes, see Release notes change log.
New features¶
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)
Note
Snowflake REST APIs are not supported in the Snowflake SnowGov regions.
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
SQL updates¶
New SQL functions¶
The following function(s) are now available with this release:
Function category |
New function |
Description |
---|---|---|
Information Schema, Table Functions |
SERVERLESS_ALERT_HISTORY |
This table function is used for querying the serverless alert usage history. The information returned by the function includes the alert name and credits consumed by runs of each alert. |
Release notes change log¶
Announcement |
Update |
Date |
---|---|---|
Release notes |
Initial publication (preview) |
18-Oct-24 |