Contents x
    BigQuery Datatype Mapping
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    BigQuery Datatype Mapping

    • 1 Minute to read
    • Print
    • 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