Hey team I am getting the following error when I am Extracti Meltano #troubleshooting

Hey team I am getting the following error when I a...

Paschalis Dimitriou

03/20/2024, 4:13 PM

Hey team I am getting the following error when I am Extracting data from: tap-google-search-console and loading the data into meltanolabs-target-snowflake.

Copy code

File "/Desktop/Repositories/chm-etl/.meltano/loaders/target-snowflake/venv/lib/python3.9/site-packages/jsonschema/_keywords.py", line 188, in multipleOf cmd_type=elb consumer=True name=target-snowflake--google producer=False stdio=stderr string_id=target-snowflake--google
failed = instance % dB     cmd_type=elb consumer=True name=target-snowflake--google producer=False stdio=stderr string_id=target-snowflake--google
decimal.InvalidOperation: [<class 'decimal.DivisionImpossible'>]

More precisely from table: PERFORMANCE_REPORT_CUSTOM table the position col is causing the issues. I expect that a decimal value of high precision is causing this error. Any ideas on how to procceed/bypass? I tried adding a stream_map but i can't round over there as it is not supported.

✅ 1

Paschalis Dimitriou

03/21/2024, 10:31 AM

Problem solved. For reference for the rest. The issue was the combination of: • decimal division (precision of 28) • tap-google-search-console "multipleOf": 1e-25 • and the fact that the potision value was more than 1000 -> 4 digits ◦ so in total i had 25+4 -> 29>28 that is supported by python decimal division. Solved it by changing the multipleOf value through the schema parameter of the meltano.config for the position column of all streams from google search console.

17 Views

Open in Slack

Previous Next