Hi
In Azure Data Factory, we have a lookup activity with an SQL Database.
There are config items on the general tab of the activity for timeout/retry/retry interval.
In the settings tab, there is a "Query timeout (minutes)" config item.
Can we have some clarity on the two timeout please and best practice? For example, one would assume it is best practice to set the "Query timeout (minutes)" to be lower than the activity timeout value?
We would like to ensure that your basic sql query timeout get handled correctly with opportunity to retry according to the retry config items against the activity.
