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

Forum Posts

fuselessmatt
by Contributor
  • 3609 Views
  • 2 replies
  • 1 kudos

Resolved! Is it possible to manage access for legacy catalogs (hive_metastore) in Terraform?

We have been successfully managing access for our unity catalogs using the databricks_grant resources in Terraform. Now we want to enable the Rudderstack integration for Databricks, but that does not support unity catalog and instead put files inside...

  • 3609 Views
  • 2 replies
  • 1 kudos
Latest Reply
Anonymous
Not applicable
  • 1 kudos

@Mattias P​ :Unfortunately, it is not currently possible to manage access to the Hive Metastore catalog (or other external metastores) using the databricks_grant resource in Terraform. This is because the databricks_grant resource is specifically des...

  • 1 kudos
1 More Replies
knawara
by Contributor
  • 2547 Views
  • 7 replies
  • 5 kudos

READ FILES and WRITE FILES when using Hive Metastore

Hello,I'm confused about documentation on privilege types when using HMS.The following page is supposed to talk about HMShttps://docs.databricks.com/sql/language-manual/sql-ref-privileges-hms.htmlbut it also mentions READ FILESQuery files directly us...

  • 2547 Views
  • 7 replies
  • 5 kudos
Latest Reply
Anonymous
Not applicable
  • 5 kudos

Hi @Chris Nawara​  I'm sorry you could not find a solution to your problem in the answers provided.Our community strives to provide helpful and accurate information, but sometimes an immediate solution may only be available for some issues.I suggest ...

  • 5 kudos
6 More Replies
quakenbush
by Contributor
  • 3758 Views
  • 4 replies
  • 5 kudos

Creating a persistent view that references both Unity Catalog and Hive Metastore objects is not supported in Unity Catalog

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

  • 3758 Views
  • 4 replies
  • 5 kudos
Latest Reply
Senthil1
Contributor
  • 5 kudos

I will suggest the below links will help you, For exposing your Hive_metastore multiple catalogs, 1) Create 3 catalogs for each environment under single metastore by using Unity Catalog2) Now expose the Unity Catalog using DELTA SHARING to your BI ap...

  • 5 kudos
3 More Replies
nihar07
by New Contributor II
  • 627 Views
  • 0 replies
  • 2 kudos

AWS VPC service endpoint for internal RDS Hive metastore

We are setting up Databricks on our AWS account using customer managed VPC and enabling private link. I could see the private endpoints for frontend and backend with which we could spin up our EC2 instances. But the problem we are facing is to connec...

  • 627 Views
  • 0 replies
  • 2 kudos
Shafi
by New Contributor III
  • 3201 Views
  • 4 replies
  • 6 kudos

Resolved! Cannot create a table having a column whose name contains commas in Hive metastore.

Hi Tried to create a delta table from spark data frame using below command:destination_path = "/dbfs/mnt/kidneycaredevstore/delta/df_corr_feats_spark_4"df_corr_feats_spark.write.format("delta").option("delta.columnMapping.mode", "name").option("path"...

  • 3201 Views
  • 4 replies
  • 6 kudos
Latest Reply
Pat
Honored Contributor III
  • 6 kudos

Hi @Shafiul Alam​ ,who gave those names to columns? you can rename you columns, replace spaces / special characters, for example:%python import re list_of_columns = df_corr_feats_spark.colums renamed_list_of_columns = [ re.sub(r'[^0-9a-zA-Z]+', "_", ...

  • 6 kudos
3 More Replies
NOOR_BASHASHAIK
by Contributor
  • 3294 Views
  • 6 replies
  • 4 kudos

Resolved! Exploiting Hive Metastore of Databricks for lineage

Hi allWanted to check if anyone has made an attempt to exploit the Hive Metastore of Databricks for lineage?For example, I loaded metadata of 2 databricks databases using the Collibra Marketplace provided Databricks driver. Here is the scenario -Data...

  • 3294 Views
  • 6 replies
  • 4 kudos
Latest Reply
NOOR_BASHASHAIK
Contributor
  • 4 kudos

@Chetan Kardekar​ @Kaniz Fatma​ yes, I still need a standard way (through SQL) to access Hive Metastore.

  • 4 kudos
5 More Replies
Labels