Vertica
Learn how to set up Vertica metadata sources with Cloudera Data Lineage (formerly Octopai).
Tool Permissions Prerequisites
Ensure the following prerequisites are met:
- Open Server Port for each Vertica Database Connection
-
Admin Vertica user for each connection with grant permission for the following dictionary tables:
- PROJECTIONS
- TEXT_INDICES
- USER_FUNCTIONS
- USER_PROCEDURES
- USER_TRANSFORMS
- VIEW_COLUMNS
- VIEWS
- VIEW_TABLES
- ALL_TABLES
- DATABASES
- COLUMNS
- COMMENTS
- HCATALOG_TABLES
- CONSTRAINT_COLUMNS
- HCATALOG_COLUMNS
- HCATALOG_SCHEMATA
- HCATALOG_TABLE_LIST
- PROJECTION_COLUMNS
Setting up Vertica 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.
