DataGrip Overview, Part 6: Data Editor
In a Nutshell
DataGrip's Data Editor provides direct table access without writing queries, supporting both client-side and server-side sorting/filtering with manual WHERE clause editing. Users can edit data inline like Excel, with multi-cell operations, CSV paste support, and local change tracking before database submission. Advanced features include foreign key navigation via Cmd+↓, heat map visualization, geographic data mapping, row grouping, and result set comparison with tolerance settings.
These notes were generated by AI and may contain inaccuracies.
When you double-click on a table in the Database Explorer, the Data Editor opens, eliminating the need to create and run a simple selection query. You can click on the arrow icons located at the top of the column to sort the data. If you click while holding down the Alt key, the sorting will be cumulative. By default, the sorting process is client-side, meaning that no new query is run, and DataGrip sorts the data locally, but only on the current page, of course.
If you want server-side sorting, which includes the data within the entire table, activate it in the options under the gear icon. In this case, each time you sort, the order by phrase will be updated. You can also see this reflected in the text field, which you can edit manually.
There are several ways to filter data. The first method is called local filtering. Invoke it by clicking on the funnel icon. Here, you can see all the loaded values and select the values you need. The icon in the toolbar allows you to enable and disable local filtering. As the name of this feature suggests, it is a local operation, meaning that no new query is run, and DataGrip filters the data locally, but only on the current page, of course.
Server-side filtering is also available, and like server-side sorting, it creates a new query with the updated statement. To use server-side filtering, update the where text field located above the data in your preferred way.
Sometimes, the most effective way to filter data is to use the text search feature. Press Command and F and search for the required data. The coolest part about text search is that it searches the entire network, so you don't need to remember or specify which column to search for data in. Don't forget that the filter rows checkbox makes only the filtered rows visible.
You can edit the data here directly. Just double-click on a cell and enter a new value. If the value is long, the value completion feature can help you. This list is filled with other values from this column. You can also edit multiple cells at once by selecting several rows and starting to type. You can even copy the data you need and then paste it anywhere in the editor. This actually works with CSV files located in the clipboard. So, for example, if you have an external CSV file, you can copy and paste it into the data editor. DataGrip attempts to automatically understand your clipboard format. But if you want to specify the CSV or TSV file format in your clipboard, you can do so using the options under the gear icon.
It is also possible to add and delete rows directly from here. In general, you have a small Excel-like application to edit your data. As you can see, all the changes you made are highlighted. This means it is local and not yet in your database. Any of your changes can be undone. You can review the statements that were created based on your changes and press submit if you want them to appear in the database. There is also a send button on the toolbar, which will do the same thing but without a preview. Something designed for very confident users.
In DataGrip, there is a chart builder that helps you visualize the data. To open the chart, click on the corresponding icon in the toolbar. In the settings, you can specify the type of chart you want to see, as well as what to visualize and how to do it.
Another feature that helps you analyze data visually is called table color assignment. Heat maps will be displayed for the values found in the table. It operates with two color system options: contrasting and sequential. A sequential color scheme consists of a single color or a group of closely related colors that differ in intensity. The contrasting color scheme emphasizes the difference relative to a specific standard. It consists of two contrasting colors that deviate from a central value in opposite directions. You can apply heat map color schemes to the entire table or to each column independently.
Do you need to examine one row in detail? Click on View History in the toolbar. A side panel opens containing all values from a single row, arranged vertically or in two columns. You can switch layouts from the panel settings menu. The values are editable and the changes are synchronized back with the network just as you would with any other edit.
The Values Editor tab displays the value of a single cell in a separate editor. If you want to open it directly from the cell value, use the shortcut shift and enter. This editor supports multi-line editing, automatic wrap-around switching, highlighting, and formatting of JSON and XML values. Images stored in blob or text format have a preview here.
In the Groupings tab, you can view the total values for multiple cells. To open this, you can also select the cells, right-click on the selection, and choose Group View. The development environment opens a list of aggregated values on the right side of the main window. Use the built-in grouping scripts or create your own. Creating your own personal grouping is extremely useful if you find yourself using specific grouping logic within your SQL queries.
You can easily navigate through the relevant data if your database contains defined foreign key relationships. For example, I have an actor named Nick Wahlberg, and his ID is two. When I click on the relevant rows button in the floating toolbar, DataGrip takes me to the film_actor table with the corresponding filter applied. In other words, this displays all the movie IDs associated with this particular actor. If I wanted to know more about one of those movies, say the movie with ID 105, I could navigate further to see its details. You can also go in the opposite direction. Instead of using the button on the toolbar, I can press Command and a down arrow on the movie ID to open a list of all related tables. Selecting the film_actor table displays all the actors who appeared in the film. Now, if I want to know more about an actor, say the actor with ID 43, I can press Command and a down arrow, and DataGrip will go to the actors table and highlight the corresponding row. It turns out that the actor in question is Kurt Jovovich, and now I know that he was once on a film set with Nick Wahlberg.
With two sets of results open, click on "Compare" to open the differences viewer for those sets of data. This can be done with two open grids, tables, result sets, or CSV files. The tolerance factor determines the maximum number of differences allowed between two sets of results. For example, if you want to consider two rows as equal even if they differ in one column, enter the number one in the tolerance field. This works perfectly when you want, for example, to compare data, but the date of last modification may differ.
You can work with a dataset structure if the set is too large to be displayed all at once. Press Command and F12 and you will see a list of columns. If you want to search for specific columns, just start typing. You can also hide and show columns for this type of dataset. Use the spacebar to do this. Don't worry, you always have the option to reset the display.
Another way to deal with very wide networks is to use the transpose feature. Recall it from the list by clicking on the letter I icon.
DataGrip includes a geographic data viewer, also known as a geoviewer, which plots geometry columns on an interactive map within the development environment. This works with WKT, WKB and PostGIS 4326 data from PostgreSQL tables, as well as CSV or XLSX files. Open any results set that contains a spatial column, and click on geo viewer. Rows and pins are crossed out, and you can even drag the tab out of the Services window.
Keep JetBrains in your library
Save the videos and channels worth coming back to, and find them again in one place.
