Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2024 01:16 PM
Interesting! I found a workaround worked:
- Add any table in hive_metastore.
- 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