Set default database and schema for a project

Answered

Whenever I open up a DB project in Datagrip, it always sets the search path to <schema>: 

 

How can I have the project default to the correct database and schema whenever I open it, like so?

 

I have scoured through all of the settings panels, and still cannot find it. I would like to have each project set up to default to its own database and schema.

2
7 comments

You need to set Automatic here

2

That did the trick, although it did take a bit of searching to find this particular screen.

Many thanks!

0

Hey, no apology needed! I am just very gratefuul that you answered my question so quickly; it is MUCH appreciated!

0

So where exactly is that screen?

0
Avatar
Yuriy Vinogradov

ExTexan it's in Data Source properties -> Options tab.

0

What worked for me was to disable the schemas of the other databases:
Data Source properties -> Schemas -> uncheck the schemas you don't need

0

Please sign in to leave a comment.