Unable to view the export history

Q&A
, , , , , ,
5

Hi @Unni

Quick Sight does not natively support tracking of report download activities (e.g., exports to CSV or Excel) per user. However, you can implement a workaround using AWS CloudTrail and other AWS services to approximate this functionality.

Workaround Using AWS CloudTrail

  1. Ensure that AWS CloudTrail is enabled for your account. CloudTrail records API calls made on your account, including those related to Quick Sight.
  2. Identify Relevant Events: While direct tracking of export actions isn’t available, certain events can indicate export activities. For example, the QueryDatabase event with a queryIntent attribute set to EXPORT_TO_CSV or EXPORT_TO_EXCEL can suggest an export action. Refer this - Is it possible to track user 'Export to Excel/CSV' activity? - #2 by Kellie_Burton
  3. Configure CloudTrail to deliver logs to an Amazon S3 bucket for storage and further analysis.
  4. Use AWS Glue to catalog the logs and Amazon Athena to query them.
  5. Import the processed data into Quick Sight to create dashboards that display user activities, including inferred export actions.

Limitations:

If users are provisioned directly in Quick Sight (not through IAM), CloudTrail may log them as unknown, limiting the ability to identify specific users.

2 Likes