Questions tagged [datagrip]
JetBrains' commercial Database IDE(formerly 0xdbe). This is a cross platform database IDE that supports most relational databases.
737
questions
58
votes
8
answers
77k
views
How to Export/Import a Data Source from DataGrip?
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 make ...
- 3,632
44
votes
2
answers
4k
views
0xDBE / PHPStorm / IDEA fails to synchronize database's tables
I'm getting the following error when trying to sync the database tables in 0xDBE:
Method org.postgresql.jdbc4.Jdbc4Array.free() is not yet implemented.
Method org.postgresql.jdbc4.Jdbc4Array.free() ...
- 680
41
votes
4
answers
74k
views
How to export a data base from DataGrip at one SQL file?
How I can export a data base from DataGrip at one SQL file as phpmyadmin export?
If I use Dump Data To Files, DataGrip save one table at one file.
And how I can create backup of all MySQL ...
- 411
39
votes
5
answers
16k
views
Datagrip - get row count (easily) on queries with more than 500 results
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 ...
- 1,445
38
votes
4
answers
20k
views
DataGrip added value compared to IntelliJ IDEA
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 spend ...
- 3,778
37
votes
5
answers
72k
views
Creating new database in DataGrip JetBrains
Anybody know how to create new database in DataGrip (database IDE from JetBrains)?
Could not find in DataGrip Help page.
- 3,386
36
votes
1
answer
44k
views
Generating sql insert into for DataGrip
When you run a query (a SELECT statement) in the console, the data retrieved from the database are shown in table format in the Result pane of the Database Console tool window.
I've searched ...
- 613
34
votes
5
answers
14k
views
DataGrip: how to connect to Oracle as SYSDBA
I tried to setup in DataGrip an Oracle connection under SYS user.
But got error:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
But there is no option in GUI to choose as SYSDBA ...
- 25.7k
33
votes
5
answers
39k
views
Import a database to DataGrip(0xDBE)
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 .sql
- 6,992
32
votes
2
answers
27k
views
How to quickly generate SELECT statement with all columns for a table in DataGrip?
In Microsoft SQL Server Management Studio (SSMS), you can right-click on a table, then go to Script Table as -> SELECT To, and then choose a destination for the generated script.
Is there anything ...
- 14.4k
32
votes
4
answers
14k
views
How do you set a cell to null in datagrip?
Is there a quick way without diving into sql to set a particular attribute back to null? entering in "" doesn't work.
- 3,229
30
votes
17
answers
30k
views
datagrip Cannot apply changes This table is read only. Cell editor changes cannot be applied
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 faced ...
- 667
27
votes
8
answers
19k
views
Use dbms_output.put_line in Datagrip for .sql files
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 ...
- 1,177
25
votes
3
answers
26k
views
How to import CSV data to MySQL in JetBrains DataGrip
I'm studying MySQL. I need to import data from a CSV file to a MySQL table using JetBrains DataGrip.
I've done such this job before in dbForge MySQL, but last week I moved from Windows to Linux.
...
- 1,204
23
votes
2
answers
17k
views
How to edit user privileges with JetBrains DataGrip?
How can I edit user privileges of some MySQL servers with JetBrains DataGrip?
- 839
22
votes
3
answers
21k
views
Defining a Redshift connection in DataGrip
I'm trying to define a Redshift connection in DataGrip but couldn't find any Redshift driver in the UI. I tried using both Postgres and generic Database Driver with no luck.
Has someone been able to ...
- 765
20
votes
1
answer
6k
views
Automatically capitialize things in datagrip
Is there a way in datagrip to automatically capitialize key words even if they are typed in lowercase? For example SELECT, FROM , WHERE , HAVING, ORDER BY?
- 2,528
20
votes
6
answers
80k
views
How to comment & uncomment multiple line SQL code in DataGrip IDE
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
user4547600
20
votes
2
answers
15k
views
How to set SQL Server Authentication Method in DataGrip?
Is there a way to specify the authentication method (SQL Server or Windows Authentication) when connecting to SQL Server with DataGrip?
I have tried configuring using both the SQL Server(jTDS) and ...
- 4,913
19
votes
2
answers
7k
views
IntelliJ DataGrip how to enable add row?
I use the DataGrip for some days now and i really like it but it has a suspicious behavior. In some tables i open i can't add new rows. In other tables of the same database it works fine.
The add row ...
- 214
18
votes
3
answers
14k
views
How To Set Server Output On in DataGrip
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 ...
- 343
17
votes
4
answers
16k
views
Script schema of the entire database with Datagrip
Is it possible to script schema of the entire database (SQL Server or Postgres) using datagrip?
I know I can get DDL for table and view and source for each stored procedure / function on it's own.
...
- 17.5k
17
votes
2
answers
20k
views
Copying/Cloning database in Datagrip(MySQL)
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 do ...
- 301
16
votes
6
answers
28k
views
javax.net.ssl.SSLHandshakeException: The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]
I upgraded DataGrip to 2021.1.2, and now when I run any query I get this response
javax.net.ssl.SSLHandshakeException: The server selected protocol
version TLS10 is not accepted by client preferences ...
- 18.2k
16
votes
3
answers
11k
views
How do I connect a MS Access database to Jetbrains DataGrip
I have been using DataGrip for a couple of weeks now and I like it a lot.
The only thing I am unable to find out is how to connect DataGrip to a MS Access database.
Could someone explain to me how ...
- 5,428
16
votes
3
answers
20k
views
How to quick view tables in DataGrip?
In sql express I could setup query shortcuts, so I simply create a "Select * from " shortcut and when I press it with the table name selected it shows me the select result
There's any way I can quick ...
- 556
15
votes
2
answers
3k
views
How do I stop SQL splitting string literals when I press Enter in DataGrip or IntelliJ Database Editor?
When my cursor is after an open quote in a SQL statement in an IntelliJ database console and I press Enter, it closes the quote on the current line and adds a concatenation symbol with an open quote ...
- 4,704
14
votes
3
answers
24k
views
How could I create relationships between tables in JetBrains' DataGrip?
I am using DataGrip by JetBrains in my work. It is ok, but I don't know how to create relationships between tables like in this picture:
- 181
13
votes
1
answer
9k
views
Using JetBrains DataGrip - where do I find Functions?
I just created a function, but I cannot find it in the schema. To make sure that I was reading the latest schema I even restarted DataGrip.
Where are Functions found in DataGrip?
- 1,511
12
votes
4
answers
11k
views
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 ...
- 3,593
12
votes
1
answer
7k
views
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?
- 901
12
votes
4
answers
19k
views
Google Big Query: alternatives to browser SQL editor? [closed]
I'm currently working a lot with Google Big Query and I absolutely hate querying in-browser. I'm used to connect to regular DB's through editors like Toad, Microsoft SQL Studio, Teradata Studio ...
- 121
12
votes
1
answer
14k
views
Does DataGrip by JetBrains support PL/SQL development?
JetBrains website displays multiple useful features of their Database IDE, including code generation as per https://www.jetbrains.com/datagrip/features/generation.html; However the website does not ...
- 312
11
votes
2
answers
8k
views
DataGrip Postgres SSL error: sun.security.validator.ValidatorException
DataGrip won't connect to my Postgres instance, but I can connect fine via psql on the terminal:
psql -h dbhost.com reps username
>Password for user... (connects)
However, IntelliJ DataGrip ...
- 28.4k
11
votes
2
answers
13k
views
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 ...
- 121
11
votes
2
answers
8k
views
How do I create a view in JetBrains DataGrip?
I am using an Azure SQL database with DataGrip. I would like to create a view connecting certain tables within my database.
Does DataGrip have a tool for doing this? If so, how can I do it?
It's ...
- 505
10
votes
2
answers
20k
views
How to connect to database through SSH using DataGrip
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
set ...
- 4,971
10
votes
1
answer
19k
views
How to connect to MS SQL Server Express in JetBrains DataGrip?
I'm trying to set up new tool from JetBrains: DataGrip to work with my local install of MS SQL Server 2014 Express. I spent some time trying to "convert" ms connection string to jdbc, but no luck. I ...
- 103
10
votes
2
answers
15k
views
How to run query with parameters in DataGrip?
In DataGrip, how can I pass parameters to SQL query? Say I have a query:
select * from table where date >= ?
Then how can I bind the variable here? When I open the parameters pane, i.e. click the ...
- 213k
10
votes
2
answers
9k
views
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?
- 111
10
votes
3
answers
14k
views
DataGrip - How to learn any table size in DataGrip?
Simple question is that I want to learn table size in DataGrip.Is there any shortcut or a simple way ..
- 362
10
votes
2
answers
15k
views
How can I connect Jet Brains DataGrip to an Elasticsearch instance?
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?
...
10
votes
1
answer
4k
views
How to change number format in DataGrip table editor
I'm wondering, why DataGrip not respecting local number format separators, when editing table values.
Here in Germany our decimal separator is a comma, not a dot. And so I can't use my keypad to edit ...
- 132
9
votes
1
answer
881
views
08006 idea-key-store KeyStore not available
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 in ...
- 489
9
votes
1
answer
3k
views
How can I add Salesforce as a data source in Datagrip?
I use Datagrip for SQL development. Recently I've had to work with Salesforce SQL (aka SOQL), but there doesn't seem to be an IDE as useful as Datagrip.
So: I'd like to add Salesforce as a data ...
- 7,836
9
votes
2
answers
9k
views
Switching PostgreSQL database or Schema in DataGrip JetBrains
Does anybody know how to switch between PostgreSQL databases or schemas in DataGrip (The Database IDE from JetBrains) in the console?
i can do that in Mysql by using:
Use my_database;
I tried ...
- 167
9
votes
1
answer
5k
views
Is there a good way to perform SQL dump of MySQL database in DataGrip?
I'm trying to use JetBrains DataGrip as my primary DB tool. However, I still find myself using SequelPro for SQL Dump. Here is why:
On a database level, I couldn't find any SQL dump functionality. ...
- 264