if

Supported Signatures

function if(bool, $1, $1) returns $1

🔗 Official Documentation

reclassify

Changes the classification label of the first argument from the expected classifier specified by the second argument to the desired classifier specified by the third. The expected and desired classifiers must belong to the same classifier group. No other classifiers attached to the first argument are impacted. The function will emit a warning if the the first argument does not have the expected classifier

Examples:

examples.sql
select reclassify(12345, 'pii.clear_text', 'pii.masked') as value; -- value '12345'

Supported Signatures

function reclassify($1, string, string) returns $1
function reclassify($1, string) returns $1

🔗 Official Documentation