Contribute in GitHub: Edit online

PostgreSQL Manual Inputs

PostgreSQL, Greenplum, Redshift, Yellowbrick, Amazon RDS, or Amazon Aurora for PostgreSQL and PL/pgSQL

By default, Manta Flow extracts DDL scripts from configured PostgreSQL, Greenplum, Yellowbrick, Redshift, Amazon RDS, or Amazon Aurora for PostgreSQL servers and then analyzes the data flows in them. It is also possible to analyze the data flows in the PostgreSQL PL/pgSQL scripts, Greenplum scripts, Yellowbrick scripts, Redshift scripts, Amazon RDS, or Amazon Aurora for PostgreSQL scripts that work with the configured server.

• Copy the PostgreSQL, Greenplum, Yellowbrick, Redshift, Amazon RDS, or Amazon Aurora for PostgreSQL PL/pgSQL scripts to the <MANTA_DIR_HOME>/input/postgresql/${postgresql.dictionary.id}[/database_name[/schema_name]] folder, where postgresql.dictionary.id is the identification of the server (if not changed in the configuration) and database_name and schema_name are optional directory structures that give IBM Manta Data Lineage information about the default database and schema for any unqualified references to database objects used in the scripts. Learn more about unqualified object references.