Supported data types
The following data types in Amazon Redshift are supported with the Spark connector. For a complete list of supported data types in Amazon Redshift, see Data types. If a data type is not in the table below, it's not supported in the Spark connector.
| Data type | Aliases |
|---|---|
| SMALLINT | INT2 |
| INTEGER | INT, INT4 |
| BIGINT | INT8 |
| DECIMAL | NUMERIC |
| REAL | FLOAT4 |
| DOUBLE PRECISION | FLOAT8, FLOAT |
| BOOLEAN | BOOL |
| CHAR | CHARACTER, NCHAR, BPCHAR |
| VARCHAR | CHARACTER VARYING, NVARCHAR, TEXT |
| DATE | |
| TIMESTAMP | Timestamp without time zone |
| TIMESTAMPTZ | Timestamp with time zone |
| SUPER | |
| TIME | Time without time zone |
| TIMETZ | Time with time zone |
| VARBYTE | VARBINARY, BINARY VARYING |