BigQuery Datatype Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

BigQuery Datatype Mapping

  • Dark
    Light
  • PDF

Article summary

We align the data types from BigQuery with the corresponding Rivery data types during the data extraction process. In cases where a specific data type isn't compatible, we will convert and assign it as a String type.

The table below illustrates the correlation between BigQuery data types and the equivalent types that are compatible with Rivery:

BigQuery DatatypeRivery Mapping TypeBigQuery's Casting in Multi-Tables River ModeBigQuery's Casting in Custom Query River Mode
ARRAYSTRINGTO_JSON_STRINGTO_JSON_STRING
BIGNUMERICFLOAT
BOOLINTEGERINTEGERINTEGER
BYTESSTRINGTO_JSON_STRING
DATETIMEDATETIMEFORMAT_TIMESTAMP("%Y-%m-%d %H:%M:%E6S)FORMAT_TIMESTAMP("%Y-%m-%d %H:%M:%E6S)
DATEDATE
FLOAT64FLOAT
INT64INTEGER
NUMERICFLOAT
RECORDSTRINGTO_JSON_STRING
STRINGSTRINGTO_JSON_STRING
STRUCTSTRINGTO_JSON_STRING
TIMESTAMPTIMESTAMPFORMAT_TIMESTAMP("%Y-%m-%d %H:%M:%E6S)FORMAT_TIMESTAMP("%Y-%m-%d %H:%M:%E6S)
TIMETIME
GEOGRAPHYSTRINGST_ASGEOJSONTO_JSON_STRING
JSONSTRINGTO_JSON_STRINGTO_JSON_STRING
INTERVALSTRINGTO_JSON_STRINGTO_JSON_STRING

Was this article helpful?

What's Next