cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

lizou
by Contributor II
  • 8463 Views
  • 7 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
  • 8463 Views
  • 7 replies
  • 4 kudos
Latest Reply
anish2102
New Contributor III
  • 4 kudos

Hello Team,Still i am facing same issue of value zero in  character_maximum_length. Is there any other way we can get character_maximum_length of columns?When we can expect to resolve this bug? 

  • 4 kudos
6 More Replies
Anonymous
by Not applicable
  • 3808 Views
  • 3 replies
  • 1 kudos
  • 3808 Views
  • 3 replies
  • 1 kudos
Latest Reply
vihangk1
Databricks Employee
  • 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
Vivek_Singh
by New Contributor III
  • 1590 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

  • 1590 Views
  • 2 replies
  • 0 kudos
Latest Reply
Vartika
Databricks Employee
  • 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
  • 5547 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"...

  • 5547 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
  • 4900 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...

  • 4900 Views
  • 3 replies
  • 1 kudos
Latest Reply
Atanu
Databricks Employee
  • 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