cannot retrieve materialized view schema from Postgres

[grimbeorn]

Hi All, I need to read from a materialized view (=>MV) in Postgres but when I retrieve the schema no MV appears.

My TOS is 7.3.1 version, postgres user has the rights to see MV.

Is there a problem with the connector? How can I solve it?

[Anonymous]

Hello,

What's PostgreSQL version are you using?

Is it possible for you to use tPostgresqlInput component to read the data from the materialized view in your job instead of using metadata/Db connections wizard?

Best regards

Sabrina

[grimbeorn]

If a use tDBinputPostgreSQL and fill all the fields manually (table name, query, metadata fields...) it works

PostgreSQL version is 11.2

[Anonymous]

Hello,

So far, PostgreSQL Metadata Wizard is not able to recognize materialized views from databases.

Here exists a jira issue: https://jira.talendforge.org/browse/TUP-23681

Best regards

Sabrina