Connector Improvement: Zendesk Connector user Table Does Not Support Masking of PII
Answered
Hi team, we are extracting user table using Zendesk Support Connector.
We notice that the data for admin, agent and end-user are all loaded into the user table. The user table contains client PII information such as name, email and phone number. We are not able to do conditional hashing based on the role of the user. We would like to hash the PII columns for records with end-user role. On the other hand, we need the name and email for agent and admin so that we can identify agents handling Zendesk tickets.
production=# SELECT DISTINCT role FROM ext__zendesk.user;
role
----------
admin
agent
end-user
(3 rows)
I suggest breaking the user table into three subsets based on their roles, for example user_admin, user_agent, user_end_user.
-
Official comment
Hi Bolin,
I can understand your request. Thanks for submitting it. While we don't support this today, here are two ideas for workarounds you may have already considered.
- Create (secure) views in your destination with limited access
- Hash the values in fivetran and repopulate admin/agent data by joining a separately created data set (perhaps via cloud function or google sheets) on user ID values
In the meantime, we'll monitor this request for demand and update this thread if it becomes prioritized!
Please sign in to leave a comment.
Comments
1 comment