User files
To work with files from your machine or any other place you have access to, attach the directory you need to the Files tool window.
Managing directories
Attach a directory with SQL files
Click .
In the Files tool window, right-click any area and select Attach directory.
Navigate to the directory that you want to attach.
Click OK.
Detach a directory with SQL files
In the Files tool window (), right-click a directory and select Detach Directory.
In the notification dialog, click Detach.
Running SQL files
Run an SQL file
Right-click a data source.
Select Run SQL Script.
In the Select Path window, navigate to the SQL file that you want to apply.
Run an SQL file for several data sources
Select the necessary SQL file in the Files tool window.
Right-click the SQL file, select Run <file_name> (or press Ctrl+Shift+F10).
-
In the Execution target window, select the necessary data sources.
Run individual statements
Open an SQL file in DataGrip.
Click the statement that you want to execute. If you want to execute more than one statement, select (highlight) the necessary statements.
Press Ctrl+Enter or select Execute from the context menu.
Select the database console where you want to execute the statement.
Configuring a dialect for SQL files
For better coding assistance, assign an SQL dialect to an SQL file. An SQL dialect is a DBMS-specific version of SQL.
DataGrip lets you specify the SQL dialect for an individual file or all SQL and DDL files that can be stored in a directory, in your project, or on your computer.
Specify a dialect for a single SQL file
Click the dialect list, which is in the upper-right corner of the window.
-
Select a dialect from the dialect list.
Specify a dialect for multiple SQL files
Click the dialect list, which is in the upper-right corner of the window.
Select SQL Dialects.
In the SQL Dialects dialog, click the Add button
and select directories or files for which you want to change a dialect. Click Open.
Click the SQL Dialect cell and select the necessary dialect.
-
Apply changes and click OK.
