PUT INTO

Applies to: Databricks SQL Connector

Put a local file into a volume.

note

This statement is only available in the Databricks SQL Connector or when connecting to Databricks using a driver. It cannot be submitted from the UI.

Syntax

PUT localfile_path INTO volume_path [ OVERWRITE ]

localfile_path

A STRING literal with the path of the local file.
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>
OVERWRITE

If specified, overwrite an existing file in the volume with the new file. If not specified, return an error if the file already exists.

SQL
> PUT '/home/bob/data.csv' INTO '/Volumes/test_catalog/test_schema/test_volume/2023/06/file1.csv' OVERWRITE