Datagrip athena how to#
I get this same error, with my username, even if I put in the role as a User in the Datagrip dialog box. Datagrip is a great database IDE, just like the other IDEs from Jetbrains: Pycharm, IntelliJ, In this blog, I describe how to connect an AWS Athena. We provide a beautiful, modern SQL editor. PopSQL is the evolution of legacy SQL editors like DataGrip, DBeaver, Postico. Add the following details: Region: This is the AWS region that you are connecting to. InfluxDB in 2022 by cost, reviews, features, integrations, deployment, target market, support options, trial offers, training options, years in business, region, and more using the chart below. Select Athena from the available options and click 'Next'. Click on the 'New Database Connection' button in the top-left corner. User: arn:aws:iam:::user/ is not authorized to perform: athena:ListDataCatalogs Ĭom.: User: arn:aws:iam:::user/ is not authorized to perform: athena:ListDataCatalogs (Service: AmazonAthena Status Code: 400 Error Code: AccessDeniedException Request ID: Proxy: null Download, install, and open the most recent version of DBeaver here. The specified database user/password combination is rejected: AthenaJDBC An error has been thrown from the AWS Athena client. However, I can't figure out what to put under User. AWS profile - I figured out what to put into "Profile" - it's the source_profile in my role's profile in my ~/.aws/config. Infrastructure Setting up AWS Athena datasource in JetBrains DataGrip Download the JDBC driver from AWS and place it in the DataGrip JDBC driver directory.User/pass - I can put in my AWS key ID and secret, but I think it would fail without the MFA token as well (there is no field for it in Datagrip 2021.1).
![datagrip athena datagrip athena](https://i.ytimg.com/vi/NoufVGsoj10/maxresdefault.jpg)
However there are two options for authenticating: Now I want to configure Datagrip for this as well. This requires me to assume a role first (I use awsume). I am able to make Athena queries through the AWS CLI.