---
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


---

# Amazon Redshift metadata collector

# Amazon Redshift metadata collector {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Amazon Redshift metadata collector provides read-only access to metadata from an Amazon Redshift database.

The Amazon Redshift collector harvests metadata for Redshift tables and columns.

## Metadata cataloged {#amazon-redshift-metadata-collector__section_y2d_ndb_xhc}

The Amazon Redshift 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.
{#amazon-redshift-metadata-collector__table_wpy_vgb_xhc__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 |
| Views | 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. Metadata harvested]

{#amazon-redshift-metadata-collector__table_wpy_vgb_xhc}

## Relationships between objects {#amazon-redshift-metadata-collector__section_b4m_3t4_13c}

Catalog pages show relationships between the following data asset types:
{#amazon-redshift-metadata-collector__table_ovf_qt4_13c__entry__2}

| Data asset page | Relationship |
|-|-|
| Table | Columns |
| Columns | Table |
| Schema | Database that contains Schema, Table that is part of Schema |
| Database | Schema contained in Database |
[Table 2. Relationships between harvested data assets]

{#amazon-redshift-metadata-collector__table_ovf_qt4_13c}

## Lineage for Redshift {#amazon-redshift-metadata-collector__section_okr_3t4_13c}

The following lineage information is collected by the Redshift collector:
{#amazon-redshift-metadata-collector__table_asy_kyn_33c__entry__2}

| Object | Lineage available |
|-|-|
| View (column-level) | The collector traces data flow from view columns to source table columns across SQL expressions and sub queries. View → Table column relationships The collector captures lineage when views: * Sort rows (ORDER BY) * Filter rows (WHERE, HAVING) * Aggregate rows (GROUP BY) |
| Stored Procedure | The collector identifies: * The associated column in an upstream view or table: * Where the data is sourced from * That sort the rows via ORDER BY * That filter the rows via WHERE/HAVING * That aggregates the rows via GROUP BY * The downstream table that has its tables updated. The following stored procedures aren't supported: <!-- --> * Stored procedures with multitable inserts. However, multiple separate insert statements that insert into one table are supported. * Stored procedure with multiple SELECT and INSERT statements not separated by a semicolon delimiter |
[Table 3. Lineage availability by object]

{#amazon-redshift-metadata-collector__table_asy_kyn_33c}

## Authentication supported {#amazon-redshift-metadata-collector__section_adt_xt4_13c}

The collector supports username and password authentication to Redshift.
* **[Prepare to run the Amazon Redshift collector](https://www.servicenow.com/docs/Q3XiFBSFY6I0eWSTSrsIVg)**   
  Create a Redshift user and configure permissions before running the collector.
* **[Create an Amazon Redshift metadata collector](https://www.servicenow.com/docs/UN_T2fW8vyeeroBGFKtjjQ)**   
  Create a collector to import metadata from Amazon Redshift.