User files
User files are the files that are stored on your machine or any other place you have access to. To work with them in DataGrip, attach the directory that contains them in the Files tool window .
You can view, edit, create, and delete the SQL files.
In the Files tool window ( View | Tool Windows | Files) , right-click the directory in which you want to create an SQL file and select New | SQL File.
In the New File dialog, specify the filename.
For a directory to appear in the Files tool window , attach it to your project.
To attach a directory, do one of the following:
In the main menu, select to File | Open.
In the Files tool window ( View | Tool Windows | Files) , right-click any area and select Attach Directory to Project.
In the Files tool window ( View | Tool Windows | Files) , click the Attach Directory to Project button (
) in the toolbar.
In the file browser, navigate to the directory that you want to attach.
Click Open.

In the Files tool window ( View | Tool Windows | Files) , right-click the directory that you want to detach and click Detach Directory from Project.
In the notification dialog, click Detach.
SQL files are run against the selected databases or schemas using run configurations. To run an SQL file, you can either create a new run configuration, or edit an existing one.
For more information about running an SQL files from your machine, refer to Run 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.
Click the dialect list, which is in the upper-right corner of the window.
Select a dialect from the dialect list.
Open settings by pressing CtrlAlt0S and navigate to Database | SQL Dialects.
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.
In the Files tool window ( View | Tool Windows | Files) , find and select the image file.
To preview an image in a popup instead of in a separate tab, select the image file in the Files tool window and press CtrlShift0I.
In the Files tool window ( View | Tool Windows | Files) , right-click the image file and select Jump to external editor.
Alternatively, press CtrlAltF4.
DataGrip opens the image in the editor that is used in your OS by default. You can configure another image editor in which the IDE will open files.
Right-click an image in the editor and select Edit Path to External Editor from the context menu.
You can also press CtrlShift0A and type
Edit Path to External Editor
.In the Path to External Editor dialog, specify the path to the application in which you want to open images and click Save.
Action | Description |
---|---|
Show Chessboard | Select this checkbox to have transparent pieces of images shown as a chessboard. |
Show Grid | Select this checkbox to have a grid displayed when reviewing image files. |
Zoom In | Click the zoom the image in. |
Zoom Out | Click the zoom the image out. |
Actual Size | Click to view the image in its actual size. |
Fit Zoom To Window | Click to make large images fit the window size. |
Show Color Picker | Open the Color Picker dialog. |
Thanks for your feedback!