Create connection

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 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 (File | Data Sources).

The following video is a general instruction on adding a data source. For illustrative purposes, the video shows how to add a PostgreSQL data source.

Select a data source that you want to create. DataGrip provides a complete support for the following database vendors:

• Amazon Redshift

• Apache Cassandra

• Apache Derby

• Apache Hive

• Azure SQL Database

• BigQuery

• ClickHouse

• CockroachDB

• Couchbase Query

• Exasol

• Greenplum

• H2

• HSQLDB

• IBM Db2 LUW

• MariaDB

• Microsoft SQL Server

• MongoDB

• MySQL

• Oracle

• PostgreSQL

• Redis

• Snowflake

• SQLite

• Sybase ASE

• Vertica

• Other

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 code assistance features are also available. Whereas a basic support has limited features available.

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

For the database vendors listed below, a basic support is provided:

• AWS Athena

• Apache Ignite

• Apache Spark

• DuckDB

• Elasticsearch

• Firebird

• Google Cloud Spanner

• Informix

• InterSystems IRIS

• Mimer SQL

• OpenEdge

• Phoenix

• Presto

• SAP HANA

• SingleStore

• Tarantool

• Teradata

• TiDB

• Tibero

• Trino

• YugabyteDB