Read multiple CSV files by extension

Reads only CSV files matching the given extension(s) from a folder. Use FilterFilesByExtension to limit which files are read (e.g. txt for .txt files).

SELECT * FROM read_csv_files_from_folder
WITH (FilterFilesByExtension='txt')