Stack Overflow
Stack Overflow

Questions tagged [intellij-datagrip]

JetBrains' commercial Database IDE(formerly 0xdbe). This is a cross platform database IDE that supports most relational databases. By default it bundled into all commercial Intellij products.

27 questions
11
votes
2 answers

How to fix " [08S01] Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. "

I'm working on a PHP project using PhpStorm + DataGrip + MySQL + WAMP and since then was working normally with remote database with these configurations (see images): but suddenly I'm getting this error: [08S01] Communications link failure The…
OUTC-K
  • 121
  • 1
  • 1
  • 8
10
votes
2 answers

Data Grip - how do I perform a simple SQL formatting (the same way ctrl+shift+F does in DBeaver)?

I'm using Data Grip and writing queries for use with Presto. How can I get Data Grip to format my queries so they will be neat and easy to read?
GiladZa789
  • 111
  • 1
  • 7
10
votes
4 answers

DataGrip view JSON in pretty

Is there a way to view JSON in a pretty format with lines wrapped when selecting the column in DataGrip? In MySQL Workbench there's a nice option of "Open value in Editor". The "Edit Maximized" does not wrap or fit in screen. DataGrip: MySQL…
John Jai
  • 3,463
  • 6
  • 25
  • 32
9
votes
1 answer

How to set datagrip to take same timezone as the host database

I want that my postgres datagrip connection should take the same timezone as the remote source (host) its connected to. How do I do this?
user248884
  • 851
  • 1
  • 11
  • 21
5
votes
1 answer

Programmatically run a query and export it as a CSV file in DataGrip

I am looking to write script in either Python on JavaScript that executes an SQL file query and then saves the results in a CSV file. Bonus points if I can also make it time-bound to run at a specific time. I have tried looking at the IDE Scripting…
Lee-on Pedahzur
  • 61
  • 6
4
votes
1 answer

DataGrip display full geometry

How can I load the full geometry in JetBrains DataGrip ? Why do I get 204 KB loaded when total is 1.75 MB. Due to this record not displayed on Geo Viewer.
IamMashed
  • 1,811
  • 2
  • 21
  • 32
4
votes
1 answer

Is there a postgis geometry viewer in jetbrains datagrip?

pgadmin4 offers postgis geometry viewer https://www.bostongis.com/blog/index.php?/archives/272-pgAdmin4-now-offers-PostGIS-geometry-viewer.html is there similar in Jetbrains Datagrip or pycharm?
IamMashed
  • 1,811
  • 2
  • 21
  • 32
4
votes
1 answer

Parsing CSV to DataGrip database failed

I tried to add values of a csv file to a local sqlite database using DataGrip. I think it's a bug in DataGrip because the preview is correct but I don't know how to fix it. This is the log I get: 2:1: assertion failure: param count (5) != value…
Philipp Niedergesäß
  • 435
  • 3
  • 17
3
votes
1 answer

Filter criteria keyboard shortcut

Having IntelliJ Ultimate / Datagrip when I go to the editor of table's data (Database tab -> schemas -> selected schema -> tables -> F4 upon selected table) I am able to provide "filter criteria" to the input field above data view by selecting…
Jakub Ch.
  • 3,577
  • 3
  • 24
  • 43
2
votes
3 answers

How to open/view/import .dbf file in jetbrains datagrip?

How do I work with .dbf files in Jetbrains DataGrip ? I am on macos and need to work with .dbf file. I managed to open dbf file in Shapefile explorer software. But I would like to use cool features DataGrip offering. Is it possible?
IamMashed
  • 1,811
  • 2
  • 21
  • 32
1
vote
2 answers

how to show un-committed changes in a database table in datagrip

How can I run a statement in the sql query console in manual mode on datagrip and see their effect on the table locally in order to make sure it has the intended effect before committing it to the database?
modernNeo
  • 137
  • 9
1
vote
1 answer

Quoting error when executing a Drill query from JetBrains JDBC driver

I have a custom datasource driver in JetBrans (Rider 2019.2) which uses apache-drill-1.17.jar JDBC driver (official). Using the driver results in this error: SELECT * FROM dfs.my_parquets."Test" limit 10; -- PARSE ERROR: Lexical error at line 1,…
rudolfdobias
  • 1,778
  • 3
  • 17
  • 40
1
vote
0 answers

datagrip - schema name missing on console when opening a routine

I am new to datagrip client, I click on shift twice to open a search window, when I search for a routine (function or procedure) and press Enter, it opens the code in the console but the schema name is missing on the routine. Example: if the…
bharat
  • 23
  • 4
1
vote
2 answers

How can you connect Snowflake to an IDE using Okta with MFA?

We currently use Okta (which requires MFA) to manage our Snowflake users, so most of our Snowflake users do not have a password. We have developers who want to use an IDE like DataGrip or DBeaver but we are unable to connect using the Okta…
Brock
  • 244
  • 2
  • 11
1
vote
1 answer

fake relationships in DataGrip

I'm trying to create an ER diagram with DataGrip 2019.3 however I get duplication of relationships. Once a "false" relay is only based on keys (t1_id:t1 id) without any foreign keys being set at all, and after creating a foreign key the relation is…
mr mcwolf
  • 2,574
  • 2
  • 14
  • 27
1
2