RVR-ATH-202

1. Issue Summary

   • The error code RVR-ATH-202 received when using Athena as a data connector in Rivery indicates an issue with retrieving columns from the query. This usually points to a problem with the SQL query used or a misconfiguration in the connection to the Athena service.
   • Initial diagnosis suggests that there might be an error in the SQL syntax, or certain columns in the SQL query are not accessible due to permissions or schema changes.

2. Action Steps:

   • Check SQL Query Syntax: Go through the SQL query being executed in Athena to ensure there are no syntax errors. Make sure the query is valid and executable directly on Athena.
   • Column Accessibility: Verify if the columns being queried exist and are accessible in Athena. Ensure that the correct database and table names are referenced in the query.
   • Permissions: Check the permissions associated with the IAM role or credentials used in connecting to Athena. Ensure that the necessary permissions are granted to access the tables and execute queries.
   • Refresh Metadata: In Rivery, try refreshing the schema to update the column list from the query results. This can sometimes resolve issues when column schemas change in the source database.
   • Logs Examination: Look into the logs in Rivery for more specific error details or messages that might guide you to a more precise issue.

3. External References:

   • Refer to the official Rivery documentation on setting up Amazon Athena as a target for connection setup and permissions.

If the issue persists or you need further assistance, please open a ticket with Rivery support.