Category Archives: Tutorial

Working with files in DataGrip

People working with databases write SQL. A lot of SQL. In this post, we’ll go over whether it’s better to just use a temporary SQL editor in DataGrip or if it’s more convenient to work directly with SQL files stored … Continue reading

Posted in Tutorial | Tagged | Leave a comment

DataGrip and GitHub: Step-by-step Integration

All the IDEs based on IntelliJ Platform have Version Control System integration. DataGrip is no exception! But because database developers usually do things a little differently to other developers and because DataGrip’s project model has its own specific workflow, the … Continue reading

Posted in Features, Tutorial | Tagged | Leave a comment

Using BigQuery from IntelliJ-based IDE

Continuing the series of posts on how to connect DataGrip (or any other IntelliJ-based IDE) to various data sources, in this post we’ll show you how to connect to Google’s BigQuery. BigQuery is a low-cost enterprise data warehouse designed to … Continue reading

Posted in Tutorial, Uncategorized | Tagged | 10 Comments

How to use Git with DataGrip

In the software world, there has been a solid habit of using version control to keep track and manage source code changes and collaboration. We have moved from centralized solutions like SourceSafe and TFS and now into using tools that … Continue reading

Posted in Tutorial | Tagged , , , | 17 Comments

Using AWS Athena from IntelliJ-based IDE

If you use the AWS cloud, then you probably store data on their S3 platform, either for your application data or in the form of logs from services like the AWS Elastic Load Balancing. Amazon offers Athena, a service built … Continue reading

Posted in Tutorial | Tagged | 10 Comments

Copy and share data sources in IntelliJ-based IDEs

Hello! In this tutorial we’re going to look at three popular use-cases: — Duplicate a data source within one project. — Share data sources between projects inside one IDE. — Copy a data source from one IDE to another IDE, … Continue reading

Posted in Tutorial, Uncategorized | Tagged | 3 Comments

Generate simple classes from database objects in DataGrip

DataGrip lets you run scripts against the selected schema objects. For example, you can generate Java classes from tables or, if you want, classes in any other language: C#, Python, etc. You can alter or extend the default functionality, for … Continue reading

Posted in Tutorial, Uncategorized | Tagged | 10 Comments

Export data in any way with IntelliJ-based IDEs

In DataGrip, or any other JetBrains IDE featuring database support, there is a powerful engine to export data in many formats. You can even create your own export format. Let’s look closer at this engine. Export directions Any table/view or … Continue reading

Posted in Features, Tutorial, Uncategorized | Tagged | 23 Comments

How to Find Things in DataGrip

Search and navigation tips When you work with a software tool, you often need to find something or other. In DataGrip, you could be looking for things like: — Database objects: tables, views, procedures, columns and so on. — Data: … Continue reading

Posted in Features, Tutorial | Tagged , , | Comments Off on How to Find Things in DataGrip

Connecting DataGrip to SQL Server Express LocalDB

First you need to check if you LocalDB instance is ready for connection. Locate SqllocalDB.exe and run the SqllocalDB.exe i command in terminal. You will see the list of available LocalDB instances on the server which you are connecting to. … Continue reading

Posted in Tutorial | Tagged , , , | 3 Comments