March 18-20, 2024 — 8.11 Release Notes¶

SELECT supports trailing commas¶

In a SELECT statement or clause, a trailing comma is now supported in a column list. For example, the following SELECT statement is supported:

SELECT emp_id,
       name,
       dept,
FROM employees;

Copy

Performance improvements for loading JSON files¶

With this release, Snowflake is pleased to announce a performance improvement for loading JSON files. This improvement results in lower ingestion latency of up to 25% for most JSON loading scenarios without any customer modification to queries.

For more information, see 2024 Performance Improvements.

Improvements to the SNOWPIPE_STREAMING_CLIENT_HISTORY view¶

With this release, the SNOWPIPE_STREAMING_CLIENT_HISTORY view resolves an issue where not all data loading events generated by the Snowpipe Streaming client calls were visible. The view has been resolved with all events showing correctly as of Feb 1, 2024.

For more information, see SNOWPIPE_STREAMING_CLIENT_HISTORY view.