AWS Athena Table Not Found during Custom SQL

plbal · April 16, 2024, 6:16pm

I am very confused.

I have a table in AWS Athena that is visible in the admin settings

moreover, I can make queries on it using the "normal" metabase question procedure. However, the custom SQL portion of metabase cant seem to connect?

moreover, i cannot even seem to view any tables

Any clue what is going on?

plbal · April 16, 2024, 7:07pm

for those reading this in the future

you have to specify the database and the table (the query tool will not have the database name pre-loaded)
it seems like the oracle syntax is used

so something like

select * from my-database-name . my-table

worked

TonyC · April 17, 2024, 11:10am

Also to give an extra hint ... if you do a normal question and then do "turn this question to SQL" you will see how metabase is running the query at SQL level

plbal · April 17, 2024, 3:33pm

is this an enterprise feature? i am not seeing this option anywhere

TonyC · April 17, 2024, 4:12pm

No it's in the question editor