User files

Last modified: 21 June 2023

User files are the files that are stored on your machine or any other place you have access to. In DataGrip, they are available to work with in the Files tool window.

Managing directories

For a directory to appear in the Files tool window (View | Tool Windows | Files), attach it to your project.

Attach a directory with SQL files

  1. 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 (Attach Directory to Project) in the toolbar.

  2. In the file browser, navigate to the directory that you want to attach.

  3. Click Open.

Attach a directory with SQL files

Detach a directory with SQL files

  1. In the Files tool window (View | Tool Windows | Files), right-click the directory that you want to detach and click Detach Directory from Project.

  2. In the notification dialog, click Detach.

    Detach a directory with SQL files

Run SQL files

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 information about how to run an SQL files from your machine, see Run files.

Configure 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

  1. Click the dialect list, which is in the upper-right corner of the window.

  2. Select a dialect from the dialect list.

    Specify an SQL dialect

Specify a dialect for multiple SQL files

  1. Open settings by pressing and navigate to Database | SQL Dialects.

  2. Click the Add button the Add button and select directories or files for which you want to change a dialect.

  3. Click Open.

  4. Click the SQL Dialect cell and select the necessary dialect.

  5. Apply changes and click OK.

    Specify an SQL dialect