DataGrip changes SQL dialect for files silently without a notification.

Completed

Hi Team,

I'm not happy to see that DataGrip changes SQL dialect for files without any notification silently in background.

  1. I set SQL dialect "Redshift" as global for a folder.
  2. I have a set of database connections (Redshift, PostgreSQL, Oracle). N.B. The Redshift connections were created as custom one before Redshift support in DataGrip 2017.2.
  3. If I run a sql file in the mentioned Redshift connection DataGrip changes SQL dialect for the specified file from "Redshift" to "PostgreSQL".
  4. Next time I want to run the file DataGrip provides me PostgreSQL connections only instead of Redshift connections.

 

Once I created a new "Redshift" database connection no more silent actions with SQL dialect change.

I've lost an hour to re-create all Redshift connections. Thank you.

 

 

Best regards,

Kostyantyn

 

DataGrip 2017.2
Build #DB-172.3544.109, built on July 27, 2017
Licensed to Kostyantyn Krakovych
You have a perpetual fallback license for this version
Subscription is active until September 24, 2018
JRE: 1.8.0_152-release-915-b6 x86_64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Mac OS X 10.12.6

1
1 comment

I suppose, it was because we used PostgreSQL dialect for custom Redshift connections. Now, since Redshift is officially supported, the problem should disappear.

1

Please sign in to leave a comment.