Now click Test and you should get Success.

S3OutputLocation is available in the AWS Console for Athena by clicking Settings. The region should be the same as you used above. Download P圜harm: Python IDE for Professional Developers by JetBrains Version: 2023.1.1 Build: 231.8770. Now click Advanced and set the two required keys, AwsRegion and S3OutputLocation.

Set the URL to jdbc:awsathena://:443/ with your region string in there. If you’re developing applications using IntelliJ, P圜harm, DataGrip, or other JetBrains tools, this post showed you how to run database queries without leaving your IDE and connecting to the Amazon Keyspaces console.

Enter the access key and secret in the User and Password fields respectively. In this post, I provided step-by-step instructions to connect to Amazon Keyspaces from your local machine. Okay so you now have the JDBC driver installed, so you need to create a connection to your Athena instance.įile > Data Sources to open the Data Sources panel and click + > AWS Athena to create a new connection using the driver. DataSpell fully supports both static and JavaScript-based outputs used by scientific libraries, such as Plotly, Bokeh, Altair, ipywidgets, and others. This new experimental UI in Jetbrains products is available to all products from Jetbrains, like Intellij IDEA, Goland, PHPStorm, WebStorm, P圜harm, Datagrip. Now back up above that select the driver Class .Driver. Here’s the confusing bit: skip down to Additional Files and click + and find the location of your driver. On Linux this was ~/.DataGrip2018.1/config/jdbc-drivers/.įile > Data Sources to open the Data Sources panel and click ‘+ > Driver’. Download the JDBC driver from AWS and place it in the DataGrip JDBC driver directory.

Download datagrip pycharm