Prerequisites

This tutorial requires a database, table, and virtual warehouse to load and query data. Creating these Snowflake objects requires a Snowflake user with a role with the necessary access control permissions. In addition, SnowSQL is required to execute the SQL statements in the tutorial. Lastly, the tutorial requires CSV files containing sample data to load.

Note that you can complete the tutorial using an existing Snowflake warehouse, database and table, and your own local data files; however, for simplicity, we recommend using the Snowflake objects and set of data files we’ve provided.

In this Topic:

Required User and Permissions

To create the database, table, and virtual warehouse used in this tutorial, your Snowflake user must have a role that has been granted the necessary permissions to create these objects.

If you do not have a Snowflake user yet, or if your user does not have an appropriate role, please contact one of your account or security administrators (users with the ACCOUNTADMIN or SECURITYADMIN role).

SnowSQL Installation

The SnowSQL installer is available for download from the Snowflake web interface.

To install SnowSQL:

  1. Log into the Snowflake web interface and click Help Help tab » Download… to display the Downloads dialog.

  2. Select CLI Client (snowsql) on the left, then click the download icon on the right for the installer that matches your client platform operating system:

    Snowflake SnowSQL options in Downloads dialog
  3. Complete the instructions for your operating system to run the installer:

    Linux

    1. Open a terminal window.

    2. Run the Bash script installer:

      $ bash snowsql-linux_x86_64.bash
      
    3. Follow the instructions provided by the installer.

    4. Open a new terminal window to run snowsql.

    Mac OS

    1. Run the PKG file by double-clicking snowsql-darwin_x86_64.pkg.
    2. Follow the instructions provided by the installer.
    3. Open a new terminal window or double-click the SnowSQL application icon to run snowsql.

    Note

    Double-clicking the SnowSQL application icon starts snowsql in the current Terminal window, if one exists, or opens a new window to start the application. If you cannot see the window running snowsql, ensure the window is not minimized, hidden, or located on a second monitor.

    Windows

    1. Run the MSI file by double-clicking snowsql-windows_x86_64.msi.
    2. Follow the instructions provided by the installer.
    3. Open a new terminal window to run snowsql.

Sample Data Files for Loading

Download the set of sample data files. Right-click the name of the archive file, getting-started.zip, and save the link/file to your local file system.

You can unpack the sample files in any location; however, we recommend using the directories referenced in the tutorial examples:

Linux/Mac OS:/tmp
Windows:C:\temp

The sample files include dummy employee data in CSV format with five records each. The field delimiter is the comma (,) character.

Example record:

Althea,Featherstone,afeatherstona@sf_tuts.com,"8172 Browning Street, Apt B",Calatrava,7/12/2017

Note

  • There are no blank spaces before or after the commas separating the fields in each record. This is the default that Snowflake expects when loading CSV data.
  • Because the field delimiter is the comma character, any commas within a field string must be escaped, or the entire field must be enclosed in double quotes (" ").

Next: Step 1. Log into SnowSQL