tencent cloud

All product documents
Tencent Cloud TCHouse-D
DocumentationTencent Cloud TCHouse-DOperation GuideData ManagementDatabase Auditing
Database Auditing
Download PDF
Last updated: 2024-12-20 15:49:51
Database Auditing
Last updated: 2024-12-20 15:49:51
Download PDF
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.

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon