Error while creating external table in unity catalog

Shubhanshu — Tue, 29 Aug 2023 10:42:10 GMT

I am trying to create an external table using csv file which is stored in ADLS gen2

My account owner has created a storage credential and an external location

I am a databricks user who all privileges on external location when trying to create a table using the query:

create table final_dataset_inc2 using csv

options ('path' 'abfss://container@storageaccountname.dfs.core.windows.net/data/dataset_inc2/*.csv',

'header' 'true',

'delimeter' '|',

'inferSchema' 'true')

I am getting this error:

Failure to initialize configuration for storage account storageaccountname.dfs.core.windows.net: Invalid configuration value detected for fs.azure.account.key

While when creating a delta table through UI in the data tab of databricks I am able to create a managed delta table.

But I dont need a delta table.

Now I am using a SQL warehouse cluster so I cannot even set spark configurations to overcome this error that is mentioned in the documentation.

How to overcome the error and create the table?
Does this has something to do with storage credential not having enough permission?

Re: Error while creating external table in unity catalog

Shubhanshu — Fri, 01 Sep 2023 13:45:14 GMT

@Debayan Can you please help me with this?

Thanks

Re: Error while creating external table in unity catalog

Debayan — Mon, 04 Sep 2023 06:20:19 GMT

Hi @Shubhanshu , Could you please try https://learn.microsoft.com/en-us/answers/questions/1314651/error-invalid-configuration-value-detected-for-fs and see if this is working?

topic Re: Error while creating external table in unity catalog in Get Started Discussions

Error while creating external table in unity catalog

Re: Error while creating external table in unity catalog

Re: Error while creating external table in unity catalog