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 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 typeRedshift 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 typeBigQuery 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 typeSnowflake 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