Answers generated from Webex transcript and chat interactions
Q: It looks like the data gets loaded into Athena, which is optimized for OLTP instead of something like Redshift which is optimized for OLAP. In your testing, would it be ideal to switch to a service that’s optimized for analytical processing instead of transactional processing?
A: We chose Athena for this solution to provide a cost-optimized approach, as Athena works easily directly with S3 and just needs metadata to access the S3 bucket. For this particular usage analytics use case, Athena should work well even for large numbers of accounts (500+) with high usage, due to the partitioning in place. However, if you have different needs, you could certainly use a different data source like Redshift. Before making a decision, it’s recommended to consult with an Athena SME to explore optimization options, as many customers successfully run large-scale querying using Athena.
Q: Does the current export contain session level data? My understanding is that CloudTrail logs don’t contain session data - they show when a user views a dashboard which doesn’t necessarily correlate with one session.
A: Yes, you will get session level details from the Cost and Usage Report data used in this solution. When users interact with dashboards, sessions are consumed and that is captured. The data shows whether anonymous users or reader sessions are being consumed on particular dashboards. If you have hourly or daily snapshots in your Cost and Usage Report, it will have that granular data. While this solution aggregates to a monthly level by default, you can customize it to use more granular data if available in your Cost and Usage Report.
Q: How do you change the managed pricing?
A: To change the managed pricing, go to the top right user icon in QuickSight and click on “Manage QuickSight”. Then go to “Managed pricing” and you will see options to switch between the user-based pricing plan and monthly capacity pricing plan.
Q: Can we bring in user group details, if they have assigned to one into qs_users_info table?
A: we are currently pulling all user info across namespace , but yes it can be enhanced to pull group info - using list group and group permission APIs
- list-group-memberships list-groups
- quicksight — AWS CLI 1.38.30 Command Reference