Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [datagrip]

DataGrip is a cross-platform IDE for databases & SQL by JetBrains

23 questions
6
votes
1 answer

Null instead '0000-00-00 00:00:00' in mysql 5.7

Before: mysql 5.6. One of the columns in the table is created as follows: `f_stamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' When i view this field in mysql client or using DataGrip, this field is displayed correctly. Now: mysql 5.7. The…
isnullxbh
  • 163
  • 2
  • 7
4
votes
1 answer

DataGrip shows a time substantially slower than EXPLAIN ANALYZE

I searched alot for the answer to my question. I have a table with 134 rows and 4 rows. My EXPLAIN ANALYZE says the execution time was: 0.038ms. But the actual execution time (using DataGrip) was: 123ms A complex query with multiple joins shows…
Ferhat Sayan
  • 141
  • 1
  • 5
2
votes
1 answer

Datagrip issues for Oracle 19c database

I've used Datagrip for a while with both SQL Server and MySql, but the experience with Oracle has been very different so far. I'm having issues with a lot of basic features I took for granted with the other databases I've worked with. There is…
Øystein Seel
  • 141
  • 4
2
votes
1 answer

How to connect Datagrip with AWS Athena using an assumed role?

I am able to make Athena queries through the AWS CLI. This requires me to assume a role first (I use awsume). The role requires MFA. Now I want to configure Datagrip for this as well. However there are two options for authenticating: User/pass - I…
Haterind
  • 151
  • 1
  • 5
2
votes
2 answers

DataGrip Issue Load Data Local Infile

I am having trouble using the LOAD DATA LOCAL INFILE statement in Datagrip. Suppose I have source_data.csv such as: rating,statement -2,"I'm hungry!" 5,"I'm satisfied." 1,"Ok, but could be better." After running the following code block in…
Vivek Jha
  • 155
  • 6
2
votes
2 answers

How to set "PRAGMA foreign_keys = ON" each time I'm connecting to sqlite db via Datagrip

In my pet project I'm working with small sqlite db and I've just came to realization that, in order to ON DELETE CASCADE actually do the thing, I need to set PRAGMA foreign_keys = ON each time I'm connecting to db. However I'm using Datagrip and…
shabunc
  • 767
  • 2
  • 6
  • 10
1
vote
2 answers

DataGrip showing prints during a transaction

I have a long running update query, for this reason I used the old well known trick of dividing the query in smaller chunks of 1000 to be print the status of the query and calm the anxiety. Unfortunately DataGrip seems to write to output all the…
s.demuro
  • 303
  • 1
  • 5
1
vote
1 answer

How to view query history in datagrip when the icon is not available?

On the datagrip website: On the toolbar of every console there is a button. Press it to see the history of all the queries which were run against this data source. Speed search also works! Also, don't forget about the Local History of each…
Daan
  • 167
  • 2
  • 8
1
vote
1 answer

Moving a large table from Localhost to remote server

Postgres 11, Windows 10, pgAdmin 4 I have a large post-gis enabled table (29million rows, 20GB + a 5GB spatial index) stored on my local machine (localhost). I want to move this table to an AWS hosted server instance (also Postgres). The table has 2…
Theo F
  • 151
  • 1
  • 1
  • 8
0
votes
1 answer

Connection rejected based on ACL filtering, but the ACL is disabled?

I'm trying to connect to an Oracle Cloud database through DataGrip (with JetBrains's instructions) but I'm getting an error: DBMS: Oracle (no ver.) Case sensitivity: plain=mixed, delimited=exact [66000][12506] ORA-12506: TNS:listener rejected…
andyinnie
  • 1
  • 2
0
votes
0 answers

Describe table from Athena data source in DataGrip fails

Whenever I attempt to Describe an AWS Athena table in DataGrip it fails. The error states that is is a permissions error but I am fairly certain it is not. In fact, I can describe tables using SQLWorkbench/j and the Athena console without issue. It…
Mattboy91
  • 1
  • 1
0
votes
1 answer

Cannot connect to a pluggable database via IDE

I have an Oracle XE database on computer1. When I try to connect to it via sqlplus from computer2, it works fine, for both cdb and pdb connections; e.g.: rlwrap sqlplus timon@//192.168.0.115:9121/xepdb1 …
Timofey Pasichnik
  • 3
  • 1
0
votes
1 answer

Communications link failure SSH Tunnel on Datagrip

I need to connect RDS through SSH for now(Local -> EC2 -> RDS). So I tried to connect MySQL via SSH Tunnel option on Datagrip, however, It cannot connect to server. [08S01] Communications link failure The last packet sent successfully to the server…
Minkyu Kim
  • 127
  • 3
  • 10
0
votes
0 answers

Datagrip connecting to databases on launch

I'm using Jetbrains Datagrip to connect to Mysql servers. My problem is that Datagrip connects to the various databases I created as soon as I launch it. That's not a problem with development databases, but I really don't want that for production…
Alexis Dufrenoy
  • 101
  • 3
0
votes
2 answers

MySQL configuration. Query doesnt get returned result (DataGrip, DBeaver, PHP). Something times out

I am running a simple INSERT INTO ... SELECT ... ON DUPLICATE KEY UPDATE ... query using either DataGrip or DBeaver or PHP and it always doesnt register the result. The SELECT inside takes about 10 minutes and the query always completes (the table…
honzaik
  • 101
  • 2
1
2