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 (https://github.com/datahub-project/datahub/blob/843f82b943b48c2e340cdb643b44fd97443a062c/metadata-ingestion/src/datahub/ingestion/source/sql/sql_common.py#L976|https://github.com/datahub-project/datahub/blob/843f82b943b48c2e340cdb643b44fd9744[…]tadata-ingestion/src/datahub/ingestion/source/sql/sql_common.py) and the postgres source doesn’t override it

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