In this lesson we will:

  • Learn about the different types of Snowflake account and the choices that you need to make when you open an account;
  • Go through the process of opening a free trial account at which we can use for the remainder of this course.

Snowflake Account Types

Snowflake has three types of account which each bring different features and support levels.

  • Standard - The baseline option;
  • Enterprise - Additional features such as longer time-travel windows and materialised views;
  • Business Critical - Additional security features for highly sensitive workloads.

As we explain in a later lesson, Snowflake billing is based on a credit model, and the credit cost is dependent on the tier chosen. For instance, a standard account in eu-west-1 AWS will cost $2.60 per credit, whereas an enterprise tier account would cost $3.90 per credit and a business critical would cost $5.20. For a sense of scale, if you really need the features in higher tiers, your per credit cost would be 100% higher than with a standard account.

Cloud Account

Though Snowflake is a fully Software-As-A-Service model, your Snowflake instance is hosted within cloud accounts hosted by AWS, Microsoft or Google. Some customers will care about this for reasons such as storing their data in an approved cloud, or wanting to store it in a data centre geographically close to their users and applications.

Once you have chosen a cloud provider, you will also need to choose a region. Typically it will make sense to choose one closest to your applications and users in order to reduce latency, though some organisations might have data locality constriants where they have to store their data in a specific country for legal reasons.

The choice of cloud and region also impacts the per credit cost. For instance, a standard account hosted in AWS eu-west-1 region will cost $2.60 per credit, whereas the same standard account is us-east-1 will cost $2.00 per credit. This could also be a factor in your decision where to host.

Within the region, your data will be managed securely across multiple "availability zones". For instance, Amazons eu-west-1 region has 3 availability zones or data centres. This implementation detail isn't expoed to the Snowflake user, but it is something which will be used behind the scenes to make your Snowflake account resilient.

Opening The Free Trial

Snowflake provides a generous free trial of up to $400 of free credits which we can use for our learning. This can be accessed by simply opening an account at

Logging Into Your Account

Most people who use Snowflake will be accessing it through the Graphical User Interface in a web browser and working through the Snowflake administration GUI.

There is also an option which is a Command Line Client (CLI) which we can use to access Snowflake through a terminal. We can try this here.

Our training virtual machine already includes the necessary command line tools, which we can try in the following way using the username and password by Snowflake:

snowsql -e <account_id> -u <username> -p <password>

You can execute the show databases command to test connectivity to your Snowflake account.

show databases

We have now opened our trial and tested connectivity, so are free to move on.

Next Lesson:

Snowflake Permission Model

In this lesson we will learn about the Snowflake permission and Role Based Access Control model.

0h 15m

Work With The Experts In Real-Time Analytics & AI

we help enterprise organisations deploy powerful real-time Data, Analytics and AI solutions based on ClickHouse, the worlds fastest open-source database.

Join our mailing list for regular insights:

We help enterprise organisations deploy advanced data, analytics and AI enabled systems based on modern cloud-native technology.

© 2024 Ensemble. All Rights Reserved.