Delta Sharing with Materialized View - recepient data not refreshing when using Open Protocol

ittzzmalind
New Contributor III

Scenario: Delta Sharing with Materialized View

Provider Side Setup :

->A Delta Share was created.

->A materialized view was added to the share.

->Recipients Created

-> 1). Open Delta Sharing recipient

       Accessed using Python (import delta_sharing)

->2). Databricks-to-Databricks recipient

      Accessed directly from another Databricks workspace

Initial Behavior 

Both recipients executed a SELECT query on the shared materialized view.

Result: Both returned the same (correct) data.

After Data Update

Source data for the materialized view changed.

The materialized view was refreshed, and new records were added.

Observed Behavior at Recipient Side

Recipient Type                            -- Result After Refresh

Open Delta Sharing (Python)     -- Returned old data only

Databricks-to-Databricks            -- Returned updated data (including new records)

Now created another recipient at provider for Open Delta Sharing (Python),  with this recipient the code run at python and results returned correctly with new added records.

tried removing materialized view from share and add it back but not working ? why behaving like this is this correct behavior ? any method to solve this??