Read multiple CSV files recursively

Reads CSV files from the target folder and all its subfolders into one result set. Set Recursive='true' to include nested folders.

SELECT * FROM read_csv_files_from_folder
WITH (Recursive='true')