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, I want to configure the unity catalog with databricks, but the Create MetaStore button does not appear in my Azure Databricks workspace.In the community, I have seen that several users present the same situation ... What is the reason...
If I am the owner of the Azure Subcription and databricks premium is in my resource group that makes me owner on that RG as well as Databricks i am still not able to see Metastore setting for unity catalog .. have someone found a resolution to this. ...
I'm working out a terraform script that creates a job that needs to write files in the volume.When the job runs as me (I have full privileges), it encounters the following error if running with job compute: Permission error: operation not permitted...
I think I found the solution, you need to specify the data_security_mode parameter as SINGLE_USER to grant access to the Unity Catalog
Hi there,Please, I am trying to understand if Databricks is able to support master data management capabilities. Particularly, focusing on the following ones:- Integrate and link different data systems: Connect various systems and make sure the data ...
We at Frisco Analytics are a built on partner for Databricks and built and MDM application that is native to Databricks. https://www.lakefusion.ai/ Please contact us at contact@friscoanalytics.com .Thank you!Haritha
Hi all,I'm deploying Unity Catalog into a large enterprise with quite strict controls. I want to give my users some autonomy over creating tables from upstream datasets they have select access on, but also restrict these controls. I've been through a...
@ajbush did you workout your requirements in a way you wanted? appreciate if you can share insights here.
I am trying to connect to Unity catalog meta store tables using Presto Based on the presto documentation I need to use the below configuration to connect to delta tables in the unity catalog https://prestodb.io/docs/current/connector/hive.htmlSo from...
Hello @December , You should contact your account team if you need more info on this feature which is not GA for the time being. Another option would be to use Iceberg REST interface: https://medium.com/@flyws1993/oss-trino-to-read-tables-from-databr...
How can I get the unity catalog code base?
https://github.com/unitycatalog/unitycatalogThis is the OSS version of course. The databricks version is not available afaik.
I get an error message saying I Error getting sample data, when I try to view sample data from a table in a schema I created in a Unity Catalog. I dropped the schema and table and got a collague to recreate and still the same message. We are both Uni...
Check your table level ACLs, refresh your session, and verify role inheritance. Even if permissions look the same, there might be a small difference causing the issue. Try comparing your access settings with your colleague’s to spot any discrepancies...
I have created an Azure data factory pipeline with a copy data function to copy data from adls path to a delta table .In the delta table drop downs i am able to see only the hive metastore database and tables only but the unity catalog tables are not...
Any further updates on this? I also have the same problem. I tried above solutions, but no luck. By default, it shows only default and it's tables and I can preview those tables. If I enter the <catalog>.<schema> manually, it populates all the tables...
I tried to create a view in hive_metastore.default which would access a table from a different catalog. Is there any chance to do so?eg.create view myTest as select * from someCatalog.someSchema.someTable
Hi, so I don't know if you still have this problem (seeing as this post is almost 3 years old now haha) but I came across this when I was trying to solve an issue. What worked for me was creating the unity catalog table in the hive_metastore using an...
In the documentation is stated that the identity information is reserved for future use and currently always returns 'NO'.when is this going to be available ? and is there an alternative way to check if a specific column is already identity-defined o...
found an alternative way to check it for the moment : # check if identity column is active or not work around identityValue = 0 try: identityValue = str(spark.sql(f"show create table {table_catalog}.{table_schema}.{tab...
When I look at the permissions for a specific catalog in Catalog Explorer, I see the Application ID from Entra ID instead of the Service Principal name defined in the Databricks account for some Service Principals, while for others, I see the Service...
Thank's for your response. I think I resolved it:The Service Principal was added via the Databricks Console with a display name and application ID, but it was not added to the Databricks Workspace that I used to display permissions for that catalog, ...
Hello!Our team wish to implement just-in-time access to the audit log, where we thought we could use row filter for the audit log, such that the different teams can see their own events, and afterwards revoke their right to see it.Upon first inspecti...
I want to try Lakehouse monitoring in Unity Catalog.But it was failed in three table patterns.All of the drift metrics and profile metrics are No Data.I used the sample data "nyc taxi trips"And I configured the details like the following image.
Hi @Yuki The reason you cannot see anything in the result tables is that Lakehouse monitoring only analyzes data from 30 days before its creation. Please try using a source table that has more recent timestamps. When you first create a time series...
Respected Concern,We are currently using unity catalog in our workspace but we still see legacy hive_metastore under catalog section. Is there any way we can remove it. Because the issue we are facing is our cluster still somehow tries to connect wit...
Hi @DSoni, By default hive_metastore uses an RDS in AWS, in the failure you can see: xyz.region.rds.amazonaws.com which I think you redacted, that is the host with the issue. I would require more details to check hive_metastore comes into picture if ...
From my understanding, a user needs to own the object in order to alter the comments of columns/tables. A user would also need ALTER TABLE permissions in order to make the change. Is there a way to permit a user to change comments without giving them...
Hi @mrosman,As far as I understand, you can only provision SELECT / MODIFY / APPLY TAG to a table. And there is no specific privilege as of now in UC where you can assign a permission to alter the table / column comments. If the user have SELECT priv...
