# Getting a error "(SNAPI\_SQL\_CONNECTION\_FAILURE)" when creating a quicksight q topic **URL:** \ **Category:** Q&A\ **Tags:** Business-Intelligence-Engineer, dataset, quick-sight\ **Created:** [March 11, 2025, 7:38am UTC](https://community.amazonquick.com/t/getting-a-error-snapi-sql-connection-failure-when-creating-a-quicksight-q-topic/43598 "2025-03-11T07:38:20Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![ayushanandd](https://avatars.discourse-cdn.com/v4/letter/a/e99b99/32.png) [@ayushanandd](https://community.amazonquick.com/u/ayushanandd)\ **Post date:** [March 11, 2025, 7:38am UTC](https://community.amazonquick.com/t/getting-a-error-snapi-sql-connection-failure-when-creating-a-quicksight-q-topic/43598/1 "2025-03-11T07:38:20Z")
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](https://d1wl4jav5dp96l.cloudfront.net/original/3X/e/0/e0ef488c9250c1fcda91345f4792dc06b8a75019.png) Thanks and looking forward foe help 🙂 ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [March 11, 2025, 3:43pm UTC](https://community.amazonquick.com/t/getting-a-error-snapi-sql-connection-failure-when-creating-a-quicksight-q-topic/43598/2 "2025-03-11T15:43:13Z")
Hello @ayushanandd , welcome to the Quick Sight 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? ---
**Author:** ![ayushanandd](https://avatars.discourse-cdn.com/v4/letter/a/e99b99/32.png) [@ayushanandd](https://community.amazonquick.com/u/ayushanandd)\ **Post date:** [March 12, 2025, 9:59am UTC](https://community.amazonquick.com/t/getting-a-error-snapi-sql-connection-failure-when-creating-a-quicksight-q-topic/43598/3 "2025-03-12T09:59:35Z")
Hello @WLS-D , 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](https://d1wl4jav5dp96l.cloudfront.net/original/3X/a/8/a859e78f25b66d3d0b6fc24112314bfbf54cf6a3.png) ---
**Author:** ![ayushanandd](https://avatars.discourse-cdn.com/v4/letter/a/e99b99/32.png) [@ayushanandd](https://community.amazonquick.com/u/ayushanandd)\ **Post date:** [March 12, 2025, 10:04am UTC](https://community.amazonquick.com/t/getting-a-error-snapi-sql-connection-failure-when-creating-a-quicksight-q-topic/43598/4 "2025-03-12T10:04:40Z")
And when clicked view (Which is marked red in previous ss) here it is what i see: ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/2/6/264573635a1d201da958432fd8b5e89e550fc02f.png) ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [March 12, 2025, 3:24pm UTC](https://community.amazonquick.com/t/getting-a-error-snapi-sql-connection-failure-when-creating-a-quicksight-q-topic/43598/5 "2025-03-12T15:24:18Z")
Hey @ayushanandd Were you able to confirm (visually/programmatically) that the dataset did successfully load into your Quick Sight account? I would also make sure that your Quick Sight account has the appropriate permissions to connect to Athena: > **[I can't connect to Amazon Athena - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/troubleshoot-connect-athena.html)** > > Troubleshoot issues with connecting to Amazon Athena when using Amazon QuickSight.