A delta folder with sample data is created by deltalake python package. Duckdb can read it properly:

./duckdb -c "select * from delta_scan('data2/datadelta')"
┌───────┬─────────┬──────────────────────────┐
│  id   │  name   │           dob            │
│ int64 │ varchar │ timestamp with time zone │
├───────┼─────────┼──────────────────────────┤
│     1 │ john    │ 2023-12-31 18:00:00-06   │
│     2 │ jane    │ 2024-02-01 18:00:00-06   │
│     3 │ jill    │ 2024-03-02 18:00:00-06   │
│     4 │ jack    │ 2024-04-03 19:00:00-05   │
└───────┴─────────┴──────────────────────────┘

Open source unity catalog is able to register the table, but not able to query it.

bin/uc table create --full_name unity.default.data --storage_location "/home/user1/work/unitycatalog/data2/datadelta" --columns "id INT, name STRING, dob DATE" --format DELTA 

bin/uc table read --full_name unity.default.data
Error occurred while executing the command. Failed to read delta table file:///home/user1/work/unitycatalog/data2/datadelta/Failed to read delta table