Saving Individual Visuals from Quicksight to Amazon S3

[Xclipse]

Hi @ZacB

Automating the export of an entire analysis or individual sheets directly to an Amazon S3 bucket isn’t natively supported. However, you can achieve this functionality through the following approach.

• Quick Sight provides asset bundle export operations that allow developers to export existing assets, such as dashboards and analyses, and download their definitions. These exported assets can be imported back into Quick Sight when needed. To export Quick Sight assets, you can start an asynchronous export job using the StartAssetBundleExportJob API call. Once the export job is completed, you can download the asset bundle using the provided download URL.

To automate the process

• Create a Lambda function that invokes the StartAssetBundleExportJob API to export the desired Quick Sight assets.​
• Configure the Lambda function to store the exported asset bundle in a specific S3 bucket.
• Set up a CloudWatch Events rule to trigger the Lambda function based on a defined schedule or specific events.

Note: While this approach automates the export of Quick Sight asset definitions, it doesn’t export the visual data as images or PDFs. If you require visual representations, consider scheduling email reports that include PDFs of your dashboards.

Please refer to the below documentation this might be helpful for you.

Automate financial statements using Amazon Quick Sight Snapshot Export APIs

Financial statements are a set of documents that contain formal records of financial activities of a business at a specific point in time. For example, a profit and loss (P&L) statement summarizes the revenues, expenses, and resulting net profit or loss of a business. It is a snapshot of the organization’s financial performance, starting from the organization’s total revenue, followed by the deductions for the costs of goods sold and operating expenses. By analyzing these profits, business leade…