Jetbrains Datagrip

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

The steps below require the Rockset Java SDK JAR file. Instructions for how to build the JAR file are in the Rockset Java client documentation. You can also download the JAR file from Maven.

Introduction

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

Configuration

1. Create an API Key using the Rockset Console. You can find instructions for how to create an API key under Manage > API Keys in the menu on the left side of the screen:

2. In DataGrip, select File > Data Sources. Click on the plus symbol (+) and then select Driver:

3. Change the driver name to Rockset in the Name field and then configure the driver:

• In Settings > Driver files, add the Rockset JDBC driver JAR.
• After selecting the driver file, enter com.rockset.jdbc.RocksetDriver in the Class field.
• Use jdbc:rockset:// as the default in URL templates.

4. In DataGrip, click on the plus symbol (+), and select the new Rockset driver:

5. Enter apikey in the User field and your Rockset API key in the Password field:

6. Right-click on the DB connection and select Synchronize to load data:

Usage

You can view the schema of all the Rockset collections in your workspace:

You can run SQL statements and view the results using the editor: