2 回答
- 最新
- 投票最多
- 评论最多
1
Hi Jeevan,in general,
UID - Redshift DB User name
PWD - Password for the Redshift user UID.
User - Username of the user in your IDP when using IAM authentication (And can be used instead of UID when using standard authentication).
Password - Password of the user in the IDP (And can also be used instead of PWD when using standard authentication)
Ideally, using UID and PWD should work. I would start by checking the JDBC logs (https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-configuring-logging.html#jdbc20-using-log-files) to identify the issue.
已回答 10 个月前
0
Hey Jeevan!, Greetings.
Sorry to say, I am not totally aware JDBC connections. But these are few points to help you out:
- Authentication and SSl
- Cluster url can help you with connection. Example: jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev
- Confirm JDBC driver version
- try sql ini file
Hope this helps,
已回答 1 年前
相关内容
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 1 年前
Hi, I did try to logging errors, it seems like driver is taking default properties ie (windows login) . user it taking precedance over UID. UID get's override. Is there any thing like, If we don't provide user, then driver takes our windows login user?
No, the UID does not have any default value. Are you trying to use SAML authentication with an IDP? In that case, You would have to verify your driver settings and the settings in your IDP.