Logging SQL Queries
2 min
To check SQL Proxy Command Logs:
- Navigate to Logging > Session Log.
- Open the Command Logs tab.
- 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.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.