CSV connector

Runs SQL over CSV files on an embedded DuckDB — no database to stand up. Each file in the directory becomes a queryable view named after the file (sales.csvsales). This is what these docs use.

# sources.yaml
main:
  type: csv
  directory: data        # folder of .csv files, relative to the project

Then query the view by file name:

SELECT month, SUM(downloads) AS downloads
FROM downloads            -- data/downloads.csv
GROUP BY month
Key Purpose
directory Folder of CSV files (each → a view).
files Or an explicit {view_name: path} map.
path A single CSV file.

Extra: none — it's in the core install. Inherits the DuckDB connector's reconnect-on-fatal resilience.

Generated