dosubot[bot] commented on issue #32394: URL: https://github.com/apache/superset/issues/32394#issuecomment-2684734899
<!-- Answer --> The error "dict is not a sequence" typically occurs when a dictionary is passed to a function that expects a sequence (like a list or tuple). In the context of Superset, this error is happening in the `pandas.io.sql` module when executing SQL queries, specifically in the `read_sql_query` function. Here are some steps you can take to troubleshoot and potentially resolve this issue: 1. **Check SQL Parameters**: Ensure that the SQL query being executed does not have any dictionary objects where a sequence is expected. This might involve checking how parameters are being passed to the query. 2. **Review RLS Filters**: Since the issue arises after applying Row Level Security (RLS) rules, verify that the RLS clauses are correctly formatted and do not inadvertently introduce dictionary objects into the query parameters. 3. **Inspect the `values_for_column` Function**: This function constructs and executes the SQL query. Ensure that the parameters passed to `pd.read_sql_query` are correctly formatted. The `sql` and `con` arguments should be a valid SQL string and a SQLAlchemy connection object, respectively. 4. **Debugging**: Add logging or print statements before the `pd.read_sql_query` call to inspect the `sql` and any parameters being passed. This can help identify if a dictionary is mistakenly being used. 5. **PostgreSQL Specifics**: Since the issue is specific to PostgreSQL, ensure that any PostgreSQL-specific configurations or extensions are compatible with the RLS setup and the SQLAlchemy version in use. If these steps do not resolve the issue, consider isolating the problem by creating a minimal example that reproduces the error, which can help in further debugging or seeking assistance. <!-- 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/29359f24-f32b-468a-b843-81634320a74c?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/29359f24-f32b-468a-b843-81634320a74c?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/29359f24-f32b-468a-b843-81634320a74c?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/29359f24-f32b-468a-b843-81634320a74c?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/29359f24-f32b-468a-b843-81634320a74c?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/29359f24-f32b-468a-b843-81634320a74c?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/29359f24-f32b-468a-b843-81634320a74c?feedback_type=other)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
