Server releases and feature updates in 2023¶

The following sections list the release notes for the server releases and feature updates in 2023:

Server releases in 2023
Feature updates in 2023

For more recent releases and feature updates, see Snowflake server release notes and feature updates.

Server releases in 2023¶

December 14-15, 2023 — 7.44 Release Notes
- New Features
  - Organization Usage: Improved views for billing reconciliation — General Availability
- SQL Updates
  - Snowflake Cortex ML-Based Time-Series Functions — General Availability
- Ecosystem Updates
  - Snowpark ML Modeling API — General Availability
  - Snowpark ML Distributed Hyperparameter Optimization — Preview
- Data Lake Updates
  - Cross-Cloud/Cross-Region Support for Apache Iceberg™ Tables — Preview
- Release Notes Change Log
December 04-05, 2023 — 7.43 Release Notes
- New Features
  - Finalizer Task — General Availability
- SQL Updates
  - New SQL functions
- Extensibility Updates
  - Python Snowpark Local Testing Framework — Preview
- Web Interface Updates
  - Load Files onto Stages and Managed Staged Files using Snowsight — General Availability
- Release Notes Change Log
November 29-30, 2023 — 7.42 Release Notes
- New Features
- Security Updates
  - Key pair authentication: Improved troubleshooting
- SQL Updates
  - Structured types — Preview
- Data Governance Updates
  - Row access policies: Reference a protected mapping table in a row access policy — General availability
- Data Collaboration Updates
  - Recurring subscription-based pricing plans for paid listings —– General Availability
  - Cross-Cloud Auto-Fulfillment support for sharing a Snowflake Native App — Preview
- Release Notes Change Log
November 11-14, 2023 — 7.41 Release Notes (with behavior changes)
- Behavior Change Bundles
- SQL Updates
- Security Updates
  - Replication of network rules — Preview
- Data Pipeline Updates
  - Dynamic tables: Support for GRANT <privilege> ON ALL/FUTURE DYNAMIC TABLE - Preview
  - Dynamic tables: Support for GRANT ALL/ALL PRIVILEGES ON DYNAMIC TABLE - Preview
- Web Interface Updates
- Release Notes Change Log
November 09-10, 2023 — 7.40 Release Notes
- SQL Updates
  - Search Optimization: Support for Substring Search in Semi-Structured Data — General Availability
  - Email Notification Integrations: ALLOWED_RECIPIENTS No Longer Required
- Web Interface Updates
  - Replication and Client Redirect in Snowsight — Preview
  - Snowsight is the default interface for Snowflake accounts in US government regions
- Release Notes Change Log
November 03-06, 2023 — 7.39 Release Notes (with Snowday 2023)
- New Features
- Security Updates
  - Access control: Database roles — General availability
- Data Pipeline Updates
  - New function SYSTEM$TASK_RUNTIME_INFO
- Extensibility Updates
  - External network access — Preview on Azure
  - Vectorized Python UDTFs — General Availability
- Data Governance Updates
  - Set a masking policy on a virtual column — General Availability
- Release Notes Change Log
October 23-24, 2023 — 7.38 Release Notes
- Security Updates
  - Network rules support Azure private endpoints — Preview
- SQL Updates
  - ALTER TABLE: Support for IF [NOT] EXISTS with ADD COLUMN and DROP COLUMN
  - H3 functions for GEOGRAPHY objects — Preview
- Extensibility Updates
  - Python packages policies — Preview
- Web Interface Updates
  - Snowsight is the default interface for Snowflake accounts in US government regions
- Release Notes Change Log
October 16-17, 2023 — 7.37 Release Notes
- New Features
  - Logging and tracing from handler code — General Availability
- Extensibility Updates
  - Reading files with a Python function or procedure — General Availability
  - Reading files with a Scala function or procedure handler — General Availability
- SQL Updates
  - Fixed an issue with column aliases for aggregates and the GROUP BY ALL clause
- Web Interface Updates
  - Can no longer add or manage payment details using Classic Console
- Release Notes Change Log
October 09-10, 2023 — 7.36 Release Notes
- Extensibility Updates
  - Support for Python 3.11 in Snowpark, UDFs, UDTFs and stored procedures — Preview
- Data Collaboration Updates
  - Company name for listing analytics
- Web Interface Updates
  - Accessing billing usage statements — General Availability
  - Viewing Query History in worksheets — Preview
