#### Query and analyze your data with our favorite commercial database tool from Jetbrains. Connects using a standard JDBC driver for Presto, which is a free download.

#### ~15 minute installation


NOTE: We assume that you already have <a href="https://www.jetbrains.com/datagrip/" target="_blank">DataGrip</a> installed on your system.

<h2>1 Download JDBC Driver</h2>

DataGrip currently does not include Presto support by default, but the Presto JDBC driver is a free download.


<a href="https://prestodb.github.io/docs/current/installation/jdbc.html" target="_blank" class="btn btn-primary my-3">Download</a>


<h2>2 Install JDBC Driver</h2>

Copy the jar file you just downloaded into your DataGrip installation. The location of this directory varies by OS.

<pre class="p-3"><code>on Mac:      $HOME/Library/Preferences/DataGrip2019.2/jdbc-drivers
on Linux:    $HOME/.DataGrip2019.2/config/jdbc-drivers
on Windows:  C:\Users\%USER%\.DataGrip2019.2\config\jdbc-drivers</code></pre>


<h2>3 Create DataGrip Driver</h2>

From the DataGrip UI, create a new driver referencing the Presto JDBC jar file.

![datagrip1.jpg](https://res.cloudinary.com/dgk9bfuhq/image/upload/v1602134943/datagrip1_95dab38b5f.jpg)


<h2>4 Create Datasource</h2>

Now create a datasource using the Presto driver you just created. On the "General" tab, enter the connection information for your Resurface database. Click the "Test Connection" button and you should see successful results.

![datagrip2.jpg](https://res.cloudinary.com/dgk9bfuhq/image/upload/v1602135110/datagrip2_71c130635b.jpg)


Now switch to the "Schemas" tab, open the "resurface" database, and select the "public/http" schema.


![datagrip3.jpg](https://res.cloudinary.com/dgk9bfuhq/image/upload/v1602135138/datagrip3_c65592b907.jpg)


Now switch to the "Advanced" tab, and configure the driver to require SSL.


![datagrip3b.jpg](https://res.cloudinary.com/dgk9bfuhq/image/upload/v1602135179/datagrip3b_1aabc35207.jpg)


<h2>5 Run SQL Queries</h2>

You can now explore tables & columns in the "public/http" schema, and open a console to run SQL queries against your Resurface database.

![datagrip4.jpg](https://res.cloudinary.com/dgk9bfuhq/image/upload/v1602135237/datagrip4_d7943db9cb.jpg)


<a href="/sql"  class="btn btn-primary my-3">SQL Reference</a>


DataGrip

Deep visibility into your APIs

Products

Docs

About

Legal