#SQL
4 posts tagged SQL. All posts
Idempotent ETL jobs: watermarks, upserts and safe rerunsBuild an incremental extract-and-load job that can run twice without harm: high-watermarks, an overlap window for late rows, SQLite upserts and run ids.
Type-safe SQL in Go with sqlcGenerate typed Go code from plain SQL with sqlc: a version 2 sqlc.yaml, :one, :many and :exec queries, using pgx or database/sql, and transactions with WithTx.
dbt Core with DuckDB: models, tests and incremental tablesBuild a small dbt project on DuckDB: the dbt-duckdb profile, CSV sources, staging and mart models with ref, generic data tests, an incremental model and dbt build.
Querying CSV and Parquet files with DuckDBUse DuckDB's CLI and Python API to query CSV and Parquet files in place, read many files with globs, write partitioned Parquet, and run SQL on pandas DataFrames.
© 2026 David Li · Home · Blog · RSS ·Classic site · Built with Astro, Starlight and three.js · Logos:Font Awesome Free (CC BY 4.0)