You can translate the question and the replies:

Denodo to Azure Data Lake Gen2

Related to: How to connect to Azure Data Lake Storage from Denodo Platform
Hi team, I am trying to connect Denodo 7.0 to connect with Azure Data Lake through Custom wrapper. I am trying to connect using shared key authentication method. So I have saved the key in core-site.xml file. the format is like Shared Key: using the storage account’s authentication secret: <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> <configuration> <property> <name>fs.azure.account.key<account>.dfs.core.windows.net</name> <value>YOUR ACCOUNT KEY</value> </property> </configuration> Now to create data soruce, I have selected the custom wrapper and given the below inputs. File system URI: abfss://<datalake url> Custom core-site.xml file: location of the file kept. After saving the data source, In the window for creating base view, have provided complete azure path of the object in path input and ,(comma) in separator input. After this I am getting error that abfss://<datalake url> has invalid authority. I have also tried the different probablities but no luck. Please give the suggestion to connect with azure data lake gen 2 as the tutorials also donot have enough guidelines to connect. Thanks in Advance.
Custom Data Sources
user
25-11-2020 05:21:03 -0500
code

3 Answers

Hi, To access Azure Data Lake Storage Gen 2, the URI needs to follow the following pattern: ``` abfs://<filesystem>\@<account>.dfs.core.windows.net (abfss:// for SSL encrypted HTTPS access) ``` Then, you need to put the credentials in the core-site.xml as follows: ``` <property> <name>fs.azure.account.key.ACCOUNT.dfs.core.windows.net</name> <value>ACCOUNT_KEY </value> </property> ``` Please review the user guide: [Denodo Distributed File System Custom Wrapper](https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Distributed%20File%20System%20Custom%20Wrapper%20-%20User%20Manual) section **HDFSParquetFileWrapper** and **Azure Data Lake Storage Gen 2** to get more information. Hope this helps!
Denodo Team
22-12-2020 04:57:32 -0500
code
I am facing similar problem but not able to pass a ACCOUNT_KEY in <Value> tag. My ACCOUNT KEY has so many special characters. Using \ not possible as there are so many chars like this = & etc etc. Is there a way?
user
19-05-2021 15:56:47 -0400
Hi, The "Invalid authority" error usually occurs when the special charaters in the URI have not been escaped. There is no need to escape the special charaters in the ACCOUNT_KEY. If you enter a literal in the URI that contains one of the special characters used to indicate interpolation variables @, \, ^, {, }, you have to escape these characters with \. E.g if the URI contains @ you have to enter \@. Hope this helps!
Denodo Team
20-05-2021 08:10:40 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here