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/21 12:57:15 UTC
[GitHub] [superset] kapilgarg83 opened a new issue #17182: Superset with Athena connection
kapilgarg83 opened a new issue #17182:
URL: https://github.com/apache/superset/issues/17182
Hi,
Facing issue in connection with Athena
using PyAthena
created the connection string
__awsathena+rest://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}__
Now the problem is {schema_name} parameter is not working
Ii am not able to connect to a particular DB or scheme it's always connected to a default data source from my Athena
Kindly suggest
--
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] morokin commented on issue #17182: Superset with Athena connection
Posted by GitBox <gi...@apache.org>.
morokin commented on issue #17182:
URL: https://github.com/apache/superset/issues/17182#issuecomment-1029350697
Hi, I can confirm somehow similar behavior. There are multiple datasources configured in our AWS Athena, up on configuring database in superset in a form of:
`awsathena+rest://key:secret@athena.us-east-1.amazonaws.com:443/schema?s3_staging_dir=bucket&work_group=some_group`
I can successfully establish (test) connection, however when I'm trying to create dataset - Superset showing schemas only from first Athena datasource (AWS Glue) so far I wasn't able to make it choose somehow other Athena datasource
--
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] youcefjd commented on issue #17182: Superset with Athena connection
Posted by GitBox <gi...@apache.org>.
youcefjd commented on issue #17182:
URL: https://github.com/apache/superset/issues/17182#issuecomment-955099605
Hi kapilgarg83 - can you please explain how you made the connection work? I tried, but I always face an error. I used PyAthena as well.
--
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] youcefjd edited a comment on issue #17182: Superset with Athena connection
Posted by GitBox <gi...@apache.org>.
youcefjd edited a comment on issue #17182:
URL: https://github.com/apache/superset/issues/17182#issuecomment-955099605
Hi kapilgarg83 - can you please explain how you made the connection work? I tried, but I always face an error. I used PyAthena as well. `awsathena+rest://@athena.us-east-1.amazonaws.com/?s3_staging_dir=s3://superset-output-workgroup/output-athena/` is my URI, and the error I get is: `An error occurred while creating databases: Connection failed, please check your connection settings`. I am not using the key/secret key because I am using a role in IAM.
--
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