presigned_url
Creates, updates, deletes, gets or lists a presigned_url resource.
Overview
| Name | presigned_url |
| Type | Resource |
| Id | snowflake.stage.presigned_url |
Fields
| Name | Datatype | Description |
|---|---|---|
presigned_url | string | Presigned url for file transfer, only works for Server Side Encrypted Stages. |
Methods
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get_presigned_url | SELECT | database_name, filePath, name, schema_name, endpoint | - | Generate a presigned url and optionally encryption materials for uploading and downloading files. |
## `SELECT` examples
Generate a presigned url and optionally encryption materials for uploading and downloading files.
SELECT
presigned_url
FROM snowflake.stage.presigned_url
WHERE database_name = '{{ database_name }}'
AND filePath = '{{ filePath }}'
AND name = '{{ name }}'
AND schema_name = '{{ schema_name }}'
AND endpoint = '{{ endpoint }}';