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...
Dear community,Our company is using Databricks and we are happy to have Unity Catalog emerged to solve part of our Data Governance problems. We are very interested in the Table Insights feature which is newly introduced (View frequent queries and use...
Dear @Retired_mod, Thanks for your answer. I just checked and indeed such information can be queried to information_schema tables.Anyways, do you have the information if there exists a plan to expose such insights via REST API, or not at all?The reas...
Hi all,I am unable to search for tables in the search bar. I can see them under Catalog and I can even see them when browsing 'Location' in the search menu.What can be the issue here? I have tables both in the DBFS root and in a separate Storage Acco...
Hi and thank you for your reply.I can see that my workspace is attached to the metastore in the admin console. I am pretty new with Databricks but everything related to Unity Catalog looks good to me.Can you be more explicit about what you mean by "E...
Hi, Is it possible to track and display data lineage with Unity Catalog while using databricks on GCP? like so: https://docs.databricks.com/en/data-governance/unity-catalog/data-lineage.htmlIf it's not yet implemented, then is there any roadmap avai...
Assuming you wish to see the Lineage on a table/view in a UC Catalog, it's just a matter of navigating to Catalog Explorer, drill down to your UC Catalog>Schema>Table/View and clicking on the 'Lineage' tab. Note this functionality is not available in...
I transfered the owner of pre-created datasets (catalogs and schemas) by workspace admin to a service principle.ALTER CATALOG xyz OWNER TO `sp`;I think as the owner, the job owned by `sp`, should be able to create table in all schemas under catalog x...
Hi @hdu ,Below is an excerpt from documentation: "Owners of an object are automatically granted all privileges on that object. In addition, object owners can grant privileges on the object itself and on all of its child objects. This means that owner...
Hello, now that a metstore is created by default; I'd like to know where the corresponding storage account is. Is it hosted by Databricks? I'm guessing so; if that the case; from a compliance and security perspective; is it better to move it to a sto...
Hi,I got error [UC_NOT_ENABLED] Unity Catalog is not enabled on this cluster, when run in the notebook to create a catalog. Looks like I followed all the steps to set up workspace, metastore and compute. The steps are:create workspace from UI -> Qu...
Hi @Meghana_Vasavad - I followed these steps below to solve the similar issue I faced today.Evidently, your workspace is not UC enabled. Please find the MS Learn link below to follow the step-by-step instructions to enable UC via account console.http...
We are trying to add Slack as a "Notification destination" under "Workspace Settings" in our Databricks workspace.However, there is no option to actually grant permission on that destination to define who gets to actually use that destination. This i...
Hi @emmalily ,thanks for your answer. I am curious to hear more about your first proposed solution "creating private channels". I am not sure how that would prevent others from using the Slack notification destination since everyone in the Databricks...
In today’s data-driven landscape, organizations increasingly recognize the critical need for unified governance to ensure consistent data security, compliance, and efficiency. AWS Glue Data Catalog users seeking enhanced governance, operational contr...
Hello community,I got this error, I created a new recipient grant the share data and created a share data with the catalog, how can I proceed in the interested catalog, where do I need to assign USE_PROVIDER?
You need to ask a metastore admin to gran you the USE PROVIDER permission at the metastore level https://docs.databricks.com/en/data-governance/unity-catalog/manage-privileges/privileges.html#use-providerThis can be done through the UI, under Catalog...
I have created an external table in unity catalog and when describing its data getting the following errororg.apache.hadoop.fs.FileAlreadyExistsException: Operation failed: "The specified path, or an element of the path, exists and its resource type ...
Can you confirm you created a Storage Credential and External Location prior to the CREATE TABLE statement. Also can you post the CREATE TABLE syntax? Thanks....
Hi, I have a couple of questions 1) For Unity Catalog can we sync 2 Metastores which are in different regions?2) If latency is not an issue, can a single metastore handle 2 different regions (and their workspaces)
1. There is no way to sync 2 metastores specifically but you can use Delta Sharing to create a read only view of a source metastore on a target metastore. 2. Metastores are associated to the region, only workspaces in the same region can be assigned
In our Production tenant we have majority of our workspaces in the North Europe region. We have disaster recovery set up and these workspaces are in West Europe, so will require 2 MetastoresIf Unity Catalog was to get implemented, is there a way to s...
I dont see the reply form KanizCan you please share what was the reply you received to your question? Thanks in advanceSaurabh
What is the pricing of Unity Catalog? Does it come without additional costs in premium workspace? If I upgrade my standard workspace to a premium workspace, is Unity Catalog added by default?
HI Shivam2, Unity Catalog features are provided to you at no charge once you upgrade to Premium or Enterprise tier. If your Databricks account is created after November 8, 2023, then Unity Catalog is enabled by default. You can use following instru...
I have been using "rdd.flatMap(lambda x:x)" for a while to create lists from columns however after I have changed the cluster to a Shared acess mode (to use unity catalog) I get the following error: py4j.security.Py4JSecurityException: Method public ...
Hi All,I faced the same issue. When i updated the cluster to DBR 15.5 it got resolved, it is not working in DBR 13.3 (my previous cluster version).Well, it is also working in DBR 10.4. I stayed with 15.5 as being the latest. Just try out with differe...
Hi, I am working with a firm that uses Databricks in order to analyze their system tables for cost visualizations and forecasting. I am trying to gain access to just the system tables without being able to view their other sensitive notebooks, artifa...
Hi @szymon_dybczak Thank you very much for the clarification! Turns out, the people I am working with are using the regular plan and not the premium so that might not be an option. Would the only other way be to send the system tables to an S3 bucket...
