"Unable to resolve column" inspection error in DB console

Database console does not need path mappings - it is automatically uses the it's own data source configuration for searching the schema. 

Make sure you have selected the default schema for the sql console: https://www.jetbrains.com/help/datagrip/schemas.html#selecting_schema

If issue remains, attach screenshots describing the problem.

OK, here you go. You can see the red highlighting for all the "not found" errors - table names and columns - and you can see the schema is selected:

Schema is selected but there are no db objects. Please follow steps 2 and 3 from https://www.jetbrains.com/help/datagrip/cannot-find-a-database-object-in-the-database-tree-view.html

OK cool! That sorted it out. DB2 is obviously a different beast from mysql, mariadb, sql server or oracle.

I have a similar issue when using a MySQL/MariaDB. I have a generic PHP script that uses either a SELF::CONSTANT_DB_NAME or SELF::CONSTANT_TABLE_NAME or a $variable_db_name or $variable_table_name when building the required queries. The PHP script loops over and array of SQL statements. 

"PostSQL" => array(
 "INSERT into $dbTo.GroupInfo (pl.pgNum, pl.plPUNum) SELECT '3', 'pl.plPUNum' FROM $dbTo.ProductList pl " .
 "WHERE pl.plPUNum REGEXP 'YourNameHere';",
)

In this snippet, it complains that 'Unable to resolve pl' if the 'pl' is removed then it cannot resolve the column names:

"PostSQL" => array(
   "INSERT into $dbTo.GroupInfo (pgNum, plPUNum) SELECT '3', 'pl.plPUNum' FROM $dbTo.ProductList " .
   "WHERE plPUNum REGEXP 'YourNameHere';",
)

These statements work as expected, but PHPstorm can't resolve the columns. If the table name is directly specified, then it works as expected.

https://youtrack.jetbrains.com/issue/WI-43882 looks related.

I have the scopes correctly set as.  The issue is that PHPStorm does not seem to parse the table name as a variable.

$dbTo.tableName and associated column names are not correctly identified.

If in the above example is the variable $dbTo replace with the correct table name then all is good:

"PostSQL" => array(
   "INSERT into MyDbName.GroupInfo (pgNum, plPUNum) SELECT '3', 'pl.plPUNum' FROM MyDbName.ProductList " .
   "WHERE plPUNum REGEXP 'YourNameHere';",
)

Maybe someone could help me on this thread. I too get the "Unable to resolve column" inspection error in DB console on PyCharm 2021.1.1. I am using Snowflake. I have made sure that the necessary schemas are selected and I can see them in the inspector. The column name is plainly visible in the inspector. Not sure what I am doing wrong, or if this is simply a bug:

@... you need to properly configure File | Settings | Languages & Frameworks | SQL Dialects  & File | Settings | Languages & Frameworks | SQL Resolution Scopes  for project(or file), then they will be resolved.

Thank you @... for replying. Do you see anything I should be doing differently?

Note that the partially obscured Path is to the root of my Python project in both cases, and the proper databases and schemas are selected for Resolution Scope.

I'm open to any other suggestions. I am finding it ever so frustrating that I haven't been able to solve this.

the issue is that you have {table} parameter in query, and it does not work properly. I mean, even if this variable is declared somewhere above, it just won't be recognized in SQL injection.

@..., that was indeed the issue. Thanks!

@Yuriy Vinogradov is there any way to solve this issue keeping the table name inside a variable? Thanks!

Martini Giulia94, if you have the same problem and SQL is injected into some files, then there is no way to keep the table name inside a variable.