Server releases in 2024¶

This topic lists the release notes for the server releases that occurred in 2024.

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

• December 16-18, 2024 — 8.47 Release Notes

  • SQL updates

    • New SQL functions

  • Extensibility updates

    • Support for a wildcard character in network rule network identifiers —– Preview

  • Data pipeline updates

    • Dynamic tables: Maximum number of dynamic tables in an account increased to 10,000

  • Data governance updates

    • OBJECT_DEPENDENCIES view: Support for dynamic tables

  • Release notes change log

• December 09-13, 2024 — 8.46 Release Notes

  • New features

    • Restricted caller’s rights — Preview

  • Snowsight updates

    • New login screen version

  • SQL Updates

    • New SQL functions

  • Release notes change log

• December 03-05, 2024 — 8.45 Release Notes

  • SQL updates

    • Snowflake Scripting: Asynchronous child jobs — Preview

  • Extensibility updates

    • Profiling Python stored procedure handlers — Preview
    • Java 17 support — General Availability

  • Data pipeline updates

    • Dynamic tables: Unlimited inputs

  • Release notes change log

• November 18-21, 2024 — 8.44 Release Notes

  • New features

    • Outbound private connectivity for Snowflake features
    • External stages using Azure Private Link — Preview
    • External volumes using Azure Private Link — Preview
    • Snowpipe automation using Azure Private Link — Preview
    • Visual Studio Code extension for Snowpark Python — General availability

  • Extensibility updates

    • External network access for Azure Gov regions — General availability

  • Data lake updates

    • Specify an external ID for SIGV4 REST catalog integrations

  • Release notes change log

• November 12-14, 2024 — 8.43 Release Notes

  • New features

    • Full-text search — General availability
    • Leaked password protection
    • Tasks: Python and JVM support for serverless tasks — General availability

  • SQL updates

    • EXECUTE IMMEDIATE FROM: Support for using content from staged files in templates
    • Automatic logging and tracing for Snowflake Scripting stored procedures
    • ACCOUNT_USAGE: New SERVERLESS_ALERT_HISTORY view

  • Extensibility updates

    • Authentication with AWS IAM from procedures and functions — General availability

  • Listings updates

    • LISTING_REFRESH_HISTORY — General availability

  • Data pipeline updates

    • Dynamic tables: Support for replication across different failover groups

  • Data Lake updates

    • Apache Iceberg™ tables: Support for Microsoft Fabric OneLake storage — Preview

  • Release notes change log

• November 04-06, 2024 — 8.42 Release Notes

  • New features

    • Trust Center: Two new scanners in the Security Essentials scanner package
    • Serverless alerts — General availability

  • SQL updates

    • PARSE_JSON and TRY_PARSE_JSON functions: Duplicate keys are now allowed

  • Extensibility updates

    • New Tensorflow version might require specifying Keras

  • Data pipeline updates

    • Tasks: Serverless tasks user control — General availability
    • Tasks: Task success notifications — General availability

  • AI & ML updates

    • API-level Role-based Access Control (RBAC) for Cortex Analyst

  • Release notes change log

• October 28-30, 2024 — 8.41 Release Notes

  • New features

    • Outbound private connectivity for Snowflake features
    • External network access from Snowpark using AWS PrivateLink and Azure Private Link — General availability
    • External network access from Snowpark Container Services via AWS PrivateLink and Azure Private Link - Preview
    • External functions using Azure Private Link — General availability
    • EXECUTE IMMEDIATE FROM: Preview SQL rendered from Jinja2 templates
    • GENERATE_SYNTHETIC_DATA: New system stored procedure for generating synthetic data — Preview

  • Security updates

    • Increased limits for network policies on internal stages

  • SQL updates

    • Extended support for bind variables

  • Extensibility updates

    • Writing files from Snowpark Python UDFs and UDTFs — Preview

  • Release notes change log

