Create an external stage (Azure)

Learn how to create an external stage.

Before you create an external stage, you must have configured an Azure cloud storage for Snowflake and created a cloud storage integration for Azure. For more information, see topics Configure Azure cloud storage for Snowflake and Create a cloud storage integration in Snowflake (Azure).

A Snowflake stage specifies where data files are stored, ready to load into a table. Snowflake external stages provide all of the required information for staging files, including the Azure container where the files are staged, the named storage integration object, and the encryption key. Create an external stage in Snowflake to load Reltio data from your Azure cloud.

To create an external stage:

In the Snowflake application worksheet area, create a new SQL worksheet.
In the SQL worksheet, run this command:
```
create stage "<database_name>"."<schema_name>"."<stage_name>"
url = '<cloud_storage_location>'
storage_integration = <storage_integration_name>;
```
where:
- <database_name>: Is the name of the database you created in Create a Snowflake database.
- <schema_name>: Is the name of the schema you created in Create a Snowflake schema.
- <stage_name>: Is the name of the external stage you're creating.
  Tip: Take note of this value. Youll need it when you Create a Snowpipe in Snowflake (Azure).
- <cloud_storage_location>: Is the value of the <storage_allowed_locations> parameter of the cloud storage integration you created in Create a cloud storage integration in Snowflake (Azure).
- <storage_integration_name>: Is the name fo the storage integration you created in Create a cloud storage integration in Snowflake (Azure).
In the SQL worksheet, view the Successfully created notification.

For general information, see Creating an Azure stage in the Snowflake documentation.

Accelerate the Value of Data

Create an external stage (Azure)

Footer