dosubot[bot] commented on issue #31191: URL: https://github.com/apache/superset/issues/31191#issuecomment-2506694380
<!-- Greeting --> Hey @dcernag, I'm here to help you with the issue you're facing. I can assist with bug fixes, answer your questions, and guide you on becoming a contributor. Let's tackle this together while we wait for a human maintainer. <!-- Answer --> In Superset version 4.1.1, there were changes to the Google Sheets database connection handling that might be affecting your setup. Here are some key points that could be relevant to the issues you're experiencing: 1. **Validation of Parameters**: The system now validates parameters more strictly, including checking for the presence of a `catalog` and `service_account_info`. If these are not provided, errors are returned <sup>[[1]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/gsheets.py)</sup>. 2. **Service Account JSON Requirement**: For public Google Sheets, a service account JSON should not be required. However, if the system is incorrectly marking it as required, it might be due to a misconfiguration or a bug in the UI logic. The `isPublic` state should be set to `true` for public sheets, which means no service account JSON is needed <sup>[[2]](https://github.com/apache/superset/blob/master/superset-frontend/src/features/databases/DatabaseModal/DatabaseConnectionForm/EncryptedField.tsx)</sup>. 3. **Error Handling**: The `InvalidParametersError` and `TABLE_DOES_NOT_EXIST_ERROR` you are encountering could be due to URL identification issues or mismatches in the expected type of Google Sheets URL. Ensure that the URL is correct and matches the type of Google Sheets allowed <sup>[[3]](https://github.com/apache/superset/blob/master/tests/unit_tests/db_engine_specs/test_gsheets.py)</sup>. 4. **Session Management and Data Upload**: The handling of POST requests and data upload processes have been updated, which might affect how connections are managed and validated <sup>[[1]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/gsheets.py)</sup>. To address these issues, you might want to double-check the configuration settings for your Google Sheets connection, especially the type of sheets allowed and the service account settings. If the problem persists, it could be beneficial to review the changes in the codebase related to Google Sheets handling in version 4.1.1 for any potential bugs or misconfigurations. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- 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: notifications-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
