Is there a way to hide some specific columns in SPICE datasets from analyses?
CLS could make the column locked from analysis, but that is not hidden.
Hi @hoyeon
You can exclude specific columns when creating or editing a dataset in Quick Sight. This will ensure that the excluded columns are not available for analyses.
We will create a dataset by SDK. Is it possible to exclude columns by API?
1 more thing to check is that we will use the hidden columns for RLS keys. Would it work with RLS after we exclude the columns from datasets?
Hi @hoyeon
No, Quick Sight API does not support for excluding columns when creating datasets via the SDK. However, you can work around this by modifying the CustomSql field in the API request to exclude specific columns at the SQL level before creating the dataset.
If you exclude columns from the dataset, those columns will no longer be available for use in Quick Sight, including for Row-Level Security (RLS) keys. RLS works by applying filters based on the columns in your dataset, so if a column is excluded, it cannot be used to define RLS rules.
We definitely need those columns for RLS rules. We will add CLS config to allow only specific users/groups for those columns and make them disabled from analysis for other users.