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.
Amazon Redshift
| 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 |
Google BigQuery
| ArcGIS data type | BigQuery data types | Notes |
|---|---|---|
Big integer | int64 | |
Blob | bytes | |
Date | datetime, timestamp | |
Date only | date | |
Double | float64, numeric, bignumeric | |
Float | Not supported | |
Geometry | geography | |
GUID | Not supported | |
Long integer | Not supported | |
Raster | Not supported | |
Short integer | boolean | |
Text | string, record, array<t> | |
Time only | time | |
Timestamp offset | Not supported |
Snowflake
| ArcGIS data type | Snowflake data types | Notes |
|---|---|---|
Big integer | number and number(p,s) | Scale (s) = 0 and precision (p) is in the range of 10 through 18 inclusive or p = 38 |
Blob | binary | |
Date | timestamp_ltz, timestamp_ntz | |
Date only | date | |
Double | float, float4, float8, double, and number(p,s) | Precision (p) is in the range of 19 through 37 inclusive and scale (s) > 0 |
Float | Not supported | |
Geometry | geography, geometry | |
GUID | Not supported | |
Long integer | number(p,s), where n is in the range 5 through 9 inclusive | Precision (p) is in the range of 5 through 9 inclusive and scale (s) = 0 |
Raster | Not supported | |
Short integer | number(p,s) | Precision (p) is in the range of 1 through 4 inclusive and scale (s) = 0 |
Text | varchar | |
Time only | time | |
Timestamp offset | timestamp_tz |