Creating a compelling and informative dashboard requires a robust database connection. A database serves as the backbone of any data-driven dashboard, providing the necessary data for visualization. Without a database, it would be impossible to pull in the structured data required for meaningful visualizations. Therefore, setting up a database is the first and most critical step in creating charts and dashboards.
In this article, we will cover the following topics:
Supported Databases
Syntasa, using Superset, supports a variety of databases. You can find the complete list of supported databases in this official blog of Superset.
Navigating to the Databases list
From the upper menu, click on the Settings dropdown link in the upper right corner and select the Database Connections option under Data. Here you will see the existing database connections that have already been configured and are available to be used.
Connecting to a new Database
Setting up and managing database connections in Syntasa using Superset is a straightforward process, ensuring you have seamless access to the data you need for your visualizations. Here are the general steps for creating a new database:
- Go to any screen of the Superset.
- Select Database Connections from the Settings dropdown link.
- Click the + Database button.
- A pop-up screen with the Connect a Database name will open.
- Select the Database of your choice (e.g.: Amazon Athena, Big Query, etc) and enter the correct details.
- Click Connect.
- The newly created database will be shown in the list.