Tableau data source with Athena custom query

Question

I'm getting the below error on Tableau Desktop when using the custom query, I'm successfully able to connect and see contents from the table when directly drag the table to query builder section on Tableau Desktop.

Datasource used: AWS Athena

Driver version: AthenaJDBC42_2.0.2

Tableau Desktop version: 10.4

com.tableausoftware.jdbc.TableauJDBCException: Error reading metadata for executed query: SELECT * FROM ( select * from tablename ) "TableauSQL" LIMIT 0 [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. Only one sql statement is allowed. Got: SELECT * FROM ( select * from tablename ;) "TableauSQL" LIMIT 0
There was a Java error.
Unable to connect to the server "Athena.us-east-1.amazonaws.com". Check that the server is running and that you have access privileges to the requested database.

score 3 · Answer 1 · answered Jun 22 '18 at 10:20

3

Try removing the ; from the subquery - That always throws errors for me

answered Jun 22 '18 at 10:20

SuperSecretAndNotSafeFromWork

1,211
1
16
31

You query confuses me, doing a select * from a select * is the same thing, right? You also have limit 0? Remove the limit 0 to have no limit on the results – SuperSecretAndNotSafeFromWork Jun 22 '18 at 12:48
My query is only `select * from tablename` I'm not sure how the outer select has come and that is creating the problem, I think. – DJo Jun 22 '18 at 13:08
What happens when you call out column names? – SuperSecretAndNotSafeFromWork Jun 22 '18 at 13:12
Its the same prblem – DJo Jun 25 '18 at 05:51
I think custom query with Athena is not working with Tableau – DJo Jun 25 '18 at 06:27

angie_s · Answer 2 · 2018-08-01T13:40:51.500

1

I was having the same issue. To provide some clarity to the above - the outer query is being added by Tableau. Here is my simple query and the error being returned by Tableau.

I was able to resolve by changing my query to refer to my table in the form "database"."table" and remove the closing ;

This custom query then worked for me:

edited Aug 01 '18 at 13:40

answered Aug 01 '18 at 13:06

angie_s

121
1
6

Tableau data source with Athena custom query

2 Answers2