I'm using v 2021.3.4 of JetBrains. I connect to hosted in AWS. The database has 28 tables, though only fifteen (15) are displayed in the Database Explorer.
Interesting thing is, I can see all the tables if I go to "show visualization":
So far this is my only workaround to get to any of the 'hidden' tables, as the visualization window allows me to right-click and select "jump to source", from there I can work on the table or switch to "edit-data" if needed:
This would be an acceptable workaround if the table names and column names were recognized and hopefully auto-populated with the DataGrip interface, but instead, I get the red-underlined table names in my .SQL with errors displayed saying that:
Just to clarify, executing my queries actually works and I get the expected result. The problem is that I compose my queries in the blind.
Things I've tried:
- refreshing the list of tables.
- disconnecting and reconnecting to the live database.
- searching for a possible solution in here, on the StackOverflow website.
Anything else you would recommend me to try?
Thank you,
[May 1, 2022]: Upgraded DataGrip to 2022.1.2, removed some tables, down to 21 total, still limited to 15. Some more details, in case this becomes a question: MacOS v11.2.3 (BigSur), 16-core Intel-based CPU, 64Gb Memory
