Impersonation / Delegation is possible against Hive / Impala
Redshift allows a round-about of doing impersonation - by dynamically generating temporary IAM-based usernames and passwords. With some extra work on Tableau's part (no ETA), this mechanism can probably be leveraged to allow impersonation against Redshift, too.
Thanks Russell, Hope giving access to IAM to all Users wouldn't be a feasible solution & BTW we would be integrate IAM with Tableau server credential since already configured to AD, Federated SSO through SAML IDP is good to hear but it require System configuration change (will try for it).
Cool to see the impersonation option available over Hive and impala.