Syntax

DOWNLOAD PERSONAL FILE '<filename>' 
    [ TO '<local_path>' ]
    [ OVERWRITE ]
    [ ENCODING '<encoding>' ]

Arguments

• filename: The name of the file in the personal space.

• local_path: Specifies the download path in the local directory.

• encoding: The encoding applied to the downloaded file.

Remarks

• If the OVERWRITE clause is specified, any existing file with the same name at the specified download path is overwritten.

• By default, files are downloaded with the binary encoding. Specify the ENCODING clause and omit the TO clause, to view the contents of the file on the standard output.

• If the TO <local_path> clause is not specified, the file is displayed on the standard output.

Examples

• The following command displays the contents of a file named stats.csv in the personal space on the standard output:

  SQL

  Copy

  DOWNLOAD PERSONAL FILE 'stats.csv' ENCODING 'utf8'; 

• The following command downloads the file to a specific location in the local storage:

  SQL

  Copy

  DOWNLOAD PERSONAL FILE 'stats.csv' 
     TO '/tmp/stats.csv'
     OVERWRITE
     ENCODING 'utf8'; 

  If the /tmp/stats.csv file exists in the local storage, it is overwritten.