According to the docs, we should be able to use SYNC TABLE to 'upgrade' a table from a Hive metastore to Unity Catalog. We are using AWS Glue as our Hive Metastore, but tables created in Glue do not seem to be set up in a format that Databricks likes. When we try to run `SYNC TABLE` on a Glue table, DBSQL returns the error message `[UPGRADE_NOT_SUPPORTED.HIVE_SERDE] Table is not eligible for upgrade from Hive Metastore to Unity Catalog. Reason: Hive SerDe table.`
Has anyone successfully gotten SYNC TABLE or SYNC SCHEMA working where a Glue table is the source?