topic Bug with show tblproperties directly returning redacted in the result set where "userid" in value in Get Started Discussions

Bug with show tblproperties directly returning redacted in the result set where "userid" in value

SamDataWalk — Sun, 24 Dec 2023 11:52:29 GMT

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'

)

select 1 as a;

and then just run

show tblproperties tmp_view

Re: Bug with show tblproperties directly returning redacted in the result set where "userid&quo

SamDataWalk — Sun, 24 Dec 2023 11:53:02 GMT

How do I report this as a bug?

Re: Bug with show tblproperties directly returning redacted in the result set where "userid&quo

PatDBX — Thu, 07 Mar 2024 16:48:26 GMT

I understand that yours is a View. For my case, it's a Table so I could use `desc detail <schema_name>.<table_name>` to get the table properties info that are not redacted in the `properties` column from the `desc detail` output.