Connecting to a database
To issue a query to a database, you must create a data source connection. Data source is the location of your data and can be a server, a CSV or a DDL file. The data source includes a name and connection settings that are dependent on the data source type. In DataGrip, you can manage these connections in the Data Sources and Drivers dialog ().
Amazon Redshift
In your Redshift dashboard, create a Redshift cluster.
For more information about the Amazon Redshift cluster, read Getting Started with Amazon Redshift.
In settings of the Redshift cluster, copy the JDBC URL.
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Amazon Redshift.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
Paste the JDBC URL from the Redshift cluster settings to the URL field in DataGrip.
In User and Password fields, specify your Redshift credentials.
To ensure that the connection to the data source is successful, click Test Connection.
Apache Cassandra
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Apache Cassandra.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Apache Derby
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Apache Derby.From the Driver list, select the type of the JDBC driver that you want to use. For remote connections, select Apache Derby (Remote). For embedded databases, select Apache Derby (Embedded).
At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Apache Hive
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Apache Hive.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Azure SQL Database
Microsoft Azure supports PostgreSQL, MySQL, MariaDB, and other Database Management Systems (DBMS). If you want to connect to these data sources, create data source connections that correspond to these DMBS. In DataGrip, these connections already include necessary JDBC drivers. So, if you want to connect to the Azure database for PostgreSQL, create the PostgreSQL connection.
In your Microsoft Azure account, create an SQL data source. For more information about the Azure SQL Database, read Azure SQL Database Documentation.
In DataGrip, navigate to Ctrl+Shift+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Azure SQL Database.At the bottom of the data source settings area, click the Download missing driver files link.
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To use Azure Active Directory Authentication, select Use Windows domain authentication. To use SQL Authentication, clear the checkbox, and specify your Microsoft Azure credentials in User and Password fields.
Note: the Use Windows domain authentication checkbox is available only on Windows.
To ensure that the connection to the data source is successful, click Test Connection.
ClickHouse
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select ClickHouse.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Exasol
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Exasol.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Greenplum
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Greenplum.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
H2
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select H2.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
HSQLDB
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select HSQLDB.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
IBM Db2
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select IBM Db2.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
MariaDB
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select MariaDB.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Microsoft SQL Server
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Microsoft SQL Server.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
The Instance field is optional.
To ensure that the connection to the data source is successful, click Test Connection.
MongoDB
In MongoDB, for authentication, you must provide a username, password, and the authentication database that is associated with this username. If the authentication database differs from the database to which you want to connect, specify the authentication database with the authSource parameter in the URL. If no authentication database is specified, MongoDB uses the admin database by default.
For example, you want to connect to the local database but your authentication database is admin. In this case, the connection URL will look like: mongodb://localhost:27017/local?authSource=admin.
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select MongoDB.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
Specify database connection details: a login, a password, and the database that you want to connect to. To set an empty password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
MySQL
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select MySQL.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Oracle
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Oracle.At the bottom of the data source settings area, click the Download missing driver files link.
From the Connection Type list, select a connection type:
SID: to use a unique name of an Oracle instance (a process that runs on the workstation).
Service name: to use an alias to an Oracle instance (or many instances).
TNS: to use tnsnames.ora configuration file. In TNSADMIN field, specify a path to the folder with tnsnames.ora. In TNS name, specify what service name to use (see a value of
net_service_namein tnsnames.ora) if you have more than one service.URL only: to use the JDBC URL.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
From the Driver list, specify the driver type. For more information about driver types, see Oracle JDBC FAQ.
At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
To ensure that the connection to the data source is successful, click Test Connection.
PostgreSQL
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select PostgreSQL.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Snowflake
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Snowflake.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
SQLite
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select SQLite.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
To connect to an existing SQLite database, specify a file path to the database file in the File field.
To ensure that the connection to the data source is successful, click Test Connection.
Sybase ASE
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Sybase ASE.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Vertica
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Vertica.At the bottom of the data source settings area, click the Download missing driver files link. Alternatively, you can specify user drivers for the data source. For more information about user drivers, see Add a user driver to an existing connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
Other
Currently, DataGrip supports vendors that are mentioned previously. The support includes such features as enhanced code completion and better retrieval of database objects (introspection). If your vendor is not in the list, you still can connect to the database with a JDBC driver.
Create a connection to a database with a JDBC driver
If you cannot find a name of a database vendor in the list of data sources, download a JDBC driver for the database management system (DBMS), and create a connection in DataGrip. With the JDBC driver, you can connect to DBMS and start working.
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Driver and Data Source.Click the User Driver link.
In the Driver files pane, click the Add icon and select Custom JARs.
Navigate to the JAR file of the JDBC driver, select it, and click OK.
In the Class field, specify the value that you want to use for the driver.
Click Apply.
Return to the created data source connection.
-
Specify database connection details. Alternatively, paste the JDBC URL in the URL field.
To delete a password, right-click the Password field and select Set empty.
To ensure that the connection to the data source is successful, click Test Connection.
DDL data source
SQL files that contain data definition language statements (DDL statements) can be used as data sources. As a result, you can reference all tables, columns and other objects defined in such files in the editor.
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select DDL Data Source.In the DDL Files pane, click the Add button
. In the file browser, navigate to the SQL file or files with DDL statements and click Open.
Click Apply.
In the SQL Dialects dialog, select a dialect that you want to use for the added SQL file.
Apply settings and click OK.
Productivity tips
Create a data source from the JDBC URL
Navigate to Ctrl+Alt+S.
In the Data Sources and Drivers dialog, click the Add icon (
) and select Data Source from URL.In the URL field, paste the JDBC URL.
From the Driver list, select the necessary driver for the data source.
In the Data Sources and Drivers dialog, enter credentials.
To ensure that the connection to the data source is successful, click Test Connection.
