How did you install Redash: docker-compose, image: redash:7.0.0.b18042
Hi, I have a problem with removing Postgresql data sources in Redash. In our process, we’re constantly adding/removing whole db’s, so there’s a lot of data sources added/removed to/from Redash on a regular basis.
My problem occurs inconsistently, because it can either happen or not, for the sources coming from the same DB. For example:
There’s 2 datasources pointed to the same endpoint, same authentication (same postgres user/pass), just different db names. Both of them had the same queries and dashboards. Then, I can easily delete one, but not the other (it get’s stuck on deleting process, then error “failed to delete data source” shows up). Sometimes, manually removing (unpublishing, then archiving) all related dashboards/queries help, but that is also inconsistent. For example, right now I am stuck with a datasource that no longer exists (db was purged), no dashboard/query uses it, yet still, I’m unable to remove it from data sources on Redash.
Is there any reason said behaviour is happening? It’s possible I’m doing things in the wrong order, so I’d like to know, what is a “proper” way to remove a data source? Is there a single operation that removed a data source and all related queries/dashboards?
At the moment, the process that works most of the time is:
Downing the DB
Purging aforementioned DB out of existence
Removing data source from Redash
If point 3 fails, then manually remove (unpublish/archive) all related dashboards/queries to said DB and trying point 3 again.
If point 4 fails, get stuck with a data source that isn’t used anywhere and cannot be removed.
to clarify, I’ve checked the behaviour when the problem initially happened on all available browsers/OS listed (Firefox/Chrome/Safari Ubuntu 18.04/Mojave) on v 4.0.1.b4038. Then upgraded the image to 7.0.0.b18042, tried it on all of the same browsers/OS again, and it still didn’t work. As in original post, the one solution to the problem that worked a couple of times already was manually removing dashboards/queries, but this time I just cannot remove the data source, no matter what I’m trying to do. The DB doesn’t exist already, queries and dashboards are unpublished and archived
Is there any idea what might be the reason for this behaviour? Or could You please respond to the other point of the post: “I’d like to know, what is a “proper” way to remove a data source? Is there a single operation that removed a data source and all related queries/dashboards?”
I do not know how to check Redash metadata database, nor the CLI command to remove the data source. I would appreciate pointer or links to Your knowledge base/documentation where I can check it, or could You provide aforementioned command Yourself? I have full access to machine running the containers, so permissions are not an issue for me