Share via

Best aproach to refresh materialized views using ADF

Fluna 21 Reputation points
2022-02-23T16:12:28.923+00:00

I would like to ask you guys, which is the best approach to have some materialized views refresh scheduled using ADF? I tried to create a regular pipeline with a Lookup activity inside to run the statement "REFRESH MATERIALIZED VIEW", but I'm receiving this error:

Exception while reading from stream Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

Any thoughts?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,565 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Fluna 21 Reputation points
    2022-02-24T12:45:42.793+00:00

    An update about this. I realized that Lookup activity has a limited timeout of 30s and the only way to increase it is changing that Linked Service connected to it. Adding these new connection parameters solved my problem:

    • Timeout 300
    • CommandTimeout 0

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.