Apache Superset with ClickHouse®: Connection Guide | Tutorial for ClickHouse®
Have questions about ClickHouse®? Get a free consultation with Altinity. Book a call here: https://hubs.la/Q02qr1RZ0 . No marketing BS. no sales talk during the call. Just answers to your questions.
______________________________
We continue our series on visualizing high volumes of ClickHouse data with Apache Superset. In this second part, we examine how to connect your ClickHouse database to Superset to generate beautiful charts and graphs (with the help of caffeine, of course)!
This video will demonstrate how to do so with two different kinds of ClickHouse servers:
1. Local Server Connection
2. Altinity.Cloud Connection
Please note that both examples utilize the SQLAlchemy format so that every database connection from Superset to your database of choice follows the same structure.
Whether your Superset is installed directly, run from Docker, or from a managed service, you can now extract ClickHouse data to feed your Superset charts.
Install Superset directly: https://superset.apache.org/docs/inst...
Learn more about SQLAlchemy clickhouse-driver Connection: https://clickhouse-driver.readthedocs...
Access our documentation on how to connect Apache Superset with ClickHouse: https://docs.altinity.com/operationsg...
Download docker-compose files from GitHub repository: https://github.com/apache/superset
Chapters:
0:00 Introduction
1:35 SQLAlchemy format
3:10 Local Server connection
5:00 Altinity.Cloud connection
#ApacheSuperset #ClickHouse #DataVisualization #BusinessIntelligence #ClickHouseSuperset
-----------------
Check out Preset Cloud: https://preset.io/product/
Try Altinity.Cloud: https://altinity.com/cloud-database/
--------------
Join Altinity Meetups on ClickHouse: https://www.meetup.com/san-francisco-...
Check out more resources on ClickHouse: https://altinity.com/resources/
Visit the Altinity Documentation site: https://docs.altinity.com/
Contribute to Altinity Knowledge Base for ClickHouse: https://kb.altinity.com/
Join the Reddit community for ClickHouse: / clickhouse
-------------
More about Altinity! 💡
Site: https://www.altinity.com
LinkedIn: / altinity
Twitter: / altinitydb
Slack: https://altinity.com/slack