Tag Archives: tutorial

Using BigQuery from IntelliJ-based IDE

Posted on July 10, 2018 by Florin Pățan

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 | 27 Comments

How to use Git with DataGrip

Posted on June 1, 2018 by Chris Woodruff

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 , , , | 27 Comments

Using AWS Athena from IntelliJ-based IDE

Posted on May 25, 2018 by Florin Pățan

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 | 11 Comments

Copy and share data sources in IntelliJ-based IDEs

Posted on May 21, 2018 by Maksim Sobolevskiy

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 | 9 Comments

Generate simple classes from database objects in DataGrip

Posted on February 13, 2018 by Maksim Sobolevskiy

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 | 12 Comments

Export data in any way with IntelliJ-based IDEs

Posted on November 8, 2017 by Maksim Sobolevskiy

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 | 32 Comments

How to Find Things in DataGrip

Posted on April 20, 2017 by Maksim Sobolevskiy

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

Posted on October 7, 2016 by Maksim Sobolevskiy

UPDATED: September, 2019 Check the LocalDB instance You can easily connect to your LocalDB instance with DataGrip. And as a first step, check if your LocalDB instance is ready for a connection. Locate SqllocalDB.exe and run the SqllocalDB.exe i command in a terminal. You … Continue reading →

Posted in Tutorial | Tagged , , , | 7 Comments

Connecting DataGrip to MS SQL Server

Posted on June 21, 2016 by Maksim Sobolevskiy

UPDATED: September, 2019 Some specific needs of SQL developers like connecting to SQL Server from OSX and even using Windows authentication can be covered by DataGrip. Since releasing DataGrip, we’ve received lots of comments about connecting to SQL Server. It … Continue reading →

Posted in Features, Tutorial | Tagged , | 66 Comments