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: ClickHouse, Exasol, Firebird, Heroku Postgres, Hive, Informix, MariaDB, Presto, SAP Hana, Teradata, Vertica.

Are stored code debugging, administration tools and NoSQL features planned?

Yes, we’re going to add this functionality in future versions.

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 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:

 MySQLDate.png

 

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.

UTC.png

 

Can I mark datasources as Production, Staging, Test etc.?

For now, there is the only way to mark your datasources: use colors.

Colorz.png

 

What about version control systems?

DataGrip supports Version Control Systems like GitSVNMercurial 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..

Git_.png

 

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.

 CopySettings_.png

Press + to add a new datasource and choose Import from Clipboard

ImportFromClipboard_.png

 

 

Please sign in to leave a comment.

Have more questions?

Submit a request