Cannot read using abfss from fabric lakehouse, Error while getting a connection handle. Error Code: 12005: The URL is invalid

[ahjulstad]

I have a parquet file in a fabric lakehouse that I would like to map in duckdb. It works well using the dfs URL
az://onelake.dfs.fabric.microsoft.com/xxx/xxxx/Files/xxxx.parquet (just copy pasting from fabric and replacing https with az

but not with the abfss URL:
abfss://[email protected]/xxxx/Files/xxxx.parquet

I authenticate using azure cli.

D create or replace view actualcosts as select * FROM 'abfss://[email protected]/xxxx/Files/xxxx.parquet';

IO Error: AzureBlobStorageFileSystem could not open file: 'xxxx Files/xxxx.parquet', unknown error occurred, this could mean the credentials used were wrong. Original error message: 'Error while getting a connection handle. Error Code: 12005: The URL is invalid

[gdubya]

I might be mistaken, but it looks to me like azure_parsed_url.cpp and azure_dfs_filesystem.cpp do not properly handle the abfs(s)://[email protected]/path syntax (as documented in https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-introduction-abfs-uri).

[gdubya]

Related? duckdb/duckdb-delta#71