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

Forum Posts

Anonymous
by Not applicable
  • 2127 Views
  • 3 replies
  • 1 kudos
  • 2127 Views
  • 3 replies
  • 1 kudos
Latest Reply
vihangk1
New Contributor II
  • 1 kudos

Starting DBR 12.1 you can run the UNDROP command to undrop a managed or external table. The table must be in Unity Catalog for this feature to work. See https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html for more det...

  • 1 kudos
2 More Replies
lizou
by Contributor II
  • 2224 Views
  • 6 replies
  • 4 kudos

no information on character_maximum_length and is_identity in unity catalog table system.information_schema.columns

no information on character_maximum_length and is_identity in unity catalog table system.information_schema.columnstable definition exampleCREATE TABLE tyable_name ( UniqueID bigint not null GENERATED ALWAYS AS IDENTITY ,  ID varchar(256))looks like ...

image
  • 2224 Views
  • 6 replies
  • 4 kudos
Latest Reply
Hubert-Dudek
Esteemed Contributor III
  • 4 kudos

@Werner Stinckens​ @Christy Seto​ @Jose Gonzalez​ can you help with that issue? It is a really interesting bug and a nice feature once it will work correctly.

  • 4 kudos
5 More Replies
Vivek_Singh
by New Contributor III
  • 757 Views
  • 2 replies
  • 0 kudos

How to update change data UnityCatalog table after migrating hive metastore delta table

If I will migrate the Hive_metastore table into Unity Catalog table and subsequently hive metastore table is target of curation process. how I will migrate the delta record from Hive_metastore table to Unity Catalog table

  • 757 Views
  • 2 replies
  • 0 kudos
Latest Reply
Vartika
Moderator
  • 0 kudos

Hi @Vivek Singh Banafar​ Hope everything is going great.Just checking in. Does @Debayan Mukherjee​'s response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?We'd love to he...

  • 0 kudos
1 More Replies
Shafi
by New Contributor III
  • 3236 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"...

  • 3236 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
Mr__E
by Contributor II
  • 3994 Views
  • 3 replies
  • 1 kudos

Resolved! Table ACLs, secrets, and compute clusters

I am adding a credential to access MongoDB through the Python MongoDB Spark connector. It is stored as a secret and the `users` group has `MANAGE` ACL privileges. I turned on table ACLs and created a `High Concurrency` compute cluster. I then run a s...

  • 3994 Views
  • 3 replies
  • 1 kudos
Latest Reply
Atanu
Esteemed Contributor
  • 1 kudos

@Erik Louie​  looks the issue is resolved. Please let me know if you need further help on this. Thanks!

  • 1 kudos
2 More Replies
Labels