Google Cloud Spanner Connector > Data type reference > Google Cloud Spanner and transformation data types
  

Google Cloud Spanner and transformation data types

The following table lists the Google Cloud Spanner data types that Data Integration supports and the corresponding transformation data types:
Google Cloud Spanner Data Type
Transformation Data Type
Range and Description for the Transformation Data Type
BOOLEAN
String
1 to 104,857,600 characters
BYTE
Byte
1 to 104,857,600 bytes
DATE
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
FLOAT64
Double
Precision 15
INT64
BigInt
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
STRING
String
1 to 104,857,600 characters
TIMESTAMP
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Note: Google Cloud Spanner Connector does not support the Array data type.