Jim Gust

Created April 20, 2021 15:35

I ran into the same issue.  What I did was set up an alias in the code completion.

1. Community
2. DataGrip
3. DataGrip - Ignore Database Table Prefix when creating aliases?

• 0 votes

Created April 16, 2021 15:10

I can see where having the schema pattern support regex would be helpful.

1. Community
2. DataGrip
3. "Schema Pattern" Data source template

• 0 votes

Created March 27, 2021 01:41

I thought I would offer some screenshots in the event you were going to go the external tool route.  I did find that the external tool isn't allowing me to pipe in a file so using a batch file as a...

1. Community
2. DataGrip
3. How to export the query results from a Database Manager to a CVS file in SQLite?

• 0 votes

Created February 20, 2021 14:39

Good news, Microsoft finally updated their JDBC driver this month and JB implemented the Azure Active Directory interactive authentication in the latest EAP build for 2021.1.  https://blog.jetbrain...

1. Community
2. DataGrip
3. DataGrip Azure Multi-factor authentication

• 0 votes

Created January 31, 2021 03:51

Those commands are special for the command line shell only.  Lines that begin with a dot (".") are intercepted and interpreted by the sqlite3 program itself. See #3 https://sqlite.org/cli.html 

1. Community
2. DataGrip
3. Why does not Datagrip run ".tables"?

• 0 votes

Edited January 24, 2021 22:20

Miroslav I also work primarily on a DWH but my role is not as an ETL/ELT developer but as a report developer.  Most of my time is spent writing stored procedures for consumers such as Jasper, Cryst...

1. Community
2. DataGrip
3. Datagrip feedback from DWH perspective

• 1 vote

Created January 12, 2021 02:41

In SQLite other, then integer primary key a column can contain multiple data types.   create table TEST_TBL ( ID INTEGER, DESC TEXT, TEST);INSERT INTO TEST_TBL (ID, DESC, TEST) VALUES (1...

1. Community
2. DataGrip
3. Extractor - data stream iterated only once assertionion error

• 0 votes

Edited December 17, 2020 13:31

In the 2020.3 release, the documentation in the extractor header was updated to add getTypeName and isStringLiteral. FORMATTER { format(row, col); formatValue(Object, col); getTypeName(Object, col)...

1. Community
2. DataGrip
3. What objects/functions are available for custom data extractors?

• 2 votes

Created October 15, 2020 12:06

This worked perfectly!  Thank you.

1. Community
2. DataGrip
3. How can I get a list of primary keys for a specified table

• 0 votes

Created September 30, 2020 19:17

Give the In-Editor Results a try and see if it's a better workflow for you.

1. Community
2. DataGrip
3. Multiple query results in the same tab

• 0 votes