• October 21-23, 2024 — 8.40 Release Notes

  • New features

    • Trust Center: New Threat Intelligence scanner package
    • Estimate the cost of Automatic Clustering — General availability
    • Snowflake REST APIs — General availability

  • Deprecated features

    • Snowflake REST APIs

  • SQL updates

    • New SQL functions

  • Data lake updates

    • Apache Iceberg™ tables: Catalog integration for Iceberg REST — General availability

  • Release notes change log

• October 14-17, 2024 — 8.39 Release Notes

  • New features

    • Cortex Analyst fully supported in Streamlit in Snowflake

  • Data pipeline updates

    • Dynamic tables: Changes to the output of the GET_DDL function

  • Data lake updates

    • Apache Iceberg™ tables: New SYSTEM$VERIFY_EXTERNAL_VOLUME function

  • Release notes change log

• October 07-09, 2024 — 8.38 Release Notes (with behavior changes)

  • Behavior change bundles

  • SQL updates

    • New SQL functions
    • Query objects larger than 16 MB in files on a stage

  • Data pipeline updates

    • Dynamic tables: Updates to input types

  • Data governance updates

    • Data quality: New SYSTEM$DATA_METRIC_SCAN function

  • Release notes change log

• September 30 - October 03, 2024 — 8.37 Release Notes

  • SQL updates

    • New SQL functions

  • Extensibility updates

    • Authentication with AWS IAM from procedures and functions — Preview

  • Release notes change log

• September 23-26, 2024 — 8.36 Release Notes

  • Data lake updates

    • Cloning support for Snowflake-managed Apache Iceberg™ tables — Preview

  • Release notes change log

• September 18-20, 2024 — 8.35 Release Notes

  • SQL updates

    • RANGE BETWEEN support for FIRST_VALUE and LAST_VALUE functions

  • Extensibility updates

    • Telemetry data to the event table from Snowflake Notebook cells temporarily disabled
    • pandas on Snowflake - General Availability

  • Data lake updates

    • Apache Iceberg™ tables: Automated refresh — Preview

  • Release notes change log

• September 09-11, 2024 — 8.34 Release Notes

  • Data loading/unloading updates

    • The vectorized scanner option supports client-side encryption

  • Data pipeline updates

    • Dynamic tables: New DYNAMIC_TABLE_REFRESH_HISTORY account usage view
    • Tasks: Python and JVM support for serverless tasks - Preview

  • Release notes change log

• September 03-05, 2024 — 8.33 Release Notes

  • New features

    • Snowflake REST APIs — Preview

  • SQL updates

    • SHOW commands: Support for new WITH PRIVILEGES parameter

  • Data lake updates

    • Apache Iceberg™ tables: Catalog integration for Iceberg REST — Preview
    • Iceberg tables: Delta table support — Preview

  • Release notes change log

• August 26-30, 2024 — 8.32 Release Notes (with behavior changes)

  • Behavior change bundles

  • SQL updates

    • New SQL functions

  • Data pipeline updates

    • Tasks: A new option for ALTER TASK

  • Release notes change log

• August 19-21, 2024 — 8.31 Release Notes

  • Data lake updates

    • Snowflake Open Catalog: New system function for troubleshooting issues with syncing Snowflake-managed Apache Iceberg™ tables - Preview
    • Apache Iceberg™ tables: Support for time travel queries using third-party engines — General availability

  • Release notes change log

• August 11-14, 2024 — 8.30 Release Notes

  • New features

    • Outbound private connectivity with Azure External Network Access and External Functions — Preview
    • Full-text search - Preview

  • SQL updates

    • Setting users as SNOWFLAKE_SUPPORT users no longer supported
    • RANGE BETWEEN with explicit offsets: Additional window functions supported
    • UNDROP command: Support for restoring objects using ID
    • Wildcard filtering for functions

  • Data loading / unloading updates

    • Loading unstructured data with Document AI — Preview

  • Release notes change log

