Cloud data warehouse data types supported in ArcGIS
ArcGIS works with specific data types. When you access a table in a cloud data warehouse through a database connection, query layer, or web service, ArcGIS filters out any unsupported data types and does not display them.
The following tables list the cloud data warehouse data types that map to an ArcGIS data type. If an ArcGIS data type is not listed, that data type is not supported for the cloud data warehouse.
|
ArcGIS data type |
Redshift data types |
Notes |
|---|---|---|
|
Big integer |
bigint, decimal(p,s) |
Precision (p) is in the range of 10 through 18 inclusive and scale (s) = 0 |
|
Blob |
Not supported |
|
|
Date |
timestamp, timestamptz |
|
|
Date only |
date |
|
|
Double |
double precision, decimal(p,s) |
Precision (p) is > 9 and scale (s) > 0 or p = 19 and s = 0. |
|
Float |
real, decimal(p,s) |
Precision (p) is in the range of 1 through 9 inclusive and scale (s) > 0 |
|
Geometry |
geometry |
|
|
GUID |
Not supported |
|
|
Long integer |
integer, decimal(p,s) |
Precision (p) is in the range of 5 through 9 inclusive and scale (s) = 0 |
|
Raster |
Not supported |
|
|
Short integer |
smallint, decimal(p,s) |
Precision (p) is in the range of 1 through 4 inclusive and scale (s) = 0 |
|
Text |
char, varchar, boolean, hllsketch, super |
|
|
Time only |
time without time zone, timetz |
|
|
Timestamp offset |
Not supported |