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!

 

85 comments
Comment actions Permalink

@Brunaodo can you share a screenshot, please? The schema is checked, the table is there, everything is fine on the database side, right?

Anyway, after making a screenshot please try to Forget Cached Schemas and resync.

0
Comment actions Permalink

Hi Maxim, I removed out the connection and reconnected and now it's working fine. I don't think there is a problem with the schema, I can connect to it using PgAdmin just fine, execute queries etc. I will take a screenshot if/when it happens again. Thanks

1
Comment actions Permalink

After upgrading to 2018.3, I experienced the same thing with SqlServer. That was a while ago. It forgot the schemas, noted by the"..." in the attached image.. I refresh them as I need them and all is good with with the world.

0
Comment actions Permalink

DataGrip 2018.3.3
Build #DB-183.5912.12, built on February 19, 2019

JRE: 1.8.0_152-release-1343-b28 x86_64

JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o

macOS 10.14.3

PostgreSQL 9.6

_________________________________________

I have a smilar issue.

The tables list is not refreshed when I click on "Synchronize" in DataGrip.

My schema is always changing on my local database due to the fact that I work with different versions of my application and my database migrations are applied on each build according to the version that I am working on.

And yes, I am 100% sure that the tables are actually there because if I select something from the tables that are not displayed in the left panel in DataGrip (under schema/public/tables), the query result is displayed as expected in the console in DataGrip.

0
Comment actions Permalink

Shouldn't' happen!  It only happens with third-party created tables, right?

Please, continue in the issue: https://youtrack.jetbrains.com/issue/DBE-7908

 

0
Comment actions Permalink

Yes, I meant that, Please write this in the issue. 

1
Comment actions Permalink

post deleted - turns out someone gave me a bad object filter

0
Comment actions Permalink

I have the same problem,I follow the instructions and clean up the cache, but it gets stuck in one place。version 2019.1.1,but I can query with SQL

1
Comment actions Permalink

Hello everybody! This topic seems to be the collection of different problems that look similar. I will kindly ask you to create an issue in the tracker every time you don't see objects in the schema.

This will help us and also you will be able to track the process.

Thanks!

0
Comment actions Permalink

My problem is solved!Method is

1.

2.

3
Comment actions Permalink

Yao Rp, this is not a solution, but a workaround. Please, create a bug in our tracker: https://youtrack.jetbrains.com/issues/DBE
We need to understand what's going on!

0
Comment actions Permalink

I have the same problem in 2019.

Sometimes no tables will be displayed under public on Postgres. If I REMOVE the connection and connect again, it sometimes work.

This problem is making it very complicated to keep using DataGrip =(

0
Comment actions Permalink

@ Andre Pena 
Could you describe your environment and steps to reproduce the issue?

0
Comment actions Permalink

same issue happening with me.

 

I've two different docker containers both has same database one has a previous version and the 2nd has a new one. On new database I created a couple of new tables now whenever I switch container instead of sync I have to delete the old connection and create a new one.

 

1
Comment actions Permalink

@Moeen Basra,

>I've two different docker containers both has same database one has a previous version and the 2nd has a new one. On new database I created a couple of new tables now whenever I switch container instead of sync I have to delete the old connection and create a new one.

In your case there is `Forget Cached schemas` or `Force Refresh` actions are suitable.

0
Comment actions Permalink

I had this problem, latest version of DG with a connection to redshift.  The main issue is the introspection fails and the tables are never shown.  I can query them and use them but not see them.  To fix this, go to connection properties -> "Auto Sync All Schemas"  and uncheck "use pre-inspected objects for system catelogs that are not introspected" and check "introspect using jdbc metadata".  Then apply, okay, and refresh the data connection. 

2
Comment actions Permalink

Marc, if that's possible, please send SQL logs to datagrip@jetbrains.com, we will investigate.

0
Comment actions Permalink

Getting the following in DataGrip 2019.3 (Redshift database with driver 1.2.36.1060)

Error encountered when performing Introspect database prod schema pg_catalog (details): [Amazon](500310) Invalid operation: syntax error at or near ")"
Position: 584;.
[Amazon](500310) Invalid operation: syntax error at or near ")"
Position: 584;
and 1 duplicate reports (17 s 185 ms)

Consequently, the displayed schema is out of date.

-----

After paying attention ;) the workaround in Marc's comment above seems to have worked for me. 

I'm not sure if or what logs you might want, but happy to send if helpful.

0
Comment actions Permalink

Robert Park,

Regarding your issue follow https://youtrack.jetbrains.com/issue/DBE-9436

At the moment we've got compatibility issues with the latest Redshift JDBC driver.

0
Comment actions Permalink

This issue exists under Pycharm 2020.3.2 where not all tables are visible under schema. I only checked this with Redshift driver JDBC42-1.2.43.1067 with Java SDK

0
Comment actions Permalink

Hi There,

I'm experiencing a similar issue here. Table names are not populating under schema:

0
Comment actions Permalink

Atharva Inamdar

Please, update IDE to the latest version where Redshift JDBC driver v.2 is available.

0
Comment actions Permalink

Jayer,

Are you using Redshift JDBC driver for PostgreSQL engine over localhost? Could you try to user dedicated PostgreSQL JDBC driver for it!

0
Comment actions Permalink

vasily chernov

I upgraded to version 2021, and the problem seems to have been resolved.

1
Comment actions Permalink

Jayer,

Great! Thank you for update!

0

Please sign in to leave a comment.