Connect to quicksight dataset using python

Question & Answer
1

I am trying to connect to quicksight data set via python and run the queries to use results in custom portal. Could you please provide a python script to connect to quicksight.

2

Hi @raviquicksight - For connecting QuickSight , please use boto3. See the documentation link below - QuickSight - Boto3 1.26.158 documentation

Regards - Sanjeeb

3

@raviquicksight ,

You cannot connect to a QuickSight dataset and run queries on them using python. The QuickSight - Boto3 1.26.158 documentation will provide you with the ability to get metadata details of a dataset not the data.

You can embed the QuickSight dashboard in your custom portal https://developer.quicksight.aws/

Kind regards,
Koushik

2 Likes
4

Thanks @Koushik_Muthanna . Yes you are correct, boto3 API are able to get the details on the meta data and not data. Thanks for clarifying it.

Regards - Sanjeeb

1 Like
5

@Koushik_Muthanna Thanks for your response. I was doing with Athena tables but trying to leverage the SPICE memory datasets . So, there is only way is embed method to use quicksight data sets?