Create vds from a pds (s3 data lake)

1

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?

2

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

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/