View SQL Grammar

View objects support the listed SQL grammar for DDL workloads.

Oracle AI Data Platform Workbench supports all standard Spark SQL data types. For more information, see Apache Spark Documentation - Supported Data Types.

Operation Grammar

Create View CREATE VIEW [IF NOT EXISTS] <<catalog_name.schema_name.view_name>> as select ... from table[TBLPROPERTIES ( DESCRIPTION = 'some-description', '<property-name>'='<property-value>'[, ...]) ]

Alter View (Coming Soon)

Rename view

ALTER VIEW <schema-name>.<old_view_name> RENAME TO <schema-name>.<new_view_name>

Change view description

ALTER VIEW <schema-name>.<view_name> set TBLPROPERTIES (DESCRIPTION = 'some-description)

Delete View DROP VIEW [IF EXISTS] <<catalog_name.schema_name.view_name>>

List Views

SHOW VIEWS FROM
                                <<catalog_name.schema_name>>

Response:

Attribute	Type
Catalog	Catalog name
Schema	Schema name
View	View name

Describe a view

DESCRIBE VIEW
                                <<catalog_name.schema_name.view_name>>

Response :

Attribute	Value
Catalog	Catalog name
Schema	Schema name
View	View name
Description	View description
View Definition	View creation grammar
Created by	User that created the view
Created on	Date and time view was created