Snowflake and Azure Blob Storage
If you want to use Snowflake and Azure Blob Storage for your data warehouse, you need the following prerequisites:
- Access to Snowflake
- A Microsoft Azure account with an active subscription
In Snowflake, create a new SQL worksheet and paste in the query shown below. The query will create a Snowflake database, a warehouse, and a user with the required permissions.
After changing the
MY_PASSWORD variables, run the entire query.
The example query will generate the following credentials:
 Region-specific account locator (opens in a new tab). You can retrieve this by hovering over your account in the account list and clicking on the
🔗 link icon that pops up.
Store these credentials in a secure location.
In the Azure console, go to
Storage Accounts and create a new storage account. Select the
Resource group to which you'd like to tie your storage account, and provide an appropriate name (e.g.,
y42demo). Select the region you want to use. Leave all other settings unchanged and click
Next, navigate to the storage account and head to the
Containers tab under
Data storage. Create a new container with an appropriate name (e.g.,
y42demo), leaving the other settings unchanged.
Lastly, also from the
Security + networking section, select the
Access keys tab. Here you will see two keys, each with their own
Connection string. Store the values of
key1 in a secure location.
Back on Y42, select
Snowflake as the provider. Add all the Snowflake credentials generated by the query above:
Azure Blob Storage. Enter the
Account name, and
Container name credentials from the previous step.
Choose a location or region where Y42 will create the Azure Blob Storage bucket.
You can now continue with configuring the Git repository for your Y42 space.