DataGrip 2017.3 Help

Managing data sources

About data sources

To be able to work with your databases in DataGrip, you should define them as data sources. See Connecting to a database.

In addition to data sources that correspond to real databases (DB data sources), DataGrip also supports DDL data sources. These are represented by one or more SQL files containing data definition language statements (SQL DDL statements).

Metaphorically, DDL data sources function as databases without data.

Data sources provide the basis for SQL coding assistance and code validation.

Creating a DB data source for H2 or SQLite by means of drag and drop

If you have H2 or SQLite database files available locally, you can create DB data sources for them by dragging the files to the Database tool window. The files can be dragged from the Files tool window, or from your file manager (e.g. Explorer or Finder).

  1. If the database files are in your DataGrip working folder, open the Files tool window. Otherwise, open your file manager.
  2. Open the Database tool window.
  3. Select the file or files of interest in the Files tool window, or in your file manager.
  4. Drag the selected file or files into the Database tool window. (For each of the files a separate data source will be created.)
  5. If you don't have the necessary database driver files yet, you can download them now. Click iconManageDataSources on the toolbar of the Database tool window. (Alternatively, select Properties from the context menu.)
  6. In the Data Sources and Drivers dialog that opens, within the line Download missing driver files, click the Download link.
  7. Click Test Connection to make sure that DataGrip can properly communicate with the database.
  8. Click OK in the Data Sources and Drivers dialog.

Creating a DDL data source

  1. Open the Database tool window and click iconManageDataSources on the toolbar.
  2. In the Data Sources and Drivers dialog that opens, click add and select DDL Data Source.
  3. In the Name field, if necessary, edit the name of the data source.
  4. Under DDL Files, click new and select the necessary SQL file or files in the dialog that opens.
  5. From the Extend list, if necessary, select another data source as a parent. As a result, the data source whose properties you are editing will "inherit" all the DDL definitions from its parent.
  6. Click OK to save the settings and close the dialog.

Creating a DDL data source by means of drag and drop

You can create DDL data sources by dragging DDL SQL files to the Database tool window. The files can be dragged from the Files tool window, or from your file manager (e.g. Explorer or Finder).

  1. If the necessary DDL SQL files are in your DataGrip working folder, open the Files tool window. Otherwise, open your file manager.
  2. Open the Database tool window.
  3. Select the file or files of interest in the Files tool window, or in your file manager.
  4. Drag the selected file or files into the Database tool window. For a new data source to be created, the red border, when dropping the file or files, should surround most of the window area (rather than one of the existing data sources).

Changing data source settings

  1. Open the Database tool window and select the data source of interest.
  2. Do one of the following:
    • Click iconManageDataSources on the toolbar.
    • Select Properties from the context menu.
    • Press Ctrl+Shift+Alt+S.
  3. In the Data Sources and Drivers dialog that opens, edit the settings as necessary. See:

Making a DB data source available in all your projects

When a DB data source is created, it's assigned to a project. That is, by default, it's available only in the project in which it was defined.

If you want to make a data source available in all your projects, you should make it global:

  1. Open the Data Sources and Drivers dialog (e.g. Ctrl+Shift+Alt+S) and select the data source of interest.
  2. Click icon importCopyrightProfile on the toolbar or select Make Global from the context menu.
  3. Click Apply or OK.

In a similar way, you can move a global data source to the project level - to make it available only in the current project: use icon importCopyrightProfile or Move to Project from the context menu.

Note that the DDL data sources exist only on the project level.

Grouping data sources

If you have many different databases, you can group data sources in the Database tool window. For this, select the necessary data source and press F6 or select Move to Group from the context menu.

DBTWMoveToGroup

From this menu, you can move the data source to an existing group, create a new group for it, or remove it from a group (move it into the root list).

Removing data sources

To remove unnecessary data sources, you can use the Database tool window or the Data Sources and Drivers dialog.

Using the Database tool window. Select the data sources to be removed and do one of the following:

  • Press Delete.
  • Select Delete from the context menu.
  • Select Edit | Delete.

Using the Data Sources and Drivers dialog. Select the data sources to be removed and do one of the following:

  • Click delete on the toolbar.
  • Press Delete.
  • Select Remove from the context menu.
Last modified: 4 April 2018