GreenPlum
Learn how to configure GreenPlum as a metadata source for Cloudera Data Lineage (formerly Octopai).
Tool Permissions Prerequisites
Add the following line to the pg_hba.conf file located under /data/master/gpseg-1.
Enable remote access, allowing the Octopai Client to perform the MetaData extraction:
| TYPE | DATABASE | USER | ADDRESS | METHOD |
|---|---|---|---|---|
| host | databasename | octopai-user | octopai-client-ip-address | md5 |
Replace "databasename", "octopai-user", and "octopai-client-ip-address" with the actual values for your database and client. This line will allow the Octopai Client to access the specified database using md5 authentication.
Ensure the following prerequisites are met:
- Postgres ODBC driver installed on the machine running the Octopai Client.
- Open Server Port for each Postgre Database Connection.
- Existing/New Postgres user (OCTOPAI_USER) for each
connection with grant select permission for the following dictionary tables:
- information_schema.tables
- information_schema.views
- information_schema.columns
- pg_catalog.pg_proc
- pg_catalog.pg_namespace
- pg_catalog.pg_attribute
- pg_catalog.pg_constraint
- pg_catalog.pg_class
- pg_catalog.pg_database
How to set up the permissions
Setting up GreenPlum Metadata Source
Metadata Sources are set on the Octopai Client
Verify extraction results
After a successful run, confirm the metadata archive in the target folder. See Verify extracted metadata files.
Troubleshoot
If an error occurs during the extraction, see Troubleshoot connector extraction failures.
