Issue with data copy using pipeline from on premisses gateway

I suggest trying these steps:

1. First, run the same query directly in a SQL tool to see how long it takes. If it's slow, try improving the query or adding indexes to speed it up.
2. Adjust the timeout settings in your gateway, or try using a temporary storage method (staging) during the copy.
3. Instead of copying everything at once, only copy new or changed data using a filter like `WHERE modified_date > last_loaded_date`.
4. Break the data into smaller parts using batching or splitting by columns if possible.
5. Consider using Dataflow Gen2 or a Data Pipeline with a Lakehouse as a temporary step, and turn on caching or staging options.
6. Lastly, increase the number of retry attempts and give it more time before it times out.