Here's your Data + AI Summit 2024 - Data Governance recap as you navigate the explosion of AI, data and tools in efforts to build a flexible and scalable governance framework that spans your entire data and AI estate. Keynote: Evolving Data Governan...
I'm using the Databricks Lakehouse Monitoring API to enable monitoring across every table in a catalog. I wrote a script that loops through all schemas and tables and calls the create_monitor API for each one. However, when running the script from a ...
Hey all,We've got a bunch of business objects we created as delta live tables. these are important as that's what business users will use in dashboards, genie rooms etc. We're trying to enrich the metadata for those but the option is greyed out and I...
Solution that worked for me with materialized views created by DLT was to use the following syntax in SQL Editor in Databricks or run sql file with sql warehouse:COMMENT ON COLUMN <catalog>.<schema>.<table>.<column> IS 'comment here' This didn't work...
I have all the necessary permissions like USE CATALOG on Catalog, USE SCHEMA on Schema and SELECT,TABLE on Table. But still when I try to access the table from catalog I get the error : Insufficient privileges: User does not have USE CATALOG on Catal...
Hi, @SP_6721 and @Pawan_1 ,Thanks for your concerns. I was able to find the problem. So the problem was the cluster was assigned to groups and for the permissions were given to individual users. When the permissions were given to the group, we were a...
Hello,I tried to search for the topic in the community but couldn't find much around downstream lineage element that can be connected to a Unity Model.As far as I understood, if I have an inference workflow that loads a model from unity catalog and t...
Hello @FedeRaimondi, Downstream lineage: clear visibility from the model to the inference tables created by jobs or workflows consuming the model—is not supported currently in the same way as upstream lineage. I checked regarding this internally and...
Hi, Databricks CommunityI am currently plan to do migrate of existing metastore (not in a desired account and name) to a new one (a different desired account) within the same region. I understand it is not as straightforward it might be and complicat...
Hi team,I can't see Kaniz's recommendations. Are there any related links in this topic? Thanks&Regards,zmsoft
Having fun at the databricks conference
Hi all,I’ve been working with Unity Catalog in Databricks and using column masking policies for sensitive fields like SSNs. While trying to retrieve metadata about which columns have masking policies applied, I ran into some challenges and wanted to ...
@jv_v There are a few more approaches that you can try which are ideal for large scale scanning, Try using, Unity Catalog System Tables via system.information_schema Instead of <catalog>.information_schema.column_masksIf that doesnt work, use Databri...
Is there a command to hide the details of DLT/materialized views from users in UC?
Hi @dataminion01,As far as I know, Unity Catalog doesn't currently provide a direct way to hide DLT or materialized view definitions. Users with SELECT access can still view the logic via the "Details" tab.You can work around this by:Moving sensitive...
Hi there,I was checking though the Databricks Runtime 17.0 features while testing:Support ALL CATALOGS in SHOW SCHEMASI faced below issues, is that anticipated or an issue which needs to be fixed?This is how it was before Runtime 17.0 I was expectin...
I was able to reproduce same issue, I am working with the team, as this DBR is in Beta version we might see some changes on the behavior, so I will confirm if anything has changed around this topic
We have implemented our own delta sharing server, following the delta sharing protocol. We are able to use the delta-sharing connectors to read shared data from our own server. However, when we tried importing our share credential file in Databricks ...
Fixed
Hi,If I update a Tag on a table within a Noetbook as follows:sql = f"""ALTER TABLE {silver_catalog}.public.tablename SET TAGS ('Is_published' = 'Y');"""spark.sql(sql)Then the User ID and Username, nor Notebook is populated when I look in the History ...
Hi team,You should be able to see the change in the History tab when changes are made manually through the UI or changes made through APIs that explicitly push user metadata. Programmatic Spark SQL updates may not automatically attach full interactiv...
I have created a catalog, a schema and several tables within unity catalog, when I run a notebook that makes a merge to one of the tables the lineage of this is correct with all its dependencies, but if I run the notebook of another different table t...
Hello @andalo! This might be happening because lineage for MERGE operations is not fully captured by default. Could you try setting the Spark property spark.databricks.dataLineage.mergeIntoV2Enabled to true?Just a heads-up, enabling this setting may ...
Hello All,We have recently created a databricks with UC enabled. All the VNET Pairing is completed. Now, while I am trying to create a table [Managed] under a catalog / schema - I am not able to query the table. I am getting below error org.apache.ha...
Hi @dipanjannet , This could be due to the code falling back to the hive metastore, which could be due to a number of reasons, but the first thing that caught my eye was that the table name in your saveAsTable() call isn't fully qualified. Can you ad...
Hi,I have tried to execute Vectorized udfs in SQL editor of Databricks, I am getting the following error[FEATURE_UNAVAILABLE] Pandas UDF is not supported in your environment. To use this feature, please contact Databricks Support. SQLSTATE: 56038Coul...
Hi Avinash, I believe this is not supported on Sql editor yet. However, it is available in DBR rollout 16.3.1. Hope this helps!
According to the docs, we should be able to use SYNC TABLE to 'upgrade' a table from a Hive metastore to Unity Catalog. We are using AWS Glue as our Hive Metastore, but tables created in Glue do not seem to be set up in a format that Databricks likes...
Hi team,The issue arises because Unity Catalog's SYNC command cannot process tables that were created using the Hive SerDe format in the hive_metastore catalog. This means that any attempts to upgrade such tables will fail. You need to convert your H...
