SQL Clients > Jetbrains DataGrip

Jetbrains DataGrip

This page describes how to set up DataGrip and configure it for use with Rockset.

The steps below require that you have a Rockset account and have the Rockset JDBC driver jar. For instructions on building the Rockset JDBC jar, refer here.

Introduction

DataGrip is a multi-engine database environment which provides efficient schema navigation and query execution.

Configuration

  1. In DataGrip, click on File > Data Sources. Click on the plus symbol (+) and then select Driver:
Datagrip select driver
  1. Change the driver name to Rockset and configure the driver as follows:
  • Under driver files, add the Rockset JDBC driver jar.
  • Once the driver file is selected, choose com.rockset.jdbc.RocksetDriver as the class name.
  • Add default URL template as jdbc:rockset://

DataGrip configure Rockset

  1. Click on the plus symbol (+) and choose the new Rockset driver:
Datagrip select Rockset
  1. Enter apikey as User and your Rockset api key as the password.

DataGrip connect Rockset

  1. Right click on the DB connection and choose Synchronize to load all data for autocomplete.
Datagrip synchronize

Usage

Explore the schema of all Rockset collections present in your workspace:

Datagrip navigate collections

Run SQL statements using the editor and view the results:

DataGrip query Rockset