GitHub

app_retail_sqlite_case.py

- Read csv files into a SQLite database. - SQLite does NOT have a built-in COPY-from-CSV like DuckDB. We create tables using SQL, then load CSV data using Python. - Use Python to automate SQL scripts ...
GitHub

app_retail_duckdb_case.py

- Read csv files into a DuckDB database. - Use Python to automate SQL scripts (stored in files). - Log the pipeline process. Paths (relative to repo root): DATA_RAW_DIR: Final[Path] = ROOT_DIR / "data ...