Skip to main content
Version: v1.x.x

Import PostgreSQL Data

This tutorial guides you through importing a PostgreSQL database 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:

  • Access credentials to your PostgreSQL database

Step 1: connect the database​

Let's connect to your PostgreSQL database.

  1. On the H2O Drive home page, click Import.
  2. Select PostgreSQL from the dropdown list of sources.
  3. If you have not added a credentials profile already, click Add New Credentials.
  4. Enter the following details to connect to the PostgreSQL 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 database.
    • Password: The password credential used to access the database.
    • Database: The name of the database.
    • Port: The port number on which the database instance is running.
    • Server: The server IP address on which the database instance is running.
      note

      For more information, see Connecting to the Database in the PostgreSQL documentation.

      import-postgres-data
  5. Click Save.
  6. Select the credentials profile that you just created from the dropdown list and click Next. select-credentials

Step 2: select the data tables​

  1. Select the data table that you wish to import. Downloading the dataset may take a few moments. select-data-table
  2. Click Next.
  3. 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
  4. Click Save. 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