@ManojkMohan 
In the steps that you mentioned, I'm still getting the same issue 

CREATE TABLE catalog.schema.table1 (
id BIGINT,
name STRING
)
USING DELTA
LOCATION 's3://bucket/path/table1'
TBLPROPERTIES (
... all my properties in the _delta_log .....
'spark.sql.collation' = 'UTF8_BINARY'
);

It says the spark.sql.collation is not matching with the propeties in the _delta_log if that particular table