Connecting Astra DB to DataGrip 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

  1. Download the DataStax JDBC Driver.

  2. 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.

  3. Download settings.zip.

    If you are already a DataGrip user, back up your existing settings because the download settings.zip might override your existing settings.

  4. Import the settings.zip into DataGrip by selecting FileManage IDE SettingsImport Settings in DataGrip.

  5. From the directory menu, select the settings.zip file from the directory where it is stored.

  6. Select Import and Restart.

    You will see a new database connection type called Astra: simba driver

  7. Go to the Advanced Settings to confirm the VM home path is set to Default. DriverThing

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>

url

  • AuthMech: Specifies whether the driver connects to a Cassandra or Astra DB database and whether the driver authenticates the connection.

  • ApplicationToken: Generated from Astra DB console. See Manage application tokens.

  • SecureConnectionBundlePath: Path to where your downloaded Secure Connect Bundle is located. See Get 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.