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
- 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:
- In DataGrip, select File > Data Sources. Click on the plus symbol (+) and then select Driver:
- 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 thedefault
in URL templates.
- In DataGrip, click on the plus symbol (+), and select the new
Rockset
driver:
- Enter
apikey
in the User field and your Rockset API key in the Password field:
- 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: