@santosh-santosh Did you execute the steps part by part i shared in the DM ? Step 0: Define your external tables, Step 1: Inspect external Delta table schema & properties 

Success Check:

Ensure all expected properties  are captured  Step 2: Inspect Unity Catalog defaults  

Success Check:

Check the spark.sql.collation property in the DESCRIBE EXTENDED output.

Note all UC default properties Step 3: Generate CREATE TABLE statements  

Success Check:

Query the table after creation 

Check that the location points to the correct S3 path.

Check TBLPROPERTIES matches expected.   can you let me know if these steps are working as expected