Destination BigQuery: map "airbyte_type": "big_number" to BIGNUMERIC

[yurii-bidiuk]

Due to new updates in the building of JSON schema, a new property "airbyte_type" was added to the field description.
One of the possible values for "airbyte_type" is "big_number". Now "airbyte_type" is ignored and all "big_number" fields are mapped as "STRING" in destination BigQuery.
According to #11090 and this comment all fields with "airbyte_type": "big_number" should be mapped as BIGNUMERIC in destination BigQuery.

Input JSON schema example:

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "type": "object",
  "properties": {
    "type_big_number": {"type": "string", "airbyte_type": "big_number"},
  }
}

Input data example:

{
  "type_big_number": "1000000000000000000000000000000000.1234"
}

[yurii-bidiuk]

As datatype mapping for destiantion-bigquery should be done on the normalization side, I'm moving this ticket to the board of Phyton team
cc: @alexandr-shegeda

[grishick]

notes from grooming: in the new protocol that supports annotations for data types, this will not be needed. Likely can close this after Destination BigQuery and normalization are updated to handle new protocol version

[etsybaev]

Depends on https://app.zenhub.com/workspaces/destinations-6332532d6893ce001c7a56a7/issues/airbytehq/airbyte/17642

Basically should be closed along the way once this PR is merged #19721

[grishick]

merged into the feature branch