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 first column in the following tables lists ArcGIS data types. The second column lists the cloud data warehouse data types that ArcGIS supports and maps to each ArcGIS data type. A blank field indicates that ArcGIS does not map a cloud data warehouse data type to that ArcGIS data type.
Amazon Redshift
| ArcGIS data type | Redshift data types |
|---|---|
BLOB | |
Date | Date, timestamp, time, timetz, timestamptz |
Double | Bigint, decimal, real, double precision |
Float | |
Geometry | Geometry |
GUID | |
Long Integer | Integer |
Object ID | |
Short Integer | Smallint |
Text | Char, varchar, boolean, hllsketch, super |
Google BigQuery
| ArcGIS data type | BigQuery data types |
|---|---|
BLOB | Bytes |
Date | Date, time, datetime, timestamp |
Double | Int64, float64, numeric, bignumeric |
Float | |
Geometry | Geography |
GUID | |
Long Integer | |
Object ID | |
Short Integer | Boolean |
Text | String, record, array<t> |
Snowflake
| ArcGIS data type | Snowflake data types |
|---|---|
BLOB | Binary |
Date | Date, time, timestamp_ltz, timestamp_ntz, timestamp_tz |
Double | Float, float4, float8, double, number |
Float | |
Geometry | Geography |
GUID | |
Long Integer | |
Object ID | |
Short Integer | |
Text | Varchar |