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 Java SDK jar. For instructions on building the jar, refer here. You can also download the jar (rockset-java-$version.jar) from Maven.

#Introduction

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

#Configuration

1. Create an API Key using the Rockset Console under Manage > API Keys.

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

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

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

5. Enter apikey as User and your Rockset API key as the password.

6. 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: