How to combine a set of CSV files which has naming rule?

1

I have many CSV files which has a naming rule.

Sales2019-01.csv
Sales2019-02.csv
…
Sales2019-11.csv
Sales2019-12.csv
Sales2020-01.csv
…

I can use “union” to merge all CSVs for 2019.

Is there any other ways to do that?

2

If you can move all the 2019 files into their own folder, you can promote the folder which will take all files in the folder and merge them into one dataset.

3

Hi, what should I do after move all the 2019 files into same folder?

Query from the folder name？

4

OK， I found this page

Querying Files and Directories

https://docs.dremio.com/data-sources/files-and-directories.html

Thanks