Database Details
Clicking the database name in the list of databases displays details about the database on the Database Instance Details page.
The following are the fields and controls on the Database Instance Details page:
Field | Description |
|---|---|
Status | Status of the database: • Creating, Create Failed, Create Error Analysis • Starting, Start Failed • Running • Scaling, Scaling Failed • Stopping, Stopped, Stop Failed • Deleting, Deleted, Delete Failed • Unknown |
Storage | The amount of storage available in the database. |
Compute | Number of Avalanche units (AUs) in the warehouse. You can scale the size of databases; for more information, see Scale Warehouses or Databases (Azure and Google Cloud Only). |
Region | Geographical location of the database |
Database ID | Unique ID of the created database. If you encounter a problem, Actian Support will need this ID. |
Warehouse Version | The version number of the database 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 database 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 database is set to the stopped state after no database (query) activity. This time period was set at database creation. Idle stop cannot be disabled in a non-production environment. For more information, see Automatic Stopping of Idle Warehouses or Databases. |
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. |
DB Admin Access | Lets you upload an RSA public key (code or external .json file) to connect to the database. The database owner is a member of the dbadmingrp by default; for more information, see Types of Users. |
Change Log | • Displays the date and time of database creation • Displays the date and time the database was last modified |
Next Step  | If you have created a warehouse for the first time, we recommend that you access Query Editor and start running sample queries. Go to Launch Query Editor. |
Last modified date: 01/04/2024