DataGrip 2020.1 Help

Manage data sources

Data source is a location of data for your application. In DataGrip, you can define the following data sources:

  • Database data source: operational databases that contain data (see Database connection).

  • Data Definition Language (DDL) files: SQL files that contain data definition language statements.

Configure data source settings

  1. In the Database tool window (View | Tool Windows | Database), select a data source that you want to change.

  2. Click the Data Source Properties icon (the Data Source Properties) on the toolbar.

    Configure data source settings

Group data sources

If you have a number of different databases, you can group their data sources in the Database tool window (View | Tool Windows | Database).

  1. To group data sources, select the necessary data source, press F6, or select Move to Group from the context menu.

  2. To create a new group, drag one data source onto the other. If you want to place the data source into an existing group, drag it to the existing group node.

  3. To remove a data source from the group, move the data source to the root list.

Configure display options for data sources

  • To group, enable, or sort data sources, click the Show Options menu icon the Show Options menu icon on the title bar of the Database tool window and select the necessary options.

    In the Database tool window (View | Tool Windows | Database), the view of the data source changes instantly.

    the Show Options menu icon

Assign a color to a data source

To have better differentiation between production and test databases, you can assign a color to a data source.

  1. Navigate to File | Data Sources or press Ctrl+Shift+Alt+S.

  2. Select the data source for which you want to assign a color.

  3. Click the Choose color icon (The Choose color icon) and select a color.

    Assign a color to a data source

Assign a color to query consoles and grids

  • The text data viewer can use the color of the data source. To set a color, right-click a data source and select Color Settings. In the Database Color Settings dialog, select the dialog and coloring options. To have the data source color applied for query consoles and grids, select the In console editors and grids checkbox.

Text data viewer uses the color of the data source

Filter objects from the toolbar

  • To select the necessary objects, use the Filter icon on the toolbar the Filter icon.

    The Filter menu
Last modified: 2 July 2020