Ultimate Database console does not recognize tables

To have completion without qualification by the schema/database in database console please set the default schema for the console. SQL Resolution scope settings are used for resolve and completion in your source code files (sql scripts and sources inside the project).

its selected 

Screenshot shows you have guest set as a current schema. Are you querying tables from this schema?

Ok. I see now. How to change that? 

I dont see option in this pic. There is database selection for me instead of schema.

on new console creation i get

but after first executed statement it is going to not recognized 

It appeared there was a bug. We have just fixed it. The fix will be available in the next DataGrip 2019.3 EAP update: https://www.jetbrains.com/datagrip/nextversion

Andrey Dernov I'm running 2020.1 and connecting to MS SQL (RDS). The database selector in the console window does not allow me to select the schema, only the database. Any ideas?

It is expected behavior for MSSQL, here you can select only target database.

I'm having the same problem - and I don't understand the response.   I'm in sql server - I want to be able to say "select * from blah" - not "select * from dbo.blah".

is your answer.. just.... "no"?  

It's depend on your 'current_schema' setting. By default it is 'dbo', and you can write 'select * from table1' if 'table1' is in dbo schema. If you have other 'current_schema', then you'll need to write dbo.table1.

Here are some details

Also we have an issue about completion for not current_schema.