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

[ossinova]

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 discovered, however when I use information_schema and data explorer it is not listed.

 

Does it have something to do with it still being associated to the old hive_metastore? I am having a hard time to figure it out and any help is appreciated.

[Hubert-Dudek]

I bet that issue is that you update it as an external table. So as it is not managed table, then infromation_schema is not updated.

[Anonymous]

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.

Thanks!