Stéphane Burwash
04/06/2022, 9:24 PMKey-error: RECORD
. Anyone ever have this, and if so how did you solve?Stéphane Burwash
04/06/2022, 9:24 PM2022-04-06T21:21:43.911337Z [error ] Loading failed code=2 job_id=dev_hubspot-to-bigquery message=CRITICAL ['Traceback (most recent call last):\n', ' File "/home/stephane/Documents/projects/meltano-projects/meltano/.meltano/loaders/target-bigquery/venv/lib/python3.9/site-packages/target_bigquery/__init__.py", line 129, in main\n for state in state_iterator:\n', ' File "/home/stephane/Documents/projects/meltano-projects/meltano/.meltano/loaders/target-bigquery/venv/lib/python3.9/site-packages/target_bigquery/process.py", line 54, in process\n for s in handler.handle_record_message(msg):\n', ' File "/home/stephane/Documents/projects/meltano-projects/meltano/.meltano/loaders/target-bigquery/venv/lib/python3.9/site-packages/target_bigquery/processhandler.py", line 179, in handle_record_message\n nr = format_record_to_schema(nr, self.bq_schema_dicts[stream])\n', ' File "/home/stephane/Documents/projects/meltano-projects/meltano/.meltano/loaders/target-bigquery/venv/lib/python3.9/site-packages/target_bigquery/schema.py", line 354, in format_record_to_schema\n record[k] = format_record_to_schema(record[k], bq_schema[k]["fields"])\n', ' File "/home/stephane/Documents/projects/meltano-projects/meltano/.meltano/loaders/target-bigquery/venv/lib/python3.9/site-packages/target_bigquery/schema.py", line 357, in format_record_to_schema\n record[k] = [conversion_dict[bq_schema[k]["type"]](vi) for vi in v]\n', ' File "/home/stephane/Documents/projects/meltano-projects/meltano/.meltano/loaders/target-bigquery/venv/lib/python3.9/site-packages/target_bigquery/schema.py", line 357, in <listcomp>\n record[k] = [conversion_dict[bq_schema[k]["type"]](vi) for vi in v]\n', "KeyError: 'RECORD'\n"] name=meltano run_id=e83dd4e4-e394-48c1-adc3-a0c308e4d651
dan_ladd
04/06/2022, 9:29 PM{}
when running --discover on the tap.
To overcome this, you can define the empty properties and pass that with the --catalog.pranit__warehows.io_
04/07/2022, 5:34 AMpranit__warehows.io_
04/07/2022, 5:35 AMdan_ladd
04/07/2022, 1:05 PMStéphane Burwash
04/07/2022, 1:22 PMStéphane Burwash
04/07/2022, 1:23 PMpranit__warehows.io_
04/07/2022, 3:54 PM2022-04-07T15:48:25.729926Z [error ] Loading failed code=2 job_id=2022-04-07T154822--tap-klaviyo--target-bigquery message=CRITICAL ['Traceback (most recent call last):\n', ' File "/home/pranit/meltano-projects/meltano-projects/nhg/.meltano/loaders/target-bigquery/venv/lib/python3.8/site-packages/target_bigquery/__init__.py", line 129, in main\n for state in state_iterator:\n', ' File "/home/pranit/meltano-projects/meltano-projects/nhg/.meltano/loaders/target-bigquery/venv/lib/python3.8/site-packages/target_bigquery/process.py", line 54, in process\n for s in handler.handle_record_message(msg):\n', ' File "/home/pranit/meltano-projects/meltano-projects/nhg/.meltano/loaders/target-bigquery/venv/lib/python3.8/site-packages/target_bigquery/processhandler.py", line 179, in handle_record_message\n nr = format_record_to_schema(nr, self.bq_schema_dicts[stream])\n', ' File "/home/pranit/meltano-projects/meltano-projects/nhg/.meltano/loaders/target-bigquery/venv/lib/python3.8/site-packages/target_bigquery/schema.py", line 359, in format_record_to_schema\n record[k] = conversion_dict[bq_schema[k]["type"]](v)\n', "KeyError: 'RECORD'\n"] name=meltano run_id=9a0d7c7e-bc89-4df9-bcc0-c8cb30994ca0
dan_ladd
04/07/2022, 6:17 PMStéphane Burwash
04/07/2022, 6:38 PMpranit__warehows.io_
04/08/2022, 4:05 AMpranit__warehows.io_
04/08/2022, 4:19 AMpranit__warehows.io_
04/08/2022, 4:22 AMpranit__warehows.io_
04/08/2022, 8:54 AMdan_ladd
04/08/2022, 1:04 PM"event_properties": {
"type": "object",
"properties": {}
},
"person": {
"type": "object",
"properties": {}
}
pranit__warehows.io_
04/08/2022, 2:45 PMpranit__warehows.io_
04/08/2022, 2:46 PMpranit__warehows.io_
04/08/2022, 2:50 PMpranit__warehows.io_
04/08/2022, 5:22 PMpranit__warehows.io_
04/08/2022, 5:44 PMtarget-jsonl
. Catalog created using discover command and singer discover utility
2022-04-07T15:48:25.729926Z [error ] Loading failed code=2 job_id=2022-04-07T154822--tap-klaviyo--target-bigquery message=CRITICAL ['Traceback (most recent call last):\n', ' File "/home/pranit/meltano-projects/meltano-projects/nhg/.meltano/loaders/target-bigquery/venv/lib/python3.8/site-packages/target_bigquery/__init__.py", line 129, in main\n for state in state_iterator:\n', ' File "/home/pranit/meltano-projects/meltano-projects/nhg/.meltano/loaders/target-bigquery/venv/lib/python3.8/site-packages/target_bigquery/process.py", line 54, in process\n for s in handler.handle_record_message(msg):\n', ' File "/home/pranit/meltano-projects/meltano-projects/nhg/.meltano/loaders/target-bigquery/venv/lib/python3.8/site-packages/target_bigquery/processhandler.py", line 179, in handle_record_message\n nr = format_record_to_schema(nr, self.bq_schema_dicts[stream])\n', ' File "/home/pranit/meltano-projects/meltano-projects/nhg/.meltano/loaders/target-bigquery/venv/lib/python3.8/site-packages/target_bigquery/schema.py", line 359, in format_record_to_schema\n record[k] = conversion_dict[bq_schema[k]["type"]](v)\n', "KeyError: 'RECORD'\n"] name=meltano run_id=9a0d7c7e-bc89-4df9-bcc0-c8cb30994ca0
pranit__warehows.io_
04/08/2022, 5:45 PMdan_ladd
04/09/2022, 1:00 AM