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 install the product and launch it for the first time, you’ll be asked to choose the color scheme for DataGrip, which can be either light or dark.
Then, choose the color scheme for the editor. You can even combine the light editor color scheme with the dark look-and-feel, if this strikes your fancy.
In the last window of the wizard, choose the default dialect. For example, if you choose SQL Server, *.sql files will be highlighted as SQL Server files by default. Then you will be able to choose any dialect for any file or folder.
Here’s how DataGrip will look after the first start:
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 be able to connect.
Now, enter appropriate values in 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 documentation articles:
If you are going to use DataGrip with a database we do not officially support (such as Vertica, 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 pane (which is called 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 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!