Questions tagged [datagrip]
DataGrip is a cross-platform IDE for databases & SQL by JetBrains
23
questions
0
votes
1
answer
38
views
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
[...
0
votes
0
answers
99
views
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 ...
1
vote
2
answers
218
views
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.
...
- 303
0
votes
1
answer
440
views
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/...
1
vote
1
answer
1k
views
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'...
- 157
0
votes
1
answer
3k
views
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 ...
- 127
0
votes
0
answers
159
views
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 ...
- 101
0
votes
2
answers
249
views
MySQL configuration. Query doesnt get returned result (DataGrip, DBeaver, PHP). Something times out [closed]
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 ...
- 101
0
votes
1
answer
433
views
Why DataGrip automatically creates Foreign Key relation when 'table_id' column is added [closed]
Not long ago I started using DataGrip from Jetbrains, I am using postgres
when I add column 'table_id' foreign key relation is automaitcally is created between tables, though I didn't add any FOREIGN ...
- 3
1
vote
0
answers
354
views
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 ...
- 131
2
votes
1
answer
3k
views
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 ...
- 141
0
votes
1
answer
442
views
Incorrect string value: '\\xD0\\xA2\\xD0\\x9E\\xD0\\x9E...' for column Username in MySQL DataGrip specific
I know that such error can be caused by incorrect character set applied to some table, but in my case it's a bit different:
I have some procedure with select, create temporary table and cursor...
The ...
- 101
2
votes
2
answers
1k
views
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."
...
- 153
0
votes
1
answer
1k
views
How can I connect to an Oracle Autonomous Data Warehouse with a 3rd party IDE (DataGrip)?
I'm trying to connect to a Oracle Autonomous Data Warehouse database with Jetbrains DataGrip. Oracle provides me with a wallet file (a zip), with contains tnsnames.ora, a keystore, ojdbc.properties, ...
0
votes
1
answer
530
views
Login failed for User 18456 State 5. User id works on other machines
I have a really weird login issue I've been pursuing. I experience this only on my Macbook Pro (2018) and only when logging into this one specific SQL Server 2016 database directly through a database ...
0
votes
1
answer
213
views
postgres function definition not saving top whitespace
For reference I am running postgres 9.6 . I'd like to write functions inside of postgres where the top of the function saves.
create or replace function
apqp.apqp_list_gentex_tool_report_getlist(...
2
votes
2
answers
1k
views
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 ...
- 737
1
vote
1
answer
2k
views
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 ...
- 141
0
votes
1
answer
6k
views
Datagrip EXPLAIN ANALYZE Gui?
In Datagrip (using 2018.2.4), you can right-click on a query and choose 'Explain' which gives nicely formatted output. Is there anyway to get this nicely formatted output using instead 'Explain ...
- 103
0
votes
2
answers
559
views
PostgreSQL Select statement produces errors in datagrip but not pgAdmin4
I can run the following script without errors in pgadmin4
SELECT * from tbl
I have tried the following in datagrip
SELECT * from tbl
and
SELECT * from public.tbl
Neither of the above scripts ...
- 111
-1
votes
1
answer
482
views
OS X 10.12 // Setting up mySQL server // JetBrains DataGrip
I am a novice beginning to learn SQL. I have gone through tutorials on how to set up mySQL server, and am trying to use DataGrip as well. When I try to connect DataGrip to the mySQL server, it says my ...
- 1
4
votes
1
answer
2k
views
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: ...
- 141
6
votes
1
answer
4k
views
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 ...
- 163