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.

    Create New API Key

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

    Datagrip select driver

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

    DataGrip configure Rockset

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

    Datagrip select Rockset

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

    DataGrip connect Rockset

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

    Datagrip synchronize

    #Usage

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

    Datagrip navigate collections

    Run SQL statements using the editor and view the results:

    DataGrip query Rockset

    Join us on Slack!
    Building on Rockset? Come chat with us!