REMOVE

Applies to: check marked yes 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>, or

    • dbfs:/Volumes/<catalog>/<schema>/<volume>/<path>/<file_name>

Examples 

> REMOVE '/Volumes/test_catalog/test_schema/test_volume/2023/06/file1.csv'