Connecting to AWS Athena in Datagrip

Are you having trouble connecting to AWS Athena in Datagrip? You're not alone! This issue is primarily caused by incorrect AWS CLI profile setup that Datagrip cannot find the expected IAM role profile. In this article, we will walk through the steps to resolve this issue and connect to AWS Athena successfully.

Step 0: Configure Everything Correctly

To begin with, make sure you have configured everything correctly in your AWS account. This includes setting up the correct IAM role profile for Datagrip to use.

Error During Configuration

If you encounter an error during configuration, it may be due to a wrong AWS CLI profile setup. In this case, Datagrip cannot find the expected IAM role profile, resulting in the error.

AWS Lake Formation and Athena Queries

AWS Lake Formation allows you to define and enforce database, table, and column-level access policies when using Athena queries to read data stored in Amazon S3. To do this, choose the Assign option for your user, and then choose Done.

Presto/AWS Athena and Datagrip Version Issue

The issue I'm seeing seems to be specific to Presto/AWS Athena and Datagrip 2017.2. Interestingly, older versions of Datagrip, such as 2017.1.4, work just fine. This suggests that the issue is related to a version-specific problem.

Assuming the Role with SAML Identity Provider

When assuming the role with a SAML Identity provider like Active Directory Federation Services (AD FS) 3, the process for retrieving temporary credentials depends on how you assume the role. To do this, follow these steps:

* Retrieve the roles' temporary credentials.

* Use IAM role credentials to connect to the Athena JDBC driver.

Configuring Connection in Datagrip

Once we have installed Datagrip locally, we can start to configure the connection. Here are the steps to follow:

* In the navigation pane, choose Applications, and then choose the name of your application (for example, Athena-ODBC-Okta).

* Choose Assign, and then choose Assign to People.

In this article, we have walked through the steps to resolve the issue of connecting to AWS Athena in Datagrip. By configuring everything correctly and using the correct IAM role profile, you should be able to connect to AWS Athena successfully. Remember to check your Datagrip version and ensure that it is not a version-specific problem. Happy querying!

Datagrip aws athena