GET

Applies to: Databricks SQL Connector

Get a file from a volume to your local storage.

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

GET volume_path TO localfile_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>

• localfile_path

  A STRING literal with the path of the local file.

Examples

> GET '/Volumes/test_catalog/test_schema/test_volume/2023/06/file1.csv' TO '/home/bob/data.csv'

Related statements

• ALTER VOLUME
• CREATE VOLUME
• DESCRIBE VOLUME
• DROP VOLUME
• SHOW VOLUMES
• PUT INTO
• REMOVE
• Volumes