Request for new database: AWS Athena / Presto / Trino

[tomsej]

Hi, thanks for this. It is really awesome extension. Can you please add AWS Athena. Thanks a lot!

[mikeburgh]

I will add it to the list, looks to be based on Presto.

[mikeburgh]

Add Trino as well

[mikeburgh]

And Starburst Enterprise.

[el-analista]

+1 to have presto/trino/hive

[mikeburgh]

I just released Trino in preview mode in version 1.13.0.

Still missing

• Complex datatypes probably wont display properly
• Binary data type handling
• Oauth support
• Date time localization

I am now starting to figure out what's actually compatible and not with the various forks implementations (Presto/Athena/Starburst etc).

It looks like Presto and starburst might be.. But Athena and Hive might need a separate implementation. If anyone can test these out and let me know that would be appreciated.

[BakPakMark]

@mikeburgh my connection to Starburst Enterprise (On-Prem) seems to be working as expected so far. I will continue using this extension for daily work and comparing results to their online IDE and will share issues here if I run into any. Thanks so much for your work on this!

[tomsej]

Thank you @mikeburgh. I was trying to use it for Athena, but Athena connects via AWS stuff (region, IAM credentials, workgroup and S3 result bucket), not a direct host like Trino does. So yeah, separate connector would be better since I do not think there is any host in Athena.