Read multiple CSV files from a folder by path

Reads all CSV files in the given folder path into one result set. Supply the folder path in Path. Data is read directly from the API; no local download is used.

SELECT * FROM read_csv_files_from_folder
WITH (Path='/myfolder')