Categories:: File functions

GET_STAGE_LOCATION¶

Retrieves the URL for an external or internal named stage using the stage name as the input.

Syntax¶

GET_STAGE_LOCATION( @<stage_name> )

Copy

Arguments¶

stage_name: Name of an external or internal named stage.

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").

Returns¶

URL of the cloud storage location in the stage definition.

Usage notes¶

This SQL function returns a value for any role that has the USAGE privilege on the stage.

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 URL for an external stage:

CREATE STAGE images_stage URL = 's3://photos/national_parks/us/yosemite/';

SELECT GET_STAGE_LOCATION(@images_stage);

+----------------------------------------------------------+
| GET_STAGE_LOCATION(@IMAGES_STAGE)                        |
+----------------------------------------------------------+
| s3://photos/national_parks/us/yosemite/                  |
+----------------------------------------------------------+

Copy