In the Athena console, you can:
-
Locate all views in the left pane, where tables are listed.
-
Filter views.
-
Preview a view, show its properties, edit it, or delete it.
To show the actions for a view
A view shows in the console only if you have already created it.
-
In the Athena console, choose Views, and then choose a view to expand it and show the columns in the view.
-
Choose the three vertical dots next to the view to show a list of actions for the view.
-
Choose actions to preview the view, insert the view name into the query editor, delete the view, see the view's properties, or display and edit the view in the query editor.
Supported DDL actions for Athena views
Athena supports the following management actions for views.
| Statement | Description |
|---|---|
| CREATE VIEW and CREATE DIALECT VIEW |
Creates a new view from a specified The optional |
| DESCRIBE VIEW |
Shows the list of columns for the named view. This allows you to examine the attributes of a complex view. |
| DROP VIEW |
Deletes an existing view. The optional |
| SHOW CREATE VIEW |
Shows the SQL statement that creates the specified view. |
| SHOW VIEWS |
Lists the views in the specified database, or in the current
database if you omit the database name. Use the optional
|
| SHOW COLUMNS |
Lists the columns in the schema for a view. |
