ul-fra opened a new issue #17072:
URL: https://github.com/apache/superset/issues/17072


   I have an AWS Athena/Glue datacatalog. This catalog contains several 
databases, e.g. db-a and db-b. Both of these two databases contain a table 
"te_general". When I create a dataset for db-a.te_general everything is fine 
but when I create the second dataset based on db-b.te_general I get the error 
message "An error occurred while creating datasets: Dataset could not be 
created.". 
   
   In the logs I can find this message: "(sqlite3.IntegrityError) UNIQUE 
constraint failed: tables.table_name"
   
   So it seems that the table_name seems to be unique. I would expect that the 
tripple of database-schema-table needs to be unique.
   
   #### How to reproduce the bug
   
   1. Go to datasets and create a first dataset for schema A and table T
   2. Go to datasets and create a second dataset for schema B and table T
   
   
   ### Expected results
   
   Both dataset should be registered.
   
   ### Actual results
   
   Second dataset is not created.
   
   #### Screenshots
   
   ### Environment
   
   -     browser type and version: Firefox 88.0
   -     superset version: Superset 0.0.0dev
   -     python version: Python 3.8.12
   -     node.js version: ? (docker exec -it superset node -v --> node not on 
path)
   -     any feature flags active: no
   
   ### Checklist
   
   Make sure to follow these steps before submitting your issue - thank you!
   
   - [x] I have checked the superset logs for python stacktraces and included 
it here as text if there are any.
   - [x] I have reproduced the issue with at least the latest released version 
of superset.
   - [x] I have checked the issue tracker for the same issue and I haven't 
found one similar.
   
   ### Additional context
   
   


-- 
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]

Reply via email to