DataGrip does not show tables under schema

Hi,

I have configured my database in DataGrip and everything works fine except that I cannot see the tables under schema. I have similar configuration for other database, which has no problem at all. Is there any setting I missed?

As you can see in the screenshot, tables show up in the database "Snapmobile". However, nothing show up in "Pixels Redshift". Both databases are AWS Redshift.

Thanks!

 

12
89 comments
Avatar
Permanently deleted user

This is an extract of the logs I get when trying to synchronise

2017-07-05 11:13:07,874 [ 693518] WARN - appers.DatabaseMetaDataWrapper - ERROR: type "e" does not exist 
java.sql.SQLException: ERROR: type "e" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:231)
at org.postgresql.jdbc.PgDatabaseMetaData.getTables(PgDatabaseMetaData.java:1248)

The list continues by more and more lines. 

0
Avatar
Permanently deleted user
0

@Ivan Santini Hi,
Could you specify a database you're trying to connect to? Could you specify driver and dialect you're using for connection?
Thank you.

 

0
Avatar
Permanently deleted user

Thanks Vasily,

I am trying to connect to a Redshift db via a PostgreSQL driver.

Inside the connection settings I have tried all possible PostgreSQL drivers (Latest version, 42.1.1, 9.4-1212, 9.4-1201) and also the Redshift drivers.

Screenshot here attached. Hope this helps!

Ivan

0

@Ivan Santini Hi,
We implemented better Amazon Redshift support in DataGrip 2017.2. Now you can try to install the latest DataGrip 2017.2 EAP. More details about Redshift support https://blog.jetbrains.com/datagrip/2017/05/25/we-open-datagrip-2017-2-eap/ and you can download free trial version here https://www.jetbrains.com/datagrip/nextversion/
Thank you.

0
Avatar
Permanently deleted user

Thanks again tons Vasily!

The EAP version works!

I can see it is valid until 29th July. Will it be released as a normal update on that day?

0

@Ivan Santini Hi,
It'll be available in coming DataGrip 2017.2.
Thank you. 

0

I'm trying to connect to a standard Heroku db in both Datagrip and IntelliJ, but no matter what I do, I can't get the tables to show up. I've tried all suggestions in this thread.

0
Avatar
Permanently deleted user

Same problem with 2017.2.2 and remote Postgres (localhost seems fine), super annoying...

The one connection allows me to run Sql commands against all the schemas and tables, but the Database tool window will not show any of the schemas and tables except the default 'postgres' schema.

0

@ Seba Illingworth 
Hi,
You need to add schemas to your introspection scope.
Thank you.

0

@vasily, I've been trying this for a year now. None of your solutions work, including introspecting the schema. On another note, if that's required, why isn't it on by default.

Because of these limitations, we avoid using Jetbrains for any kind of database interaction, which is frustrating.

1

@e

>> On another note, if that's required, why isn't it on by default.
In case you've got more than 100 schemas, do you suppose to retrieve all of'em?

>> Because of these limitations
Could you describe your problems in details?

Thank you.

0

@vasily - I'm not sure. I do know, though, that Datagrip/IntelliJ is the only db client that makes connecting to the database so onerous. When I use clients like Navicat, I can easily get a list of the databases, tables, etc without having to manually set introspection settings, etc. I'm not sure how they handle this technically, but this is even on pg servers that have thousands of databases. (E.g. Heroku free tier db servers)

0

Same experience as e. This is really frustrating because I hate SQL Management Studio, but DataGrip is just not up to scratch.

0

@e Perhaps the implement lazy tree, once you o[pen the node, you see the content. Why we have no this possibility? Because of code completion: we index everything in your server to have code completion work really really fast (as you can see). That's why lazy variant is not implemented. But it is the thing to consider, I agree.

0
Avatar
Permanently deleted user

Same problem with MS SQl, surprisingly with localhost db everything works fine and tables under schema can be observed.

At the same time, tables are not visible if to connect to remote server, as a consequence IntelliSense doesn't work.

0

Hello, Ivan! Let's start from upgrading to the latest version which is 2017.2.3.

0
Avatar
Permanently deleted user

Does DataGrip support external tables in Redshift? I can't see it under schema's tree. However I can query against such tables.

 

DataGrip 2017.3.7 Build #DB-173.4674.7, built on February 27, 2018 ...

2018 JRE: 1.8.0_152-release-1024-b15 amd64 JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o Linux 4.4.0-116-generic

 

0
Avatar
Permanently deleted user

Not sure if this is intended functionality, but it looks like with SQL Server, if you connect to a database server without specifying a database, you only get the default schemas (dbo, and some other system schemas).

However, if I setup a connection and include the specific database in the configuration, I am able to see all the schemas. 

0

@Tyler Hartwig
You need to Refresh tree on a desired db if it's not specified in connection:

 

=>

Does it help?

0
Avatar
Permanently deleted user

@vasily chernov

 

I tried this this morning, and when I initially setup the database. I get the same result, however other user created schemas exist in the database which do not display, and all that appears is the system created schemas. 

does your database have other schemas outside of dbo?

 

 

0
Avatar
Permanently deleted user

Hello,

I have same problem, but I have MS SQL databases.

My solution: Right click on datasource -> on floating menu click: "Properties" (dialog appears).

On the dialog choose the "Schemas" tab. There I check the right database and schema (under databse leaf), result: tables are shown.

0

@Tyler Hartwig & @Peter Varsanyi our quick steps guide should help you https://www.jetbrains.com/datagrip/quick-start/

1

I have the same issue, but it seems when I connect to Microsoft Azure databases the sync does not fully work.

In the schemas tab I see the correct list, however, it is not pulling all of the tables.

Incorrect list of tables

This is how it looks in SQL Management studio and all of the correct tables are listed:

 

0

@Daniel Divita

Are you sure that you use the same credentials? 

0

I am positive and check it several times. 

My version Info:

DataGrip 2018.1.3
Build #DB-181.5087.19, built on May 16, 2018



0

Oh, thanks. let's try to check on the latest version: 2018.3 https://www.jetbrains.com/datagrip/download/

0

Getting this same issue on DataGrip 2018.3.2 . I'm running PostgreSQL locally and am unable to see my table. It was working fine and first and now just stopped. Bad timing on my side, I've been trying to convince my company to buy jetbrains products and my manager was not impressed -_-

0

Please sign in to leave a comment.