Categories:: File functions

GET_RELATIVE_PATH¶

Extracts the path of a staged file relative to its location in the stage using the stage name and absolute file path in cloud storage as inputs.

Syntax¶

GET_RELATIVE_PATH( @<stage_name> , '<absolute_file_path>' )

Copy

Arguments¶

stage_name: Name of the internal or external stage where the file is stored.

Note

If the stage name includes spaces or special characters, it must be enclosed in single quotes (e.g. '@"my stage"' for a stage named "my stage").
absolute_file_path: Stage location, including the path and filename, of the file in cloud storage.

Returns¶

Path of the file relative to the stage location.

Usage notes¶

This SQL function returns a value for any role that has the following privilege on the stage:

External stage:

USAGE

Internal stage:

READ

If files downloaded from an internal stage are corrupted, verify with the stage creator that ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE') is set for the stage.

Examples¶

Retrieve the relative path of a bitmap format image file in an external stage, where the @images_stage stage references the s3://photos/national_parks/ bucket and path:

SELECT GET_RELATIVE_PATH(@images_stage, 's3://photos/national_parks/us/yosemite/half_dome.jpg');
+================================================================================---------------------+
| GET_RELATIVE_PATH(@IMAGES_STAGE, 'S3://PHOTOS/NATIONAL_PARKS/US/YOSEMITE/HALF_DOME.JPG')  |
+================================================================================---------------------+
| us/yosemite/half_dome.jpg                                                                 |
+================================================================================---------------------+

Copy