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:

2. 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://

3. Click on the plus symbol (+) and choose the new Rockset driver:

4. Enter apikey as User and your Rockset api key as the password.

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

#Usage

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

Run SQL statements using the editor and view the results: