REMOVE
Applies to: Databricks SQL Connector
Remove a file from a volume.
Note
This statement is only available in the Databricks SQL Connector. It cannot be submitted from the UI.
Syntax
REMOVE volume_path
Parameters
volume_path
A
STRING
literal with the path of the volume.volume_path
must be in the format:/Volumes/<catalog>/<schema>/<volume>/<path>/<file_name>
, ordbfs:/Volumes/<catalog>/<schema>/<volume>/<path>/<file_name>
Examples
> REMOVE '/Volumes/test_catalog/test_schema/test_volume/2023/06/file1.csv'