Skip to content

🐛 Destination BigQuery : normalization incorrectly processes arrays #13154

Closed
@DoNotPanicUA

Description

@DoNotPanicUA

Current Behavior

The normalization surrounds all incoming values by brackets " and then fails or stores it as surrounded text.

JSON schema: data_type_array_test_catalog.txt

Test data: data_type_array_test_messages.txt

  1. Date fail example:
    The result column contains a normalization error instead of data. The root cause of the error is that value is surrounded by brackets.
    Screenshot from 2022-05-24 23-50-41

  2. Text example:
    The value is double surrounded by brackets which leads to an error when you read this data.
    Screenshot from 2022-05-24 23-52-54

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions