Skip to content
This repository has been archived by the owner on Oct 17, 2022. It is now read-only.

Using Datagrip With Astra

Jump to bottom
Cedrick Lunven edited this page Feb 18, 2022 · 5 revisions

🏠 Back to home | Last Update 2/17/2022

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

B - Prerequisites

Datagrip reference documentation

C - Installation and Setup

✅ Step 1: Download JDBC Driver

Download the JDBC driver from the DataStax website:

  1. Go to https://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 the download settings.zip might override your existing settings.

✅ Step 3: Import the settings.zip into DataGrip

  • Selecting File → Manage IDE Settings → Import 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.

🏠 Home | AstraDB Docs | DataStaxDevs | Community

Awesome Astra

Clone this wiki locally