Create external tables with properties set in delta log and no collation
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2025 11:01 AM
- There is an external delta lake table that need to be mounted on to the unity catalog
- It has some properties configured in the _delta_log folder already
- When try to create table using CREATE TABLE catalog_name.schema_name.table_name USING DELTA LOCATION 's3://table_path' it throws, [DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTY] The specified properties do not match the existing properties at 's3://table_path' due to the collation property getting added by default to the create table query
- How to mount such external table to the unity catalog?
