# 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: file
config:
path: ./out/users.csv
csv:
delimiter: ","
has_headers: true