Skip to content

‣ Datagrip

Overview

DataGrip is a database management environment for developers. It is designed to query, create, and manage databases. Databases can work locally, on a server, or in the cloud. Supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and more. If you have a JDBC driver, add it to DataGrip, connect to your DBMS, and start working.

Prerequisites

Installation and Setup

Step 1: Download JDBC Driver

Download the JDBC driver from the DataStax website:

  1. Go to downloads.datastax.com/#odbc-jdbc-drivers.
  2. Select Simba JDBC Driver for Apache Cassandra.
  3. Select JDBC 4.2.
  4. Read the license terms and accept it (click the checkbox).
  5. Hit the blue Download button.
  6. Once the download completes, unzip the downloaded file.

Step 2: Download Settings.zip

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

Step 3: Import the settings.zip into DataGrip

  • Selecting FileManage IDE SettingsImport Settings in DataGrip.

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

  • Select Import and Restart.

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

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

Step 4: 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.
  • SecureConnectionBundlePath: Path to where your downloaded Secure Connect Bundle is located.
  • TunableConsistency: Specifies Cassandra replica or the number of Cassandra replicas that must process a query for the query to be considered successful.

Last update: 2022-10-27