# Read a SQLite table into CSV. Demonstrates source/sink combinations that
# don't require network access — handy in CI and locked-down environments.
version: 1
name: sqlite_to_csv
pipeline:
source:
type: sqlite
config:
database_url: sqlite://./data/app.db
query: SELECT id, email, created_at FROM users ORDER BY id
sink:
type: csv
config:
path: ./out/users.csv
delimiter: 44 # ','
write_headers: true
append: false