BigQuery Data Type Conversions

NOTE: The Cloud Dataprep data types listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

When a BigQuery data type is imported, its data type is remapped according to the following table.

Tip: Data precision may be lost during conversion. You may want to generate min and max values and compute significant digits for values in your BigQuery tables and then compute the same in Cloud Dataprep by TRIFACTA.

Source Data TypeSupported?Cloud Dataprep Data Type
StringYString
BytesYString
IntegerYInteger
FloatYDecimal
BooleanYBoolean
TimestampYDatetime
DateYDatetime
TimeYDatetime
DatetimeYDatetime
ArrayYArray
RecordYObject

Publish/Write

NOTE: Cloud Dataprep data types not listed here are written as string types in the target database.

Cloud Dataprep Data Type BigQuery Data TypeNotes
StringString
IntegerInteger
DecimalFloat
BooleanBoolean
DatetimeDatetimeTarget data type is based on the underlying data. Time zone information is lost.
Datetime (timestamp)TimestampTarget data type is based on the underlying data. Time zone information is retained.
ArrayString
ObjectString
Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation