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...
When I run CREATE OR REPLACE VIEW on an existing view in Unity Catalog, the grants that were made on that object are removed. This seems like it is a bug. Is it on purpose or not?How to replicate:1. Create the viewRun the create or replace statement:...
Would also love any sort of communication back from Databricks on why create or replace view acts like this.I have had to run my CICD once with create (or replace) and then make a code change to swap to "alter view," which per https://docs.databricks...
Hi there,Is there any way to have an automatic Data Lineage without the usage of Unity Catalog, instead utilizing legacy Hive?My limited research shows there is no such option, at least without using some external tools which is not really an option ...
Hi @ty090 , you need to build a lineage generation tool if you have specific requirement of not using unity catalog or beyond databricks.
Hello all,We are currently running Azure Databricks notebooks through Azure Data Factory pipelines, where we use job clusters defined through policies. As an admin, I am able to see the list of all job clusters that have created when ADF makes a call...
Yes if you are run a notebook activity from ADF. You will not be able to see the job runs in databricks unless you are admin. But if you want to see any details you can use a python code to see the job runs and details of the run.You need a Service p...
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...
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...
