DataGrip 2017.2 EAP 3 build

Maksim Sobolevskiy

Hello! A new build of DataGrip 2017.2 EAP is available. It brings a small but a called-for feature: a notification is now displayed when a large query is finished. To disable it, in Settings look for the “Database queries that took much time” notification. It appears if it took more than 20 seconds to execute a statement.

Screen-Shot-2017-06-16-at-15.01.45

We improved the introspection for Amazon Redshift which is now incremental. This means that only modified objects will be refreshed in a database tree after any operation instead of all objects.

Also, generation of DDL scripts for tables and functions has been enhanced.

Now DDL for tables contains the following attribute:

[ BACKUP { YES | NO } ]

column_attributes:
[ DEFAULT default_expr ]
[ IDENTITY ( seed, step ) ] 
[ ENCODE encoding ] 
[ DISTKEY ]
[ SORTKEY ]

and table_attributes:
[ DISTSTYLE { EVEN | KEY | ALL } ] 
[ DISTKEY ( column_name ) ]
[ [COMPOUND | INTERLEAVED ] SORTKEY ( column_name [, ...] ) ]

The source code of a function is now generated with the following section:
{VOLATILE | STABLE | IMMUTABLE }

That’s all for today. Take DataGrip 2017.2 EAP for a spin!

Your DataGrip Team