Skip to main content
Version: v0.7.x

Import Snowflake Data

This tutorial guides you through importing a Snowflake data warehouse into your H2O Drive workspace. Follow the steps below to connect to your datasource and import the data.

Prerequisites

Before you begin, you will need:

  • A Snowflake account
  • Credentials for the Snowflake data warehouse

Step 1: connect the data warehouse

Let's connect to your Snowflake data warehouse.

  1. On the H2O Drive home page, click Import.
  2. Select Snowflake from the dropdown list of sources.
  3. Enter the following details to connect to the Redshift database.
    • Profile Name: A suitable name for your personal credentials profile. This is the name that will appear on the dropdown list (which you saw on the previous screen) when you are selecting the credentials profile you wish to use.
    • User: The username used to access the warehouse.
    • Password: The password credential used to access the warehouse.
    • Url: The connection URL to the Snowflake data warehouse.
    • Warehouse: The name of the data warehouse.
      note

      For more information, see Using Account Identifiers for Connecting to Your Accounts in the Snowflake documentation.

      import-snowflake-data
  4. Click Save.

Step 2: select the data table

  1. Select the credentials profile that you just created from the dropdown list.
  2. Select the data table that you wish to import. Downloading the dataset may take a few moments. select-data-table
  3. Click Next.
  4. Once the data table has been imported successfully, enter a filename for the table so that you will be able to easily identify it on your H2O Drive workspace later. enter-filename
  5. You have successfully imported a dataset. You should now be able to see it displayed on H2O Drive under the specified filename. imported-dataset

Step 3: share the dataset

  1. Select the imported dataset by clicking on the filename.
  2. Click Get Link to get a pre-signed link that you can share with other users or applications that need to access this dataset.
  3. Set the expiration time and click Get Link. set-expiry-time
  4. Copy the link that appears and click Close. You can now use the copied link to share this dataset.

You can import this dataset using the pre-signed link to H2O-3, Driverless AI, or share it with someone else who can then import it onto their H2O Drive instance using the HTTP download option.


Feedback