Luckily Naren sankar (solution architect) from Dremio came to our office yesterday and today we connected and he helped me to figure it out . The issue is in host field I need to type “localhost” not the private IP of EC2 instance and it worked fine . Thank you for your help though .