XSD Datatype Mapping
Redshift supports multiple aliases and synonyms for datatypes. The following table shows how those datatypes are mapped to XSD data types in the plug-in.
| Data Type | Aliases | XSD Format Mapping in BW | Description |
|---|---|---|---|
| SMALLINT | INT2 | xsd:short | Signed two-byte integer |
| INTEGER | INT, INT4 | xsd:int | Signed four-byte integer |
| BIGINT | INT8 | xsd:long | Signed eight-byte integer |
| DECIMAL | NUMERIC | xsd:decimal | Exact number of selectable precision |
| REAL | FLOAT4 | xsd:float | Single precision floating-point number |
| DOUBLE PRECISION | FLOAT8, FLOAT | xsd:double | Double precision floating-point number |
| BOOLEAN | BOOL | xsd:boolean | Logical Boolean (true/false) |
| CHAR | CHARACTER, NCHAR, BPCHAR | xsd:string | Fixed-length character string |
| VARCHAR | CHARACTER VARYING, NVARCHAR, TEXT | xsd:string | Variable-length character string with a user-defined limit |
| DATE | NONE | xsd:date | Calendar date (year, month, day) |
| TIMESTAMP | TIMESTAMP WITHOUT TIME ZONE | xsd:dateTime | Date and time (without time zone) |
| TIMESTAMPTZ | TIMESTAMP WITH TIME ZONE | xsd:dateTime | Date and time (with time zone) |