June 19-22, 2023 — 7.21 Release Notes

The following new features, behavior changes, and updates (enhancements, fixes, etc.) have been introduced in this release. If you have any questions about these additions, please contact Snowflake Support.


Each release may include updates that require the web interface to be refreshed.

As a general practice, to ensure these updates do not impact your usage, we recommend refreshing the web interface after each Snowflake release has been deployed.

SQL Updates

New SQL Functions

The following function(s) are now available with this release:

Function Category

New Function


Geospatial Functions (Transformation)


Converts a GEOMETRY object from one spatial reference system (SRS) to another.

This function is a preview feature.

Data Loading Updates

Support REPLACE_INVALID_CHARACTERS for Avro, Parquet, Orc, and XML

With this release, we are pleased to announce that the COPY INTO and CREATE EXTERNAL TABLE commands support the file format option REPLACE_INVALID_CHARACTERS for Avro, Parquet, Orc, and XML. Previously, this file format option only worked with CSV and JSON.

For more information, refer to CREATE FILE FORMAT.