Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

UPLOAD FILE TO STAGE

Syntax

UPLOAD FILE TO STAGE '<stage_path>'
    [ { IN GROUP { ID '<deployment_ID>' | '<deployment_name>' } | IN { ID '<deployment_ID>' | '<deployment_name>' } } ]
    FROM '<local_path>' [ OVERWRITE ]

Arguments

stage_path: The path in the Stage where the file is uploaded. It must end with a trailing /.
deployment_ID, deployment_name: The ID or name of the deployment (cluster group) in which the Stage is attached.
local_path: Specifies the path to the file in the local directory.

Remarks

If the OVERWRITE clause is specified, any existing file with the same name at the specified path is overwritten.
The IN and IN GROUP clauses specify the ID or the name of the deployment in which the Stage is attached.

Example

The following command uploads a file to the Stage attached to the deployment named s2-group and overwrites any existing files with the same name at the specified path:

SQL

UPLOAD FILE TO STAGE '/data/stats.csv' IN 's2-group'
FROM '/tmp/stats.csv' OVERWRITE;