The Database Auditing feature displays the historical information of all SQL operations within the cluster and supports search, filtering, and download.
Information displayed includes: time, client address, database name, user account, SQL type, SQL statement, returned rows, scanned rows, and execution time.
Note:
To ensure data security, Tencent Cloud Warehouse-D currently does not support collecting audit logs via ES/CLS. If needed, you can query the audit tables doris_audit_tbl__ in the default library doris_audit_db__ for analysis.
Operation Guide
Log in to Tencent Cloud TCHouse-D Console, and select Data Management > Database Auditing from the left side list to enter the audit page.
Select a time range: Supports customizing the time range to seek any time frame's audit log.
Search and filter: To precisely locate query records, you can filter the audit logs by the SQL statement. You can also filter by database name, user account, SQL type, and more.
Download data: Support exporting audit logs within a certain time range, with a single export limit of 20,000 records. If this limit is exceeded, adjust the time range.
Note:
During download, the conditions set by the user for search and the filters for database name, user account, and SQL type columns on the page will be retained.
Yes
No
Was this page helpful?