I am not sure if there is a mechanism for specifying Presto session variables from TD when foreign server is used.
Though, even if that is possible you cannot increase memory limit in Presto using session variable on per-query basis.
Session variable only allow you to decrease the limit.
So only option you have is to change configuration of Presto cluster and restart it.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.