If I want to query the spice data set using python and show the relevant value to my app then give me the following steps and description of that.
Hi @agni_04
you want to query a spice dataset outside of QS with Python?
BR
Hi @agni_04 - I do not think you can query Spice data set out of Quick Sight console. Using Boto3 API you can create, update and set permissions for Quick Sight artifacts.
Regards - Sanjeeb
1 Like
Thank you so much for this. I have the same requirement and I wanted to confirm that if this is still not possible?
I saw an API endpoint called ’ start_dashboard_snapshot_job’. Seems like we can extract data using this. Did any one tried? I am unable to do this as I do not have the add-on.
Regards
Sandipan
Hi @sandygh,
Yes, if you have the pixel-perfect reporting add-on, you can use StartDashboardSnapshotJob to export data in the form of CSV files but not directly from a dataset. You can only only export from table or pivot table visuals. If you create a table visual that contains every column from your dataset, you can essentially export data from your entire dataset as long as you don’t exceed the row/size limitation of the export.
Thank you so much David for the reply.
Question 1 - Can you please let us know whats is the limit for row/size?
I found these links, one mention 500MB other one mention 1TB.
link1 - Exporting data from visuals - Amazon QuickSight
link2 - Data source quotas - Amazon QuickSight
Question2: As currently we can not create a table with all the columns. Is there any possible way we can extract the data from the base query (the query which is powering the dashboard)? If we have multiple data sources(query), can extract from all the sources?
Thanks
Sandipan