Snowflake Data Cloud Connector

Back Next

Access to data files in a Microsoft Azure Data Lake Storage Gen2 container

You must have access to data files in a Microsoft Azure Data Lake Storage Gen2 container to load data from Microsoft Azure Data Lake Storage Gen2 to Snowflake.

To do this, perform the following steps:

Create a Cloud Storage Integration object that contains the details of the Microsoft Azure Data Lake Storage Gen2 container from which you want to read data.

After you create the Cloud Storage Integration in Snowflake, specify the Cloud Storage Integration name in the

Additional JDBC URL Parameters

connection property.

The Storage Integration value is case-sensitive.

The Snowflake Data Cloud Connector creates a temporary external stage that uses the Cloud Storage Integration you created.

Prepare for SQL ELT

Configuring storage integration for Microsoft Azure Data Lake Storage Gen2

Granting access to the storage locations

Download Guide

Watch

Comments

Cloud Connectivity Homepage