Okay, Let’s Get Started!

In order to access all the features of Snowflake that I would like to discuss, I am going to purchase an Enterprise plan.  At the time of this writing, the cost is $3.00 per credit.  I do not plan to do anything outrageously expensive, but just in case, I will configure my system to warn me if things get pricey.

Let’s navigate to this page here on Snowflake’s site.  Please note that they are recommending a cloud storage of AWS (Amazon Web Services) in Northern Virginia.  Click on the “Get Started” link and sign up for your free trial.  Note:  I’ll be putting in a credit card to make sure it renews appropriately.  Quick note:  The sign-up form does not seem to play well with Firefox, so I used Chrome.  Be sure that when you choose your cloud provider in the sign-up, you choose Amazon Web Services — US East (Northern Virginia.)

After you have checked all the options, Snowflake will send you a link to your sign up email asking you to activate your account.  You will need to click the button (or the link in the email — either is fine) and go to Snowflake.  Firefox seems to work fine here.  You will be asked to create a username and a password.

After you have created a username and a strong password, you will be asked if you would like to load data for TastyBites, a fictional global food truck business.  I said “Yes” to this — the exercises are not very long, and they give a good overview of how to query and import data through Snowflake.

And yes — that is all there is to it.  In our next few posts, we will take a quick tour of Snowflake, and will try out a few USE commands to show us around.  But first, we will configure a Resource Monitor so that we don’t accidentally overspend!

I do assume a bit of familiarity with SQL.  I hope that’s okay.

PS  One final note — you will get an email from Snowflake with your account information.  Don’t lose that — it is how you log in.