Understand how Google BigQuery data types map to process field types when you use a Google BigQuery V2 connection in Application Integration.
The following table describes the Google BigQuery data types that you can use with Application Integration:
Google BigQuery data type
Description
Maps to process field type
STRING
Variable-length character data
String
INT64
64-bit signed integer
Integer or Long
FLOAT64
64-bit floating-point number
Double or Float
BOOL
Boolean value (true or false)
Boolean
DATE
Calendar date (year, month, day)
Date
DATETIME
Date and time
DateTime
TIMESTAMP
Absolute point in time with microsecond precision
DateTime or Timestamp
TIME
Time of day, independent of date
String or Time
NUMERIC
Exact numeric value with 38 digits of precision
Decimal or String
BYTES
Variable-length binary data
Binary or String
ARRAY
Ordered list of values
Array or List
STRUCT
Container of ordered fields
Object or Struct
GEOGRAPHY
Geographic data (points, lines, polygons)
String in well-known text (WKT) format
Consider the following factors when you work with Google BigQuery data types:
•Timestamp precision: Google BigQuery TIMESTAMP values have microsecond precision. When you map to DateTime fields, the precision might reduce to milliseconds.
•Numeric precision: For NUMERIC values that require precision, use String fields to avoid rounding errors.
•Complex types: For ARRAY and STRUCT types, ensure your process fields are configured as complex objects that match the structure.
•DATE and TIME: Google BigQuery separates date and time types. Ensure you use the appropriate field type in your process.
•NULL values: All Google BigQuery data types accept NULL values. Ensure your process handles null values appropriately.