In this release (Release 2025.10.30), we are introducing a set of new features, enhancements, and bug fixes. These updates will be rolled out progressively across the regions listed below. The full rollout is expected to complete within one to two weeks from the release date, depending on your region.

Global Regions

• Alibaba Cloud (Singapore)
• AWS (Singapore)

China Regions

• Alibaba Cloud (Shanghai)
• Tencent Cloud (Shanghai / Beijing / Guangzhou)
• Amazon Web Services (Beijing)

SQL Updates

Enhanced Incremental Computation Capabilities:

• Dynamic Table: Now supports refreshing by arbitrary partitions, improving flexibility and efficiency in data processing. [Reference Link]

New Data Type Support:

• BITMAP Data Type: Comprehensive support for the BITMAP data type is now available. This delivers significant performance improvements and storage optimization for precise distinct counting on large-scale datasets (e.g., UV statistics) and user profile analysis (e.g., cohort selection).

New Built-in Functions:

• trans_array: Designed for efficient handling of nested arrays. It replaces complex split + explode operations, simplifying data processing logic.
• regexp_instr: A new regular expression matching function that locates the position of a pattern within a string, compatible with Spark.
• regexp_count: A new regular expression counting function that calculates the number of times a pattern appears within a string.

Syntax and DDL/DML Enhancements:

• QUALIFY Clause: Now supported for filtering the results of window functions directly within SELECT statements.

• Command Extensions:

  • DESC CATALOG: The output now includes a connection_name field for easier identification and management.
  • DESC FUNCTION: Now supports displaying function comments, improving readability and usability.

• Function Extension: The EXTRACT function now supports the QUARTER date part, facilitating easier date and time analysis by quarter.

• SHOW Command Enhancement: Support added for SHOW PIPES IN WORKSPACE <workspace_name>, allowing users to list all PIPE objects within the current workspace.

AI Updates

• [Private Preview] Semantic View: We have officially launched the creation capability for "Semantic View." Semantic View is designed to encapsulate complex underlying physical data models into semantic concepts—such as dimensions and metrics—that are easily understood by business users. This feature is currently in Private Preview.

• Lakehouse MCP Server Enhancements:

  • To improve the efficiency of developing and debugging AI-related features, we have expanded the number of local MCP Server tools to 63. This allows users to interact with and manage the Lakehouse more efficiently and comprehensively when connecting via an MCP client.

Data Openness

Comprehensive Enhancement of Iceberg Ecosystem Bi-directional Integration: This update fully bridges connections with the external Iceberg ecosystem, significantly enhancing platform openness and data federation capabilities.

• Standard Iceberg REST Catalog Service - for Outbound Data Access: The Lakehouse now provides standard Apache Iceberg Catalog REST API interfaces. This means external compute engines (such as Apache Spark) can directly access and query Iceberg tables stored in the Lakehouse via this industry-standard protocol. Users can maintain unified data storage while flexibly choosing different compute engines for analysis.
• Access External Catalogs via Iceberg REST - for Inbound Data Access: Through external Catalog integration, the Lakehouse can now connect to and access Iceberg tables in systems like Snowflake OpenCatalog. Users can seamlessly query and analyze data stored within the Snowflake ecosystem directly from the Lakehouse, enabling cross-cloud and cross-platform federated queries.

Functional Improvements

Data Ingestion: Command Enhancements

• COPY OVERWRITE: Now supports outputting query results directly into a single file. This simplifies the data export process, particularly for scenarios requiring the archiving or delivery of analysis results.

User Self-Service & Workspace Management

• BYOS Self-Configuration: For BYOS (Bring Your Own Storage) scenarios, we have launched a self-service whitelist configuration process, reducing onboarding and management overhead for users.