# How to create a view in dremio for set of parquet files

**URL:** <https://community.dremio.com/t/how-to-create-a-view-in-dremio-for-set-of-parquet-files/4268>\
**Category:** Uncategorized\
**Created:** [October 7, 2019, 8:40am UTC](https://community.dremio.com/t/how-to-create-a-view-in-dremio-for-set-of-parquet-files/4268 "2019-10-07T08:40:07Z")\
**Posts on this page:** 4\
**Page:** 2

<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:** [October 15, 2019, 4:00am UTC](https://community.dremio.com/t/how-to-create-a-view-in-dremio-for-set-of-parquet-files/4268/23 "2019-10-15T04:00:27Z")

</div>

Hi,  
Below are the details

Url: [http://host:9766/api/v3/catalog](http://host:9766/api/v3/catalog)

Request Body:

{  
“entityType”: “dataset”,  
“path”: [  
“SPACE\_1”,  
“Test”,  
“VDS1”  
],  
“type”: “VIRTUAL\_DATASET”,  
“sql”: “select \* from DREMIO\_SAMPLE\_DATA.gregg\_sens”,  
“sqlContext”: [“VDS1”, “DREMIO\_SAMPLE\_DATA”]  
}  
In above request body “gregg\_sens” is a PDS.

I am following below link  
Example name is POST CATALOG FOR DATASETS  
[https://docs.dremio.com/rest-api/catalog/post-catalog.html](https://docs.dremio.com/rest-api/catalog/post-catalog.html)

---

<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:** [October 16, 2019, 11:23am UTC](https://community.dremio.com/t/how-to-create-a-view-in-dremio-for-set-of-parquet-files/4268/25 "2019-10-16T11:23:15Z")

</div>

I am waiting for response, the query i have already added in above comment.

---

<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:** [October 16, 2019, 6:36pm UTC](https://community.dremio.com/t/how-to-create-a-view-in-dremio-for-set-of-parquet-files/4268/26 "2019-10-16T18:36:09Z")

</div>

Does running `select * from DREMIO_SAMPLE_DATA.gregg_sens` work in the UI?

---

<div class="post-metadata">

**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\
**Post date:** [October 16, 2019, 10:40pm UTC](https://community.dremio.com/t/how-to-create-a-view-in-dremio-for-set-of-parquet-files/4268/27 "2019-10-16T22:40:20Z")

</div>

Yes, as @doron pointed out, please try the VDS sql in the Dremio UI with the same query context. Does the job complete, or do you get a syntax error?

[Previous page](https://community.dremio.com/t/how-to-create-a-view-in-dremio-for-set-of-parquet-files/4268.md?page=1)