SQL cell issue

Traceback (most recent call last):
at block 2, line 1
at #1line 5, in _datalore_internal_python_execute_sql_query(sql_query, database_id, user_id, parameters)
at #1line 40, in _datalore_internal_execute_sql_query(sql_query, database_id, user_id, parameters)
at /opt/python/lib/python3.8/json/init.pyline 357, in loads(s, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)
at /opt/python/lib/python3.8/json/decoder.pyline 337, in decode(self, s, _w)
at /opt/python/lib/python3.8/json/decoder.pyline 353, in raw_decode(self, s, idx)
JSONDecodeError: Unterminated string starting at: line 1 column 5275643 (char 5275642)

I checked the query directly on Snowflake worksheet and it is working fine. But the same query is throwing error on Datalore SQL cells. How do I fix this?

1 Like

We found and fixed a race condition which caused JSONDecodeError during the data processing step. The fix is already deployed to our cloud instance (datalore.jetbrains.com) and will also be included into the next Enterprise release (2023.2, mid-April).

Thank you!