Hi, for z3z1ma's target-bigquery I am getting this...
# troubleshooting
j
Hi, for z3z1ma's target-bigquery I am getting this error when setting upsert to True
Copy code
2024-07-15T03:31:26.531723Z [info     ]   File "/workspaces/meltano/meltano-uowaikato-main/.meltano/loaders/target-bigquery/venv/lib/python3.11/site-packages/referencing/jsonschema.py", line 56, in _legacy_dollar_id cmd_type=elb consumer=True job_name=dev:tap-tiktok-to-target-bigquery name=target-bigquery producer=False run_id=b0731a91-d41a-4027-9540-c1ac834ea862 stdio=stderr string_id=target-bigquery
2024-07-15T03:31:26.531817Z [info     ]     id = contents.get("$id")   cmd_type=elb consumer=True job_name=dev:tap-tiktok-to-target-bigquery name=target-bigquery producer=False run_id=b0731a91-d41a-4027-9540-c1ac834ea862 stdio=stderr string_id=target-bigquery
2024-07-15T03:31:26.531901Z [info     ]          ^^^^^^^^^^^^          cmd_type=elb consumer=True job_name=dev:tap-tiktok-to-target-bigquery name=target-bigquery producer=False run_id=b0731a91-d41a-4027-9540-c1ac834ea862 stdio=stderr string_id=target-bigquery
2024-07-15T03:31:26.532010Z [info     ] AttributeError: 'str' object has no attribute 'get' cmd_type=elb consumer=True job_name=dev:tap-tiktok-to-target-bigquery name=target-bigquery producer=False run_id=b0731a91-d41a-4027-9540-c1ac834ea862 stdio=stderr string_id=target-bigquery
I saw there is an issue that is completed on Github fixing this https://github.com/z3z1ma/target-bigquery/issues/87 Not sure why my vesrion installed is still having this problem
Copy code
- name: target-bigquery
    variant: z3z1ma
    pip_url: git+<https://github.com/z3z1ma/target-bigquery.git>
    config:
      dataset: '${BQ_DATASET}'
      project: REDACTED
      location: REDACTED
      denormalized: true
      options:
        storage_write_batch_mode: true
      method: batch_job
      upsert: 'True'
a
mmm I rather some times define the pypi packange and the version to make sure I am using the latest
e
can you change
upsert: 'True'
to
upsert: true
? https://github.com/meltano/hub/issues/1266
🙌 1
j
Thanks @Edgar Ramírez (Arch.dev) This was the issue and it is working now
👌 1
The interactive CLI for target-bigquery saves the input as a string, I'll make an issue on github