CODEWITHSUNDEEP
sqloracle-databasedatagrip
Oliver
Oliver

Reputation: 604

Resolve Symbols in Datagrip

I have a DWH with a few schemas. I always have to use tables and views from different schemas to combine them for new views. This is done in a REPORT schema that has all the synonyms to almost all the tables and views in the other schemas. All those tables and views also have privileges granted to REPORT.

Whenever I make a reference to a different schema then REPORT, Datagrip is not able to resolve that reference, stating that it is "Unable to resolve symbol.."

I am not sure, whether this is needed for the referencing or not, but I have database connections in the project to all schemas.

Let's say, I need col1 and col2 from a table srctable located in a schema DATA. I do all the code in the schema REPORT.

I have tried code like

SELECT 
  col1,
  col2
FROM
  srctable

And also

SELECT 
  col1,
  col2
FROM
  DATA.srctable

Since I get the data from the query, everything seems to be set up right. But I want to utilise the power of Datagrip and it is annoying I can not get the references to work.

Upvotes: 2

Views: 1064

Answers (1)

Vasilii Chernov
Vasilii Chernov

Reputation: 1464

You need to choose destination schemas in database tree for completion to work.

resolve

Upvotes: 1

Related Questions