Logging SQL Queries

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 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