Visualizing Data in ClickHouse
Now that your data is in ClickHouse, it's time to analyze it, which often involves building visualizations using a BI tool. Many of the popular BI and visualization tools connect to ClickHouse. Some connect to ClickHouse out-of-the-box, while others require a connector to be installed. We have docs for some of the tools, including:
ClickHouse Cloud Compatibility with Data Visualization Tools
Tool | Supported via | Tested | Documented | Comment |
---|---|---|---|---|
Apache Superset | ClickHouse official connector | ✅ | ✅ | |
AWS QuickSight | MySQL interface | ✅ | ✅ | Works with some limitations, see the documentation for more details |
Deepnote | Native connector | ✅ | ✅ | |
Explo | Native connector | ✅ | ✅ | |
Grafana | ClickHouse official connector | ✅ | ✅ | |
Hashboard | Native connector | ✅ | ✅ | |
Looker | Native connector | ✅ | ✅ | Works with some limitations, see the documentation for more details |
Looker | MySQL interface | 🚧 | ❌ | |
Looker Studio | MySQL interface | ✅ | ✅ | |
Metabase | ClickHouse official connector | ✅ | ✅ | |
Power BI Desktop | ClickHouse official connector | ✅ | ✅ | Via ODBC, not suitable for large workloads (no direct query mode) |
Power BI service | ClickHouse official connector | 🚧 | ❌ | |
Rocket BI | Native connector | ✅ | ❌ | |
Tableau Desktop | ClickHouse official connector | ✅ | ✅ | Certification in progress |
Tableau Online | MySQL interface | 🚧 | ❌ | Compatibility fix in progress |
Zing Data | Native connector | ✅ | ✅ |