Flat Google Cloud Storage file data types and transformation data types
Flat 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 Google Cloud Storage data types that the Secure Agent supports and the corresponding transformation data types:
Flat Google Cloud Storage Data Type
Transformation Data Type
Description
BigInt
BigInt
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision of 19, scale of 0
Number
Decimal
Precision 1 to 28 digits, scale 0 to 28
Nstring
Text
1 to 104,857,600 characters
Fixed-length or varying-length string.
STRING
String
1 to 104,857,600 characters
Default precision is 256. You can increase the value up to 104857600 characters.
Note: BigInt, Number, and Nstring data types are applicable only when you select Import from Schema File as the Schema Source in the file formatting options.