Athena Views support?

[chwonghk01]

First of all, thanks for the great plugin!

However it seems that currently the driver only support tables but not views in Athena. Is this known issue? Any plan to support Athena views?

[dacort]

Ah, good catch. Yes, would definitely like to support views.

get-tables will need to get updated to be able to identify those. I believe the table type comes back as VIRTUAL_VIEW.

[jamarzka]

It does but there is an issue with how the queries are built still. Currently all columns are formatted database.table.column and that doesn't work when using a view. It can't include the database.

[dacort]

@jamarzka Do you have an example of how you query views using the JDBC driver?

edit: Nevermind, I see what you mean.

SELECT database.table.column FROM database.table works fine
But SELECT database.table.column FROM database.view does not.

SELECT column FROM database.view does work.

[lukealexmiller]

Unless I misunderstand the previous comments, Athena views remain unsupported (I am unable to see any views in the database schema in Metabase). Is a PR expected for this any time soon? Would be great to be able to use Athena views. Thanks for the great work on the plugin!

[dacort]

@lukealexmiller Correct, views remain unsupported. I'm in the codebase this week, so I'll try to get a level of effort for what it would take to support views, but no work is currently planned to implement them. That may change depending on the investigation.

[vaibhav-acko]

@dacort - Does athena view support coming soon? We are also looking to query views from metabase.

[chrispruitt]

It looks like the views are working when writing custom queries, however they are not shown as a part of the DB schema. So we are unable to create any Field Filters from the view columns, among other features. Also higher level users are unable to choose a view as a data source for a simple question.

Any movement on this lately?

[dacort]

I unfortunately haven't been able to get around to adding support for them yet, sorry.

[dacort]

I think the right thing to do here is add VIRTUAL_VIEW into the list of table patterns in the get-tables function.

Note that I'm also planning on upgrading the Athena JDBC driver and, as part of that, there's a new option to map virtual views to views. But it should be easy enough to add support for virtual views. We still need a custom get-tables to deal with the fact that tables show up as EXTERNAL_TABLE.