DataGrip 2017.3 EAP 3

Maksim Sobolevskiy

Hi there! In this post, I’ll tell you all about what our team has been up to and what the latest EAP build has in store for DataGrip 2017.3.

SQL generator

Press Ctrl/Cmd+Alt+G or choose Context menu → SQL Scripts → SQL Generator… and get the generated DDL of any object (table, schema, procedure, whatever) or even several objects simultaneously.

SQL-Generator

Paste multiple rows from an external source

We were asked to implement pasting from Excel tables. Generally to do this, it means that we need the ability to paste data in DSV format. In DataGrip you can define any format or you can let the IDE detect the format automatically.

PasteDetect

That’s how it works now.

PasteTSV

SSH tunneling

SSH

From this build DataGrip supports:

— Reading OpenSSH config files (`~/.ssh/config` и `/etc/ssh/ssh_config`).
— Showing dialogue for One Time Password.
— Using Ssh-agent and Pageant in authentification.

P.S. And for those who use DataGrip with Exasol, we added Exasol 5 support!

That’s all for today. Take DataGrip 2017.3 EAP for a spin!

Your DataGrip Team

 

Comments below can no longer be edited.

9 Responses to DataGrip 2017.3 EAP 3

  1. John says:

    November 2, 2017

    The Toolbox update of existing EAP3 doesn’t seem to be working correctly. It starts to look for the d/l then stops. I can send log, etc. privately if requested.
    –J

  2. Alex Kunin says:

    November 3, 2017

    In “SSH tunneling”, when .ssh/config has references to user home directory with both tilde and username (e.g. “IdentityFile ~username/.ssh/key”), tilde is expanded to current user name, not referred user’s name (e.g. “/Users/currentuserusername/.ssh/key”).

    So, it seems SSH does correct tilde expansion (like here: https://www.gnu.org/software/bash/manual/html_node/Tilde-Expansion.html) when it reads config file) — both “~” and “~username” forms are parsed correctly. And DataGrip understands only “~” form.

  3. Jesse Engelberg says:

    November 10, 2017

    EAP 3 has caused my scratches to disappear! The files are still in the Preferences folder, but the Scratches and Consoles window is empty and there’s nowhere I can find to add it in. Is there a preference setting I’m missing?

    • Maksim Sobolevskiy says:

      November 10, 2017

      They are INSIDE Files now.

  4. ZhangHao says:

    November 12, 2017

    Hope add select some rows and paste data from an external source.

    • Maksim Sobolevskiy says:

      November 13, 2017

      Hi! Isn’ it a feature already introduced in this build?