π First stable release of Insert Tools β a flexible CLI for inserting SELECT query results into ClickHouse, with optional schema validation and CAST rewriting.
β¨ Features
- π Insert data into ClickHouse using SELECT queries
- π§ Matches columns by name (not index) in target table
- π‘οΈ Auto CAST rewriting for safe type conversions
- π JSON-based configuration support
- π§° CLI with argparse, available via the bd-insert command
- π§ͺ Test suite covering CLI, casting, and runner logic
- π§ Python 3.8+ compatible
π¦ Installation
pip install insert-tools
Or run from source:
git clone https://github.com/castengine/insert-tools.git
cd insert-tools
pip install .
bd-insert --help
π§ͺ Covered Components
- clickhouse_insert.runner
- clickhouse_insert.cast_rewriter
- clickhouse_insert.cli
β Notes
This is a solid base release intended for early adopters. Feedback, issues, and contributions are welcome!
Full Changelog: v1.0.0...v1.0.0