Reference Guide
SQL Proxy

Logging SQL Queries

2min

To check SQL Proxy Command Logs:

  1. Navigate to Logging > Session Log.
  2. Open the Command Logs tab.
  3. Enter the information into the search filter and click Search.

In the command result, you can observe the result of commands. If the command has a black key in it, it should be given Not Executed.

In the detail column, you can read the information about whether the query returns masked data or not

SQL Proxy Logs
SQL Proxy Logs


sql.proxy.metadata.sync.period: This parameter determines the interval (in milliseconds) at which metadata is fetched or synchronized from the database. The default is 30000 (30 seconds). Adjust it based on the frequency of metadata changes and performance needs.

Application properties should be edited in /pam/sql/config/application.properties on a Linux device with PAM. Then restart the `pam-sql` service.