aws-sdk-pandas
aws-sdk-pandas copied to clipboard
Athena unload_approach issues
Describe the bug
I discovered a number of issues to address while using Athena unload_approach:
unload_approachinput argument does not exist forathena.read_sql_table- Database and table names are not sanitised like for other approaches. For instance, a table name of
amazon-reviewswould fail because the Glue catalog only accepts underscore (amazon_reviews) - The query results location should not be the same as the query output location. This is because the query results location must a valid location for the Athena workgroup. In other words, if the specified output location is not a valid Athena workgroup location, the query fails
How to Reproduce
- Attempt
unload_approachinwr.athena.read_sql_table - Pass in an unsanitised database or table name
- Pass an
s3_outputpath which is not a valid Athena workgroup path
Expected behavior
No response
Your project
No response
Screenshots
No response
OS
Mac
Python version
3.8
AWS SDK for pandas version
2.17.0
Additional context
No response