Skip to content

Insert Tools v1.0.0

Latest
Compare
Choose a tag to compare
@castengine castengine released this 17 May 12:58
· 25 commits to main since this release

πŸš€ 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