Amazon Redshift is a cloud-based data warehousing service that you can use to analyze and store data.
Objects extracted
Metadata Command Center extracts the following metadata from an Amazon Redshift source system:
•Database
•Schema
•External Schema
•Table
•External Table
•View
•Materialized View
Note: Objects of the Materialized View type appear as View in Data Governance and Catalog.
•Function
•Procedure
•Column
Data profiling for Amazon Redshift objects
Configure data profiling to run profiles on the metadata extracted from an Amazon Redshift source system.
You can run data profiles on the following objects:
•Table
•View
•Spectrum External Table
You can run profiles on Spectrum external tables that are created using the following file formats:
•PARQUET
•AVRO
•TEXT
•RC
•SEQUENCE
•ORC
Note: If the Spectrum external tables include columns with string data types, those columns are skipped and are not considered for data profiling and data quality.
The data profiling task runs profiles on the following data types:
•SMALLINT
•INTEGER
•BIGINT
•DECIMAL
•REAL
•DOUBLE PRECISION
•BOOLEAN
•CHAR
•VARCHAR
•DATE
•TIMESTAMP
•STRING
•SUPER
Sampling type
Determine the sample rows on which you want to run the data profiling task. You can choose one of the following sampling types:
- All Rows
- Limit N Rows
- Random N Rows
Data Lineage
The following lineage data is available for Amazon Redshift assets:
•From table to view
•Stored Procedures linked to tables or views
•Functions linked to tables or views
•Procedure calling a procedure
•Procedure calling a function
For more information about data lineage, see Data Lineage in the Working With Assets help.