hello I am running a pipeline from chargebee =>...
# troubleshooting
d
hello I am running a pipeline from chargebee => bigquery and I am getting this error with denormalization on, Command
Copy code
docker run -v $(pwd):/projects -w /projects meltano/meltano --environment=dev run --full-refresh tap-chargebee target-bigquery
Error
Copy code
raise exceptions.from_http_response(response) cmd_type=elb consumer=True name=target-bigquery producer=False stdio=stderr string_id=target-bigquery
2023-06-16T22:42:07.080608Z [info     ] google.api_core.exceptions.BadRequest: 400 POST <https://bigquery.googleapis.com/bigquery/v2/projects/nucalmv3-dev/datasets/meltano/tables?prettyPrint=false>: Invalid field name "validation_status,". Fields must contain the allowed characters, and be at most 300 characters long. For allowed characters, please refer to <https://cloud.google.com/bigquery/docs/schemas#column_names> cmd_type=elb consumer=True name=target-bigquery producer=False stdio=stderr string_id=target-bigquery
d
@doug_read I've submitted a fix to tap-chargebee: https://github.com/hotgluexyz/tap-chargebee/pull/34. You can already use that in your Meltano project by changing
pip_url
on
tap-chargebee
to
git+<https://github.com/DouweM/tap-chargebee.git@fix-validation-status>
and running
meltano install
.
d
awesome, sorry i am new to these frameworks, i saw that but wasn’t sure why it’s there
have to fix a few more fields, making some git PR’s