How to access Hive on Private subnet AWS


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.?