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
Download this script that creates the
foundational
user and role:
create_foundational_user.sql
Change the
<fill-the-password-here>
to a pasword you would like to use
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
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
Open the Connectors page in Foundational and select the Greenplum connector
Fill in the following information:
Database URL: host address of the Greenplum Database.
Database Name: The name of the database in your Greenplum instance
User Name: username for foundational to connect to your Greenplum. If you used the script in this guide, the name is
foundational
Password: password for the
foundational
username (which you picked above when running the script).