About the Plugin
The clickhouse_connector QGIS Plugin seamlessly connects ClickHouse databases with QGIS, allowing you to visualize point data as GeoJSON layers within the QGIS environment. Additionally, the plugin features a custom query tool that enables users to run SQL queries directly on their ClickHouse database and visualize the results on QGIS maps.
How to Use the Plugin
- Install the Plugin: Download and install the clickhouse_connector plugin from the QGIS Plugin Repository (experimental section) or our GitHub repository.
- Connect to ClickHouse: After installation, open QGIS and navigate to the clickhouse_connector plugin tab. Enter your ClickHouse database credentials to establish a connection.
- Visualize Data: Once connected, you can select tables containing point data and visualize them as GeoJSON layers on the QGIS map.
- Run Custom Queries: Use the custom query tool to run SQL queries on your ClickHouse database. The query results will be displayed directly on the QGIS map.
System Requirements
- ClickHouse: A running instance of ClickHouse to connect to the plugin.
- QGIS Version: QGIS 3.10 or later.
- Python: Python 3.8 or higher.