This article provides a brief overview of the new features, enhancements, and other important changes introduced in this scheduled release of Snowflake. For more detailed information, see the Snowflake documentation.
Important: These changes may take 24 hours or more (after the completion of the release) to become available.
If you have any questions, please email firstname.lastname@example.org.
Tables: Automatic Reclustering No Longer Performed After DML
In this release, the reclustering behavior for tables with clustering keys is changed as follows:
- Previous behavior: When a table with clustering keys defined was modified through a DML statement (i.e. INSERT, UPDATE, DELETE, MERGE, COPY), the table was automatically reclustered according to the clustering keys for the table. For large-scale DML, this operation could consume significant resources.
- Current behavior: Snowflake no longer automatically reclusters a table with clustering keys when DML is performed on the table. Reclustering of a table is only performed by explicitly executing the ALTER TABLE … RECLUSTER command.
COPY Command: Support Added for Unloading Unenclosed Empty Strings
In this release, the behavior of the COPY INTO location command is changed as follows:
- Previous behavior: When unloading empty string values from a table, the COPY INTO location command required setting the FIELD_OPTIONALLY_ENCLOSED_BY file format option, either directly or by referencing a named file format or stage with the option set. If the option was not set, the command generated an error.
- Current behavior: The COPY INTO location command now unloads empty string values successfully without quotes enclosing field values when the FIELD_OPTIONALLY_ENCLOSED_BY option is not set, as long as the EMPTY_FIELD_AS_NULL file format option is FALSE. This behavior change allows you to unload empty strings without replacing them with SQL NULL values.
If the FIELD_OPTIONALLY_ENCLOSED_BY option is not set and the EMPTY_FIELD_AS_NULL option is TRUE, the command generates an error.
QUERY_HISTORY Information Schema Function: New Columns Added to Output
The following columns have been added to the QUERY_HISTORY table function output to further enhance query auditing and reporting:
SnowSQL: Now Also Available via Homebrew Cask (Mac OS)
For users on Mac OS, SnowSQL can now be installed by Homebrew Cask, using the following command:
$ brew cask install snowflake-snowsql
Note that there is no separate SnowSQL installer to download. You can install directly through Homebrew Cask.
SnowSQL can also be downloaded from either the Amazon S3 artifact repository or the Snowflake web interface.
Snowflake JDBC Driver: Source Code Now Available in GitHub
The driver source code (and additional information) is now available in a repository in the Snowflake GitHub organization.