RVR-ATH-202

Issue summary

The error code RVR-ATH-202 received when using Athena as a data connector in Data Integration indicates an issue with retrieving columns from the query. This points to a problem with the SQL query used or a misconfiguration in the connection to the Athena service.

Initial diagnosis suggests an error in the SQL syntax, or certain columns in the SQL query are not accessible due to permissions or schema changes.

Action steps

To resolve the error, follow these steps:

1. 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 can be executed directly in Athena.
2. Column accessibility: Verify if the columns queried exist and are accessible in Athena. Ensure that the correct database and table names are referenced in the query.
3. Review 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.
4. Refresh metadata: In Data Integration, 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.
5. Examine logs: Look into the logs in Data Integration for more specific error details or messages that might guide you to a more precise issue.

External references

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

note

If the issue persists or you need further assistance, open a support case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.