--- sourceDocument: Australia Workflow Data Fabric sourceDocumentLink: https://www.servicenow.com/docs/r/australia/integrate-applications Release : - australia ft:locale : - en-US ft:publication_title : - Australia Workflow Data Fabric ft:clusterId : - crint bundleId : - crint workflow : - Creator --- # PostgreSQL metadata collector # PostgreSQL metadata collector {#ariaid-title1} Release version: Australia Updated March 12, 2026 ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete. ## Summary of PostgreSQL metadata collector The PostgreSQL metadata collector provides read-only access to metadata from PostgreSQL databases, enabling ServiceNow customers to harvest detailed metadata for tables, columns, views, materialized views, functions, and stored procedures. It supports both self-hosted PostgreSQL instances and managed services like AWS RDS. This collector makes metadata searchable and discoverable within the ServiceNow data catalog, facilitating improved data governance and management. Show full answer Show less ## Key Features * **Authentication:** Supports username/password and AWS IAM authentication for secure access. * **Comprehensive Metadata Cataloging:** Captures detailed attributes such as column names, descriptions, data types, keys, table schemas, indexes, views, materialized views, functions, and stored procedures. Each version of overloaded functions and stored procedures is uniquely identified. * **Profiling and Sampling:** When enabled and with appropriate read permissions, collects column statistics including average length, value distributions, distinct counts, min/max values, non-null counts, sample string values, and table row counts to provide deeper insight into data quality and characteristics. * **Relationships and Lineage:** Displays relationships between tables, columns, indexes, schemas, views, and materialized views. Provides column-level lineage tracing for views and materialized views, linking derived columns back to source table columns through SQL operations like filtering, sorting, and aggregation. ## Practical Guidance for ServiceNow Customers * Before running the collector, create a PostgreSQL user with proper read permissions to enable metadata harvesting and profiling. * Create and configure a PostgreSQL metadata collector within ServiceNow to import metadata from your PostgreSQL environment. * Use the harvested metadata and lineage information to enhance data cataloging, improve data discoverability, and support governance initiatives. Provides read-only access to metadata from a PostgreSQL database. The collector harvests metadata for PostgreSQL tables and columns, making them searchable and discoverable in the data catalog. Supports both self-hosted PostgreSQL instances and managed PostgreSQL instances, such as those hosted on AWS RDS. ## Authentication supported {#postgresql-metadata-collector__section_vgv_wck_13c} Username and password authentication and AWS IAM authentication. ## Metadata cataloged {#postgresql-metadata-collector__section_vdj_xck_13c} The PostgreSQL collector catalogs the following information. Note: All versions of overloaded functions and stored procedures are cataloged. Each version has its own title in the catalog but a distinct identifier. {#postgresql-metadata-collector__table_xgm_jdk_13c__entry__2} | Object | Information cataloged | |-|-| | Columns | Name, Description, JDBC type, Column Type, Is Nullable, Default Value, Key type (Primary, foreign), column size, column index | | Table | Name, description, primary key, schema | | Table Index | Index Cardinality, Column name, Index Type, Index Name, is non Unique, Ordinal Position, Pages, Sort Sequence | | Views | Name, description, SQL definition | | Materialized View | Name, description, SQL definition | | Schema | Identifier, Name | | Database | Type, name, identifier, server, port, environment, JDBC URL | | Function | Name, Description, Function Type | | Stored Procedure | Name, Description, Stored Procedure Type | [Table 1. Cataloged metadata] {#postgresql-metadata-collector__table_xgm_jdk_13c} When profiling and sampling parameters are enabled, the following additional column information is cataloged: Note: The user/role must have read access to data to be able to harvest profiling information (column statistics). {#postgresql-metadata-collector__table_cg5_n2k_13c__entry__2} | Object | Information cataloged | |-|-| | Column | * Average Length (sample) * Average Value (sample) * Data Distribution * Distinct Values * Estimated Distinct Values * Estimated Non-null Values * Maximum Length (sample) * Maximum Value (sample) sorted numerically or alphabetically (z-a) * Minimum Length (sample) * Minimum Value (sample) sorted numerically or alphabetically (a-z) * Non-null Values (sample) * Sample String Values (first 5 items in a column) | | Table | * Row Count * Sample Count (Target sample size) | [Table 2. Profiling and sampling specific information] {#postgresql-metadata-collector__table_cg5_n2k_13c} ## Relationships between objects {#postgresql-metadata-collector__section_e3n_xck_13c} Catalog pages show relationships between the following data asset types: {#postgresql-metadata-collector__table_okm_12k_13c__entry__2} | Data asset page | Relationship | |-|-| | Table | Columns, Table Indexes | | Columns | Table | | Schema | * Database that contains Schema * Table that is part of Schema * View that is part of Schema * Materialized View that is part of Schema | | View | * Schema that contains Views * Columns that are part of Views | | Materialized View | * Schema that contains Materialized Views * Columns that are part of Materialized Views | [Table 3. Relationships between harvested data asset pages] {#postgresql-metadata-collector__table_okm_12k_13c} ## Lineage for PostgreSQL {#postgresql-metadata-collector__section_bks_xck_13c} The collector identifies column-level lineage for Views and Materialized Views, tracing data sources from view columns to source table columns across SQL expressions and subqueries. Establishes relationships between Views and source Table columns that: * Sort rows (SQL ORDER BY) * Filter rows (SQL WHERE and HAVING clauses) * Aggregate rows (SQL GROUP BY) Note: View-to-table relationships can be established transitively through column-level relationships. Variable statement lineage isn't supported. * **[Prepare to run the PostgreSQL collector](https://www.servicenow.com/docs/Aq_jUy5Bwu~SFGsgWXYVkg)** Create a PostgreSQL user and configure permissions before running the collector. * **[Create a PostgreSQL metadata collector](https://www.servicenow.com/docs/NUyk6b_dg3_Qi91tPXcKAQ)** Create a collector to import metadata from PostgreSQL.