Hello all
I have been trying to figure out the best way to mask a jsonb column I decided to create a customer algorithm with a dataset of the same structure to get round the challenges of masking jsonb columns.
however in the rule set I set a custom SQL to cast the column to varchar which works fine but when running the masking job it errors because it tries to update the jsonb column with a string from my algorithm and I cant find anyway to cast that string to a jsonb
I assume this isnt possible but thought I would check here first
Thanks in advance for any help given
I am using Delphix Masking - 6.0.5.0 and I am setting up everything through the UI on an EC2 instance and it was setup from the AWS Marketplace AMI
------------------------------
Paul Mathieson
Community Member, Modulr Finance
Delphix Community Members
------------------------------