cockroachdb / cockroachdb/cockroach
Have the ability to filter out internal queries when using `sql.log.user_audit` cluster setting
Open
C-enhancement
O-support
P-3
T-observability
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
**Is your feature request related to a problem? Please describe.**
When using `sql.log.user_audit`, the audit log records ALL queries generated by the user, even ones that are internally created by viewing the DBConsole etc. There should be an option to only record explicit SQL queries ran externally from clients.
**Describe the solution you'd like**
A new cluster setting, which works with `sql.log.user_audit` to disable the logging of anything where the query is generated internally (e.g. ApplicationName is one of `$ internal-console`, `$ internal-check-is-admin`, etc.
Jira issue: CRDB-29113
Contributor guide
Assessment
This issue has not been assessed yet.