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