DataGrip column picker

Question

Is it possible to use a column picker in JetBrains DataGrip? I was not able to use this feature in DataGrip. For instance, sql complete contains this feature: sql complete column picker image.

Answer 1

Currently, there is no feature like this in DataGrip. I can offer you a couple of workflows:

— Use code completion, it is really fast. Once you have the table in your query (typing SEL → Tab activates Live Template for SELECT query), start typing column names in the list and completion will prompt you column names.

— Use wildcard and then expand it by Alt+Enter → Expand column list. Yo will get the whole column list, just remove unnecessary ones.

— If you need to have a result with some columns, not all of them, press Ctrl+F12 on the result-set. Then you'll get a popup where you can show/hide columns with Space. Notice, that text speed search works there as well. See Operations with columns in the structure view.

All of them are shown in the attached gif file.