# How to create view of hdfs dataset

**URL:** <https://community.dremio.com/t/how-to-create-view-of-hdfs-dataset/3947>\
**Category:** Dremio University\
**Created:** [August 27, 2019, 11:40pm UTC](https://community.dremio.com/t/how-to-create-view-of-hdfs-dataset/3947 "2019-08-27T23:40:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gautam](https://avatars.discourse-cdn.com/v4/letter/g/7ab992/32.png) [@Gautam](https://community.dremio.com/u/Gautam)\
**Post date:** [August 27, 2019, 11:40pm UTC](https://community.dremio.com/t/how-to-create-view-of-hdfs-dataset/3947/1 "2019-08-27T23:40:50Z")

</div>

what type of a view file should be created, so that tableau can query a set of parquet files using that view?"

Like in Apache drill a view file can be created “ABC.view.drill”, which can be easily queried by tableau.

Is there any similar kind of view file for dremio?

---

<div class="post-metadata">

**Author:** ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)\
**Post date:** [August 27, 2019, 11:55pm UTC](https://community.dremio.com/t/how-to-create-view-of-hdfs-dataset/3947/2 "2019-08-27T23:55:30Z")

</div>

Hi,

You can promote a folder that contains the parquet files and create a dataset from that folder. For folders, if you hover over the action column you will see a format folder button.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/1/1acc3145be896d2319d24294997ce42864f82eaf.png)

You then can reference that folder (hdfs.data.dremio in this case) in Tableau.

---

<div class="post-metadata">

**Author:** ![Gautam](https://avatars.discourse-cdn.com/v4/letter/g/7ab992/32.png) [@Gautam](https://community.dremio.com/u/Gautam)\
**Post date:** [August 28, 2019, 12:36am UTC](https://community.dremio.com/t/how-to-create-view-of-hdfs-dataset/3947/3 "2019-08-28T00:36:02Z")

</div>

## I used to create drill file programatically, but how we can promote a folder which contains parquet files programatically? Programatically as in, by use of scala programs. Basically Drill file used to be like { View Name: ABC Command: Select \* from HDFS Location

* * *

}

Here in above view, command contains HDFS Location , which is a location where parquet files are present.

The option you suggested will create/export the data in another file format, which will be copying the data from one formate to another,which is memory consuming process.

---

<div class="post-metadata">

**Author:** ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)\
**Post date:** [August 28, 2019, 12:56am UTC](https://community.dremio.com/t/how-to-create-view-of-hdfs-dataset/3947/4 "2019-08-28T00:56:10Z")

</div>

You can use our REST API ([http://docs.dremio.com/rest-api/catalog/post-catalog-id.html](http://docs.dremio.com/rest-api/catalog/post-catalog-id.html)) to promote programmatically. For folders of parquet, you should be able to also just run `SELECT * FROM hdfs.data.dremio` and it will auto-promote for you.

---

<div class="post-metadata">

**Author:** ![Gautam](https://avatars.discourse-cdn.com/v4/letter/g/7ab992/32.png) [@Gautam](https://community.dremio.com/u/Gautam)\
**Post date:** [September 12, 2019, 6:35am UTC](https://community.dremio.com/t/how-to-create-view-of-hdfs-dataset/3947/5 "2019-09-12T06:35:52Z")

</div>

Actually, I need a file which will act as a view. So that using that view file tableau can query the parquet file data which is on HDFS location.  
And this needs to be done via dremio. I don’t think tableau is able to query via API.