Skip to main content

How to Set up Greenplum

Updated over a month ago

This setup should take 5 minutes.

Use this connector to have Foundational scan and determine lineage and downstream impact for Greenplum

Permissions: You'll need to be a Greenplum admin for this setup

In order to provide Foundational access to Greenplum/VMware Tanzu Greenplum, please follow these steps below.

1. Create User and Grant Permissions to Metastore Database

You can access the Greenplum database through your preferred client. The command line presented here are using psql

  1. Download this script that creates the foundational user and role:
    create_foundational_user.sql

  2. Change the <fill-the-password-here> to a pasword you would like to use

  3. Run this script on your Greenplum database as admin, using the following command:
    psql -h <greenplum-host> -p 5432 -U gpadmin -d postgres -f create_foundational_user.sql

  4. Verify there are no errors or any other problems that were encountered. You should see this if the script succeeded:

    ...
    ----------------------------------------------------------------------
    Succeeded in creating Foundational role, and granting metadata permissions
    ----------------------------------------------------------------------
    ...

2. Configure Greenplum Connector in Foundational

  1. Open the Connectors page in Foundational and select the Greenplum connector

  2. Fill in the following information:

    1. Database URL: host address of the Greenplum Database.

    2. Database Name: The name of the database in your Greenplum instance

    3. User Name: username for foundational to connect to your Greenplum. If you used the script in this guide, the name is foundational

    4. Password: password for the foundational username (which you picked above when running the script).

Did this answer your question?