Overview
The Amazon Redshift data source template provides metadata ingestion, data type mappings, and profiling definitions for Amazon Redshift data warehouse connections.
Platform: Amazon Redshift
Connection Category: Database
Template Category: Marketplace
What's Included
Connection Configuration
- Supports Redshift native and ODBC connections
- Identifier delimiters:
"/"
Data Type Mappings
Includes mappings for Redshift data types:
- String types:
VARCHAR,CHAR,BPCHAR,TEXT - Numeric types:
INTEGER,INT4,BIGINT,INT8,SMALLINT,INT2,DECIMAL,NUMERIC,REAL,FLOAT4,DOUBLE PRECISION,FLOAT8 - Date/time types:
DATE,TIMESTAMP,TIMESTAMPTZ,TIME,TIMETZ - Boolean:
BOOLEAN,BOOL - Other:
SUPER,HLLSKETCH,GEOMETRY,GEOGRAPHY
Metadata Ingestion
Queries Redshift's INFORMATION_SCHEMA and SVV_* system views to discover schemas, tables, and columns.
Installation
Customization
Common customizations:
- Schema filters — Exclude Redshift system schemas and internal schemas
- External schemas — Include or exclude Redshift Spectrum external schemas
- Distribution and sort keys — Add custom profiles for Redshift-specific table properties