Read multiple CSV files from a folder by ID

Reads all CSV files in a folder into a single result set, using the folder ID. Each file’s rows are returned; you can identify the source file from the result columns if needed.

SELECT * FROM read_csv_files_from_folder
WITH (Path='id:ZirXxxxxxxxAAAAAAAAABw')