• August 07-08, 2024 — 8.29 Release Notes

  • Security updates

    • Session policies: Support added for secondary roles

  • Extensibility updates

    • Python user-defined aggregate functions — General availability
    • Access to Git repositories from Snowflake — General availability

  • Data lake updates

    • Apache Iceberg™ tables: Support for government regions — General availability

  • Release notes change log

• July 29-August 01, 2024 — 8.28 Release Notes

  • SQL updates

    • New SQL functions
    • CREATE and ALTER commands for replication and failover groups: Support added for tags
    • Account Usage: New SEARCH_OPTIMIZATION_BENEFITS view

  • Data governance updates

    • Object Tagging: Support added for replication and failover groups
    • Data Quality and data metric functions (DMFs) — General Availability

  • Data loading/unloading updates

    • Snowpipe: New output in SYSTEM$PIPE_STATUS

  • Data pipelines updates

    • Dynamic tables: Support for incremental lateral flatten

  • Data lake updates

    • Apache Iceberg™ tables: Support for Snowflake Open Catalog — Preview

  • Release notes change log

• July 22-25, 2024 — 8.27 Release Notes (with behavior changes)

  • Behavior change bundles

  • New features

    • Support for sending webhook notifications to Slack, Microsoft Teams, and PagerDuty
    • Triggered tasks — General availability

  • SQL updates

    • GET_DDL function: Support for warehouses

  • Data governance updates

    • Custom Data Classification — General availability
    • Data Classification of tables in a schema with Snowsight — General availability

  • Release notes change log

• July 15-17, 2024 — 8.26 Release Notes

  • New features

    • Estimate the cost of Automatic Clustering — Preview

  • SQL updates

    • New TYPE property for USER —— General availability

  • Extensibility updates

    • Access to external network locations on AWS in the Gov region — General availability

  • Cost management updates

    • Support for Snowpark Container Services in custom budgets — General availability

  • Release notes change log

• July 08-12, 2024 — 8.25 Release Notes

  • SQL updates

    • Wildcards are now supported in OBJECT constants

  • Release notes change log

• July 01-03, 2024 — 8.24 Release Notes

  • Security updates

    • Trust Center: CIS Benchmarks scanner package — General availability
    • Authentication policies: New multi-factor authentication parameters

  • Virtual warehouse updates

    • Hybrid tables: Changes to capacity quotas — Preview

  • Release notes change log

• June 17-30, 2024 — 8.23 Release Notes

  • Security updates

    • Trust Center: Security Essentials scanner package — General availability

  • SQL updates

    • Window functions: extended support for RANGE BETWEEN — Preview
    • Account Usage: TABLE_DML_HISTORY and TABLE_PRUNING_HISTORY views — General availability

  • Data governance updates

    • Data quality: add new system DMFs — Preview

  • Data pipelines updates

    • ALTER DYNAMIC TABLE command: Support for adding search optimization and setting additional properties

  • Snowflake Native App Framework

    • Updates to logging and tracing for a Snowflake Native App — Preview
    • New events generated during app installation and upgrade — Preview

  • Release notes change log

• June 10-15, 2024 — 8.22 Release Notes (with behavior changes)

  • Behavior change bundles

  • SQL updates

    • Some bitwise expression functions support BINARY data

  • Virtual warehouse updates

    • Account Usage: WAREHOUSE_EVENTS_HISTORY view — General availability

  • Release notes change log

• June 03-06, 2024 — Summit announcements

  • New features

    • Specify appearance in Snowsight — Preview
    • Snowflake Native SDK for Connectors — Preview
    • Snowflake Notebooks — Preview
    • Snowpark pandas API — Preview
    • Snowflake Cortex Fine-Tuning — Preview
    • Snowflake Native Apps with Snowpark Container Services — Preview
    • Apache Iceberg™ tables — General availability

  • Extensibility updates

    • Snowpark Python local testing framework — General availability

  • Snowsight updates

    • Universal Search — General availability

