1) Seed the raw orders

Create duckdb-ducklake/assets/orders.csv:

order_id,country,amount
1,US,120.50
2,US,80.00
3,DE,200.00
4,DE,55.25
5,TR,300.00
6,TR,45.00
7,GB,150.75
8,GB,90.00

Create duckdb-ducklake/assets/raw_orders.asset.yml:

name: raw.orders
type: duckdb.seed

parameters:
  path: orders.csv

columns:
  - name: order_id
    type: integer
  - name: country
    type: string
  - name: amount
    type: float

The seed asset loads the CSV into raw.orders in duckdb-default. Declaring the column types keeps downstream SQL predictable because CSV values do not include type information.