You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/10/29 23:26:31 UTC
[GitHub] [superset] youcefjd opened a new issue #17295: Unable to Connect to Amazon Athena
youcefjd opened a new issue #17295:
URL: https://github.com/apache/superset/issues/17295
Hi - Superset is unable to connect to Athena. I created a role in IAM that has Athena full access and attached it to the EC2 instance running Superset. However, when I try to login, using this connection string (URI): `awsathena+rest://@athena.us-east-1.amazonaws.com/?s3_staging_dir=s3://bucket/output-athena/` it gives me this error when I check the logs in the UI:
`db_creation_failed.DatabaseTestConnectionFailedError`
I checked CloudWatch, and the attempt to connect doesn't generate an error. I tried modifying the URI by including the key/secret key, but nothing works. I systematically get this error: A`n error occurred while creating databases: Connection failed, please check your connection settings`
Help, please!
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] amitmiran137 closed issue #17295: Unable to Connect to Amazon Athena
Posted by GitBox <gi...@apache.org>.
amitmiran137 closed issue #17295:
URL: https://github.com/apache/superset/issues/17295
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] eschutho commented on issue #17295: Unable to Connect to Amazon Athena
Posted by GitBox <gi...@apache.org>.
eschutho commented on issue #17295:
URL: https://github.com/apache/superset/issues/17295#issuecomment-956998444
You may be redacting your string for security, but are you including everything that is here in this example:
https://superset.apache.org/docs/databases/athena
`awsathena+jdbc://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}&...`
I didn't see the access key id and key for example in your URI. You may also want to try putting the port after `amazonaws.com` (port 443 is the default for https)
We're in the process of building out forms for each db to make this process easier.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] eschutho commented on issue #17295: Unable to Connect to Amazon Athena
Posted by GitBox <gi...@apache.org>.
eschutho commented on issue #17295:
URL: https://github.com/apache/superset/issues/17295#issuecomment-956998444
You may be redacting your string for security, but are you including everything that is here in this example:
https://superset.apache.org/docs/databases/athena
`awsathena+jdbc://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}&...`
I didn't see the access key id and key for example in your URI. You may also want to try putting the port after `amazonaws.com` (port 443 is the default for https)
We're in the process of building out forms for each db to make this process easier.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] eschutho commented on issue #17295: Unable to Connect to Amazon Athena
Posted by GitBox <gi...@apache.org>.
eschutho commented on issue #17295:
URL: https://github.com/apache/superset/issues/17295#issuecomment-956998444
You may be redacting your string for security, but are you including everything that is here in this example:
https://superset.apache.org/docs/databases/athena
`awsathena+jdbc://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}&...`
I didn't see the access key id and key for example in your URI. You may also want to try putting the port after `amazonaws.com` (port 443 is the default for https)
We're in the process of building out forms for each db to make this process easier.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org