dosubot[bot] commented on issue #33134: URL: https://github.com/apache/superset/issues/33134#issuecomment-2806270436
<!-- Answer --> The unique constraint error you're experiencing in Superset 4.1.2 is due to a change in how dataset uniqueness is enforced. In this version, the `UniqueConstraint` is applied to the combination of `database_id`, `schema`, and `table_name` in the `SqlaTable` model, meaning each combination must be unique across the table <sup>[[1]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2022-04-01_14-38_a9422eeaae74_new_dataset_models_take_2.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/daos/dataset.py)</sup>. This constraint was likely introduced or enforced in the migration script `2022-04-01_14-38_a9422eeaae74_new_dataset_models_take_2.py`, which is why it worked in version 4.0.2 but not in 4.1.2 <sup>[[1]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2022-04-01_14-38_a9422eeaae74_new_dataset_models_take_2.py)</sup>. If this behavior is unintended for your use case, you might need to explore configuration options or check for any updates or patches that address this issue in newer versions of Superset. <!-- 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/c4a7338c-1911-47d3-91d7-7894f54c4452?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/c4a7338c-1911-47d3-91d7-7894f54c4452?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/c4a7338c-1911-47d3-91d7-7894f54c4452?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/c4a7338c-1911-47d3-91d7-7894f54c4452?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/c4a7338c-1911-47d3-91d7-7894f54c4452?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/c4a7338c-1911-47d3-91d7-7894f54c4452?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/c4a7338c-1911-47d3-91d7-7894f54c4452?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]
