---
title: "Amazon Redshift Data Source Template"
slug: "amazon-redshift-data-source-template"
updated: 2026-08-13T18:30:19Z
published: 2026-08-13T18:30:19Z
canonical: "docs.validatar.com/amazon-redshift-data-source-template"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.validatar.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Amazon Redshift Data Source Template

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

## Related Articles

- [What Is a Data Source Template?](/docs/what-is-a-data-source-template-overview)
- [Metadata Ingestion Scripts — SQL Templates](/docs/metadata-ingestion-scripts-sql-templates)