Using a view created in athena as source for dataset

Question & Answer
1

Hi guys. I’m doing my first steps in AWS & Quicksight. I tried several things but still failing. So I hope some experts can help:

My SQL statement (Create view…) in Athena gives a proper result as expected. Using this view as the source for my quwicksught dataset fails: SQL exception…
I tested creating a table instead of a view: Works in Athena and can be used as source for my dataset in Quicksight.

How to make the view work as basis for my dataset in Quicksight?

Thank you very much for any hint!
Regards
Markus

2

what is failing?

Can you select your view from the athena datasource?

image
image615×511 25 KB

1 Like
3

Hi @MWZorro - Can you please give the screenshot as suggested by Max. It will be easy to understand the issue.

Athena supported the view and a details for an use case can be found from the blog -Analyze and visualize nested JSON data with Amazon Athena and Amazon QuickSight | AWS Big Data Blog

Regards - San

4

Hello @Max @Sanjeeb2022 , Thank you for your reply!
Yes I can select in the dialog you’re showing.
Klicking “EDIT/Preiview date” opens the quicksight screen and I can see the “attributes” lefthandside. In parallel dataset starts loading. After roughly 45 secondes I get a message: “Your database caused a SQL exception…, potentially caused by timeouts, resource restrictions, enexpected DDL-Changes…” (To be honest i do not trust those mentioned potential causes as a identical table performs rightaway.)
Thank you in advance!

Regards
Markus

1 Like
5

Ho @MWZorro - Thanks. Can you please raise a ticket to AWS team so that they can see your issue in screen share and fix it. To raise a ticket, please follow the link ( Creating support cases and case management - AWS Support).

If you do not have access to raise a ticket, please request your AWS admin team to raise a request on your behalf.

Regards - San

6