clickhouse-connector

It connects Clickhouse with QGIS, enabling seamless integration and visualization of spatial data. It retrieves records from ClickHouse that contain point information and displays them as layers in QGIS. This plugin allows users to easily manage and visualize large geospatial datasets stored in Clickhouse directly within the QGIS environment.

Clickhouse Plugin for QGIS

Query and Visualize Clickhouse Point data in QGIS.

Requirements

QGIS 3.10 (minimum)

Important Note

• The code uses "—break-system-packages" to install the dependencies (try it at your own risk).
• By default:
  • If timestamp field is there in clickhouse table then last 8 hours data will be displayed (without any query), to query data beyond that use query tool to write your own queries.
  • If timestamp field is not present then 10000 rows of data will be displayed (without any query), to query data beyond that use query tool to write your own queries.

    Install

Install from ZIP file

The plugin can be installed using Install from ZIP option on the QGIS plugin manager.

• Download zip file from the required plugin released version.
• From the Install from ZIP page, select the zip file and click the Install button to install plugin
• It might take a few minutes to get all the required dependencies for plugin to work

Install from QGIS plugin repository in experimental plugins

• Open QGIS application and open plugin manager.
• Search for clickhouse_connector in the All page of the plugin manager.
• From the found results, click on the clickhouse_connector result item and a page with plugin information will show up.
• Click the Install Plugin button at the bottom of the dialog to install the plugin.