Qrew LegendWhat if you try a pipeline step to copy the value of the formula query into a scalar field. Then use the scalar field in the real Pipeline. The copy could be done by making a bulk upsert and adding the Bulk upsert rows one by one, then commit the Pipeline. maybe that way it only has to calculate the formula queries record by record and it won't time out.
You may be able to copy your existing pipeline and then use the new pipeline designer interface to insert steps before your main pipeline steps.
At face value you might try a Table to Table Import instead of processing it through a Pipeline, but your actual error relates to a formula query execution. Are one or several of the fields that you're moving between field sets formula queries? Have you optimized those fully or is there a way to not use formula-queries?
