search

aws / aws-toolkit-jetbrains

AWS Toolkit for JetBrains - a plugin for interacting with AWS from JetBrains IDEs
https://plugins.jetbrains.com/plugin/11349-aws-toolkit
Apache License 2.0
730 stars 198 forks source link

Athena easy authentication (database) #2427

Open jco-08 opened 3 years ago

jco-08 commented 3 years ago

Hi,

My organisation has recently moved to an SSO approach, which has changed how we access Athena data in PyCharm. The plugin having SSO support has been a life saver in terms of reading data in (massive thanks for that), however this doesn't seem to apply to databases, i.e. when I 'query the console' I'm still required to update my credentials file manually.

Maybe there is already and I just don't have it set up correctly, but if there was some way to have the database link to SSO using the plugin then this would be great.

I currently have a profile in my config file that has the SSO details, which is used by the plugin, and then I also have a separate profile in my credentials file that I update when the temp credentials expire. When I've tried setting the database to use the SSO profile it doesn't work.

hunterwerlla commented 3 years ago

Hello, we support this scenario for SQL databases that support it (PostgreSQL/MySQL/the Aurora versions of those) as well as Redshift, but we haven't thought about supporting it for Athena.

How are you using Athena? Through the database browser?

jco-08 commented 3 years ago

Thanks for the response. Yes, I'm querying Athena in PyCharm. It sounds like the support you have for other databases is exactly what I need. Is it possible that this can be done for Athena?

abrooksv commented 3 years ago

Each database support has to be coded for each implementation.

I'm not aware of PyCharm supporting Athena, how are you setting it up?

jco-08 commented 3 years ago

Ahh, therein probably lies the issue. I think we had to set up the Athena driver ourselves rather than it already being an option in PyCharm.