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:
Field | Description |
|---|---|
Status | Status of the warehouse: • Creating, Create Failed, Create Error Analysis • Starting, Start Failed • Running • Scaling, Scaling Failed • Stopping, Stopped, Stop Failed • Deleting, Deleted, Delete Failed • Unknown |
Storage | AWS: The amount of AWS S3 storage available in the warehouse. ] Azure: The Authentication mechanism that Actian 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 Actian is located and the credentials that are generated must be supplied to Actian so that it can access and load the data. For more information, see Set Up Microsoft Azure Access. ] Google Cloud: Google Cloud Storage. ] |
Compute | Number of Actian units (AUs) in the warehouse. |
Region | 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. For more information, see Automatic Stopping of Idle Warehouses or Databases. 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:
• Connections page – Access Warehouse or Database Connection Information
• Monitoring page – Monitor Warehouses (currently not available for Google Cloud warehouses)
• Query Editor page – Query Editor
Last modified date: 12/12/2024