datagrip Questions

3

Solved

To connect and set up properly with a command line, I "simply" have to do: ssh <MY_USERNAME>@<URL> -L 1139:arcade:139 Enter <MY_PASSWORD> psql -h postgres \c ift2935 se...
Differentiable asked 20/2, 2019 at 4:5

3

Is there any way to reopen closed tabs on DataGrip? not recently closed :)
Operational asked 29/3, 2022 at 4:28

5

Solved

Is there a way (setting or shortcut) for displaying the total row count of a query that outputs more than 500 rows - that is, without modifying the "Result set page size" value in preferences? I'm ...
Contrive asked 15/2, 2017 at 13:29

3

Simple question is that I want to learn table size in DataGrip.Is there any shortcut or a simple way ..
Atmospheric asked 4/6, 2016 at 19:4

4

Solved

So, I was wondering if there is really some new features coming from JetBrains DataGrip software. So far, I didn't find anything that is not already there in IntelliJ IDEA (Ultimate). I didn't spe...
Trichromatic asked 17/10, 2016 at 15:11

8

Solved

I can't seem to figure out how to export a data source configuration in DataGrip (currently on 2016.2 EAP). I would like to export a handful of data sources and share them with my teammates to mak...
Contiguity asked 20/6, 2016 at 20:27

2

Solved

I'm connecting to a local MongoDB instance installed through brew via the IntelliJ Database tool. I can see and query things; but as soon as I try to update a record eg set a database lock back to ...
Tamikatamiko asked 16/12, 2019 at 22:38

8

Solved

I started to use Datagrip for my PL/SQL (school) projects that need the use of DBMS_OUTPUT.PUT_LINE. Before this I was using Oracle SQL developer and I was able to use DBMS_OUTPUT by adding the fol...
Warble asked 2/4, 2018 at 7:13

2

Solved

This is related to How to print out more than 20 items (documents) in MongoDB's shell?. Right now I'm only seeing 20 items at a time returned from my IntelliJ MongoDB interactive shell. Things that...
Assiduity asked 25/5, 2021 at 9:21

5

Solved

How do I import a database just like in phpmyadmin at DataGrip? I have the .sql exported from phpmyadmin... but those are lots of lines so that the IDE stops working when trying to run the whole ....
Poulenc asked 19/12, 2015 at 17:39

4

Solved

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" doe...
Dagnydago asked 9/5, 2020 at 16:13

1

Solved

After upgrading to Intellij 2023.2, I can no longer execute queries against any PostgreSQL database using the Database Tools and SQL plugin bundled with Ultimate edition. Executing any SQL results ...
Brophy asked 27/7, 2023 at 21:8

2

I have been having this odd issue where my DataGrip diagram generations do not showcase the relationships between tables (in other words, the relationship arrows do not appear). Here is an imag...
Teleutospore asked 15/5, 2018 at 4:3

2

Solved

I have Jet Brains DataGrip, I also have an elasticsearch instance running locally in docker exposed on a known port via the tcp protocol. How can I connect DataGrip to my elasticsearch instance? ...
Zadoc asked 2/5, 2019 at 12:11

6

I would like to comment out queries with a keyboard shortcut, like so SELECT * FROM Academics WHERE Academic_id = 1 To become --SELECT * --FROM Academics --WHERE Academic_id = 1
Agentival asked 3/4, 2019 at 15:27

3

Solved

I can't find a search function with which I can search all tables in a database for a certain value in DataGrip. This functionality does exist in other database tools, see: PhpMyAdmin MySQl Work...
Atwood asked 23/2, 2019 at 9:48

17

Solved

So simply the problem occurs when I want to edit selected rows and then apply it. I'm sure it worked some time ago. Tried redownload postgres driver in preferences(yeah, I use postgres) Anyone face...
Purchasable asked 22/9, 2015 at 6:16

2

Solved

How can I edit user privileges of some MySQL servers with JetBrains DataGrip?
Yama asked 16/2, 2017 at 13:47

2

Solved

I have a file that contains multiple select queries. I run these on a weekly basis to generate internal company reports For example (these are not the actual queries): -- Select number of users SEL...
Henig asked 20/12, 2022 at 18:16

2

When I run "DESCRIBE table_name;" in SQLWORKBENCHJ for redshift, or mysqlworkbench for MySQL, it will list the columns of the table, primary key, foreign keys, etc. However, I don't find the equiva...
Deferment asked 19/7, 2019 at 1:41

4

Solved

Is there a quick way without diving into sql to set a particular attribute back to null? entering in "" doesn't work.
Ethiopic asked 20/10, 2016 at 5:12

2

How can I copy a schema to another schema I've created in Datagrip, essentially creating a clone of the original. For some reason my CMD prompt is not set for MySQL, and I have not found the way to...
Pamela asked 29/4, 2020 at 23:31

3

How Can I "set server output" on in Jetbrains DataGrip IDE? I am able to do this in SQL Developer and run the SQL script successfully. The same script I try to run in DataGrip and it gives error. I...
Ebonyeboracum asked 5/1, 2017 at 17:18

2

Solved

I currently connect JetBrain's DataGrip IDE to Google BigQuery to run my queries. I get the following error however: [Simba][BigQueryJDBCDriver](100034) The job has timed out on the server. Try inc...
Turaco asked 10/12, 2021 at 21:27

2

Solved

I'm debugging SQLServer sp using SMSS, but interested debugging using DataGrip. Anyone can help?
Loganloganberry asked 14/5, 2020 at 11:10

© 2022 - 2025 — McMap. All rights reserved.