Search code examples
intellij-ideadatagrip

Default SQL Server Session for Intellij

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:

enter image description here

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

Solution

  • 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.