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