duckdb_azure
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.
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'`