I am trying to enable column level permission by referring to the official docs.
- I cant see aml and sql tabs in the create custom dimension tab as referred in the docs.
- would be helpful if anyone could help with the right command.
this is the command i am referring now from the docs
I am using holistics 4.0
i have defined user attribute pii_access
custom dimension code I am using:
case(
when:H.current_user.pii_access=1,
then: {{ solar_id }},
else: “redacted”
)
and the error I am getting:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'when:H.current_user.pii_access=1, then: dealer_visit
.solarId
, else: ’ at line 5