Json object limit

Ask for Help
1

Hello everyone,

I’m encountering an issue with a JSON template column and wanted to check if there’s a known limit on its length.

In my setup, I’m joining multiple JSON objects from two tables into a single array, which is then split into a helper table. This approach has been working fine—until today. Suddenly, the JSON template is throwing an error.

I’ve verified that all individual JSON objects from the source tables are correctly formatted. I also tested by limiting the query to reduce the size of the resulting JSON array, and it works under those conditions. However, it’s not very predictable.

From my tests, it seems that once the JSON string exceeds approximately 33,200 characters, the process fails. This is strange, as we’ve successfully handled longer JSON strings in the past without issues.

Has there been a recent change in limits or behavior? Or was this limit always in place and we’ve just now hit it?

Thanks in advance for your help!

Best regards,
Lucas

2

As far as I understand, the limit of characters in a single cell should be around 1 million. 32k is much lower than that threshold.

I’m not aware of any recent changes. Can you show us what was the error for the JSON template column?

1 Like