What's New in Version 2025.8.4-d86e019

This release includes important performance improvements and enhancements to the Snowflake native app installation process and internal storage cleanup reliability.

Note that RelationalAI Native App upgrades are applied automatically and require no action on your part, unless you have disabled automatic upgrades. One exception this week is a manual migration step required to take advantage of new performance improvements.

New Features and Enhancements

• We’ve migrated the RAI Native App to a new internal data format that significantly improves query performance! The new data format will allow us to dramatically reduce the compilation time, also called warmup time, that our logic engines require to process queries.

  Benefits include:

  • Up to 50–80% reduction in query warmup time.
  • Faster and more responsive developer experience.
  • From our internal testing we have seen that on TPC-H scale factor 1, these changes reduced cold runtime from ~200s to ~80s.

  Beginning with the next release, all new installations will use this new format. We’re asking all existing users to manually migrate their app to this new format to take advantage of these performance improvements. See the Migration Guide for step-by-step instructions.

  Note

  We’re confident this upgrade will significantly improve your experience with the RelationalAI Native App, and we appreciate your support in making this transition smooth. Please reach out to us at support@relational.ai if you have any questions about this upcoming change.

• The RAI Native App now uses Snowflake Manifest Version 2, which enables automatic privilege management. All Snowflake privileges required by the app are granted automatically during installation, so manual grants are no longer needed.

  Existing installations already have the necessary privileges, so no action is needed for current users. This change mainly affects new installations.

  Note that after this change, the privileges granted to the app cannot be revoked, even if you installed the app before this release. See the Installation guide for more details.

Bug Fixes

• A one-time full storage vacuum (BlobGC) pass will run automatically in all accounts during this upgrade to repair any previously corrupted storage state caused by a past bug that could prevent storage cleanup from running correctly. This repair is applied automatically with no user action needed.

Migration Guide

We recommend performing the migration during a maintenance window or when your app is not in active use.

During the migration:

• The RAI Native App will be taken offline for a few minutes while the migration steps are performed.
• All existing streams will be deleted and re-created. You will incur standard Snowflake costs for setting up the streams.
• All data loaded via streams will be wiped and re-ingested.

To migrate your app to the new data format:

1. First, delete any old or unused CDC streams that do not need to be migrated. This will reduce the amount of data that needs to be migrated and speed up the process. See Delete a Data Stream for instructions.

2. Next, execute the following SQL as an app admin (or ACCOUNTADMIN) to begin the migration:

   CALL relationalai.api.upgrade_storage_format_with_downtime('1');

   This will block for a few minutes while the app is taken offline and the migration steps are prepared. When it returns, the migration steps will be completed, and the CDC rebuilding process will have begun.

3. Use the following SQL to poll for CDC rebuilding status:

   CALL relationalai.api.show_storage_upgrade_status();

   You can resume your ordinary workloads at any time during CDC rebuilding, and they will simply block until the data is loaded, per normal RAI data stream behavior.

Note that running the migration on an already migrated account will produce an error message and is otherwise a noop.