Opening a View
Graphical window for creating a GeminiDB Cassandra view is not available. To create a view, execute SQL statements in the SQL window. For details, see Executing SQL Statements.
After a view is created, you can open the view on the DAS console and view data in it.
Precautions
GeminiDB Cassandra views cannot be edited.
Procedure
- Click
in the upper left corner and select a region and project. - Click
in the upper left corner, and under Databases, click Data Admin Service. - In the navigation pane on the left, choose Development Tool.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Keyspace Management.
- Click Change Keyspace on the right of the current keyspace to switch to the keyspace where you want to open a view.
- On the displayed Objects tab, choose Views on the left. In the table list, locate the view you want to open, and click Open in the Operation column.
- On the displayed page, obtain details of the view. You can also perform the operations listed in Table 1.
Table 1 UI operations Name
Description
Where Condition
Filters records.
Copy Column
Allows you to copy all data in a column by selecting this column from the Copy Column drop-down list.
Column Settings
Allows you to set the columns you want to display.
Refresh
Allows you to update table data manually.