Skip to content

contact_lists.* to target-bigquery causes OBJECT is not a valid value  #171

Description

@crackedbeefcake

the target-bigquery throws and OBJECT is not a valid value error when data from hubspot-tap is piped into it.

meltano invoke tap-hubspot | meltano invoke target-bigquery

INFO Appending to t_test-contact_lists_0ca3xxxa20c1
INFO loading t_test-contact_lists_0ca3xx20c1 to BigQuery
ERROR failed to load table t_test-contact_lists_0ca39xx20c1 from file: 400 POST https://bigquery.googleapis.com/upload/bigquery/v2/projects/warehxx6/jobs?uploadType=resumable: Invalid value for type: OBJECT is not a valid value
CRITICAL 400 POST https://bigquery.googleapis.com/upload/bigquery/v2/projects/warehxxx06/jobs?uploadType=resumable: Invalid value for type: OBJECT is not a valid value

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions