Supported data types with Apache Iceberg tables - Amazon Redshift

Supported data types with Apache Iceberg tables

This topic describes the supported data types that Redshift Spectrum can read from tables in Apache Iceberg format.

Amazon Redshift can query Iceberg tables that contain the following data types:

binary
boolean
date
decimal
double
float
int
list
long
map
string
struct
timestamp without time zone

For more information about Iceberg data types, see the Schemas for Iceberg in the Apache Iceberg documentation.

The following table shows the relationship between Amazon Redshift data types and Iceberg table data types.

Iceberg type Amazon Redshift type Notes
boolean boolean
- tinyint Not supported for Iceberg tables in Amazon Redshift.
- smallint Not supported for Iceberg tables in Amazon Redshift.
int int In Amazon Redshift SQL statements, this type is INTEGER.
long bigint
double double
float float
decimal(P, S) decimal(P, S) P is precision, S is scale.
- char Not supported for Iceberg tables in Redshift Spectrum.
string string In Amazon Redshift SQL statements, this type is VARCHAR.
binary binary
date date
time -
timestamp timestamp
timestamptz -
list<E> array
map<K,V> map
struct<...> struct
fixed(L) - The fixed(L) type is not currently supported in Redshift Spectrum.

For more information about data types in Amazon Redshift, see Data types.