duckdb_azure icon indicating copy to clipboard operation
duckdb_azure copied to clipboard

I am trying to read my delta table present in Azure ADLS Gen2 using SAS token but unable to do it.

Open BharatSingla12 opened this issue 5 months ago • 0 comments

Below is the reference error. Is there any way to read delta table present in ADLS gen2 using duckdb by connecting via SAS token?

`--------------------------------------------------------------------------- InvalidInputException Traceback (most recent call last) Cell In[65], line 1 ----> 1 db.sql(f""" 2 INSTALL delta; LOAD delta; 3 INSTALL azure; LOAD azure; 4 CREATE SECRET azure_secret ( 5 TYPE AZURE, 6 PROVIDER ACCESS_TOKEN, 7 ACCESS_TOKEN '{delta_folder_sas_token}', 8 ACCOUNT_NAME '{storage_account_name}' 9 ); 10 """)

InvalidInputException: Invalid Input Error: Secret provider 'access_token' not found for type 'azure'`

BharatSingla12 avatar Oct 01 '24 14:10 BharatSingla12