ALTER VOLUME

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 13.2 and later check marked yes Unity Catalog only

Alters the name or owner of a volume.

Syntax 

ALTER VOLUME volume_name
      { RENAME TO new_volume_name |
        [ SET ] OWNER TO principal }

Parameters

  • volume_name

    The name of the volume to be altered.

  • RENAME TO new_volume_name

    Renames volumne_name to new_volume_name. The new name must be unique and the schema must not change.

  • [ SET ] OWNER TO principal

    Transfers ownership of the volume to principal.

    SET is allowed as an optional keyword.

Examples 

- Change the owner of the volume `my_volume`
> ALTER VOLUME my_volume SET OWNER TO alf@melmak.et
  OK

- Change the name of the volume from `my_volume` to `new_name_volume`
> ALTER VOLUME my_volume RENAME TO new_name_volume
  OK