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

23

Hi,
Below are the details

Url: 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

25

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

26

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

27

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?