Create Multiple VDS in one go

1

Is there a way we can create multiple VDS in one go. For example- I have a Source folder which contains multiple csv files (around 150 files). I need to create a VDS for each of these files.
I am newbie to dremio and not sure if there is a way i can create multiple VDS.

2

Hi @sarika

You should be able to use a JDBC tool like DBeaver and run multiple SQL. I am not able to connect CSV to VDS, is it

  1. PDS to CSV mapping

(OR)

  1. Each CSV is a SQL to create a VDS?

Thanks
@balaji.ramaswamy

3

Thanks for the response. For eaxample - I have a folder with name “test” which has multiple csv files(50 files with same column names).I need to create a single VDS for all these files. When i create the PDS on a folder level , it combines all the data from .csv files which is good but the column names from each files is being considered as data row nd visible into the output.

Output is something like this:
Col1 col2 col3 col4 col5
1 2 3 4 5
Col1 col2 col3 col4 col5
6 7 8 9 10

HOwever the expected output should be like
Col1 col2 col3 col4 col5
1 2 3 4 5
6 7 8 9 10

4

@sarika

format-options
format-options2532×1254 216 KB
You might have to check “Extract Field Names” and select the right line delimiter and field delimiter

Thanks
@balaji.ramaswamy