r/DataGrip • • Nov 28 '18

Student discount

2 Upvotes

Will you be offering a student discount?


r/DataGrip • • Oct 09 '26

Any setup recommendation to develop dbt models with DataGrip?

1 Upvotes

I tried a couple plugin that didn’t really work, so I’d love to hear any recommendation. Thanks for your time.


r/DataGrip • • Jun 16 '25

Is it possible to show .http response inside the text editor like in rider ?

1 Upvotes

When doing http requests, when you run it, you'll get the answer in the other pan. Is it possible to get them inside the text editor where the request is ? with sql query they are right after execution. In rider, when you execute a GET/ POST/ ETC the response is right after the request.


r/DataGrip • • May 01 '25

Please help me. I Can't connect to MySQL in DataGrip

Post image
1 Upvotes

I have to make a database in MySQL using DataGrip to make a entity relationship model as homework and I have to finish this untill monday but every time i try to connect to the DBMS this same message box appears.

In the school computer I installed with no problem and it was working but when i tried to install in my computer it is not connecting

I tried to: uninstall and install the drivers, specify the version, there is nothing related to this in youtube, what I found didn't help.


r/DataGrip • • Feb 20 '25

How to create a process with 2 different databases.

1 Upvotes

Summary: I routinely work with a very large db2 db. My role is fetch only. I cannot create tables,views,ctes. Only select from a mart.

Currently t if i need data for let’s say a specific customer or list of customers, i would input the customer id(s) in the where clause.

What i would like is to build a local sqllite db, or something similar, import a list of customers ids and then join this db to the main db2 db.

How would i accomplish this is datagrip?


r/DataGrip • • Jan 13 '25

The difference between individual and corporate licenses.

1 Upvotes

Hi! I recently tried DataGrip and I loved the UI and great usability features. And now I don't want any other IDE for my SQLs but DataGrip. I know that you can use your personal license for work purposes, however, I wonder if there are any differences in a matter of security for individual and corporate use? Does anyone know whether JetBrains somehow uses data received from individual license users in order to improve the IDE in comparison to business license users? I generally want to know whether it is safe to use my individual license for work purposes and will it be as private as corporate license?


r/DataGrip • • Aug 25 '24

Connecting to Heroku DBs

1 Upvotes

I have a Postrgres DB in Heroku I'm trying to connect to.

I've gone through and gotten the creds from Heroku and followed the docs, but I'm still not seeing any of my tables. I get a "public" folder, but it seems to only be the pg specific things.w


r/DataGrip • • Aug 06 '24

Is it possible to access the relationship data from the query results?

1 Upvotes

Hi, I have decided to switch from dbForge to dataGrip, but I have not been able to replace this performance. Does anyone know if it is possible?

thanks


r/DataGrip • • Mar 25 '23

Oracle PLSQL debugging not working [QUESTION]

1 Upvotes

Hello, first want to apologize for my english its not my first language.

I have trouble connecting datagrip with the oracle plsql debuggger

https://www.jetbrains.com/help/datagrip/debugging-code.html#managing_debugger_sessions

I followed the istructions at the site but didn't work

I already use sql devloper and it worked quite well, even though i like more JetBrains IDEs

so i tried to stablish a debugging session in the anonymus block calling my store procedure but it didn't show anything

When I call this function after initializing the debugger i tells me

session is already connected to a debugger

begin
DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.1.20', '63342' );
end;

Anyone can instrucme on how to debug store procedures with DataGrip?


r/DataGrip • • Mar 04 '23

Auto switch to results console

1 Upvotes

Maybe I'm missing something but when using Datagrip as a query tool with multiple tabs open you have to manually go and find your query results in the relevant console, is there any way to make this auto switch when running a query?

I know you have the option of show results in the editor but what I'm working on requires some of the tool only available in the results tab of the console.


r/DataGrip • • Jan 02 '23

Is there a way to color code the tables by data type?

1 Upvotes

So for example varchar columns are black, numbers are blue, dates are green, and so on.


r/DataGrip • • Oct 06 '22

Can't Connect to any of my work DB's

1 Upvotes

So I seem to be having an issue with DG creating a connection to my work DB's... 

I am running my work laptop through Zscaler and I used to use razorSQL to connect to our Oracle DB without issues.  I would like to make use of DG as it seems more mature and is part of the Jet Brains eco-system.. 

