Snowflake beginner course

Snowflake Beginner Course
Snowflake Beginner Course at iExpertify

Snowflake beginner course

Using the Web Interface

Using the Web Interface: General Usage Notes

This topic provides general usage information for the Snowflake web interface.

In this Topic:

Browser Requirements

You can use any of the following browsers to access the Snowflake web interface:

Supported Browser

Minimum Version

Chrome

47

Safari

9

Firefox

45

Opera

36

Edge

12

Tip

We recommend using Google Chrome. Other browsers have not been tested as extensively as Chrome and may exhibit some unexpected behavior. If you encounter issues using the web interface with any of the
listed browsers, please contact Snowflake Support.

Account Administration

If the SECURITYADMIN or ACCOUNTADMIN role has been granted to you and the role is in use for your interface session, you can access the Account Account tab tab, where you can perform administration
tasks, such as creating and managing users and security roles:

Note

The Account Account tab tab is displayed in the navigation bar only if the SECURITYADMIN or ACCOUNTADMIN role (or a role that has been granted the MONITOR USAGE global privilege)
is in use for the session. For more details, see Changing Your Password / Switching Your (Session) Role / Logging Out.

Accessing Documentation, Support, Downloads, and Context-sensitive Help

To access any of these resources at any time, click the Help Help tab icon in the upper right. From the dropdown menu, choose one of the following actions:

  • View the Snowflake Documentation

    Opens the documentation in a new tab/window.

  • Visit the Community

    Opens the Snowflake Support Portal/Community in a new tab/window. Once there, you can freely browse the articles and discussions in the site, but to submit cases or participate in discussions,
    you must log into the portal using your Snowflake Community user credentials. These credentials are distinct/separate from your Snowflake user credentials.

  • Download…

    Displays a dialog where you can:

    • Download the following client software provided by Snowflake:

      • Command line client (SnowSQL)

      • ODBC driver (for your platform)

    • View the distribution info for the following client software provided by Snowflake:

      • Connector for Spark v2.0 and higher — Connector for Spark v1.5 and v1.6 has been deprecated

      • JDBC driver

      • Connector for Python (and related components)

      • Node.js driver

  • Show help panel

    Displays context-sensitive help for the current page, including:

    • A description of the page.

    • Tasks you can perform on the page or step-by-step instructions for performing a particular task.

    • Helpful documentation links.

    • A breadcrumb trail that takes you back to the Getting Started dialog.

Classic Web Interface

The Snowflake web interface is easy to use and powerful. You can use it to perform almost every task that can be performed using SQL and
the command line, including:

  • Creating and managing users and other account-level objects (if you have the necessary administrator roles).

  • Creating and using virtual warehouses.

  • Creating and modifying databases and all database objects (schemas, tables, views, etc.).

  • Loading data into tables.

  • Submitting and monitoring queries.

In addition, you can use the web interface to change your Snowflake password and manage your user preferences.

Note that this set of topics do not describe all the tasks you can perform in the interface. Instead, they provide general usage information,
as well as highlight some of the more important and useful features of the interface, particularly in the Worksheets Worksheet tab
and History History tab pages.

Note

A note about the new web interface.

We are pleased to introduce a preview of our new web interface, which is built using a completely new architecture to run modern, high-performance web applications.

For convenience, when working in the new web interface, we recommend opening the classic (production) web interface in a separate tab if you need to access its functionality in your current user session.

Next Topics:

Loading Using the Web Interface (Limited)

The Snowflake web interface provides a convenient wizard for loading limited amounts of data into a table from a small set of flat files. Behind the scenes, the wizard uses the PUT and COPY commands to load
data; however, the wizard simplifies the data loading process by combining the two phases (staging files and loading data) into a single operation and deleting all staged files after the load completes.

The instructions in this topic pertain to loading both structured data (e.g. CSV) and semi-structured data (e.g. JSON, Avro, ORC, Parquet, or XML).

Important

The wizard is only intended for loading small numbers of files of limited size (up to 50 MB). This file size limit is intended to ensure better performance because browser performance varies from computer
to computer and between different browser versions. Also, the memory consumption required to encrypt larger files might cause a browser to run out of memory and crash.

For loading larger files or large numbers of files, we recommend using the Snowflake client, SnowSQL. For details, see Bulk Loading Using COPY.

In this Topic:

Step 1: Opening the Load Data Wizard

  1. Click on Databases Databases tab » Tables.

  2. Either:

  • Click on a table row to select it, then click the Load Data button.

    or

  • Click a table name to open the table details page, then click the Load Table button.

The Load Data wizard opens. The wizard will load data into the table you selected.

Step 2: Selecting a Warehouse

  1. Select a warehouse from the dropdown list.

    The list includes any warehouse on which you have the USAGE privilege. Snowflake will use this warehouse to load data into the table.

  2. Click Next.

Step 3: Selecting Source Files

Important

Remember, the wizard is designed to load small amounts of data. Your individual data files should each be smaller than 50 MB in size.

You can choose to load data from files on your local machine or files already staged in an existing cloud storage location on Snowflake, Amazon S3, Google Cloud Storage, or Microsoft Azure.

Loading From Your Local Machine

  1. Select the Load files from your computer option, and click the Select Files button.

  2. Select one or more local data files, and click the Open button.

  3. Click the Next button.

Loading from Cloud Storage

Choosing an Existing Stage

  1. Select an existing named stage from the Stage dropdown list.

  2. Click the Next button.

Creating a New Stage

Complete the steps in this section once per storage location.

  1. Click the plus (+) symbol beside the Stage dropdown list.

  2. Select the location where your files are located: Snowflake or any one of the supported cloud storage services, and click the Next button.

  3. Complete the fields that describe your cloud storage location. For more information, see CREATE STAGE.

  4. Click the Finish button.

  5. Select your new named stage from the Stage dropdown list.

  6. Click the Next button.

Step 4: Selecting a File Format

The dropdown list allows you to select a named set of options that describes the format of your data files.

Choosing an Existing Named File Format

  1. Select an existing named file format from the dropdown list.

  2. Click the Next button.

Creating a New Named File Format

  1. Click the plus (+) symbol beside the dropdown list.

  2. Fill in the fields on the screen to match the format of your data files. For descriptions of the options, see CREATE FILE FORMAT.

  3. Click the Finish button.

  4. Select your new named file format from the dropdown list.

  5. Click the Next button.

Step 5: Selecting Load Options

  1. Specify how Snowflake should behave if errors in the data files are encountered. For more information about the ON_ERROR copy option, see COPY INTO <table>.

  2. Click the Load button.

    Snowflake loads the data into your selected table using the warehouse you selected.

    Note

    If the warehouse is not currently running, resuming the warehouse could take some time (up to 5 minutes), in addition to the time required for loading.

  3. Click the OK button. The load data wizard closes.