Hello All, I am trying to load klaviyo data into ...
# troubleshooting
p
Hello All, I am trying to load klaviyo data into big query. But while running big query pipeline it fetches below error. What I think is target is not able to identify the target tables due to file
table_config
has anyone ever loaded json data into big query? My pipeline works fine when I load data into
target-jsonl
. Please help if you have done similar implementation ``` meltano elt tap-klaviyo target-bigquery 2022-04-08T073657.151263Z [info ] Running extract & load... job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=meltano run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d 2022-04-08T073657.200926Z [warning ] No state was found, complete import. 2022-04-08T073658.073478Z [info ] INFO METRIC: {"type": "timer", "metric": "http_request_duration", "value": 0.2923893928527832, "tags": {"endpoint": "bounce", "http_status_code": 200, "status": "succeeded"}} cmd_type=extractor job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=tap-klaviyo run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdio=stderr 2022-04-08T073658.084611Z [info ] INFO Replicated bounce up to {'since': '2021-07-04T170952Z'} cmd_type=extractor job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=tap-klaviyo run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdio=stderr 2022-04-08T073658.332504Z [info ] INFO METRIC: {"type": "timer", "metric": "http_request_duration", "value": 0.24312186241149902, "tags": {"endpoint": "bounce", "http_status_code": 200, "status": "succeeded"}} cmd_type=extractor job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=tap-klaviyo run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdio=stderr 2022-04-08T073658.343660Z [info ] INFO Replicated bounce up to {'since': '2021-07-08T184559Z'} cmd_type=extractor job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=tap-klaviyo run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdio=stderr 2022-04-08T073658.622826Z [info ] INFO METRIC: {"type": "timer", "metric": "http_request_duration", "value": 0.274533748626709, "tags": {"endpoint": "bounce", "http_status_code": 200, "status": "succeeded"}} cmd_type=extractor job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=tap-klaviyo run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdio=stderr 2022-04-08T073658.633150Z [info ] INFO Replicated bounce up to {'since': '2021-07-13T130524Z'} cmd_type=extractor job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=tap-klaviyo run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdio=stderr 2022-04-08T073658.926897Z [info ] INFO METRIC: {"type": "timer", "metric": "http_request_duration", "value": 0.28935813903808594, "tags": {"endpoint": "bounce", "http_status_code": 200, "status": "succeeded"}} cmd_type=extractor job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=tap-klaviyo run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdio=stderr 2022-04-08T073658.937656Z [info ] INFO Replicated bounce up to {'since': '2021-07-14T110120Z'} cmd_type=extractor job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=tap-klaviyo run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdio=stderr 2022-04-08T073659.085683Z [info ] INFO bounce schema: {'properties': {'uuid': {'type': 'string'}, 'event_name': {'type': 'string'}, 'timestamp': {'type': 'integer'}, 'object': {'type': 'string'}, 'datetime': {'type': 'string'}, 'statistic_id': {'type': 'string'}, 'id': {'type': 'string'}, 'event_properties': {'properties': {}, 'type': 'object'}, 'person': {'properties': {}, 'type': 'object'}}, 'type': 'object'} cmd_type=loader job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=target-bigquery run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdio=stderr 2022-04-08T073659.086097Z [info ] WARNING the pipeline might fail because of undefined fields: an empty object/dictionary indicated as {} cmd_type=loader job_id=2022-04-08T073656--tap-klaviyo--target-bigquery name=target-bigquery run_id=520c1185-dd0f-4df8-96e5-0ab695cd7f0d stdi…
@atharh