To create a VAST database via VAST Web UI:
-
From the left navigation menu, choose DataBase -> VAST DB.
-
In the VAST DB page that opens, click the + New Database button.
-
In the New Database dialog, fill in the fields:
Field
Description
Database Name
Enter a name for the database. The name must meet the requirements for S3 bucket names.
Path
Enter a path for the database.
Policy name
Select a S3 policy from the dropdown list.
Database owner
Specify a database owner user.
-
Click Create.
The newly created database is displayed in the database tree.
To create a database via VAST CLI, use the schema create command. The database is created together with a schema.
Deleting a database involves deleting all database schemas together with tables and deleting the database view.
-
From the left navigation menu, choose DataBase -> VAST DB.
-
In the database tree, click the schema you want to delete and choose Delete in the actions menu.
Repeat this step for all schemas in the database that you want to delete.
-
From the left navigation menu, choose Element Store -> Views.
-
Find the database view in the list of Element Store views and choose Remove in its actions menu.
Deleting a database involves deleting all database schemas together with tables and deleting the database view.
-
Run the
schema listcommand to get the ID(s) of the schema(s) in the database you want to delete. -
Delete the database schema(s) with the
schema deletecommand. -
Run the
view listcommand to get the ID of the database view. -
Delete the database view using the
view delete --id IDcommand.
To create a database schema via VAST Web UI:
-
From the left navigation menu, choose DataBase -> VAST DB.
-
In the VAST DB page that opens, select the database for which you want to create a schema and click the + Add Schema button.
-
In the Add Schema dialog, enter a name for the schema. The name must meet the requirements for S3 object names.
-
Click Create.
The newly created schema is added to the database and displayed in the database tree.
To rename a database schema via VAST Web UI:
-
From the left navigation menu, choose DataBase -> VAST DB.
-
In the VAST DB page that opens, select the schema you want to rename and click
to the right of the schema name.
-
Type a new name for the schema. The name must meet the requirements for S3 object names.
-
Click Save.
The schema is displayed in the database tree under the new name.
To delete a database schema via VAST Web UI:
-
From the left navigation menu, choose DataBase -> VAST DB.
-
In the VAST DB page that opens, select the schema you want to delete and choose Delete from the Actions menu.
-
Confirm the action in the confirmation prompt.
The schema is deleted from the database together with the tables contained in it.
Use the following commands to manage VAST database schemas:
|
Action |
Command |
|---|---|
|
List schemas |
|
|
Create a schema |
|
|
Rename a schema |
|
|
Delete a schema |
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.
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 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.
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
-
Type a new name for the table. The name must meet the requirements for S3 object names.
-
Click Save.
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.
Use the following commands to manage VAST database tables:
|
Action |
Command |
|---|---|
|
List tables |
|
|
Create a table |
|
|
Rename a table |
|
|
Delete a table |
With VAST Web UI, you can add, modify and remove columns in VAST database tables.
-
From the left navigation menu, choose DataBase -> VAST DB.
-
In the VAST DB page that opens, navigate to the table you want to modify by clicking the database, the schema and the table name in the database tree.
-
In the table page that opens, manage table columns as necessary:
-
To add one or more columns:
-
Click + Add Column.
-
In the Add Column popup that opens, 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.
-
-
If necessary, add more columns with the + Add Column button.
-
Click Create.
-
-
To rename a column, select it and click the Edit button in the Actions column. In the Column name field that appears above the list of columns, type a new name for the column and click Save.
-
To delete a column, select it and click the Delete button in the Actions column.
-
Use the following commands to manage columns in VAST database tables:
|
Action |
Command |
|---|---|
|
List table columns |
|
|
Add one or more columns |
|
|
Rename a column |
|
|
Delete a column |
Comments
0 comments
Article is closed for comments.