Volume SQL Grammar

Volume 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.

Table 22-3 Volume SQL Grammar

Operation	Grammar
Create volume	CREATE [ EXTERNAL ] VOLUME [IF NOT EXISTS ] <<catalog_name.schema_name.volume_name>> [ LOCATION location_path ] [ PROPERTIES (DESCRIPTION = description ) ]
Alter volume properties	ALTER VOLUME <<volume_name>> { RENAME TO <<new_volume_name>> | [ set properties (DESCRIPTION = description) ] }
Drop volume	DROP VOLUME [ IF EXISTS ] <<volume_name>> OR DROP VOLUME <<catalog_name>>.<<schema_name>>.<<volume_name>> By default during DROP volume, all child objects will also get deleted
List Volumes	SHOW VOLUMES [ { FROM | IN } catalog_name.schema_name ] [ [ LIKE ] regex_pattern } ]
Describe Volume	DESCRIBE VOLUME volume_name Attribute Value Catalog name Catalog name Schema name Schema name Volume name Volume name Description User defined description of volume Location Location in catalog Volume type Type of volume Error: Error: <<SQL Command>> failed due to <<reason>>