mdeshmu opened a new issue, #21080:
URL: https://github.com/apache/superset/issues/21080
I am trying to connect to redshift via redshift_connector using passwordless
IAM Authentication.
It works fine when i directly login to ecs container where superset is
hosted and create/execute the cursor but When i try to create a database
connection from super ui then I am getting ConnectionRefusedError.
#### How to reproduce the bug
1. Go to 'Databases'
2. Choose 'Amazon Redshift'
3. Set SQLALCHEMY URI to `redshift+redshift_connector:///<databasename>`
4. Go to ADVANCED --> Other --> ENGINE PARAMETERS and add following:
```
{
"connect_args":
{
"iam":"True",
"cluster_identifier":"<clusteridentifier>",
"db_user":"<databaseuser>"
}
}
```
6. Click on "Test Connection"
7. See error
### Expected results
Should be able to connect and query to Redshift from Superset UI
### Actual results
ERROR: (redshift_connector.error.InterfaceError) ('communication error',
ConnectionRefusedError(111, 'Connection refused'))
(Background on this error at: http://sqlalche.me/e/13/rvf5)
#### Screenshots
### Environment
- browser type and version: Google Chrome Version 103.0.5060.134 (Official
Build) (64-bit)
- superset version: 1.5.1
- python version: 3.8.12
- node.js version: NA
- any feature flags active: NA
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included
it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version
of superset.
- [x] I have checked the issue tracker for the same issue and I haven't
found one similar.
### Additional context
I can telnet over 5439 to the redshift from ecs container as well as my
local system.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
