Connect DataGrip with Astra DB using Simba JDBC Driver
You can connect your DataStax Astra DB to Datagrip using the Simba JDBC Driver for Apache Cassandra®. Follow these steps to set up the connection so you can run queries.
Import IDE Settings
-
Download the DataStax JDBC Driver.
-
Unzip the driver download.
By default, your file will be stored in your downloads directory. If you want to store your JDBC jar elsewhere, change the path under driver files to match the new file path.
-
Download settings.zip.
If you are already a DataGrip user, back up your existing settings because the download
settings.zipmight override your existing settings. -
Import the
settings.zipinto DataGrip by selecting File → Manage IDE Settings → Import Settings in DataGrip. -
From the directory menu, select the
settings.zipfile from the directory where it is stored. -
Select Import and Restart.
You will see a new database connection type called Astra:
-
Go to the Advanced Settings to confirm the VM home path is set to
Default.
Establish the connection
When you create your connection, the URL will look like this:
jdbc:cassandra://;AuthMech=<2>;UID=token;PWD=<ApplicationToken>;SecureConnectionBundlePath=<PATH TO YOUR SECURE CONNECT BUNDLE>;TunableConsistency=<6>
-
AuthMech: Specifies whether the driver connects to a Cassandra or Astra DB database and whether the driver authenticates the connection.
-
ApplicationToken: Generated from Astra Portal. See Manage application tokens.
-
SecureConnectionBundlePath: Path to where your downloaded Secure Connect Bundle is located. See Downloading secure connect bundle.
-
TunableConsistency: Specifies Cassandra replica or the number of Cassandra replicas that must process a query for the query to be considered successful.
What’s next?
Now that your connection is working, you can create tables, introspect your keyspaces, view your data in the DataGrip table explorer, and more.
To learn more about DataGrip, see Quick start with DataGrip.