intellij-idea - Default SQL Server Session for Intellij

Question

When opening a .bdy(/sql/vew/..)-File in IntelliJ, it always greets me with semantic errors for almost every line. That is because it needs a dbsession to check the references against. DataGrip behaves identical.

For reference:

Can I somehow state a default here per file/dir/proj/global?

标签： intellij-ideadatagrip

Answer 1

It's in File | Settings | Languages & Frameworks | SQL Resolution Scopes, here you can specify global Project Mapping to data source/database/schema, or define mapping for any directory/file. in DataGrip setting path will be as follow File | Settings | Database | SQL Resolution Scopes.