Tutorial

Basics The source code of the object is the core part of the DDL script which is needed to create this object. In other words, the CREATE statement is not part of the object's source code. The source code is stored inside the database. The most common objects found with the source code are views, functions, and stored procedures.In many other tools, to update the source code, you would need to

The 2021.1 update brings full native support for BigQuery. To learn how to use this, head over to our Documentation. This article covers support pre-2021.1 for BigQuery. If you are still using such a version, we encourage you to upgrade to the latest IDE version and check out the native support. Continuing the series of posts on how to connect DataGrip (or any other IntelliJ-based IDE) to various

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 distribute the management with Mercurial and Git. While both centralized and distributed technologies have pros and cons, we will be looking at why database profess

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 on Presto, and allows you to query this S3 data using ANSI SQL syntax. So how to access this data straight from the IDE? To do this, we’ll first need to do some configuration t

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, or to another computer. Duplicate a data source within one project A trivial problem deserves a trivial solution: in the context menu of the selected data source, click Duplica

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 instance, generate an HTML or Markdown report. Out of the box, DataGrip can generate Java classes. To do this, go to the context menu of a table (or several

In DataGrip, as well as all other JetBrains IDEs that feature 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 result-set can be exported to a file or copied to the clipboard. To export to file:       — Context menu on a table/view an

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: enough said. — Code: for example a piece of code in a big script or the source code for a database object. — Lots of other things: files, settings, IDE actions, etc. F

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 will see a list of available LocalDB instances on the server. To create an instance, run SqlLocalDB

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 appears it's not straightforward as with other databases, requiring a couple of extra steps beforehand. Here is a small guide describing the main problems you may f