Tools and features for importing data

One of the biggest features I look for in a Database IDE is does the IDE make it easier to import data into a database. Currently I am not aware of how to do that in Datagrip. Even a feature that reads headers in a csv and suggests data type would be very helpful. I regularly import files with 50+ columns and an IDE that can quickly read all the headers and help me craft import statements is a real timesaver.

Am I missing something in Datagrip or is this a feature I need to request?

3 comments
Comment actions Permalink

Hello Nathan,
With DataGrip you can open a file, say of a csv type, select to edit it as a Table from it's context menu, configure table csv format if necessary, then Right-click in created table and select Dump Data to File action, where to configure extractor type (sql insert/update statements).

0
Comment actions Permalink

any plans for excel import?

1
Comment actions Permalink

No particular plans yet, please follow the https://youtrack.jetbrains.com/issue/DBE-95 for updates.

0

Please sign in to leave a comment.