Getting a error "(SNAPI_SQL_CONNECTION_FAILURE)" when creating a quicksight q topic

Question & Answer
, ,
1

Hello Everyone,

When creating a dataset using create_dataset API from boto3 for quicksight and then creating a topic upon the created dataset, getting an error saying “(SNAPI_SQL_CONNECTION_FAILURE)”.

Can anyone help me find the possible reasons for this error message?

image
image671×226 8.25 KB

Thanks and looking forward foe help :slight_smile:

1 Like
2

Hello @ayushanandd , welcome to the QuickSight community!

Can you walk me through your process when trying to create the Q Topic? Also, what data source did you try to create this dataset from?

3

Hello @duncan , Thanks for the follow-up

The data source I am using is aws Athena and trying to create a dataset for quicksight through the athena datasource by calling create_dataset api from boto3 quicksight as client.

And when the dataset is created, I am trying to create a q topic upon that using create_topic boto3 api and quicksight as client.

here is the view of datafield of the q topic:

image
image1838×232 24.4 KB

1 Like
4

And when clicked view (Which is marked red in previous ss) here it is what i see:

image
image1825×507 53.3 KB

1 Like
5

Hey @ayushanandd

Were you able to confirm (visually/programmatically) that the dataset did successfully load into your QuickSight account?

I would also make sure that your QuickSight account has the appropriate permissions to connect to Athena: