cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Barney
by New Contributor II
  • 5004 Views
  • 7 replies
  • 1 kudos

How to Import an old Unity Catalog Metastore to a new Unity Catalog Metastore?

Hi All,I have created a new Unity Catalog (UC) metastore (new metastore ID) in west europe and now i want to import alle catalog/schema/tables form the old metastore (west europe) container to the new UC metastore.Note: coping all tables form the old...

  • 5004 Views
  • 7 replies
  • 1 kudos
Latest Reply
Kaniz
Community Manager
  • 1 kudos

Hi @Barney, To import all catalog/schema/tables from the old metastore to the new Unity Catalog (UC) metastore, you can use the Data Explorer upgrade wizard provided by Databricks. Here are the steps: 1. Open the Data Explorer by clicking Data in th...

  • 1 kudos
6 More Replies
Chris_Shehu
by Valued Contributor III
  • 3590 Views
  • 5 replies
  • 2 kudos

Resolved! Are their plans to support init scripts within shared compute resources?

Currently we have an Init script that specifies the location of different network resources by updating the hosts file. When we moved to the Unity catalog all of our clusters had to be upgraded to support it. Now our scripts have stopped working due ...

  • 3590 Views
  • 5 replies
  • 2 kudos
Latest Reply
youssefmrini
Honored Contributor III
  • 2 kudos

We are bringing soon init script and Scala to shared Cluster

  • 2 kudos
4 More Replies
amitca71
by Contributor II
  • 2333 Views
  • 5 replies
  • 2 kudos

external location on unity catalog permits access to s3

Hi,when i create external location on unity catalog. even if i dont provide any user grants, i have an write access to the s3 bucket from attached workspace.i created external location xxxxi didnt allow any permissions on it on a workspace that is co...

  • 2333 Views
  • 5 replies
  • 2 kudos
Latest Reply
Sivaprasad1
Valued Contributor II
  • 2 kudos

@Amit Cahanovich​ : Could you please share your config details,Which DBR version ?Cluster has any instance profile?

  • 2 kudos
4 More Replies
Gilg
by Contributor II
  • 760 Views
  • 2 replies
  • 0 kudos

Delta Sharing within the same region

Hi Team,I have setup UC and have a Metastore for AUE. Assigned 2 workspaces to the AUE Metastore and both with different set of users and group . 1 workspace is the data provider and the other is a data consumerNow since 2 workspaces are in one Meta...

  • 760 Views
  • 2 replies
  • 0 kudos
Latest Reply
youssefmrini
Honored Contributor III
  • 0 kudos

If the two Workspaces are under the same metastore you don't need Delta Sharing because they already have access to the same data. Unless you want to do data segregation per workspace. if it's the case it's coming soon at the end of february

  • 0 kudos
1 More Replies
ossinova
by Contributor II
  • 803 Views
  • 2 replies
  • 3 kudos

When adding new columns with overwriteSchema = True it does not add it to UC

I have discovered some strange behavior when adding new columns to a table associated with Unity Catalog. I overwrote the data specifying overwriteSchema = True and passing in the abfss path as it is an external table. When quering against it, it is ...

Screenshot 2022-10-14 120710
  • 803 Views
  • 2 replies
  • 3 kudos
Latest Reply
Anonymous
Not applicable
  • 3 kudos

Hi @Oscar Dyremyhr​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Tha...

  • 3 kudos
1 More Replies
J_M_W
by Contributor
  • 1921 Views
  • 3 replies
  • 6 kudos

Resolved! Upgrade tables to Unity Catalog error (Azure)

Hi all, I have set up a Unity Catalog (UC), and I am attempting to "upgrade my Delta tables" in the hive_metastore to my new catalog.I have followed the instructions here: https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catal...

image
  • 1921 Views
  • 3 replies
  • 6 kudos
Latest Reply
J_M_W
Contributor
  • 6 kudos

FYI - this is now magically resolved. I'm guessing it was a temporary bug or something.​

  • 6 kudos
2 More Replies
yvuignie
by Contributor
  • 5427 Views
  • 18 replies
  • 8 kudos

Resolved! Unity catalog - Service Principal SCIM API account unauthorized

Hi,Is it possible to create groups at the account level in Unity Catalog as a Service Principal ?I can manage to create groups when authenticated as a user, but not as a Service Principal. I then get an error "user not authorized". The service princi...

  • 5427 Views
  • 18 replies
  • 8 kudos
Latest Reply
yvuignie
Contributor
  • 8 kudos

@Pearl Ubaru​ Thank you for your help

  • 8 kudos
17 More Replies
ossinova
by Contributor II
  • 2676 Views
  • 8 replies
  • 2 kudos

UC Enabled cluster for ADF ingestion

I am migrating my Data Lake to use Unity Catalog. However, this comes with changes to the clusters. I have tried a few options, but it seems rather complex than it should be. I need to create a cluster used by ADF that is Unity Enabled that can insta...

  • 2676 Views
  • 8 replies
  • 2 kudos
Latest Reply
-werners-
Esteemed Contributor III
  • 2 kudos

I exclusively use job clusters. They are cheaper.Especially when you create a pool with spot instances. I'd go for that because that is what it's made for: batch jobs/

  • 2 kudos
7 More Replies
data_boy_2022
by New Contributor III
  • 4229 Views
  • 2 replies
  • 3 kudos

Are Python UDFs supported in Unity Catalog?

I am trying to execute a UDF written in Python and receive the following error message:Error message: [UC_COMMAND_NOT_SUPPORTED] UDF/UDAF functions are not supported in Unity Catalog.;The limitation is not mentioned in the docs( https://docs.databric...

  • 4229 Views
  • 2 replies
  • 3 kudos
Latest Reply
-werners-
Esteemed Contributor III
  • 3 kudos

Indeed it is not mentioned in the limitations.This blog mentions python UDFs in UC, but in databricks SQL, not the classic DE workspace.So it seems that it is not (yet) supported, as the docs only mention SQL functions.

  • 3 kudos
1 More Replies
Labels