- Release Notes Change Log
October 03-05, 2023 — 7.35 Release Notes
- New Features
- SQL Updates
  - New SQL Functions
- Data Collaboration Updates
  - Allow non-admins to set up Cross-Cloud Auto-Fulfillment
  - Offer a limited trial of a data product on the Snowflake Marketplace — Preview
- Web Interface Updates
  - Task graph run debugging — Preview
- Release Notes Change Log
September 27-29, 2023 — 7.34 Release Notes (with behavior changes)
- Behavior Change Bundles
- New Features
  - Snowflake Alerts — General Availability
- SQL Updates
  - New SQL Functions
- Web Interface Updates
  - Allow Snowflake On Demand customers to purchase listings
September 18-19, 2023 — 7.33 Release Notes
- New Features
- Data Loading Updates
  - Cross-platform Support for Snowpipe Auto-Ingest — General Availability
  - Amazon EventBridge Support for Snowpipe Auto-Ingest — General Availability
- Data Governance Updates
  - Tag-based Masking Policy: Support for Database & Schema — General Availability
  - Shared Tag References — Preview
September 11-12, 2023 — 7.32 Release Notes
- SQL Updates
  - New Function: IS_DATABASE_ROLE_IN_SESSION
- Data Loading / Unloading Updates
- Data Governance Updates
  - Row access policies: Reference a protected mapping table in a row access policy — Preview
  - Share data protected by a role-based policy — Preview
- Web Interface Updates
  - Managing data governance in Snowsight — Generally Available
September 05-06, 2023 – 7.31 Release Notes
- New Features
  - New Information Schema Views for Class Instances
  - External Network Access — Preview
August 28-29, 2023 — 7.30 Release Notes
- New Features
  - Data Pipelines Replication Support — Preview
- Security Updates
  - Password policies: Add support for password history and time to wait to change a password
- SQL Updates
  - EXECUTE IMMEDIATE FROM File — Preview
  - Organizations & Accounts: Dropping an account URL — Preview
- Developer and Extensibility Updates
  - Support for Python 3.9 and 3.10 in Snowpark, UDFs, UDTFs and stored procedures — General Availability
  - Tabular Return Values from Python Stored Procedures — General Availability
- Data Governance Updates
  - Set a masking policy on a virtual column — Preview
- Web Interface Updates
  - Governance area supports GOVERNANCE_VIEWER and OBJECT_VIEWER database roles
  - Provider Studio Onboarding — General Availability
August 22-23, 2023 – 7.29 Release Notes (with behavior changes)
- Behavior Changes Bundles
- Non-bundled Pending Behavior Changes
- SQL Updates
August 16-17, 2023 — 7.28 Release Notes
- New Features
  - Blocking Public Access to Azure Internal Stages — General Availability
- SQL Updates
  - Python Package Version Range Support — Preview
- Data Loading Updates
  - New File Format Option: USE_LOGICAL_TYPE
- Web Interface Updates
  - Snowsight Worksheet Tabs — General Availability
August 07-08, 2023 — 7.27 Release Notes
- New Features
  - Account Usage: New CLASS_INSTANCES View
- SQL Updates
  - New System Stored Procedure for Sending Email Notifications — General Availability
- Web Interface Updates
  - Sharing: Improved UI Messaging
August 01-02, 2023 — 7.26 Release Notes
- SQL Updates
- Data Collaboration Updates
  - Recurring Subscription-based Pricing Plans for Paid Listings — Preview
  - Non-Recurring Subscription-based Pricing Plans for Paid Listings — General Availability
- Documentation and Learning Resources
  - Weekly Release Notes in the Snowflake Documentation
July 25-26, 2023 — 7.25 Release Notes
- New Features
  - Organization Usage: New QUERY_ACCELERATION_HISTORY View
- SQL Updates
  - Snowflake Alerts: Support for Future Grants and Object Tagging
  - Search Optimization: Support for Substring Search in Semi-Structured Data — Preview
- Data Governance Updates
  - Access History: Track Masking & Row Access Policy References — General Availability
- Web Interface Updates
  - Create Named Stages using Snowsight — General Availability
July 19-20, 2023 — 7.24 Release Notes
- New Features
  - SQL Syntax for Enabling the ORGADMIN Role — Preview
July 10-12, 2023 — 7.23 Release Notes (with behavior changes)
- Behavior Changes Bundles
- New Features
  - Schema Detection and Evolution for Kafka Connector With Snowpipe Streaming — Preview