• May 28-30, 2024 — 8.21 Release Notes

  • New features

    • Triggered tasks — Preview

  • SQL updates

    • Email notification integrations no longer limited to 10
    • UNPIVOT supports rows with NULLs in results

  • Data loading / unloading updates

    • New Parquet file format option USE_VECTORIZED_SCANNER — General Availability

  • Streamlit in Snowflake updates

    • Support for v1.29.0 and v1.31.1 of the Streamlit library

  • Release notes change log

• May 20-22, 2024 — 8.20 Release Notes

  • New features

    • Trust Center — Preview

  • SQL updates

    • CREATE OR ALTER TABLE and CREATE OR ALTER TASK — Preview

  • Apache Iceberg™ table updates

    • Apache Iceberg™ tables — General availability
    • Replace invalid UTF-8 characters in Iceberg tables
    • Structured type evolution for Iceberg tables
    • Set a storage serialization policy
    • Change ALLOW_WRITES to FALSE for external volumes
    • New ICEBERG_ACCESS_ERRORS view

  • Release notes change log

• May 13-15, 2024 — 8.19 Release Notes

  • New features

    • Serverless alerts — Preview

  • Security updates

    • Tri-Secret Secure self-registration

  • SQL updates

    • Jinja2 template support for EXECUTE IMMEDIATE FROM — Preview

  • Data loading/unloading updates

    • Resolved a known issue for INCLUDE_METADATA copy option

  • Release notes change log

• May 08-09, 2024 — 8.18 Release Notes

  • SQL updates

    • Dynamic pivot available
    • Added support for structured data types in UDFs
    • New SQL functions

  • Extensibility updates

    • Python user-defined aggregate functions — Preview
    • Access to external network locations on AWS in the Gov region — Preview

  • Release notes change log

• April 30-May 07, 2024 — 8.17 Release Notes (with behavior changes)

  • Behavior change bundles

  • Security updates

    • Authentication enhancements — General Availability
    • Authentication policies
    • Identifier-first login flow
    • New properties for SAML2 security integrations
    • Multiple identity providers support

  • SQL updates

    • READ ONLY property available for tables
    • ST_INTERSECTION_AGG and ST_UNION_AGG functions — General Availability

  • Data loading /unloading updates

    • New copy option: INCLUDE_METADATA

  • Release notes change log

• April 22-24, 2024 — 8.16 Release Notes

  • SQL updates

    • New SQL command(s)
    • SQL API support for hybrid tables

  • Extensibility updates

    • Asynchronous job support in Snowpark stored procedures

  • Data Lake Updates

    • Apache Iceberg™ tables: Support for un-materialized identity partition columns

  • Release notes change log

• April 17-19, 2024 — 8.15 Release Notes

  • SQL updates

    • New SQL functions

  • Data loading / unloading updates

    • Support for granting the READ and WRITE privileges on external stages

  • Release notes change log

• April 08-15, 2024 — 8.14 Release Notes

  • New regions

  • Extensibility updates

    • Python UDTFs with vectorized process methods — General Availability

  • Snowflake Cortex updates

    • Forecasting improvements in Snowflake Cortex ML Functions

  • Release notes change log

• April 01-03, 2024 — 8.13 Release Notes

  • Snowflake Cortex updates

    • Evaluation Metrics for Forecasting and Anomaly Detection

  • SQL updates

    • Fixed an issue with the PARSE_IP function
    • Fixed an issue with the SPLIT_PART function

  • Extensibility updates

    • Access to Git repositories from Snowflake — Preview

  • Release notes change log

• March 26-27, 2024 — 8.12 Release Notes (with behavior changes)

  • Behavior Change Bundles

  • SQL Updates

    • Organization Usage: Improved views for billing reconciliation — General Availability

  • Data Pipeline Updates

    • Replication: Stages, pipes, storage integrations, load history, and Snowpipe Streaming — General Availability
    • Schema detection and evolution for Kafka connector with Snowpipe Streaming — General Availability

  • Data Governance Updates

    • Memoizable functions with constant arguments
    • Share data protected by a role-based policy — General Availability
    • Access History: Stored procedure ancestor queries — General Availability
    • Shared tag references — General Availability
    • Access History: Track objects modified by a DDL operation — General Availability

  • Release Notes Change Log

