Redshift Materialized view lineage not extracting in Open Metadata v1.11.5

[Prakhar-Mishra1107]

Affected module
Effecting Lineage functionality for redshift connection

Describe the bug
OM V1.11.5 cannot extract lineage from Redshift materialized views, while Postgres sql view lineage works correctly.

To Reproduce

1. Create a redshift materialized views with:

Create materialized view dm.mv_claims Auto refresh as (select * from dm.source_table)

2. Configure OM v1.11.5 connector for redshift

3. Run meta data ingestion

4. Check lineage tab for materialized views

5. Observe : SQl statement is unparsable

Expected behavior
Lineage should be extracted from Redshift materialized views

Version:

• OS:
• Python version:
• OpenMetadata version: 1.11.5
• OpenMetadata Ingestion package version:

Additional context
Using self hosted OM, deployed using kubernetus.

When converted materialized view to regular view it worked

[Prakhar-Mishra1107]

Any updates ?
Will help us plan better