Run a query
After you connected to a database, you can run a query. To run a query, use a database console. The database console is an SQL file where you can compose and execute SQL statements. When you create a data source, a database console is created automatically. For more information about database consoles, see Database consoles.
Open a console
In the Files tool window ( ), navigate to , double-click a console file.
In the Database tool window, click the Jump to console icon () and select a console.
Click a data source, press F4, and select the console that you need.
Execute an SQL statement
Place the cursor within the statement.
Right-click the statement and select Execute (Ctrl+Enter). Alternatively, click the Execute icon on the toolbar.
If you have several statements, select whether you want to execute all statements or a single statement. The suggestion list always contains an item for running all the statements.
Attach a directory with SQL files
In the Files tool window, right-click any area and select Attach directory.
Navigate to the directory that you want to attach.
Run existing SQL files
Double click an SQL file to open it in DataGrip.
From the <console> drop-down list, select a console file that you want to use.
Click the Run icon (Shift+F10).
Select statements that you want to execute and press Enter.