How to access Hive on Private subnet AWS

Hi,

I am trying to connect hive server hosted on AWS ec2 machine which is in private subnet. I am using bastion host and tunneling process to connect to hive in sql-workbench and tableau. when i am trying to do the same process in snaplogic its not working. Can any help out with this issue.?

Regards,
Venkat