Column level permission

I am trying to enable column level permission by referring to the official docs.

  1. I cant see aml and sql tabs in the create custom dimension tab as referred in the docs.
  2. 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

1 Like

Hi @hari,

At the moment, we don’t officially support creating AML field in the UI Mode of the Model. It’s still currently our experimental solution.
However, since you’re in the version 4.0, you can just switch to Code view of the Model and write the aml expression from there

Hope this helps. :grin:

1 Like

Thanks alot @Khai_To, this is working fine now

1 Like