How to Connect Apache Superset with YugabyteDB
Learn to Connect Apache Superset (Open Sour Data Visualization) with YugabyteDB (Open Source Database)
Superset is fast, lightweight, intuitive, and loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to highly detailed geospatial charts.
Powerful yet easy to use
Superset makes it easy to explore your data, using either our simple no-code viz builder or state-of-the-art SQL IDE.
Integrates with modern databases
Superset can connect to any SQL-based databases including modern cloud-native databases and engines at petabyte scale.
Modern architecture
Superset is lightweight and highly scalable, leveraging the power of your existing data infrastructure without requiring yet another ingestion layer.
Rich visualizations and dashboards
Superset ships with 40+ pre-installed visualization types. Our plug-in architecture makes it easy to build custom visualizations.
What is YugabyteDB?
YugabyteDB is a high-performance, cloud-native, distributed SQL database that aims to support all PostgreSQL features. It is best suited for cloud-native OLTP (i.e., real-time, business-critical) applications that need absolute data correctness and require at least one of the following: scalability, high tolerance to failures, or globally-distributed deployments.
100% open source YugabyteDB is fully open-source under the Apache 2.0 license. The open-source version has powerful enterprise features such as distributed backups, encryption of data-at-rest, in-flight TLS encryption, change data capture, read replicas, and more.
Before proceeding for Database connection, Kindly make sure that you have installed Database Connection Dependencies mention on Apache Superset Website.
Step 01: Click on Database Connection.
Step 02: Click on add Database.
Step 03: Click on PostgreSQL.
Step 04: Add your Host and Port, Port will be 5433 and Host will be localhost when it is On Premises, for Cloud check you host and enter it along with port.
Step 05: Add your database name here.
Step 06: Enter Your Database user name i.e yugabyte
Step 07: Enter you database password.
Step 08: Enter Display name as Yugabyte
Step 09: Click on Connect
Step 10: If Everything goes well then click on finish.
Step 11: Click on SQL Lab to see your database.
Step 12: Click on your database Yugabyte.
Step 13: Click on schema as public.
Step 14: Click on your table within database.
Step 15: Now you can see the transactions in Tables.
