Facing a blocker while developing a Usage Dashboard for our Quicksight account

Question & Answer
, ,
1

Hi, we are trying to develop our Usage dashboard for our “adsbi” Quicksight account.
This is a critical Quicksight account since it is a centralised platform for all Ads team to build their reports. As part of our reporting strategy, we are trying to develop a Usage dashboard to measure the customer engagement and other usage metrics. We are referring to the AWS blog here: Measure the adoption of your Amazon QuickSight dashboards and view your BI portfolio in a single pane of glass | AWS Business Intelligence Blog.

However, we are facing a blocker, as the lambda function - “Data_Prepare” times out after 15mins but fails to create “group_membership.csv” and “object_access.csv” files . Can you please look into it?

2

Hi Abishek

Can you please review the lambda logs and see if there is an error?

3

Below is the error message from the Lambda log:

QS_error
QS_error1419×350 13.4 KB

4

I can see on the blog, a comment from another user who has faced the same error

5

Hi, is there any alternative solution to this issue. Seems many other users are also facing the same issue

6

Hello @ABHISEK_MONDAL, is this an ongoing issue when trying to create the Usage Dashboard? I’m not sure if @Ramon_Lopez has a different suggestion than me, but is there anything you can do to optimize the code run by the lambda function to try and ensure it runs the full function before timing out? The other option I am thinking of is to increase memory to the lambda so that the entire function will run.

If you have found a solution on your own, do you mind responding with the steps you took to fix this issue? Otherwise, let me know if you have any follow-up questions and we can try to find a solution.

7

Hi all

Please note the initial blog post has been updated to use glue jobs, primarily to bypass the lambda timeout issue.

PLease review and let us know your thoughts.

Thanks!
Ramon Lopez

1 Like