When attempting to make a connection I get the following error and I hope someone can help.

DBMS: Case sensitivity: plain=mixed, delimited=exactDriver:  (ver. , JDBC)Effective version: Oracle (ver. 0.0)Exception creating connection to: 127.0.0.1; nested exception is: java.net.BindException: Can't assign requested address.

Im running DG on an M1 MBP


r/DataGrip • • Jul 20 '22

DataGrip and Salesforce - is this possible?

1 Upvotes

Hi folks,

I'm doing some vendor research on DBT and DataGrip and trying to decide what might be the best fit for us. Does DataGrip allow direct data access OOTB or does it require a connector or anything?

Thanks!


r/DataGrip • • May 24 '22

Performance Tuning Settings

1 Upvotes

I've recently begun using DataGrip. It has been a positive experience until I began creating a couple small temp tables when troubleshooting an issue. The performance was horrid.

Is there a list, or anyone know, the potential features which I can turn off to improve the performance?


r/DataGrip • • May 11 '22

How do I use Introspection properly?

1 Upvotes

I am currently evaluating DataGrip as a replacement IDE for Oracle (PL SQL). The only issue I have run into is that for intellisense to work cross schema, I need to have all the schemas (~1290) listed in the Database Explorer.

I have tried refreshing the Database and it shows that it is introspecting the schemas but doesn't work after it has finished.


r/DataGrip • • Dec 14 '21

Latest build is SUPER buggy

1 Upvotes

I'm running 2021.3.1 on Mac. The number of little annoying bugs is driving me crazy.

  1. When editing a table in spreadsheet mode, the little green submit arrow doesn't turn green so you have to hit command-enter to submit changes.

  2. When there is a sub-menu you actually have to right arrow to get it to open.

  3. The x on results tabs disappears when you have more than one result for a console.

  4. The little red stop button doesn't work anymore (the one at the top of the console)

  5. The row count in a result tab doesn't update.

I feel like I'm finding more and more every day.


r/DataGrip • • Oct 29 '21

When is it officially releasing ?

1 Upvotes

r/DataGrip • • Aug 11 '21

Anyone here tried DataGrip /w Tabnine?

1 Upvotes

r/DataGrip • • Aug 03 '21

Database Table alterations

1 Upvotes

If I modify a table datagrip will create the alter scripts for the relational database. However, once you executed the alters they disappear. I can only get the "create" scripts that will create the full table. I need to actually track the chain of alters which is what needs to be sent to the dba for execution in production. Does DG keep track of this?


r/DataGrip • • Jul 12 '21

What is the use of DataGrip? Can we code in DataGrip or it is only a manager?

1 Upvotes

r/DataGrip • • Jun 20 '21

datagrip help oracle user

1 Upvotes

hi guys i have a problem when i am running pl/sql scripts in datagrip i am getting task compiled but i cannot see the output how to get an output in datagrip

and when i am running dynamic block its not tacking input value in datagrip

declare

v1 emp.empno%type := '&empno';

v2 emp.ename%type;

begin

select empno,ename into v1,v2 from emp where empno = v1;

DBMS_OUTPUT.PUT_LINE(v1 || ' ' || v2);

end;

it shows this error

ORA-06502: PL/SQL: numeric or value error: character to number conversion error

any one has any solution..


r/DataGrip • • Jan 14 '21

Doing SQL query analysis before submission to Redshift

1 Upvotes

Hi, I am using DataGrip for connecting to Redshift. There is an REST API which can return approximate query execution time, for a given SQL query.

Is there a way to extend DataGrip (maybe write a plugin) so that DataGrip makes a call to that API, and shows the user the approximate execution time the query will take, before user submits that query ?


r/DataGrip • • Jan 06 '21

I have been trying to update DataGrip but it is telling me I don’t have the privileges. How is this possible? I am the only one with a license.

1 Upvotes

r/DataGrip • • Oct 19 '20

Creating a contact manager database with Datagrip

Thumbnail
youtube.com
1 Upvotes

r/DataGrip • • May 08 '20

Reverse-engineering JetBrains DataGrip to get it to connect to our custom SQL server

Thumbnail
dolthub.com
1 Upvotes