Jetbrains DataGrip

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

The steps below require that you 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: