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 (#53061, #53066) |
| Deepnote | Native connector | ✅ | ✅ | |
| Explo | Native connector | ✅ | ✅ | |
| Grafana | ClickHouse official connector | ✅ | ✅ | |
| Looker | Native connector | ✅ | ❌ | Works with some limitations, documentation is needed |
| 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 | ✅ | ✅ |