Creating a Table via VAST Web UI
To create a database table via VAST Web UI:
From the left navigation menu, choose DataBase -> VAST DB.
In the VAST DB page that opens, select the database and the schema where you want to create a table. Then click the + Add Table button.
In the Add Table dialog, enter a name for the table in the Table Name field. The name must meet the requirements for S3 object names.
Under Columns, add columns to the table as follows:
To create a column, specify a name for the column in the Name field and select a data type from the Column Type dropdown.
Column naming requirements are the same as for S3 object names.
Depending on the data type you selected, you may need to complete additional fields as follows:
For the Decimal 128 data type, specify the (the number of significant digits in a decimal) and the Scale (the number of digits after the decimal point).
For the Timestamp data type, specify the time Unit.
For the List data type, select a data type for the list items from the Item Type dropdown.
For the Map data type, select a data type for the key from the Key Type dropdown and for the value from the Value Type dropdown.
For the Struct data type, use the + Add Struct Column button to add as many nested columns as you need.
Note
For information about data types supported by VAST Database, see Supported Data Types.
Add more columns with the + Add Column button.
Click Create.
The newly created table is added to the schema and displayed in the database tree.
Viewing a Table via VAST Web UI
To view a VAST database table, choose DataBase -> VAST DB and navigate to the table you want to view by clicking the database, the schema and the table name in the database tree.
For each table, the following information is displayed:
Created on: The date and time when the table was created.
Rows: The number of rows in the table.
Size: The table's logical size.
A list of table columns with indication of the following for each column:
Column name
Nested columns, if any (for data types that imply nesting)
Data type name
Unit of measurement, precision and scale, where applicable
The table page lets you rename or delete an existing table, and also manage table columns.
Renaming a Table via VAST Web UI
To rename a database table via VAST Web UI:
From the left navigation menu, choose DataBase -> VAST DB.
In the VAST DB page that opens, navigate to the table you want to rename by clicking the database, the schema and the table name in the database tree.
In the table page that opens, click
.png?sv=2022-11-02&spr=https&st=2026-02-09T12%3A24%3A11Z&se=2026-02-09T12%3A37%3A11Z&sr=c&sp=r&sig=EoaGCvMC7TqAvpmfbkNJjiLfOxz4FOkKAN6WTHdBu3g%3D)
to the right of the table name.Type a new name for the table. The name must meet the requirements for S3 object names.
Click Save.
Deleting a Table via VAST Web UI
To delete a database table via VAST Web UI:
From the left navigation menu, choose DataBase -> VAST DB.
In the VAST DB page that opens, navigate to the table you want to delete by clicking the database, the schema and the table name in the database tree.
In the table page that opens, choose Delete from the Actions menu.
Confirm the action in the confirmation prompt.
The table is deleted from the database.
Managing Tables via VAST CLI
Use the following commands to manage VAST database tables:
Action | Command |
|---|---|
List tables | |
Create a tables | |
Rename a table | |
Delete a table | |
Show details for a table |