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.
Conflicting Parameters Now Return Error
In January, a behavior change for conflicting parameters in the COPY INTO table command was implemented. The same change now applies to the CREATE | ALTER STAGE command, as well as all SQL commands that support file format options:
- Previous behavior: If the following commands contained any parameters that conflicted with each other, the command did not return an error and instead executed using the conflicting parameter that occurred last in the command:
- CREATE | ALTER FILE_FORMAT
- CREATE | ALTER STAGE
- COPY INTO location
Parameter conflicts occur when the same parameter is specified more than once in the statement, e.g.:
- New behavior: If any of these commands encounter any parameter conflicts, the command returns an error and does not execute.
ALTER WAREHOUSE | USER Commands: Support for Aborting All Jobs
With this release, ALTER WAREHOUSE and ALTER USER provide a new parameter, ABORT ALL JOBS, that enables canceling all queries or SQL statements, running and queued, for the specified warehouse/user. For example:
ALTER WAREHOUSE testwh ABORT ALL JOBS;
ALTER USER user1 ABORT ALL JOBS;
This release introduces the following new function(s):
|String Functions||INITCAP||Returns the input string with the first letter of each word in uppercase and the subsequent letters in lowercase.|
Support for Metadata Columns
With this release, we are pleased to introduce access to a limited set of metadata recorded internally for each data file staged to an internal stage or staging location.
The following metadata columns can be queried or copied into tables:
- METADATA$FILENAME: Name of a staged data file.
- METADATA$FILE_ROW_NUMBER: Row number for each record in a staged data file.