Unity catalogue sync problem

ajai_duraisamy — Fri, 26 Sep 2025 14:08:55 GMT

Hi Everyone ,
while I am creating sync table in UC, I got an error and failed . then I am not able to recreate the same table.
when I checked the catalogue table name is there but not able to open , and I am querying the same in the notebook .
it's giving as The table or view cannot be found
Can some one help me here.

Thankyou

Re: Unity catalogue sync problem

nayan_wylde — Fri, 26 Sep 2025 14:47:54 GMT

@ajai_duraisamy Here are few checks you can do:

1. SHOW TABLES IN <catalog>.<schema> LIKE '<table>'; This command will show if the table exists in UC.

2. Make sure your compute is UC‑enabled.
If you’re on a cluster/SQL Warehouse without UC enabled (or created before the metastore assignment settled), object resolution can misbehave. You should see the Unity Catalog badge on the cluster and use Single User or Shared access mode.

3. Run refresh command on the table.

%sql -- Force Spark to drop any cached plan/metadata REFRESH TABLE <catalog>.<schema>.<table>; -- Ask UC to resync table metadata (works for Delta tables) REPAIR TABLE <catalog>.<schema>.<table> SYNC METADATA;

4. If none of the above steps works out. Can you please drop the table and run a dry run on the table and share the output.

%sql SYNC TABLE <uc_catalog>.<uc_schema>.<table> FROM hive_metastore.<hms_schema>.<source_table> DRY RUN;

topic Re: Unity catalogue sync problem in Data Governance

Unity catalogue sync problem

Re: Unity catalogue sync problem