Nivethan_Venkat
Databricks MVP

Hi @Kayla,

SYNC command is to sync your hive EXTERNAL table to your Unity Catalog name space. If the table is external, the UC table will be in sync with your external location. If it is hive managed table, you can't use SYNC command to have your managed table in UC metastore. For more details on table compatibility and SYNC, please refer the following documentation: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-aux-sync