The masking function example in this document generates SQL like this:
SELECT "'--- masked ---'" "users__first_name" FROM ECOM.USERS AS "users"
This is incorrect because quotes indicate a column name. If we remove the escaped quotes, then the query works.
Definitely feel free to tell me I'm wrong, this is just what I experienced in testing!
Check List
[ ] Tests has been run in packages where changes made if available
[ ] Linter has been run for changed code
[ ] Tests for the changes have been added if not covered yet
[ ] Docs have been added / updated if required
Issue Reference this PR resolves
[For example #12]
Description of Changes Made (if issue reference is not provided)
The masking function example in this document generates SQL like this:
SELECT "'--- masked ---'" "users__first_name" FROM ECOM.USERS AS "users"
This is incorrect because quotes indicate a column name. If we remove the escaped quotes, then the query works.Definitely feel free to tell me I'm wrong, this is just what I experienced in testing!
Check List
Issue Reference this PR resolves
[For example #12]
Description of Changes Made (if issue reference is not provided)
[Description goes here]