# Create vds from a pds (s3 data lake)

**URL:** <https://community.dremio.com/t/create-vds-from-a-pds-s3-data-lake/8595>\
**Category:** Uncategorized\
**Created:** [January 13, 2022, 4:55am UTC](https://community.dremio.com/t/create-vds-from-a-pds-s3-data-lake/8595 "2022-01-13T04:55:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rusha](https://avatars.discourse-cdn.com/v4/letter/r/3ab097/32.png) [@rusha](https://community.dremio.com/u/rusha)\
**Post date:** [January 13, 2022, 4:55am UTC](https://community.dremio.com/t/create-vds-from-a-pds-s3-data-lake/8595/1 "2022-01-13T04:55:00Z")

</div>

Hello,

I have a use case where I connect to a s3 bucket from data lake, perform some transformations on the parquet file and save it as vds. Could you please let me know if there is an option to do this without using UI?

---

<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:** [January 13, 2022, 8:13am UTC](https://community.dremio.com/t/create-vds-from-a-pds-s3-data-lake/8595/2 "2022-01-13T08:13:59Z")

</div>

@rusha You can use the CREATE OR REPLACE VDS AS SELECT … command

[https://docs.dremio.com/sql-reference/sql-commands/datasets/?parent=sql-commands](https://docs.dremio.com/sql-reference/sql-commands/datasets/?parent=sql-commands)

You can use a JDBC tool or use the POST SQL API

[https://docs.dremio.com/rest-api/sql/post-sql/](https://docs.dremio.com/rest-api/sql/post-sql/)