dosubot[bot] commented on issue #33134: URL: https://github.com/apache/superset/issues/33134#issuecomment-2805082763
<!-- Answer --> The issue you're encountering seems to be related to changes in how Superset handles dataset uniqueness constraints between versions 4.0.2 and 4.1.2. In version 4.1.2, there is a unique constraint on the combination of `database_id`, `catalog`, `schema`, and `table_name` in the `tables` table, which ensures that each dataset is unique across these fields <sup>[[1]](https://github.com/apache/superset/blob/master/superset/connectors/sqla/models.py)</sup>. This constraint might be causing the error when you try to create a dataset with the same table name in a different database. To resolve this, you might need to ensure that the combination of `database_id`, `catalog`, `schema`, and `table_name` is unique for each dataset you create. If the databases are truly separate and should allow for the same table names, you may need to check if there are any configuration or migration issues that could be affecting how these constraints are applied. If this behavior is unintended, it might be worth checking if there are any updates or patches that address this issue in newer versions of Superset or if there are any configuration options that can be adjusted to handle this scenario. <!-- 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/296360ee-2690-4ccc-8ef5-0f58027062f2?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/296360ee-2690-4ccc-8ef5-0f58027062f2?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/296360ee-2690-4ccc-8ef5-0f58027062f2?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/296360ee-2690-4ccc-8ef5-0f58027062f2?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/296360ee-2690-4ccc-8ef5-0f58027062f2?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/296360ee-2690-4ccc-8ef5-0f58027062f2?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/296360ee-2690-4ccc-8ef5-0f58027062f2?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]
