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:

• Apache Superset
• Astrato
• Chartbrew
• Databrain
• Deepnote
• Dot
• Draxlr
• Embeddable
• Explo
• Fabi.ai
• Grafana
• Lightdash
• Looker
• Luzmo
• Metabase
• Mitzu
• Omni
• Querio
• Rill
• Rocket BI
• Tableau
• Zing Data
• Holistics BI

ClickHouse Cloud compatibility with data visualization tools

Tool	Supported via	Tested	Documented	Comment
Apache Superset	ClickHouse official connector	✅	✅
Astrato	Native connector	✅	✅	Works natively using pushdown SQL (direct query only).
AWS QuickSight	MySQL interface	✅	✅	Works with some limitations, see the documentation for more details
Chartbrew	ClickHouse official connector	✅	✅
Databrain	Native connector	✅	✅
Deepnote	Native connector	✅	✅
Dot	Native connector	✅	✅
Explo	Native connector	✅	✅
Fabi.ai	Native connector	✅	✅
Grafana	ClickHouse official connector	✅	✅
Hashboard	Native connector	✅	✅
Holistics	Native connector	✅	✅
Lightdash	Native connector	✅	✅
Looker	Native connector	✅	✅	Works with some limitations, see the documentation for more details
Looker	MySQL interface	🚧	❌
Luzmo	ClickHouse official connector	✅	✅
Looker Studio	MySQL interface	✅	✅
Metabase	ClickHouse official connector	✅	✅
Mitzu	Native connector	✅	✅
Omni	Native connector	✅	✅
Power BI Desktop	ClickHouse official connector	✅	✅	Via ODBC, supports direct query mode
Power BI service	ClickHouse official connector	✅	✅	A Microsoft Data Gateway setup is required
Querio	Native connector	✅	✅
Rill	Native connector	✅	✅
Rocket BI	Native connector	✅	❌
Tableau Desktop	ClickHouse official connector	✅	✅
Tableau Online	MySQL interface	✅	✅	Works with some limitations, see the documentation for more details
Zing Data	Native connector	✅	✅