Qlikview and Azure databricks connectivity

[Vaishali04]

Hi All,

I am getting below error when am trying to read data from azure databricks. Connection is getting create but not able to read tables. 

Error: ERROR [HY000] [Qlik][Hardy] (35) Error from server: error code: '0' error message: 'org.apache.hive.service.cli.HiveSQLException: Error running query: java.util.concurrent.ExecutionException: shaded.databricks.org.apache.hadoop.fs.azure.AzureException: hadoop_azure_shaded.com.microsoft.azure.storage.StorageException: Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature

Please suggest if anyone aware of this issue or related

Regards

Vaishali

[Chip_Matejowsky · Accepted solution]

Hi @Vaishali04,

This looks to be an Azure based error.  I did a Google search on the error and found the following:

https://docs.microsoft.com/en-us/answers/questions/334786/azure-blob-storage-fails-to-authenticate-3...

https://github.com/Azure/azure-storage-net-data-movement/issues/176

https://stackoverflow.com/questions/24492790/azurestorage-blob-server-failed-to-authenticate-the-req...

Suggest you reach out to MS for further assistance.  Databricks community is here:  https://community.databricks.com/s/

Best Regards