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?
请先登录再写评论。
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).
any plans for excel import?
No particular plans yet, please follow the https://youtrack.jetbrains.com/issue/DBE-95 for updates.