When I use show tblproperties on a view/table to see the metadata, it will redact any value which has "userid" anywhere put in to it.

And it is not just through the visual interface, when I query it through python directly, it contains the redacted value.

To reproduce.

create or replace view tmp_view tblproperties (

   notes='userid',

   notes2='myuserid',

   something='this will be fine'

)

as

select 1 as a;

 

 

and then just run

 

show tblproperties tmp_view