Introduction

You want to find a table’s last accessed details for audit purposes. 

Instructions

Run the following query. You can retrieve details about rows, but not columns. 

SELECT
  max(event_time) as event_time,
  request_params.table_full_name

FROM system.access.audit
WHERE 
  request_params.operation = 'READ'
GROUP BY request_params.table_full_name
ORDER BY event_time DESC