DataGrip
 
Get DataGrip

Data sources

Last modified: 04 December 2024

Data source is a connection configuration. It stores a list of connection details that are used to establish connection to a database. For example, host, port, database name, driver, SSH and SSL configuration settings, and so on. In data source settings, you can also select databases and schemas for introspection and display in Database Explorer, and change the driver for your connection.

You can configure your data sources in the Data Sources and Drivers dialog (CtrlAltShift0S) . To access the dialog, in the Database Explorer (View | Tool Windows | Database Explorer) , click the Data Source Properties button (the Data Source Properties button) on the toolbar.

Data source with connection details for a PostgreSQL database

You can see the list of created data sources in the Database Explorer (View | Tool Windows | Database Explorer) . Data sources with an active connection to a database are marked with a green dot in the corner of their icons.

Data sources in the Database Explorer

In DataGrip, you can create the following data sources:

  • Database data sources: connection configurations for the operational databases that contain data.

    For different database vendors, DataGrip provides complete support and basic support. Complete support of a database vendor includes such features as enhanced code completion and better retrieval of database objects (introspection). All the inspections, quick-fixes, and other coding assistance features are also available. Whereas basic support has limited features available.

    For more information on the support types, refer to the Other databases topic.

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