Snowflake setup on Azure step-by-step

Snowflake setup on Azure step-by-step

Create Snowflake account on Azure

Snowflake, the data warehouse built for the cloud is now available on Microsoft Azure as a public preview. In our earlier writings, we have extensively described the benefits of Snowflake as a cloud data warehouse that was designed for the cloud instead of hosting a traditional on-premise data warehouse in the cloud.

Snowflake is now available in the Azure marketplace as well. In this article, we will take you through the complete provisioning process between the two products. To start the process, all you essentially need is a credit card and by completing the initial registration, you will be provided $400 to spend on Snowflake credits for 30 days. Snowflake pricing is a “pay-as-you-go”; where you pay only for the time that the warehouse is active. Every possible size of a virtual data warehouse has a cost expressed in the number of credits per hour. The smallest instance, ‘X-Small’ (extra small), costs 1 credit/hr., where the cost of credit starts at $2. There is an additional cost for storage, however during the trial period it is possible to keep an X-Small instance under full load for 200 hours.

The journey with a Snowflake trial begins by creating your free account and claim your $400 credit.

You will be redirected to the registration form. Please choose “Microsoft Azure” in the last drop-down field if you want to get all the benefits of Azure integration and avoid inbound/outbound network transfer fees if you choose Amazon AWS.

After you complete the form, click ‘CONTINUE’, and you will be taken to a second, ‘payment’ screen, where you will be prompted to enter your credit card details. This transaction is used only for verification purposes to begin your trial, and you will not be charged immediately.

The provisioning process starts just after the registration and you should receive an email that is shown below. The “CLICK TO ACTIVATE” button will redirect you to your private Snowflake address for your account.

Next, Choose the administrator’s login and password. For safety reasons we advise to avoid obvious administrator’s account names like: root, admin, administrator.

The URL generated bill be your private instance of snowflake, and you should bookmark it for future use. Many snowflake tools require the account name which is just after https://. The account name would be similar to xy12345.east-us-2, please write it down.

The Snowflake management portal has three important options that you will be using:

  • Databases – Shows all databases that are available in your account. There are some sample databases that you can use for testing.
  • Warehouses – Virtual Databases (Data Warehouses) that you can create or resize.
  • Worksheet – An SQL panel for running ad-hoc queries.

Snowflake Virtual Data Warehouse resize

As the first step, we suggest you to go to the “Warehouses” section, select the default “COMPUTE_WH” warehouse and click “Configure”. You can change the size of the data warehouse to save free credits.

Snowflake drivers download

The tools and drivers (like ODBC drivers for BI tools) are available for download after clicking the “Help” icon at the top of screen.

At this moment, the Snowflake instance will be fully usable. We will show how to load data from Azure Blob Store to Snowflake in the next post.

BigData Dimension specializes in Snowflake deployments, data warehouse modernization and Business Intelligence. Schedule a meeting to talk with our experts today, we are eager to share our experience and best practices in data warehouse modernization using Snowflake.