Was this helpful?
Warehouse Details
Clicking the warehouse name in the list of warehouses displays details about the warehouse on the Warehouse Details page.
The following are the fields and controls on the Warehouse Details page:
Status of the warehouse:
Creating, Create Failed, Create Error Analysis
Starting, Start Failed
Scaling, Scaling Failed
Stopping, Stopped, Stop Failed
Deleting, Deleted, Delete Failed
AWS: The amount of AWS S3 storage available in the warehouse.  ] 
Azure: The Authentication mechanism that Avalanche supports to ingest data from a general-purpose v2 storage account is through Azure Active Directory using a service principal.
The instructions in this section are intended to be performed in the Azure subscription, where the source data for Avalanche is located and the credentials that are generated must be supplied to Avalanche so that it can access and load the data.
For more information, see Set Up Microsoft Azure Access.  ] 
Google Cloud: Google Cloud Storage.  ] 
Number of Avalanche units (AUs) in the warehouse.
Azure: You can scale the size of Azure warehouses; for more information, see Scale Warehouses or Databases (Azure and Google Cloud Only).  ] 
Geographical location of the warehouse
Warehouse ID
Unique ID of the created warehouse. If you encounter a problem, Actian Support will need this ID.
Warehouse Version
The version number of the warehouse in the format major.minor.patch. For more information about features in a particular warehouse version, see What’s New in Avalanche.
IP Allow List
Displays the Allow List IP addresses for warehouse access. Clicking the Show IP Labels toggle shows or hides text labels for the listed IP addresses:
To add or remove IP addresses, see Update Allow List IP Addresses.
Idle Stop
Amount of time set before the warehouse is set to the stopped state after no database (query) activity. This time period was set at warehouse creation. Idle stop cannot be disabled in a non-production environment.
Note: Idle stop is currently not available for Google Cloud warehouses.
External Table Access
Lets you set storage account authentication by entering environment credentials. For more information, see Grant Access to Warehouse or Database for External Tables Access.
Connection Password
Lets you set or reset the password for dbuser to connect to the warehouse. For more information about the dbuser, see Set the dbuser Connection Password. If you have not set the password, do so now. The dbuser is a member of the dbadmingrp by default; for more information, see Types of Users.
Note: Setting service account credentials is currently not available for Google Cloud warehouses. You must set it using SQL through the Query Editor. For more information, see Add Native Users.
Created By
Date and time of warehouse creation
Last Modified By
Date and time warehouse was last modified
More information:
Monitoring page – Monitor Warehouses (currently not available for Google Cloud warehouses)
Query Editor page – Query Editor
Last modified date: 05/15/2024