Then I think this feature could close the gap external data access for pipeline datasets 
It requires Delta 4.0+ via UC APIs support which DuckDB already supports.

Compatibility Mode vs External Data Access Mode

If that is not a path, then a CDF/MERGE copy into a plain UC table is still the practical workaround.

View solution in original post