1回答
- 新しい順
- 投票が多い順
- コメントが多い順
1
I found a (Japanese) site that might answer your question. https://dev.classmethod.jp/articles/visualize-amazon-quicksight-api-logs-with-quicksight/
The steps are below:
- Enable CloudTrail
- QuickSight permission settings for Athena
- Create Athena Table
- You can create a table from the CloudTrail console ( I used to run a query to create a table from the Athena console ).
- Create Dataset on QuickSight
- There is a SQL sample on the following site
- I was using the below query
SELECT
date
,eventtime
,eventname
,useridentity.username AS username
,json_extract_scalar( serviceeventdetails, '$.eventResponseDetails.dashboardDetails.dashboardName' ) AS dashboardName
,json_extract_scalar( serviceeventdetails, '$.eventResponseDetails.analysisDetails.analysisName' ) AS analysisName
FROM "logs"."cloudtrail_logs"
WHERE
region = 'ap-northeast-1'
AND eventsource = 'quicksight.amazonaws.com'
AND eventname in ( 'GetDashboard','GetAnalysis')
;
- Create a graph
- I have graphed the number of users by date as in the image below
Good solution and we also followed the same but instead of Athena, we used our custom spark on EMR and developed this as we used EMR for our big data processing.
関連するコンテンツ
- AWS公式更新しました 1年前
- AWS公式更新しました 3年前
You can collect all quicksight events via cloudtrail and save into S3. Once the data is written to S3, either custom program ( using python) or Athena can be used to filter quicksight events and understand the dashboard usage and summary. This is a custom solution followed by many organization. For filtering only specific region, you need to create trail via cli .