JSON Google Cloud Storage file data types and transformation data types
JSON Google Cloud Storage file data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the JSON Google Cloud Storage file data types that the Secure Agent supports and the corresponding transformation data types:
JSON Google Cloud Storage File Data Type
Transformation Data Type
Range and Description
ARRAY¹
Array
Unlimited number of characters
BIGINT
Bigint
Precision of 19 digits, scale of 0
BOOLEAN
Integer
TRUE (1) or FALSE (0)
DOUBLE
Double
Precision 15
INTEGER
Integer
-2,147,483,648 to 2,147,483,647
Precision of 10, scale of 0
OBJECT¹
Struct
Unlimited number of characters
STRING
String
1 to 104,857,600 characters
Default precision is 256. You can increase the value up to 104857600 characters.
¹Applies only to mappings in advanced mode.
Note: The following JSON complex data types are not applicable for Google Cloud Storage V2 Connector: