Can QuickSight access the views from Athena?

Question & Answer
,
1

Hi all,

I am trying to create the dataset in QS from Athena views, but seems like it cannot access it → it shows the drop down with all of the tables & views, but views do not have any data in them:

image
image610×570 5.89 KB

I can see the view with the retrieved content in Athena, however, nothing is shown in QS

Do you have any ideas why it’s the case?

2

Hi @AndriyShepel,

Thanks for your question, and yes you can access views in Athena from QuickSight in this way.

In Athena I created a simple view from a table that I have access to using:

CREATE OR REPLACE VIEW "mytestschema".v_myview AS
SELECT
    myid as myviewid
FROM "mytestschema"."mytable";

I can then build datasources against this view. Are you able to create a simple test as above and perhaps we can help troubleshoot.

One question, are you able to connect to and successfully query Athena tables (including those referenced in your view) from QuickSight?

Many Thanks,
Andrew

3

Hi Andrew

Thanks for your reply
Unfortunately, i cannot share the access with the environment i am looking at.

I am pretty sure it will work if i create a test example :slight_smile:

What i got now in the live environment:

  • I can see the tables from Athena and i can view them
  • I can see the views from Athena, but the viewing them fails (showed in the previous screenshot)
  • I can use the custom SQL queries in QS to Athena - this works

I feel like there’s something incomplete concerning my user role or right to be able accessing views in Athena

4

Hey @AndriyShepel

I usually use virtual views coming from Athena, and I never had an issue with them while reading from QS.

Could be that you have an issue with the permissions. Are you using the Quicksight managed role or an existing role in your account?
Did you include in the one that you are using the rights to read the content of the datacatalog?

Regards

1 Like
5

Yes, there was an issue with the QS access to Athena views :slight_smile:
Fixed!

Many many thanks

1 Like