โ03-03-2024 09:28 AM
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')
as
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)
โ03-07-2024 11:55 PM
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.
โ03-07-2024 08:53 AM
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.
โ03-07-2024 09:36 AM
Yes, it is indeed a view which that command errors for.
thanks anyway, appreciate the suggestion
โ03-07-2024 11:55 PM
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.
Excited to expand your horizons with us? Click here to Register and begin your journey to success!
Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!