Issue with Materialized Views in PostgreSQL when displayed in DataHub as non-materialized views

Original Slack Thread

Hi. Perhaps you have already encountered a situation when a materialized view in PostgreSQL is displayed in DataHub as view (Materialized=False). I couldn’t find an answer in my search.attachment

Hi, thanks for the heads up - <@U01GZEETMEZ> could you confirm if this is an expected behavior when ingesting postgresql?

Looks like a bug - I think our sql sources assume that all views are not materialized (|[…]tadata-ingestion/src/datahub/ingestion/source/sql/ and the postgres source doesn’t override it

<@U052NDW21LG> Would this be something you’d want to send a PR for?