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
  - 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
- SQL updates
- 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
- 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
- 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
- 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
- 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
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
- 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
- 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
- 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
- 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 11-12, 2024 — 8.10 Release Notes (no announcements)
- Announcements
- 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
- 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
- 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
  - CREATE <object> … CLONE command: New parameter
- 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