Actian Warehouse Release Notes¶

Add Auth0 capabilities for logging into the Actian Data Platform.

Updates for GCP, Azure, and AWS.

Updates for GCP, Azure, and AWS.

Updates for GCP, Azure, and AWS.

New APIs to manage the automation of warehouse updates, such as showing updates available for a given warehouse, showing next update applied, setting versioning of update, and triggering an update to a version.

Please see Swagger documentation for the Actian Data Platform.

New APIs to manage the automation of warehouse updates, such as showing updates available for a given warehouse, showing next update applied, setting versioning of update, and triggering an update to a version.

Please see Swagger documentation for the Actian Data Platform.

Updates to cloning an Actian warehouse and monitoring warehouse usage. Please see Actian Warehouse Clone and to the Monitor AU Usage.

Updates to cloning an Actian warehouse and monitoring warehouse usage. Please see Actian Warehouse Clone and to the Monitor AU Usage.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Dynamic scaling enables warehouses to scale up or down in size without a restart. This enables you to adjust resources available to a warehouse without interrupting workloads. This feature is only available in a 620.x or above warehouse. Any existing 610.x-based warehouses need to upgrade to enable this new feature.

Note: Upgrading your warehouse to enable dynamic scaling requires a support ticket. New warehouses use 620.x warehouses by default.

For more information, see Scale a Warehouse

The architecture for Avalanche is updating for AWS. AWS AV-2 is a distinction that the architecture has been refreshed for AWS and it supports the same features as Google Cloud. AWS AV-1 is still supported, meaning customers that have warehouses built on AWS AV-1 are keeping the legacy functionality without being forced to go to the AV-2 functionality. When there are differences in the architecture, the documentation will note AWS AV-1 versus AWS AV-2.

You can create a new warehouse with data at rest encryption through Key Management Services (KMS). For more information, see Set Up Key Management Service for Data Encryption.

The database engine is updated to 6.1.30110.

Backend fixes and improvements were made.

The database engine is updated to 6.1.30108.

Enhance users ability to save, import, and export queries to and from their local system. For more information, see Save an Existing Query as a New Query, Import Queries, Export an Open Query, and Export All Queries from Saved Queries or Query History.

Enhance monitoring of Avalanche with new service checks to assist Support diagnostics.

The database engine is updated to 6.1.30107.

The Warehouse Details page is updated with a new menu on the left side of the page. For more information, see Warehouse Details.

The ability to create database instances is added to Avalanche.

Instructions on adding SSO users is updated at Add SSO Users.

The database engine is updated to 6.1.30105.

Backend fixes and improvements were made.

Backend fixes and improvements were made.

Account Administrators may monitor AU usage using the Administration interface. For more information, see Monitor AU Usage.

A new status, “Backing Up,” is added. For more information, see Warehouse Details and Automated Backup Process.

Nine monitoring tables from the imadb database are available for querying to those with useradmin profiles:

• ima_dbms_server_status

• ima_gca_connections

• ima_locklists

• ima_locks

• ima_log_transactions

• ima_resources

• ima_server_sessions

• ima_server_sessions_query

• ima_server_sessions_extra

For more information, see Working with Monitoring (imadb) Tables.

A Recurrence interval of “Schedule Once” is added to warehouse scheduling. For more information, see Schedule a Warehouse.

Backend fixes and improvements were made.

The database engine was updated to 6.1.30104.

Two new monitoring capabilities are added: Cluster CPU Load and Execution Memory. For more information, see Cluster CPU Load and Execution Memory.

Long-running queries are now terminated after 24 hours. For more information, see Query Editor Troubleshooting.

The database engine was updated to 6.1.30102.

You may now scale warehouses up or down while they are running. For more information, see Scale a Warehouse.

The database engine was updated to 6.1.30101.

The login page now supports logging in to Avalanche using your Actian ID or your organization’s Single-Sign-on credentials. For more information, see Log In.

You can now modify the idle stop period for Google Cloud warehouses. For more information, see Modify Idle Stop Period (Google Cloud Only).

Idle stop now supports periods of 15 and 30 minutes. For more information, see Create a Warehouse.

You can open a service request with Actian Support on the Administration page. For more information, see Open a Service Request. If you are an administrator, you may contact Actian Support directly; see Contact Support.

The database engine was updated to 6.1.0-30101.

Google Cloud Platform is now supported. For more information, see Set Up Google Cloud Access.

The Query Editor was redesigned for a better user experience. For more information, see Using the Query Editor.