topic Re: Databricks bug with show tblproperties - redacted - Azure databricks in Data Engineering

Databricks bug with show tblproperties - redacted - Azure databricks

SamDataWalk — Sun, 03 Mar 2024 17:28:08 GMT

I am struggling to report what is a fairly fundamental bug. Can anyone help? Ideally someone from Databricks themselves. Or others who can confirm they can replicate it.

There is a bug where databricks seems to be hiding “any” properties which have the characters “user” in them.

This is not just in the display, but in the actual underlying result set.

To reproduce the bug.

create or replace view tmp_view

tblproperties ( notes='userid', notes2='myuserid', something='this will be fine')

select 1 as a;

Now in the next cell just run

show tblproperties tmp_view

and it doesn’t just hide the data from the diusplay, but it changes the data inside the resultset. My application which connects to databricks and runs this command is actually getting the string *****(redacted)

Re: Databricks bug with show tblproperties - redacted - Azure databricks

PatDBX — Thu, 07 Mar 2024 16:53:12 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.

Re: Databricks bug with show tblproperties - redacted - Azure databricks

SamDataWalk — Thu, 07 Mar 2024 17:36:38 GMT

Yes, it is indeed a view which that command errors for.

thanks anyway, appreciate the suggestion

Re: Databricks bug with show tblproperties - redacted - Azure databricks

SamDataWalk — Fri, 08 Mar 2024 07:55:47 GMT

I managed to get a response back from support at databricks.

Admittedly it is a bit nuclear, but there is a way of switching it off.

spark.conf.set("spark.databricks.behaviorChange.SC102534CommandRedactProperties.enabled", False)

So, I have managed to use this, to temporarily switch it off whilst this bit of my code is extracting the meta data.

Re: Databricks bug with show tblproperties - redacted - Azure databricks

SamAdams — Thu, 10 Oct 2024 23:01:47 GMT

@SamDataWalk thanks for posting the solution. I ran into the same problem while writing some logic that updates table constraints across many tables from a config. They were coming back as redacted - this allowed me to actually read them and update as needed.

Re: Databricks bug with show tblproperties - redacted - Azure databricks

SamAdams — Thu, 10 Oct 2024 23:05:23 GMT

Like your example that redaction behavior seemed to pick up on the column name: a condition that included a column named "URL" was redacted, but one that included a "modifiedDateTime" was not