C3 AI Documentation Home

Greenplum Node

Load data from Greenplum into Visual Notebooks.

Prerequisites

Follow the steps below to add credentials for Greenplum.

  1. Drag a Greenplum node onto the Visual Notebooks workspace
  2. Select the gear icon beside the Credential field Adding Greenplum credentials - step 1
  3. Select the plus sign in the upper right corner Adding Greenplum credentials - step 2
  4. Enter a name for the credential
  5. Enter the URL for Greenplum
  6. Enter the username and password you use to access Greenplum Adding Greenplum credentials - step 3

Configuration

FieldDescription
Name OptionalA user-specified node name displayed in the canvas
Credential RequiredThe information needed to access Greenplum data Select a saved credential from the dropdown menu. Select the gear icon to add a new credential or delete existing credentials.
Database RequiredThe name of the desired Greenplum database Specify the database to be used to load data.
Query RequiredThe data to upload Select the table you want to upload from the auto-populated dropdown menu or enter a SQL query that returns the desired data.
Filter by Value OptionalConfigure filters to be applied to data Use the dropdown fields to filter results. Filter options include is null, is not null, is equal, is not equal, begins with, ends with, in between, is less than, is less than or equal to, is greater than, and is greater than or equal to. Filters can be applied on any column datatype. Add additional filters to create "And" conditional logic treatment.

Node Inputs/Outputs

InputNone
OutputVisual Notebooks returns a table, called a dataframe, that contains all uploaded data. Columns are labeled and include a symbol that specifies the data type of that column.

Example dataframe output

Figure 1: Example dataframe output

Examples

Specify the Greenplum table that contains the desired data. Select Run to create a dataframe.

Greenplum table configuration

Example dataframe created from a Greenplum table

Figure 2: Example dataframe created from a Greenplum table

You can also write a SQL query to create a dataframe with only specific data.

  1. Select a Greenplum database.
  2. Write a query that returns the desired data.
  3. Select Run to create a dataframe.

In the example below, the query returns all columns for the first 10 rows of the "stocks" table.

Greenplum SQL query configuration

Example dataframe created from a Greenplum query

Figure 3: Example dataframe created from a Greenplum query

Alternately, filter the data with the Filter by Value widget.

  1. Select the Greenplum table ("stocks" in this example) that contains the desired data.
  2. Add a "filter" using the Filter by Value widget. The input allows users to easily and visually configure ways to filter--for example by selecting a string column and only selecting rows that begin with a certain letter or selecting a numeric column and only returning results where the value is greater than a user specified input. In this example, a filter is used to select rows where the "Volume" is greater than 20747586.
  3. Select Run to create a dataframe.

Greenplum filter configuration

Example dataframe created with filter

Figure 4: Example dataframe created from a Greenplum table with a filter

Was this page helpful?