Once you have established the connection, you can check the “Advance” tab to access additional settings. These allow you to fine-tune various aspects of the database connection.

The two important configurations here are SQL Lab and Performance:

SQL lab

Enable “Expose database in SQL Lab” to make the database available in SQL Lab and Enable “Allow this database to be explored” to allow database exploration and interaction.

Performance

Set the CHART CACHE TIMEOUT. This is a configuration parameter related to how Tathya caches (stores temporarily) the results of chart queries. Caching is a technique used to improve performance by storing and reusing previously fetched data.

Save the configured settings to establish the connection between Tathya and your MySQL database.

Now, proceed to click on the "Test Connection" button to ensure that Tathya can successfully connect to your MySQL database. Address any issues that arise.

Once the test is successful, click "Save" to confirm the configuration and finalize the setup.

Now, you can use the configured MySQL database for data exploration in Tathya.

Tathya is a data exploration and visualization platform that lets users connect to various data sources, explore data, and create interactive dashboards.

Tathya itself doesn't have a storage layer to store your data but instead pairs with your existing SQL-speaking database or data store. So, to be able to query and visualize data from Tathya, you first need to add the connection credentials of your database.

Setup your database

Login into Tathya with your credentials, now on the homepage go to the top right corner, go to settings and click on the "Data" menu to access the data source configuration.

In the "Data" menu, select "Databases" to manage your database connections. Click on the "+" button to initiate the setup process.

From the resulting modal “connect a database”, select the type of database you are connecting to (e.g., MySQL, PostgreSQL, SQLite).

We usually use the MySQL database type, once selected in the next step you have to enter the essential connection details and credentials to establish a connection with the MySQL server.

The required MySQL credentials includes the following fields:

Host

The "host" refers to the network address or hostname of the MySQL server where your database or data source is located. It is the address that Tathya will use to reach the database.

Port

The "port" is a specific endpoint on the host machine. The port number is essential for Tathya to know where to communicate with the database service.

Database Name

The “database name” is the name of the specific MySQL database you want to connect to.

Username and Password

The “username and password” are associated with the account you want to use for the connection.

Display Name

The “display name” is how the database will display in Tathya.

Choose a descriptive name for the connection. For example, if a project were named Wasatch Ski, the display name should be “Wasatch Ski OMS”