# ADLS Gen2 storage access using Oauth

**URL:** <https://community.dremio.com/t/adls-gen2-storage-access-using-oauth/7863>\
**Category:** Uncategorized\
**Created:** [August 15, 2021, 8:25pm UTC](https://community.dremio.com/t/adls-gen2-storage-access-using-oauth/7863 "2021-08-15T20:25:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rammi16](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rammi16](https://community.dremio.com/u/rammi16)\
**Post date:** [August 15, 2021, 8:25pm UTC](https://community.dremio.com/t/adls-gen2-storage-access-using-oauth/7863/1 "2021-08-15T20:25:13Z")

</div>

Hi Team,

I am new to Dermio and I am currently doing POC to evaluate dremio for our usecase. I have installed dremio in AKS and trying to create azure storage source. Unfortunately I am not able succeed to add this source.

I have service principles only to specific directory in my container(e g storage\_accout/container/directory/subdir). My organization restricted to access only though OAUTH. I tried to configure new data lake source(azure storage) with all combinations , but nothing worked out.

My question are ,

1. Does dremio required access at container level? If not please help me the detailed steps to configure the azure source with OAUTH. I have found the document with only basic settings, I did not find help how to set the advanced options in my case.
2. How to enable debug options? I am getting access denied error when I check master pod logs, but I did not find much info with that error log.
3. If my POC goes well and satisfied with the results, how to obtain enterprise edition.  
4 Difference between installing Dermio in my AKS vs Install through market place. Advantages and disadvantages. It would be great if I can get the pricing details.

Regards,  
Ramesh

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [August 16, 2021, 6:52am UTC](https://community.dremio.com/t/adls-gen2-storage-access-using-oauth/7863/2 "2021-08-16T06:52:28Z")

</div>

@rammi16 Maybe give the source path you have access in the advanced options root folder?

 ![Screen Shot 2021-08-15 at 11.52.10 PM](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/3/3306ae3ec1aa6c4c916b48f8c4741252461b69db.png)

---

<div class="post-metadata">

**Author:** ![rammi16](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rammi16](https://community.dremio.com/u/rammi16)\
**Post date:** [August 21, 2021, 8:30pm UTC](https://community.dremio.com/t/adls-gen2-storage-access-using-oauth/7863/3 "2021-08-21T20:30:22Z")

</div>

Thank you! Sorry for the late response. It was a permission issue. Dremio expecting to have list permissions from adls file system to till the sub directory.

Interesting thing is, it doesn’t require list permissions till sub directory to access from spark.

Now I am trying to connect dremio from superset, I can able to establish the connection, but unable to create the dataset.

Does anyone succeed to create the dremio dataset in superset?

Appreciated if any provide the list of steps. I am really stuck here. I have posted same question in superset community, no response yet

Regards,  
Ramesh

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [August 23, 2021, 6:29am UTC](https://community.dremio.com/t/adls-gen2-storage-access-using-oauth/7863/4 "2021-08-23T06:29:47Z")

</div>

@rammi16 I am checking internally on superset and will get back to you

---

<div class="post-metadata">

**Author:** ![rammi16](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rammi16](https://community.dremio.com/u/rammi16)\
**Post date:** [August 23, 2021, 10:38am UTC](https://community.dremio.com/t/adls-gen2-storage-access-using-oauth/7863/5 "2021-08-23T10:38:46Z")

</div>

Thank you Balaji! I am able to create the datasets and created the reports as well.

Regards,  
Ramesh
