Server releases and feature updates in 2024¶

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

Server releases in 2024
Feature updates in 2024

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

Server releases in 2024¶

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

Feature updates in 2024¶