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.

Amazon Redshift

ArcGIS data typeRedshift data typesNotes

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 typeBigQuery data typesNotes

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