Quicksight API (export the analysis into CSV format)

Question & Answer
,
1

I have an analysis in quicksight which is basically a table. I have used the way of quicksight API only to create that analysis. We have option of exporting the table visual into CSV through UI. How can I achieve the same through a quicksight API?

Summarising, I need to use quicksight API into python code to export my visual/analysis (which is in a table) to export it into a csv/excel format.

2

Hi
using this API you can do this.

1 Like
3

Thankyou very much. I tried using this but I am unable to get the output. The reason is that while setting Userconfiguration in the start_dashboard_snapshot_job, it is giving me the following error:

An error occurred (UnsupportedPricingPlanException) when calling the StartDashboardSnapshotJob operation: This API action is supported only when the account has an active paginated reports add-on plan.

My only work is to export my table visual into S3. I don’t want to put any row level restrictions to any user for any dataset. Can you tell me a way through?

4

Hi @karora28

The error message you’re encountering indicates that the start_dashboard_snapshot_job operation requires the Paginated Reports add-on in Amazon QuickSight. To resolve this issue:

  1. Verify Your Subscription: Ensure your AWS account has the Paginated Reports add-on activated.
  2. Upgrade If Necessary: If you don’t have this feature, consider upgrading your QuickSight subscription.

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

1 Like
5

Hi @karora28

It’s been a while since we last heard from you, did you have any additional or follow up questions regarding your initial topic? Were you able to try out the approach that was shared?

If we do not hear back within the next 3 business days, I’ll go ahead and mark the solution to close out the topic.

Thank you!

6

Hi @karora28,
Since we have not heard back from you, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!