helo-ch opened a new issue #15733: URL: https://github.com/apache/superset/issues/15733
We use several Timescale DB databases. Some tables have been migrated from one DB (DB1) to another (DB2). There are datasets pointing on tables from DB1, that we would like to edit to point on DB2. ### Expected results The Dataset editing window seemingly allows us to edit the Database, schema and table, so that we could edit a dataset to point on a table from DB2 rather than from DB1. <img width="324" alt="superset_edit_dataset_window" src="https://user-images.githubusercontent.com/28846165/125913483-dbec087c-aab2-43c7-b937-44013c925b3d.PNG";> ### Actual results But when we click save on that window, nothing happens and the dataset is unchanged, it still points to the same table from DB1. We tried syncing columns from datasource before saving, the result is still the same. It doesn't seem to be linked to roles or permissions, as it happens even with admin role. To clarify, table name and table schema are the same in DB1 and DB2, the only part that we need to change is the Database. ### Environment (please complete the following information): - superset version: `1.0.1` Is it possible to edit a dataset to point on a table from a different database? If it is not possible, it should be made clearer in the editing window. -- 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]
![https://user-images.githubusercontent.com/28846165/125913483-dbec087c-aab2-43c7-b937-44013c925b3d.PNG"](https://user-images.githubusercontent.com/28846165/125913483-dbec087c-aab2-43c7-b937-44013c925b3d.PNG"){kind=link}