Additional Settings
Explore additional settings in Tathya's database configuration, including the 'Advance' tab for fine-tuning aspects like SQL Lab and Performance.
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.
Databases are configured once for a project.
Last updated