topic Re: cannot retrieve materialized view schema from Postgres in Talend Studio

cannot retrieve materialized view schema from Postgres

grimbeorn — Thu, 17 Sep 2020 15:31:22 GMT

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?

Re: cannot retrieve materialized view schema from Postgres

Anonymous — Fri, 18 Sep 2020 08:19:41 GMT

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

Re: cannot retrieve materialized view schema from Postgres

grimbeorn — Fri, 18 Sep 2020 10:32:16 GMT

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

PostgreSQL version is 11.2

Re: cannot retrieve materialized view schema from Postgres

Anonymous — Mon, 21 Sep 2020 03:26:30 GMT

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