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
- Create an API Key using the Rockset Console under Manage > API Keys.
- In DataGrip, click on File > Data Sources. Click on the plus symbol (+) and then select Driver:
- 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 asjdbc:rockset://
- Click on the plus symbol (+) and choose the new
Rockset
driver:
- Enter
apikey
as User and your Rockset API key as the password.
- 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:
Join us on Slack!
Building on Rockset? Come chat with us!