First, great job to the DataGrip team on an excellent SQL IDE. There are still a lot of features and enhancements I'd like to see, but for a 1.0 release this is promising to be the best in class very soon.
Since I started evaluating DataGrip, I've noticed long running queries under my user name that I did not explicitly run. I suspect these are some introspection queries. The queries look like this:
SELECT t.* FROM some_schema.some_table t
The problem is that in many cases the table being queried has billions of rows and a query like the above is a really bad idea.
Is there a way to disable this sort of introspection? (If this is introspection, it should ideally put a limit on the query.)
- Mac OSX 10.10.5
- DataGrip 1.0.1 Build #DB-143.1411
- JRE 1.8.0_40-release-b108 x86_64
- Driver: Vertica JDBC 7.1.2-0
- Dialect: Generic
As you can see, this is a Vertica db using the generic driver settings.