Salesforce CDP Calculated Insight should not allow SQL to exceed the character limit of 131,021 characters
Trailblazer Community

Salesforce CDP Calculated Insight should not allow SQL to exceed the character limit of 131,021 characters

CDP

Last updated 2022-05-17 ·Reference W-11131473 ·Reported By 0 users

Fixed - Summer '22 Patch 6.0

Summary
When you create a Calculated Insight in Salesforce CDP using the Create with SQL option, you can add SQL of any length and save your Calculated Insight.

However, upon creation the SQL will be cropped once it exceeds the limit of 131,021 characters.

This bug will add validation to check if the SQL exceeds this intended character limit and prevent validation if the SQL is too long.

Repro
-Click New on the Calculated Insight tab.
-Select Create with SQL.
-Add SQL that exceeds 131,021 characters.
-Validate the syntax. Note: no validation error is show.
-Save the Calculated Insight.

Note: the SQL is cropped after characters when you check the Expression tab of the created Calculated Insight. As a result the Calculated Insight will likely fail due to the SQL being cropped.

Workaround
Amend your SQL so that it is within the intended character limit of 131,021.

Reported By (0)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.