DataGrip Quick Start Guide
Hello, and thank you for giving DataGrip a try! Let’s go on a little journey that will see you through to your first query result.
After you have installed the product and launched it for the first time, you’ll be asked to choose the color scheme for DataGrip, which can be either light or dark.
In the next window of the wizard, choose the default dialect and scripts directory.
First, choose the main dialect for your files. For example, if you choose SQL Server, the
*.sql files will be highlighted as SQL Server files by default. You will then be able
to choose any dialect for any file or folder.
Next, select the directory where you are going to keep your scripts. Or just point to the directory where the SQL files you’ll be working with are. This directory will become attached and its content will be shown in the Files tool window of the IDE.
Here’s how DataGrip will look after the first start:
In this notification popup, DataGrip will suggest that you connect to the database and attach the folder for scripts if you haven’t already done so from the startup wizard. Anyway, if this popup never appeared or has already disappeared, it might still be useful for us to go through and look at how to connect to the database.
Open the Database view by pressing Ctrl+1. The panel on the left displays all the data sources. We have none yet, so let’s make our first data source. Click +, and then choose the database type you are going to work with.
Then you’ll see the connection window.
Important! DataGrip does not ship Java drivers, which are needed for connectivity. Click the Download button in order to get the drivers you need and be able to connect.
Now, enter the appropriate values into the fields: host, instance, database, port, user, and password. For more details about the specific databases and how to connect to them, please refer to the corresponding articles from our documentation:
If you are going to use DataGrip with a database we do not officially support (such as Teradata, Snowflake, or Firebird), connect to it with the help of a JDBC driver. See this article for detailed instructions.
Finally, click the Test Connection button. A green Successful note will tell you that you’ve passed the most important stage.
On the Options tab, choose which databases or schemas will be visible in the database tree.
Click OK. Your data source will appear in the left-hand pane (which we usually call the Database view), and the default query console will display. The console is an SQL file attached to your data source where you write SQL queries.
In the top right-hand corner of the console, there is a drop-down where you can choose the context: database, schemas, or, in the case of PostgreSQL, the search path for this console.
You can also create several query consoles. To do that, use the context menu.
The last step is to write an SQL query in the query console. Then press Ctrl+Enter and get the result!