ExcelFileSource

ExcelFileSources let you query a local Excel file with SQL — no database required.

The file is loaded into an in-memory DuckDB connection and exposed as a view named after the source, so models can SELECT from it like any other table.

Example

sources:
  - name: budget_xls
    type: xls
    file: data/budget.xlsx

models:
  - name: budget
    source: ${ref(budget_xls)}
    sql: SELECT * FROM budget_xls

Attributes

Field	Type	Default	Description
path	string	None	A unique path to this object
name	string	None	The unique name of the object across the entire project.
file_path	string	None	The path to the file that contains the object definition.
type	string	None
file	string	None	Path to the Excel file, relative to the project directory.
delimiter	string	,	Character separating values in the file.
encoding	string	utf-8	Text encoding of the file.
has_header	boolean	True	Whether the first row of the sheet contains column names.