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.
- I set SQL dialect "Redshift" as global for a folder.
- 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.
- If I run a sql file in the mentioned Redshift connection DataGrip changes SQL dialect for the specified file from "Redshift" to "PostgreSQL".
- 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
Please sign in to leave a comment.
I suppose, it was because we used PostgreSQL dialect for custom Redshift connections. Now, since Redshift is officially supported, the problem should disappear.