njcheng
New Contributor II

Interesting! I found a workaround worked:

  1. Add any table in hive_metastore.
  2. Update the connection string of the ODBC data source in Linked Table Manager, as mentioned by @jakubk .  Make sure the catalog and schema are one with target table in unity catalog:

Driver=Simba Spark ODBC Driver;Host=[redacted].azuredatabricks.net;Port=443;HttpPath=/sql/1.0/warehouses/[redacted];SSL=1;AuthMech=11;Auth_Flow=2;Catalog=XXX;Schema=XXX

3.  Click the table in linked table manager, then click relink to update with target table name  in unity catalog

4. Rename table name in All Access Object Panel