Amazon Redshift Reference

Reference material for Amazon Redshift Publishing -- data type mappings, CLI arguments, and querying.

Data Type Mapping

Source types map automatically to Redshift-compatible types. LakeXpress exports through Parquet, so the mapping is driven by the normalized source type name.

Pick your source database:

PostgreSQL

PostgreSQL to Redshift

PostgreSQL Type	Redshift Type
SMALLINT	SMALLINT
INTEGER, INT4	INTEGER
BIGINT, INT8	BIGINT
NUMERIC(p,s)	DECIMAL(p,s)
REAL, FLOAT4	REAL
DOUBLE PRECISION, FLOAT8	DOUBLE PRECISION
VARCHAR(n)	VARCHAR(n)
TEXT	VARCHAR(MAX)
CHAR(n)	CHAR(n)
BOOLEAN	BOOLEAN
DATE	DATE
TIME	VARCHAR(20)
TIMESTAMP	TIMESTAMP
TIMESTAMPTZ	VARCHAR(40)
BYTEA	VARBYTE
UUID	VARCHAR(36)
JSON, JSONB, array []	SUPER

SQL Server

SQL Server to Redshift

SQL Server Type	Redshift Type
TINYINT, SMALLINT	SMALLINT
INT	INTEGER
BIGINT	BIGINT
DECIMAL(p,s)	DECIMAL(p,s)
MONEY	DECIMAL(19,4)
SMALLMONEY	DECIMAL(10,4)
FLOAT	DOUBLE PRECISION
REAL	REAL
BIT	BOOLEAN
VARCHAR(n), NVARCHAR(n), NCHAR(n)	VARCHAR(n)
CHAR(n)	CHAR(n)
TEXT, NTEXT	VARCHAR(MAX)
DATE	DATE
DATETIME, DATETIME2, SMALLDATETIME	TIMESTAMP
DATETIMEOFFSET	VARCHAR(40)
VARBINARY	VARBYTE
UNIQUEIDENTIFIER	VARCHAR(36)

Oracle

Oracle to Redshift

Oracle Type	Redshift Type
NUMBER	DECIMAL(38,18)
NUMBER(p,s)	DECIMAL(p,s)
FLOAT	DOUBLE PRECISION
VARCHAR2(n), NVARCHAR2(n)	VARCHAR(n)
CHAR(n)	CHAR(n)
CLOB, NCLOB	VARCHAR(MAX)
DATE	DATE
TIMESTAMP	TIMESTAMP
RAW, BLOB	VARBYTE

Teradata

Teradata to Redshift

Teradata Type	Redshift Type
BYTEINT, SMALLINT	SMALLINT
INTEGER	INTEGER
BIGINT	BIGINT
DECIMAL(p,s), NUMERIC(p,s)	DECIMAL(p,s)
NUMBER	DECIMAL(38,18)
FLOAT, REAL	DOUBLE PRECISION
VARCHAR(n)	VARCHAR(n)
CHAR(n)	CHAR(n)
CLOB	VARCHAR(MAX)
DATE	DATE
TIME	VARCHAR(20)
TIMESTAMP	TIMESTAMP
BYTE, VARBYTE, BLOB	VARBYTE

MySQL

MySQL to Redshift

MySQL Type	Redshift Type
TINYINT, SMALLINT, YEAR	SMALLINT
MEDIUMINT, INT	INTEGER
BIGINT	BIGINT
DECIMAL(p,s)	DECIMAL(p,s)
FLOAT, DOUBLE	DOUBLE PRECISION
BIT	BOOLEAN
VARCHAR(n)	VARCHAR(n)
CHAR(n)	CHAR(n)
TINYTEXT	VARCHAR(255)
TEXT, MEDIUMTEXT, LONGTEXT	VARCHAR(MAX)
ENUM, SET	VARCHAR(256)
DATE	DATE
TIME	VARCHAR(20)
DATETIME, TIMESTAMP	TIMESTAMP
BINARY, VARBINARY, BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB	VARBYTE
JSON	SUPER

MariaDB

MariaDB to Redshift

MariaDB Type	Redshift Type
TINYINT, SMALLINT, YEAR	SMALLINT
MEDIUMINT, INT	INTEGER
BIGINT	BIGINT
DECIMAL(p,s)	DECIMAL(p,s)
FLOAT, DOUBLE	DOUBLE PRECISION
BIT	BOOLEAN
VARCHAR(n)	VARCHAR(n)
CHAR(n)	CHAR(n)
TINYTEXT	VARCHAR(255)
TEXT, MEDIUMTEXT, LONGTEXT	VARCHAR(MAX)
ENUM, SET	VARCHAR(256)
DATE	DATE
TIME	VARCHAR(20)
DATETIME, TIMESTAMP	TIMESTAMP
BINARY, VARBINARY, BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB	VARBYTE
JSON	SUPER

SAP HANA

SAP HANA to Redshift

SAP HANA Type	Redshift Type
TINYINT, SMALLINT	SMALLINT
INTEGER	INTEGER
BIGINT	BIGINT
DECIMAL(p,s)	DECIMAL(p,s)
SMALLDECIMAL, CLOB, NCLOB, TEXT, SECONDDATE	VARCHAR(MAX)
REAL	REAL
DOUBLE	DOUBLE PRECISION
BOOLEAN	BOOLEAN
VARCHAR(n), NVARCHAR(n), NCHAR(n)	VARCHAR(n)
CHAR(n)	CHAR(n)
DATE	DATE
TIME	VARCHAR(20)
TIMESTAMP	TIMESTAMP
VARBINARY, BLOB	VARBYTE

CLI Reference

Redshift Publishing Arguments

Option	Type	Description
--publish_target ID	String	Credential ID for Redshift publishing (required)
--publish_method internal|external	String	Table type: native Redshift table (internal) or Spectrum external table (external)
--publish_schema_pattern PATTERN	String	Schema naming pattern (default: {schema} for internal, EXT_{schema} for the default external method, unless set explicitly)
--publish_table_pattern PATTERN	String	Table naming pattern (default: {table})
--sub_path PATH	String	Value substituted for the {subpath} naming token
--pk_constraints	Flag	Add informational PRIMARY KEY constraints (internal tables only)
--n_jobs N	Integer	Parallel workers for table creation (default: 1)

Querying Redshift Tables

Internal table:

SELECT * FROM int_mydata_20260730.customer LIMIT 10;

External table (Spectrum):

SELECT * FROM ext_mydata_20260730.customer LIMIT 10;

See Also

• Amazon Redshift Publishing - Setup and usage guide
• CLI Reference - All command-line options
• Storage Configuration: S3 - S3 credential setup