Scratch files
Sometimes you may need to create temporary notes or draft up some code outside the project context. Instead of switching to a different application, you can use scratch files and scratch buffers.
Scratch files are fully functional , runnable, and debuggable files that support syntax highlighting, code completion, and all other features for the corresponding file type. For example, while working on one database, you may come up with an idea for a method that you could later use in another database. You can create a scratch file with a draft of the method, which is not stored in your database directory but can be opened when you're working on any other database. You can use scratch files to draft code constructs, HTTP requests, JSON documents, and so on.
Scratch buffers are simple text files without any coding assistance features. Scratch buffers can be used for simple task lists and notes to yourself. They are also not stored in the database directory and can be opened from any other database. You can create up to five scratch buffers with default names, which are rotated and reused by clearing the content.
Create a scratch file
From the main menu, select or press Ctrl+Alt+Shift+Insert.
Select the language of the scratch file. Scratch files of the same type are automatically numbered and added to the Scratches and Consoles directory of the Project view.
Alternatively, you can create a new scratch file with the contents of the current selection in the editor. Select some text or code, press Alt+Enter and then select Create new scratch file from selection. DataGrip will attempt to detect the language of the selected fragment and use the appropriate type and extension. If it can't detect the language of the selection, DataGrip will create the file with the same type and extension as the original file.
DataGrip numbers scratch files sequentially starting from 1. If you close a tab with an empty scratch file, DataGrip deletes it.
Create a scratch buffer
There is no dedicated menu item for the action to create a new scratch buffer, but you can use the Find Action popup Ctrl+Shift+A and run the New Scratch Buffer action.
You can also add a shortcut for the New Scratch Buffer action as described in Keyboard shortcuts.
DataGrip creates a text file named buffer1.txt. The next scratch buffer you create is named buffer2.txt, and so on up to buffer5.txt. When DataGrip reaches that limit, it will recreate buffer1.txt and suggest clearing the content for it. If you want to make sure DataGrip does not clear the scratch buffer after you have five, you can rename it.
View all scratch files and buffers
Open the Project view and expand .
Use the Find Action popup Ctrl+Shift+A to invoke the Show Scratch Files action and view all available scratch files in a popup:
Location of scratch files and buffers
By default, DataGrip stores scratch files and buffers in the IDE configuration directory under scratches. They are available from any IDE and project that uses this configuration directory.
- Syntax
%APPDATA%\JetBrains\<product><version>
- Example
C:\Users\JohnS\AppData\Roaming\JetBrains\DataGrip2022.1
- Syntax
~/Library/Application Support/JetBrains/<product><version>
- Example
~/Library/Application Support/JetBrains/DataGrip2022.1
- Syntax
~/.config/JetBrains/<product><version>
- Example
~/.config/JetBrains/DataGrip2022.1
To change the location of the Scratches and Consoles directory, use the idea.scratch.path platform property. To change the location of just the Scratches directory, use the idea.scratch.path/scratches platform property. For more information, see Advanced configuration.
Include a scratch file into your database
If a scratch file grows into something that you want to use in your database, move it into the desired directory of your database structure.
Open a scratch file in the editor or select it under the directory in the Project view, press F6, and select the target directory in your database.
Drag a scratch file from the directory in the Project view to the target directory in your database.
Select a scratch file in the directory in the Project view and press Ctrl+X, then select the target directory in your database and press Ctrl+V.
Change the language of a scratch file or buffer
In the Files tool window, open the .
Right-click a scratch file or buffer and then click Change Language.
Select the desired language. You can start typing the name of the language to narrow down the list.
View documentation for scratches
Select any scratch file or buffer in the Project tool window and press Ctrl+Q to view quick documentation with the location, type, size, creation and modification date of the file.
Run an SQL scratch file
To run an SQL scratch file, you need to have a connection to a data source. For this, attach a scratch file to the query console.
When you attach the console, DataGrip resolves the objects in your SQL code. As a result, you can navigate from the SQL code to the database tree.
Press Ctrl+Enter or click
in the gutter. In the Sessions window, select a query console.Click the <session> on> switcher in the upper right corner of the window and select a console. The switcher menu includes consoles that are associated with the same language as your scratch file.
If you want to attach a console from another DBMS, change the scratch file language. To change a language, right-click any area in the open scratch file and click Change Language.
Right-click any area in the open scratch file and click Execute. In the Sessions window, select a query console.
