You can configure your Azure Storage to use an external Snowflake staging location. The following section describes how you create a new remote file server connection for staging (storing) your data on Azure Storage.
-
To create a new remote file server connection:
From a Server Properties dialog for a Snowflake server, under Staging, click New.
Right-click a host or the Remote file serversbranch, and select New Remote File Server.
The Remote File Server Properties dialog opens.
Right-click a host and select Properties.
The Remote File Server Properties dialog opens.
- On the Cloud tab, enter information for each field.
|
Parameter |
Description |
|---|---|
|
Name |
Use alphanumeric characters to specify a unique remote file server name for use in the model. Note: The slash (/), backslash (\), colon (:), left caret
(<), right caret (>), and spaces cannot be used in a Server
name.
|
|
Connection type |
Select Azure Storage from the drop-down list. Based on your selection, you will get a different set of options in the Remote File Server Properties window. |
|
Authentication method |
Click the Authentication method drop-down list and select one of the following
authentication methods:
|
| Azure shared key |
Use the Shared Key authorization scheme to make requests against the Blob, Queue, and File services. Enter the Azure access key for Azure Shared Key Authorization. When creating a storage account, Azure generates two 512-bit access keys. You can use either of the two keys, however, the best practice is to use the first key and reserve the use of the second key for when you are rotating keys. See the Azure storage documentation for more information |
|
Verify |
Click to test the remote file server connection. After a few seconds a message opens with information about whether the test was successful. If the test was unsuccessful, note the errors in the message, troubleshoot, and verify again. |