{"repo":"ClickHouse/clickhouse-connect","free":true,"listed":false,"github":"https://github.com/ClickHouse/clickhouse-connect","clone":"git clone https://github.com/ClickHouse/clickhouse-connect.git","description":"Python driver/sqlalchemy/superset connectors","language":"Python","stars":515,"topics":["clickhouse","python"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"ClickHouse Connect A high performance core database driver for connecting ClickHouse to Python, Pandas, and Superset Pandas DataFrames (numpy and arrow-backed). Requires pandas 2.0 or later. Numpy Arrays PyArrow Tables Polars DataFrames Superset Connector SQLAlchemy Core (select, joins, lightweight deletes; limited feature set) ClickHouse Connect uses the ClickHouse HTTP interface for maximum compatibility. An experimental chDB backend is also available for running queries against an embedded in-process engine with get client(interface='chdb') . Install it with pip install clickhouse-connect[chdb] . Installation ClickHouse Connect requires Python 3.10 or higher. Upgrading from 0.x The 1.0 release includes breaking changes. If you are upgrading from a 0.15.x or earlier release, see MIGRATION.md for a guide to the changes and their replacements. Superset Connectivity ClickHouse Connect is fully integrated with Apache Superset. Previous versions of ClickHouse Connect utilized a dynamically loaded Superset Engine Spec, but as of Superset v2.1.0 the engine spec was incorporated into the main Apache Superset project and removed from clickhouse-connect in v0.6.0. If you have issues connecting to earlier versions of Superset, please use clickhouse-connect v0.5.25. When creating a Superset Data Source, either use the provided connection dialog, or a SqlAlchemy DSN in the form clickhousedb://{username}:{password}@{host}:{port} . SQLAlchemy Implementation ClickHouse Connect includes a l","default_branch":null,"files":null,"tree":[],"storefront":"/r/ClickHouse","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ClickHouse/clickhouse-connect/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}