How to access query history database

Note: This feature is available in Enterprise and AWS editions only.

Table of contents

• Accessing the database

The system uses an internal database to store query history, API call logs, and other service data.

Accessing the database

1. Create the target folder inside the container.

   docker compose exec cloudbeaver mkdir -p /opt/cloudbeaver/workspace/sample

2. Copy the database folder.

   docker compose exec cloudbeaver cp -r /opt/cloudbeaver/workspace/.metadata/qmdb/ /opt/cloudbeaver/workspace/sample/

3. Connect to the internal server database used in your deployment (for example, H2 Embedded V.2):

   • Set the path to ${workspace}/sample/qmdb/qmdb.

   • Default login and password aren't required unless changed in the Query manager database configuration.

   

   The H2 Embedded V.2 driver might be disabled by default. To enable it, see Server configuration and administration.

4. Explore the internal tables to view stored data:

   Table	Description
   qm_query	Contains query history
   qm_api_call_log	Contains API call logs. For configuration details, see Logger settings.