- SQL Updates
  - SYSTEM$CLUSTERING_INFORMATION Returns Error Messages
- Web Interface Updates
  - Snowsight Set as Default Web Interface
July 05-06, 2023 — 7.22 Release Notes
- New Features
  - Deleting an Account (Self-service) — Preview
  - Organization Usage: New REPLICATION_GROUP_USAGE_HISTORY View
- SQL Updates
  - New SQL Functions
  - GROUP BY: New ALL Keyword
Summit announcements - Jun 26-29, 2023
- New features
June 19-22, 2023 — 7.21 Release Notes
- SQL Updates
  - New SQL Functions
- Data Loading Updates
  - Support REPLACE_INVALID_CHARACTERS for Avro, Parquet, Orc, and XML
June 14-15, 2023 — 7.20 Release Notes
- New Features
  - Snowpipe Streaming Replication Support — Preview
- Security Updates
  - Access Control: New Privilege for Delegating Warehouse Management — Preview
- SQL Updates
  - Improved Performance for SELECT Statements With LIMIT and ORDER BY Clauses — General Availability
  - Support for Python 3.10 in Snowpark, UDFs, UDTFs and Stored Procedures — Preview
- Data Governance Updates
  - Tag-based Masking Policy: Support for Database & Schema — Preview
  - Access History: Track Objects Modified by a DDL Operation — Preview
- Web Interface Updates
  - Load Files From a Stage Into a Table — General Availability
June 07-08, 2023 — 7.19 Release Notes (with behavior changes)
- Behavior Changes Bundles
- New Features
- SQL Updates
  - Support for Python 3.9 in Snowpark, UDFs, and Stored Procedures — Preview
  - UDFs, UDTFs, and Stored Procedures Support Passing Arguments by Name
- Data Science Updates
  - Work With Snowflake’s Upcoming ML features
- Organization Updates
  - ACCOUNTS View (Organization Usage) — Preview
- Web Interface Updates
  - New Organizations Only Have Snowsight Access
May 31-June 01, 2023 — 7.18 Release (no announcements)
May 2023
- New Features
  - Logging and Tracing in Procedures and Functions — Preview
- SQL Updates
- Data Collaboration Updates
  - Cross-Cloud Auto-Fulfillment for Listings — General Availability
- Data Governance Updates
  - Memoizable Functions — General Availability
- Web Interface Updates
April 2023
- New Features
- SQL Updates
- Data Loading Updates
- Data Collaboration Updates
  - Timed Trials for Paid Listings — General Availability
- Data Governance Updates
  - Object Tagging: Support Added for Policy Objects
- Web Interface Updates
March 2023
- New Features
  - Snowpipe Streaming — Preview
  - Tabular Return Values from Java or Scala Stored Procedures — Preview
- New Regions
- SQL Updates
- Data Pipeline Updates
  - Streams on Views — General Availability
- Data Lake Updates
  - External Table and Directory Table Auto-Refresh Observability and Billing
- Data Governance Updates
  - Allow Masked Columns as Inputs to Row Access Policies and Conditional Masking Policies
- Replication Updates
  - Account Replication: Notification Integration Support — Preview
- Web Interface
  - Python Worksheets — Preview
  - Individual Task Observability — General Availability
February 2023
- New Features
- Security Updates
  - Deprecated SAML SSO Parameters
  - Improved Error Messages for SSO Login Failures — General Availability
- SQL Updates
  - ROUND Function: New Argument for Specifying the Rounding Mode
  - Search Optimization Service: Support for Tables with Masking Policies and Row Access Policies — General Availability
- Virtual Warehouse Updates
  - Query Acceleration Service — General Availability
  - Snowpark-optimized Warehouses — General Availability
- Data Loading Updates
  - ON_ERROR Copy Option Supports All File Formats
  - New Metadata Columns for Staged Files
- Data Collaboration Updates
  - Listing Discovery Controls — General Availability
- Web Interface Updates
  - SQL Editor Improvements —– General Availability
January 2023
- New Features
- SQL Updates
  - Setting a Snowflake Scripting Variable to the Scalar Return Value from a Stored Procedure
  - New SQL Functions
- Data Governance Updates
  - Column Lineage — General Availability
- Web Interface Updates
  - Snowsight Worksheet Version History Retention

Feature updates in 2023¶