• March 18-20, 2024 — 8.11 Release Notes

  • SQL updates

    • SELECT supports trailing commas

  • Data loading / unloading Updates

    • Performance improvements for loading JSON files
    • Improvements to the SNOWPIPE_STREAMING_CLIENT_HISTORY view

  • Release notes change log

• March 04-05, 2024 — 8.9 Release Notes

  • Non-bundled Behavior Changes

  • Data Governance Updates

    • Custom Classification — Preview

  • Data lake updates

    • Primary key information added to Apache Iceberg™ table metadata

  • Release Notes Change Log

• February 26-28, 2024 — 8.8 Release Notes

  • Data Lake Updates

    • Secure Data Sharing for Apache Iceberg™ tables
    • Query an Apache Iceberg™ table without granting the USAGE privilege on related objects

  • Extensibility Updates

    • External network access — General Availability

  • Release Notes Change Log

• February 19-21, 2024 — 8.7 Release Notes (with behavior changes)

  • Behavior Change Bundles

  • SQL Updates

    • SQL Functions Add Support for the upper, lower, and trim Collation Specifiers

  • Data Lake Updates

    • GET_DDL for external tables supports fully-qualified location names

  • Release Notes Change Log

• February 12-14, 2024 — 8.6 Release Notes

  • SQL Updates

    • New SQL functions

  • Data Loading / Unloading Updates

    • Specify an external ID for AWS storage access

  • Release Notes Change Log

• February 05-06, 2024 — 8.5 Release Notes

  • Security Updates

    • External API authentication and secrets — General Availability

  • Extensibility Updates

    • External network access — General Availability
    • Python packages policies — General Availability

  • Data Loading / Unloading Updates

    • COPY FILES — Preview

  • Data Governance Updates

    • Data Classification: Asynchronous tag assignments for columns of tables in a schema and automate tagging for a single classification event — Preview

  • Release Notes Change Log

• January 29-30, 2024 — 8.4 Release Notes

  • Security Updates

    • Authentication enhancements — Preview
    • Authentication policies
    • Identifier-first login flow
    • Multiple identity providers support
    • New properties for SAML2 security integrations

  • Virtual Warehouse Updates

    • Larger warehouses — General Availability in Microsoft Azure Regions

  • Extensibility Updates

    • External network access — Preview
    • Java 17 support — Preview

  • Data Loading / Unloading Updates

    • Snowpipe update: a new pipe status

  • Data Pipeline Updates

    • Automatic task graph retry — General Availability

  • Release Notes Change Log

• January 22-23, 2024 — 8.3 Release Notes

  • Security Updates

    • Network rules — General Availability
    • Enhanced network security — General Availability
    • Network isolation to internal stages using AWS PrivateLink — General Availability

  • Release Notes Change Log

• January 15-17, 2024 — 8.2 Release Notes (with behavior changes)

  • Behavior Change Bundles

  • New Features

    • Access History: Support added for stored procedure ancestor queries — Preview

  • Release Notes Change Log

• January 08-10, 2024 — 8.1 Release Notes

  • New Features

    • EXECUTE IMMEDIATE FROM File — General Availability

  • SQL Updates

  • New SQL functions

  • Extensibility Updates

    • Support for Python 3.11 in Snowpark, UDFs, UDTFs and stored procedures — General Availability

  • Release Notes Change Log

• January 03-04, 2024 — 8.0 Release Notes

  • Extensibility Updates

    • Account Usage: New EXTERNAL_ACCESS_HISTORY View

  • Data Collaboration Updates

    • Organization Usage: New LISTING_AUTO_FULFILLMENT_USAGE_HISTORY View

  • Release Notes Change Log