The transfer run has failed : Your query took too much memory to process

My job has been failing for over months. Is there any way to see quert that job is using ?  and those queries should be optimised by me or Supermetric side ?  Or any suggestions are welcome. Thanks.