Planning
Creating your Snowflake account
Connecting to Snowflake
By the end of this chapter, you will be ready to begin your cloud analytics journey and follow along with the remaining chapters of this book. In the “Planning” section, we will cover what decisions should be made before creating your Snowflake account. These considerations include pricing and region choices. We will also briefly introduce the Snowflake web interface.
Planning
Snowflake editions
Cloud providers and regions
Snowflake pricing model
Types of Snowflake tools
Deciding on a Snowflake Edition
When you create your Snowflake account, you will be asked to choose a Snowflake edition. Snowflake offers five account types, and each one provides progressively more features.
Snowflake Editions
Choosing a Cloud Provider and Region
At the time of this publication, a Snowflake account can be hosted on either Amazon Web Services (AWS) or Microsoft Azure. Each cloud provider has data centers in many locations around the world. These locations are referred to as regions . Transferring data between regions can have cost implications. Therefore, region considerations are important because the costs can vary depending on your requirements.
Multiple regions might be necessary to address global data access speeds as well as replication needs. For example, if you have users located in different parts of the world, it might make sense to replicate or partition the data closer to your users. If you have a use case for multiple regions, then you will need to create a Snowflake account for each region. We will talk about solving multiple-region issues in later chapters.
Note
Snowflake accounts do not support more than one region. You will need to create a Snowflake account for each region.
Limitations to Your Snowflake Account When Hosted on Microsoft Azure
Snowflake editions impacted | Virtual Private Snowflake (VPS) is not currently available on Azure but is planned to be released shortly. Check with the Snowflake web site for more details: https://docs.snowflake.net/manuals/user-guide/intro-editions.html |
Security and data encryption | No support for encryption with customer-managed keys. |
No support for secure connectivity to customer-owned virtual networks. | |
Data loading | To access S3 from Azure, IAM policies must allow for Snowflake access. |
Third-party application support | Check with your third-party partner to determine whether Azure is supported. These partners do support Azure: Alooma, Attunity, Databricks, Fivetran, Informatica, Looker, Matillion, MicroStrategy, Periscope, Power BI, Qubole, Sigma Computing, Stitch, Tableau, Talend, and Wherescape. |
Examining Snowflake’s Pricing Model
Credits Charged by Full Hour Based on Virtual Warehouse Size
X-Small | Small | Medium | Large | X-Large | 2X-Large | 3X-Large | 4X-Large |
---|---|---|---|---|---|---|---|
1 | 2 | 4 | 8 | 16 | 32 | 64 | 128 |
Note
Credits are billed on a per-second basis only when virtual warehouses are running. If a virtual warehouse is suspended, it will not accrue charges.
If a virtual warehouse needs to be resized, credits are billed only for the additional increase or decrease in servers. For example, if your virtual warehouse is increasing from Large to X-Large, you will be charged per minute for each cluster being added. In this case, eight additional credits are accrued for that minute during the increase. Also, each time a server is started or stopped, there is a one-minute minimum billing charge even if it took less time. After the minute of billing has occurred, then charges go back to per-second billing. Refer to the Snowflake web site to get the current pricing per credits in your currency.
Other Pricing Considerations
You can choose to leave your data in the Snowflake database. But if you need to transfer or copy your data out of Snowflake and into another external storage location (i.e., AWS S3), Snowflake will charge for the query compute costs associated with the export. Also, if you’re going to export your data out of Snowflake and into a cloud storage such as S3 or Azure Blob, there are additional egress charges for that if the location is either in a different region or with a different cloud storage provider.
Remember
Snowflake does not charge to load data into your Snowflake environment from any external stage; however, your cloud storage provider (Amazon S3 or Microsoft Azure) might charge a separate egress fee if your data storage is located in a region or network different from your Snowflake account.
Examining Types of Snowflake Tools
Snowflake web interface. Most browsers can support the Snowflake web interface. For minimum versions, check the Snowflake web site. Snowflake recommends Google Chrome (minimum version).
SnowSQL, the Snowflake command-line client.
Any client application connected via JDBC or ODBC.
Third-party partners that have been built with Snowflake capabilities, like Tableau and Matillion.
Snowflake Web Interface
Browsers Supported by the Snowflake Web Interface
Browsers | Versions |
---|---|
Chrome Safari Firefox Internet Explorer Opera Edge | 47+ 9+ 45+ 11+ 36+ 12+ |
SnowSQL
SnowSQL is a command-line client for connecting to and using Snowflake. SnowSQL can be installed on any Red Hat–compatible Linux operating system, macOS (64-bit), and Windows (64-bit). Other operating systems have not been tested and may not work with SnowSQL. There are some Linux systems that may not have all the needed libraries used by the SnowSQL client. SnowSQL is available for download from the Snowflake web interface as well as the Snowflake web site. We will cover SnowSQL in later chapters of this book.
JDBC and ODBC OS Platform Requirements
Both the Snowflake JDBC (64-bit) and ODBC (32-bit and 64-bit) drivers can be installed on Linux, macOS, and Windows. The JDBC driver is available for download from the Maven Central Repository at http://search.maven.org/. The ODBC driver is available on the Snowflake Client Driver Repository at https://sfc-repo.snowflakecomputing.com/odbc/index.html. The ODBC driver can also be downloaded from the Snowflake console. Windows users may need to install .NET drivers prior to the installation of the ODBC driver.
Third-Party Partners
In later chapters we will go over how the third-party partners Matillion and Tableau use Snowflake. Right now, Snowflake makes it easy to integrate with some of the more popular third-party tools like Databricks, Alteryx, Looker, Qubole, Matillion, and Tableau. For a current list of the Snowflake third-party partners, please visit the Snowflake web site at https://docs.snowflake.net/manuals/user-guide/ecosystem-all.html.
Creating a Snowflake Account
Note
Account activation must occur within 72 hours or you will need to create another trial account.
Connecting to Snowflake
- 1.
Log into the Snowflake web interface
- 2.Tour the web interface, which will include the following:
Databases page
Shares page
Warehouses page
Worksheets page
History page
Partner Connect page
Help menu
User Preferences menu
Logging Into the Snowflake Web Interface
Snowflake makes it easy to navigate and learn about the different features included in the web interface. We will go over what is included in the web interface in the next section.
Touring the Web Interface
Now that you’ve logged into your Snowflake web interface, you can create and manage all of your Snowflake objects. You can also use the web interface to load some data into tables, execute ad hoc queries, run Data Manipulation Language (DML) statements such as update, run Data Definition Language (DDL) statements such as alter/create, view past queries, change your password, set your user preferences, and perform administrative tasks if you’ve been granted admin access.
If you have the required administrator role, you can perform administrative tasks in the web interface such as creating and managing users. We will go over the administrative portion of the interface in Chapter 7. For this section, we will review the following parts of the web interface: Databases page, Warehouses page, Worksheets page, History page, Help menu, and User Preferences menu.
Databases Page
Warehouses Page
Shares Page
If you need to share your data with other teams inside or outside your organization, then Snowflake data sharing might be the solution you are looking for. Snowflake data sharing enables data providers to effectively share their data and to service their data consumers in a scalable and cost-effective manner. Snowflake data sharing is available to all Snowflake customers.
Worksheets Page
The Worksheets page is probably going to be the most used page for those with access to the Snowflake user interface. This page is where users can submit ad hoc SQL queries and execute DDL and DML statements. Other tasks that can be done on the Worksheets page include the following: opening concurrent worksheets that work in separate sessions, saving and reopening worksheets, logging out of Snowflake or switching roles within the worksheet, exporting query results, and resizing the current virtual warehouse if needed.
Caution
If you log out of Snowflake, all running queries in the worksheet will cease.
History Page
The History page saves details of what was executed through the Worksheets page, SnowSQL, and any other SQL client that connects to your Snowflake instance. The history goes back 14 days, and you are able to view the details about each query. Results of queries are available for only 24 hours after the query has completed running. There are filters available to easily scan through the history, and you’re also able to change how the history is viewed by adding additional columns, such as for the status or virtual warehouse.
Partner Connect Page
The Partner Connect page is available to the right of the History page. This page provides instant access to all the third-party partners that Snowflake is compatible with. It is easy to get set up; just click Partner Connect, choose the partner tool, and click Connect. Once you receive confirmation that your account was created, click Launch. In just a few short minutes you will be able to integrate the partner with your Snowflake account.
Help Menu
The Help menu is available in the upper-right corner of the Snowflake web interface, next to Partner Connect. The Help menu is where you can access the Snowflake documentation. Additionally, if you need support, the Help menu is where you can create a support case. Also, Snowflake drivers are available for download in the Help menu.
User Preferences Menu
The User Preferences menu can be accessed by clicking the drop-down menu in the upper-right corner, next to your account name. The preferences menu is where you can change your password, security role, and notification settings. It is also where you can log out of Snowflake.
Reminder
Logging out of Snowflake will cancel all running queries that are in a worksheet.
Summary
In this chapter, we covered planning your Snowflake environment and creating a Snowflake account, and we gave you a high-level overview of the web user interface. You are now ready to load data and build your virtual warehouse. The next few chapters will help you get started onboarding your data, and then later chapters will discuss the tools you can use to analyze your data.