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

  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

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

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

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

  6. Select Import and Restart.

    You will see a new database connection type called Astra: Simba Cassandra JDBC 4.2 driver shown.

  7. Go to the Advanced Settings to confirm the VM home path is set to Default. VM home path is set to a value named 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>

URL in the screenshot shows the format described in the previous sentence.

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