DataGrip FAQ
If your question isn't on the list, post it in comments.
Is DataGrip available via JetBrains Toolbox as part of the “All Products” pack?
Yes, it is available both as a Single IDE and as part of “All Products.”
Does DataGrip repeat the functionality of the database tools in other JetBrains IDEs?
Yes. All of DataGrip’s features are also available in other IDEs from JetBrains like IntelliJ IDEA, PhpStorm, PyCharm, RubyMine, as well as the upcoming Rider and Gogland.
Can I use DataGrip with SQL dialects that are not listed?
DataGrip can connect to any database which has a JDBC-driver. It means that you can connect to the database, see tables and other objects, and run queries. Special features of these kind of database are not supported and their syntax is not correctly highlighted. There is an issue in our tracker about adding the possibility to define custom dialects in DataGrip.
Our users already have tried DataGrip with: Firebird, SAP Hana, Athena, Teradata, BigQuery.
I cannot connect to the database. What should I do?
Please, visit our troubleshooting page.
Are stored code debugging, administration tools and NoSQL features planned?
Yes, we’re going to add this functionality in future versions. Please, vote here.
How can I help make the product better?
The best way is to share your feedback. Feel free to report bugs and submit feature requests through the issue tracker.
What about data visualization, like graphs or pie-charts?
Sorry, there is no data visualization in DataGrip.
How do I export data to a format I need?
In DataGrip you can create your own format of export. This format should be described as an extractor file. To know how to use custom extractors please see our tutorial: Export data in any way with IntelliJ-based IDEs.
How should I connect to MS SQL Server?
There is a tutorial covering frequent problems with SQL Server connection.
We explicitly support MS SQL Server from 10.50 2008 R2. If you have an earlier version, please go to Options tab in data source settings and choose Introspect using JDBC metadata.
MySQL shows NULL instead of '0000-00-00 00:00:00' in datetime field. Why?
It is the driver option we changed in DataGrip by default. You can configure it the way you like:
DataGrip shows time in local time zone, I want it to be shown in UTC, what should I do?
Go to Advanced tab of datasource and put -Duser.timezone=UTC into VM options field.
Can I mark datasources as Production, Staging, Test etc.?
For now, there is the only way to mark your datasources: use colors.
How to put data sources into folders?
Press F6 on the data source and create a new group. Or add to the existing one.
Can I work with existing sql files from my machine?
Yes, you need to attach your work directory to the Files tool window. It can be done from the context menu.
Please, see the tutorial: Working with files in DataGrip.
What about version control systems?
DataGrip supports Version Control Systems like Git, SVN, Mercurial and some others. But this support doesn’t come out of the box: you need to install a JetBrains plugin for it. Go to Settings → Plugins → Browse repositories and search for the plugin you need. This plugin will bring first-class support for any VCS you need.
Please see our tutorials:
DataGrip and GitHub: Step-by-step Integration; How to work with Git in DataGrip.
Is there a way to share data sources from DataGrip to other IDEs?
Select the data sources you want to share and then go to context menu → Database Tools → Copy Settings.
Press + to add a new datasource and choose Import from Clipboard.
Please, see our tutorial: Copy and share data sources in IntelliJ-based IDEs
My Clojure extractors don't work anymore. What should I do?
Now there is no Clojure engine by default. To keep Clojure extractors work, please install IntelliJ Scripting: Clojure plugin.
Please sign in to leave a comment.
“All the features” are present in PyCharm? The one thing I can’t seem to do is attach a directory to a project. Whereas in DataGrip you have the “files” window, in PyCharm the equivalent is “Project”, with no way to attach external directories that I can tell. Is there a setting somewhere or do you just have to move directories you want to use inside the project directory itself?
It's possible in PyCharm here:
Excellent - thanks!
How do you get the DateTime Picker to use the Timezone of the local machine or even the database server the data source is connected to? I've tried everything I could think of, and it still seems to always be 4 hours ahead of EST. I tried all kinds of variations to the VM options on the data source, but it doesn't change anything.
-Duser.timezone=EST
-Duser.timezone=EDT
-Duser.timezone="America/New_York"
-Duser.timezone=America/New_York
-Ddate.timezone=EST
-Ddate.timezone=EDT
-Ddate.timezone="America/New_York"
-Ddate.timezone=America/New_York
I've checked that my local machine is set to that timezone, and also the db server.
@Justin Davis that's a bug, we'll fix it. Thanks!
@Justin Davis, I am having the same issue, running DG 2019.1.3 on macOS 10.14.6.
I was hoping that it would be fixed by now...
Actually, I just found the solution! Open the properties panel for the database connection, and select the second tab:
Apparently, if this field is blank, it defaults to 'UTC', which is not what I would expect to see. In my opinion, if this field is empty, it should just use whatever is set in postgresql.conf. In any case, I am glad I finally found it.
Thanks, but unfortunately, that didn't fix it for me. I have it set for New_York/America and it is still coming up 4 hours ahead.
Using a MacBook Pro on Mojave 10.14.5
Justin Davis, thanks for the report, weэму fixed the behavior of the date picker, expect in the closest bug-fix update (or EAP)
Thanks! I look forward to the update.
Why can't I just type NOW() into a datetime column in the data editor view? Even Sequel Pro can do something so basic. Is there a way to escape MySQL functions in the data editor? Also, how do I get the database tool window to reuse a single tab? Everytime I click a new table, it opens in a new tab. I have a DB with over a 100 tables. I don't want to be constantly closing tabs
Ronald, thanks for the comment.
1. About NOW(), it's impossible in the current version. Please follow the ticket: https://youtrack.jetbrains.com/issue/DBE-1412
2. About tabs. Play with that setting:
I had to close and re-open DG to get the time zone setting to take effect. In case anyone else is wondering why it won't work after the setting has been applied.
@jaredbaszler
Yes, you ned to stop and run your connections again.
@Justin Davis i found the solution
Set your use_server_time_zone and use_time_zone option values and be happy)
Is there a function to view detailed tables like toad or DBeaver?
Yes, Ctrl\Cmd+F6 should help
If the functionality of DataGrip is similar to database tools from other IDEs, can we expect discounts for IDE license holders? I am comfortable with having a separate program for working with the database, but I do not want to pay twice as much for the separate window function
We understand the need, but we don't plan these kinds of discounts now.
On the IDEA database connection dialog, there are two different options for Authentication: "User & Password" and "Authenticator". I can't find any documentation for the "Authenticator" option.
I am trying to connect to a Snowflake instance that requires Okta SSO for accessing the database. Is this supported from IDEA or DataGrip? Do I use "Authenticator" for that? How do I configure it?