how to connect to fabric lakhouse using duckdb from databricks premium workspace?

[sleepeatazure]

how can I access data from fabric datalake from databricks using duckdb? I am using databricks premium workspace and can read and wite using spark. But when trying to connect through duck db I am getting the below error (I am not using any SPN or access key for duckdb client):

IOException: IO Error: AzureBlobStorageFileSystem could not open file: 'abfss://demo@onelake.dfs.fabric.microsoft.com/Lakehouse.Lakehouse/Files/20180402040501.CSV', unknown error occurred, this could mean the credentials used were wrong. Original error message: 'Fail to get a new connection for: https://demo@onelake.blob.fabric.microsoft.com. Problem with the SSL CA cert (path? access rights?)' 

[v-cboorla-msft]

Hi @sleepeatazure 

Thanks for using Microsoft Fabric Community.

Please refer to the documentation where you might get some insights on how to connect to fabric lakhouse using duckdb.

Document : Exploring Python Libraries for Data Engineering in MS Fabric: Pandas, Polars, DuckDB, and PySpark | ...

I hope this information helps. Please do let us know if you have any further queries.

Thank you.

[v-cboorla-msft]

Hi @sleepeatazure 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[v-cboorla-msft]

Hi @sleepeatazure 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.