You can translate the question and the replies:

How to access Delta Table on Azure BlobStore from Denodo

Hi, I stored my delta tables on Azure Blob Storage. Now I want to access these tables from Denodo. Alternatively, I tried Simba connector to connect Azure DataBricks tables, and that works fine. But that does not show the Blob Store Tables. Ideally Simba connects to Spark so its obvious. Is there another type of connector I should try?
deltalake Azure Data Lake Storage Gen2 BLOB simba
user
18-05-2021 17:40:00 -0400
code

2 Answers

I found a documentation on Denodo Site "DFSParquetFileWrapper" at this [link](https://community.denodo.com/docs/html/document/denodoconnects/6.0/Denodo%20Distributed%20File%20System%20Custom%20Wrapper%20-%20User%20Manual). while I setup the connector but when I try to connect/test connection it gives me error I know thi serror is coming from core-site.xml where I have put the 'Azure Storage Account" > Access Signature. My signature string has special characters like.. `sp=rw&st=2021-05-19T06:07:10Z&se=2021-05-27T03:07:10Z&sv=2020-02-1 .....more` > There was an error while creating this base view: Error while executing custom wrapper method 'getSchemaParameters': [com.ctc.wstx.exc.WstxLazyException] Unexpected character '=' (code 61); expected a semi-colon after the reference for entity 'st' > at [row,col {unknown-source}]: [115,25] Please suggest how to resolve it. I tried adding double and single quotes aroung the access key but still same error.
user
19-05-2021 14:59:30 -0400
Hi, I was able to reproduce the same error when I used the **Access Signature** from Azure Storage account > Security + networking > Shared access signature instead of **Access Key** into the core-site.xml file. I was able to successfully [connect to Azure Blob Storage](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Azure%20Blob%20Storage%20from%20Denodo) when I copied the Access Key by navigating to Storage Account > Security + networking > Access keys. You can copy the key from the storage account and then paste it into the core-site.xml file as explained in this example [here](https://imgur.com/a/6D5LhDg). You can follow the document [How to connect to Azure Blob Storage from Denodo](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Azure%20Blob%20Storage%20from%20Denodo) or[ How to connect to Azure Blob Storage from Denodo Platform](https://www.youtube.com/watch?v=Amojdwu7T5g) video tutorial for detailed steps on this. Hope this helps!
Denodo Team
 Edited on: 21-05-2021 10:30:08 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here