Supported data types with Apache Iceberg tables - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Supported data types with Apache Iceberg tables

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 - The timestamptz type is not currently supported in Redshift Spectrum.
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.