GitHub user dosubot[bot] added a comment to the discussion: Cursor Can Only Scan Forward
<!-- Greeting --> Hey @bradley-jt! I'm here to help you with any bugs, questions, or contributions. Let's tackle this issue together! <!-- Answer --> The error message you're encountering suggests that the cursor being used in your SQL query is not configured to support backward scanning, which is typically enabled by the SCROLL option. Unfortunately, I couldn't find specific documentation or code comments in Superset that explain how to enable the SCROLL option for cursors <sup>[[1]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/base.py)</sup>. To address this issue, you might need to modify the database connection or query execution settings to enable SCROLL for cursors. This could involve adjusting the database engine specifications or the way queries are executed in Superset. You may want to check the `superset/db_engine_specs/aurora.py` file, which contains the configuration for Aurora database connections, to see if there are any options related to cursor behavior that can be adjusted <sup>[[2]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/aurora.py)</sup>. If the issue persists, consider reviewing the database-specific documentation for Aurora to see if there are any settings or configurations that need to be applied to support SCROLL cursors. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/06c0d2e1-e6c4-427d-bb82-a0eef20b240c?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/06c0d2e1-e6c4-427d-bb82-a0eef20b240c?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/06c0d2e1-e6c4-427d-bb82-a0eef20b240c?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/06c0d2e1-e6c4-427d-bb82-a0eef20b240c?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/06c0d2e1-e6c4-427d-bb82-a0eef20b240c?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/06c0d2e1-e6c4-427d-bb82-a0eef20b240c?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/06c0d2e1-e6c4-427d-bb82-a0eef20b240c?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/33712#discussioncomment-13392687 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
