presigned_url

Creates, updates, deletes, gets or lists a presigned_url resource.

Overview

Name	presigned_url
Type	Resource
Id	snowflake.stage.presigned_url

Fields

The following fields are returned by SELECT queries:

get_presigned_url

Materials for uploading and downloading stage files

Name	Datatype	Description
presigned_url	string	Presigned url for file transfer, only works for Server Side Encrypted Stages.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_presigned_url	select	database_name, schema_name, name, filePath, endpoint		Generate a presigned url and optionally encryption materials for uploading and downloading files.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
database_name	string	Identifier (i.e. name) for the database to which the resource belongs. You can use the /api/v2/databases GET request to get a list of available databases.
endpoint	string	Organization and Account Name (default: orgid-acctid)
filePath	string	The full stage path of the file.
name	string	Identifier (i.e. name) for the resource.
schema_name	string	Identifier (i.e. name) for the schema to which the resource belongs. You can use the /api/v2/databases/{database}/schemas GET request to get a list of available schemas for the specified database.

SELECT examples

get_presigned_url

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 }}' -- required
AND schema_name = '{{ schema_name }}' -- required
AND name = '{{ name }}' -- required
AND filePath = '{{ filePath }}' -- required
AND endpoint = '{{ endpoint }}' -- required;