Questions tagged [datagrip]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
22 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 ...
1
vote
2answers
149 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." ...
0
votes
1answer
418 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
1answer
58 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
1answer
29 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
2answers
382 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 ...
0
votes
1answer
529 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 ...
0
votes
1answer
1k 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 ...
0
votes
2answers
363 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 ...
0
votes
1answer
98 views

DataGrip commands with non-US keyboard

DataGrip editor has command ⌘-/ to "Comment with line comment", in SQL that means adding -- to beginning of line. On my MacBook Pro with Finnish keyboard, / is located in shift-7. When I press ⌘-...
-1
votes
1answer
393 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 ...
2
votes
1answer
1k 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: ...
5
votes
1answer
2k 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 ...