Google Cloud Storage V2 Connector > Data type reference > Parquet Google Cloud Storage file data types and transformation data types
  

Parquet Google Cloud Storage file data types and transformation data types

Parquet 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 file data types that the Secure Agent supports and the corresponding transformation data types:
Parquet Google Cloud Storage File Data Type
Transformation
Description
BIGINT
Bigint
Precision of 19 digits, scale of 0.
BOOLEAN
Integer
TRUE (1) or FALSE (0)
DATE
Date/Time
January 1, 0001 to December 31, 9999.
DECIMAL
Decimal
Precision 1 to 28 digits, scale 0 to 28.
Note: You cannot use decimal values with precision greater than 28.
DOUBLE
Double
Precision of 15 digits.
FLOAT
Double
Precision of 15 digits.
Int32
Integer
-2,147,483,648 to 2,147,483,647
Precision of 10, scale of 0
Int64
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision of 19, scale of 0
Int96
Date/Time
Jan1,0001 to Dec 31, 9999. Precision of 29, scale of 9.
Map¹
Map
Unlimited number of characters.
Struct¹
Struct
Unlimited number of characters.
String
String
-1 to 104,857,600 characters.
Time
Date/Time
Time of the day. Precision to microsecond.
Timestamp
Date/Time
January 1, 0001 00:00:00 to December 31, 9999 23:59:59.997. Precision to microsecond.
Note: You cannot set precision to nanoseconds.
group(LIST)¹
Array
Unlimited number of characters.
¹Applies only to mappings in advanced mode.
Note: The following Parquet complex data types are not applicable for Google Cloud Storage V2 Connector:
The Parquet schema that you specify to read or write a Parquet file must be in lowercase. Parquet does not support case-sensitive schema.