Hi all, I am unable to use Custom SQL in Quick Sight to add SQL-Query from hubble with QS.
Hi @praleadr
Validate your SQL and data in Athena first, review permissions, check for schema changes, and optimize your queries for speed.
Please refer to the below documentations this might be helpful for you.
Hi, I’m currently using Hubble for SQL and want to use the same query in Quick Sight so that I can schedule it to run automatically. However, I’m facing issues while setting this up. Timeout isn’t the problem since I’m trying it for the first time. please help
Hi @praleadr - Can you please execute the SQL in Athena to ensure the SQL is working fine or not, all I can say the issue is with SQL syntax not with Athena. A quick view on the SQL the column asin, can you put in double quotes.
Regards - Sanjeeb
Hi, @Sanjeeb2022 thanks for reply.
Yeah, you were right, there is permission issue to execute query in Athena, but I tried everything and do not know how I can get permission. When I am trying with “Diagnose with Amazon Q” there is also permission issue. could you please help me
Hi @praleadr
Please refer to the below documentation this might be helpful for you.
Hi @Sanjeeb2022 thanks for the help. I am now able to execute quary in athena but in quicksight I still do not able to get.
getting this error, however i have created policy and have workgroup in athena as well.
Hi @praleadr
Please refer to the documentation on authorizing connections to Athena.
Hi @praleadr
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @praleadr
Since we have not heard back from you, I’ll go ahead and close/archive 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!