search

apache / superset

Apache Superset is a Data Visualization and Data Exploration Platform
https://superset.apache.org/
Apache License 2.0
62.06k stars 13.61k forks source link

Superset Test Connection/Connect to AWS Athena Visitable Type is not Subscriptable #25651

Open davekristianuyau opened 11 months ago

davekristianuyau commented 11 months ago

Hi, im having errors in connecting to AWS Athena using the awsathena+rest://@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}) i can't even connect, is just says Error: visitable type is not subscriptable, and also superset is currently deployed to AWS.

mdeshmu commented 11 months ago

which pyathena version are you using?

davekristianuyau commented 11 months ago

currently deployed with pyAthena version 1.2.0 and pyAthenaJDBC 1.0.9

mdeshmu commented 11 months ago

Please send full traceback of the error

davekristianuyau commented 11 months ago

im only viewing the error through cloudwatch image

mdeshmu commented 11 months ago

please try upgrading pyathena

davekristianuyau commented 11 months ago

to what version would you suggest i upgrade pyathena, because currently i have 2 environments, one for production and staging, the production is using the same setup but is not producing these errors, the error is just happening on the stg environment

mdeshmu commented 11 months ago

I have seen such errors with PyAthena when we upgrade superset and there is some kind of incompatibility in python dependencies. You will have try different versions, probably from pyathena 2.x to see which one works. Did anything change in your stg env recently?

davekristianuyau commented 11 months ago

no changes to the stg-env recently both stg and production are using the same superset config

rusackas commented 6 months ago

@davekristianuyau are you able to check the installed dependencies on both instances, and the db connection settings on both instances? If it's not the config, there must be a difference somewhere.

rusackas commented 2 months ago

Is anyone still encountering this? It's at risk of being closed as stale. Contributions or updated context are more than welcome :)