Protect audit (beta)

An audit log contains information about the queries that were run to access the data and the data that was accessed.

This topic describes how to generate an audit log and what is shown in an audit log.

Generate an audit log

You can generate an audit log of access records from the data source on the Audit page.

Note The time that it takes for the actions performed in a data source to appear in an audit log in Collibra Protect varies from several minutes to hours, depending on the data source.

Requirements and permissions

You have a global role that has the Protect > Edit or Protect > Administration global permission.

Steps

  1. Open Protect.
  2. Click the Audit tab.
  3. Depending on your data source, click BigQuery or Snowflake.
  4. Click one of the following buttons: Today, Yesterday, A week ago, 30 days ago.
    Tip The start date corresponding to the button that you clicked is shown in the Start Date field. Alternatively, you can enter or select a date in the Start Date field, and then click Generate Log.

    The audit log is generated.
Important 
  • The generation of an audit log may take up to a minute. After clicking Generate Log, do not navigate away from the Audit page because doing so cancels the audit log generation.
  • The audit log contains the first 1,000 records from the selected start date. If you want to view the remaining records, contact your data source administrator.

Audit log data

The following table describes the columns that are shown in an audit log.

Column Description
Query ID The ID of the query in the source database.
Query Start Time The date and time of the query in the source database.
Source User Name The name of the user in the source database who ran the query to access the data.
Direct Object Accessed The database object (a table or a view) that was used to access the data.
Base Object Accessed The database object that was accessed.