I’ve run into a problem with an RLS dataset. The field used for validation is of type STRING and contains comma-separated, concatenated IDs that are used to filter data from datasets for the dashboard. However, this field includes too many IDs and its length exceeds 2,047 characters. Is there any workaround to handle this—for example, if I have several hundred concatenated IDs?
Hi @zubr
Welcome to the community!
Quick Suite enforces a field length limit of 2047 Unicode characters for any value in a SPICE dataset, including fields used in permissions (RLS) datasets for row level security. Fields longer than this are truncated during ingestion, so having a single field with several hundred comma separated IDs easily exceeds this maximum, causing issues with filtering and data security.
Instead of storing all IDs in a single comma separated string per user, create multiple rows for each user ID pair. For example, if one user has access to 300 IDs, the permissions dataset should have 300 separate rows, each listing the user and one ID.
Please refer to the following documentation this might be helpful for you.