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

    • Native Apps: Support for reference and privilege validation in the manifest file — Preview
    • Schema detection for JSON and CSV — General Availability
    • Table schema evolution — General Availability
    • Apache Iceberg™ tables — Preview
    • Self-service: Enabling the ORGADMIN role — General Availability
    • Self-service: Deleting an account — General Availability

  • 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

    • New SQL functions
    • UDFs and Stored Procedures: Support for Optional Arguments
    • Snowflake alerts: Manual execution of alerts

  • Security Updates

    • Replication of network rules — Preview

  • Data Pipeline Updates

    • Dynamic tables: Support for GRANT ALL/ALL PRIVILEGES ON DYNAMIC TABLE - Preview

  • Web Interface Updates

    • More control over notification contacts in Snowsight
    • Snowsight is the default interface for Snowflake accounts in US government regions
    • Changes to formatting of query results in worksheets and dashboards

  • 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

    • Account Usage: New AGGREGATE_QUERY_HISTORY View — Preview
    • Budgets on Azure, GCP, and VPS — Preview
    • Snowflake Native SDK for Connectors — Preview

  • 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

    • Budgets — Preview
    • Dynamic tables refreshed on creation by default — Preview
    • Dynamic tables new sharing capabilities — Preview

  • 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

    • Network Rules — Preview
    • Enhanced Network Security — Preview
    • Network Isolation to Internal Stages Using AWS PrivateLink — Preview

  • 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

    • Replicating streams on Snowflake tables populated by Snowpipe Streaming
    • Snowpipe Streaming authentication updates
    • New options for INFER_SCHEMA

  • 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

    • GET_QUERY_OPERATOR_STATS Function — General Availability
    • Using the Query Hash to Identify Patterns and Trends in Queries
    • New SQL Functions

• 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

    • SELECT *: Selecting Columns Matching a SQL Pattern and Replacing Column Values
    • Transforming a GEOMETRY Object to a Different Spatial Reference System (ST_TRANSFORM) — General Availability
    • Vectorized Python UDTFs — Preview

  • 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

    • Dynamic tables — Preview
    • Amazon S3-compatible storage — General Availability
    • Passing references for tables, views, functions, and queries to a stored procedure — Preview
    • Snowpark ML: Machine learning at scale — Preview
    • ML functions — Preview
    • Native Applications Framework — Preview
    • Custom event billing for applications — Preview
    • Marketplace Capacity Drawdown Program — General Availability

• 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

    • Anonymous Procedures — General Availability
    • Reading Files With a Java Function or Procedure Handler — General Availability
    • Reading Files With a Scala Function or Procedure Handler — Preview
    • Reading Files With a Python Function or Procedure — Preview
    • Schema Detection for JSON and CSV — Preview
    • Table Schema Evolution — Preview

  • 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

Feature updates in 2023¶

• December 20, 2023 — Snowpark Container Services Release Notes
• December 15, 2023 — Cost Management Release Notes
• December 01, 2023 — Streamlit in Snowflake Release Notes