PostgreSQL
Installation
Section titled “Installation”The PostgreSQL connector is based on the node-postgres package and is installed automatically with the Katalogue backend API service.
Authentication
Section titled “Authentication”Authentication with username and password is supported.
Required Permissions
Section titled “Required Permissions”By default, Katalogue requires read access to the following resources:
- information_schema.information_schema_catalog_name
- information_schema.schemata
- information_schema.tables
- information_schema.columns
- information_schema.key_column_usage
- information_schema.table_constraints
- information_schema.referential_constraints
- pg_catalog.pg_database
- pg_catalog.pg_namespace
- pg_catalog.pg_class
- pg_catalog.pg_views
- pg_catalog.pg_depend
- pg_catalog.pg_rewrite
Note that other permissions might be required if custom import queries are used.
Limitations
Section titled “Limitations”Lineage
Section titled “Lineage”The PostgreSQL connector does only provide dataset/table lineage for views out of the box, not for tables.