0

Make column recognition in view work if referencing a manually defined schema

Raphael Mitsch fa 8 anys updated by Adam Mościcki fa 8 anys 1

Can't get column recognition to work if a insert a SQL query in a view's SQL field and refer to tables or views in other schemas. E.g.: If a insert this query in a view's SQL field, the columns get recognized automatically -

select id from some_table

- but if I do this, the parser shows an error message:

select id from some_schema.some_table

Even though some_table has "some_schema" set as it's schema.


Is there a way to get this to work or is it simply a bug/only partly implemented feature?

Answer

Answer

Hello,


Sorry for a late response. We have missed that one.

I think it is a partially implemented feature and works only for `schemaless` views.


Best regards,

Adam Mościcki

Answer

Hello,


Sorry for a late response. We have missed that one.

I think it is a partially implemented feature and works only for `schemaless` views.


Best regards,

Adam Mościcki