DataGrip 2023.1 Help

File management

In DataGrip, you can work with four file types:

  • Query or database consoles are SQL files that are attached to a particular data source. When you create a data source, a query console is created automatically. But you can add more consoles to a data source, each of them will then create a new connection. If you do not want to create new connections, enable single session mode. For more information about query consoles, see Working with query consoles.

  • Scratch files are similar to query consoles, but they are not attached to a data source. We refer to scratch files as temporary notes or drafts for code ideas. Usually, scratch files are outside of the project context. But you can associate an SQL scratch file with a data source and use it as an SQL editor. For more information about scratch files, see Scratch files.

  • User files are SQL scripts that you store on your computer or on a server. For more information about working with directories and user files, see User files.

  • Object editors are internal files where you edit the DDL of a procedure, a view, a function, or other objects.

Create an SQL file

  1. 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.

  2. In the New File dialog, specify the filename.

    Create an SQL file
Last modified: 21 April 2023