DataGrip Overview, Part 5: Navigation and Search

Navigation and Search00:00

Every database object used in your SQL code is actually a link. Clicking on an object while holding down the command key will take you to the DDL editor. This works not only with tables, but with all objects including columns. If you do not prefer using the mouse, you can press command and B to achieve the same results. There is also the option to go to the database explorer, which selects a specific object in the database explorer. The shortcut for this action is alt, shift, and B. After that, there is the edit option, which can be accessed by pressing command and F6. This action opens a dialog window where you can edit the objects. Another useful navigation action is to go to Data, which you can invoke by pressing F4 to go to the Data Editor for tables and views, allowing you to monitor and edit the data. Finally, if you don't want to lose focus but still want to know more details about the objects in your SQL code, hover your mouse over the object. You will see DDL and other important information about the object. For tables and views, data preview is also available. The same window can be brought up by pressing F1.

Search Panel01:30

In DataGrip, there is a search panel with different tabs. Simply press Shift twice and the search will open with the All tab activated. We call this feature search everywhere. Tables, files, procedures, and code references are all here, each responsible for a specific type of search. Most of them have their own shortcuts for direct access.

Database Tab02:01

The shortcut is command and O. Here, you can search for all other major objects in the database such as tables, procedures, or views. In cases where there are many objects with similar names, identify the source of data that you want to search. The filter icon in the upper right corner helps you specify the types of objects that should be included in the search results. Clicking on a table will open it. If you wish to view the DDL or navigate to the Database Explorer from here, use the relevant shortcuts for these actions.

Files Tab02:30

In the Files tab, you are looking for files from the attached directories. For example, to search for CSV files in attached directories, type a CSV file here and see the results. Pressing Enter will open the file. If you want to highlight it in the Tools window, use the Select Open File button.

Code Tab03:00

The Code tab is accessed by pressing Alt, Command and O. Here, you can search for references in script files. For example, suppose you are looking for the phrase that creates the stored procedure film_not_in_stock. Write it here and specify the file location where it was created.

Actions Tab03:30

The Actions tab allows you to search for commands and actions that you want to run within the Integrated Development Environment (IDE). This is especially useful if you do not remember the user interface for these actions. You can invoke this action by pressing Shift, Command, and A. To reformat your code, just type reformat here.

Database Explorer Search03:30

There is also a quick way to locate database objects in Database Explorer. Just start writing. It is important to know that this only works if the node is already open. In fact, in DataGrip, all lists and tree structures can be filtered in this way. So, don't forget to try it in other places.

Full-Text Search04:01

Sometimes you need to search for specific data. While you can search within a single table from the client side, more complex searches can be performed using full-text search in the database. Right-click on a data source or chart, and from the context menu, go to Tools then Full-text search, and set the condition you need. After the search is performed, DataGrip displays the tables in which your data appears. For example, here, the results are in two tables. When clicking on the customers table, the exact rows that contain the matching data are visible.