Hi everyone, I have couple of questions related to QuickSight reports, couldn’t find the answer in the documentation.
Any assistance would be appreciated
Can the email list be automatically updated from a dataset? (to change the list dynamically)
From which email address are reports sent? Can we connect a custom email? company email for example?
Can reports be generated through API?
Can the dashboard be automatically filtered by email (for example by user ID)? Meaning, I create one report and each email recipient automatically gets the data that is relevant to them?
No. Scheduled email reports in QuickSight require you to specify recipients as QuickSight users or groups (or “all users with access”) at schedule creation. There’s no built-in feature to pull email addresses directly from a data field or dataset—they must be managed in the QuickSight console to the schedule’s recipient list. Refer this link
By default, QuickSight sends from no-reply@quicksight.aws. You can override this by creating a custom email template under Manage QuickSight → Account customization → Email report template. There you choose either the QuickSight default or a custom SES-verified email address (including a friendly display name), then authorize QuickSight via an SES sending policy. Refer to the following documentations this might be helpful for you.
Yes. QuickSight provides APIs, such as StartDashboardSnapshotJobSchedule (for scheduled snapshots) and StartDashboardSnapshotJob (for on-demand jobs) that you can call via AWS CLI, or Boto3 to trigger report delivery according to the dashboard’s configured schedule and settings. Refer to the following documentations this might be helpful for you.
Yes. By implementing Row-Level Security (RLS) and Column-Level Security (CLS) on the QuickSight username or email, each scheduled email report delivers a personalized snapshot containing only the data the user is permitted to see. The same security and dynamic defaults you apply in the interactive dashboard carry over into the emailed report.