Unable to see Dashboards with any user. #6946
-
|
I connected a new data source today onto my Redash and ever since then on any user group I am unable to see the dashboards that I had created. |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 2 replies
-
|
That doesn't sound good at all. Also, if all else fails, how recent is your last backup? Just in case. 😄 |
Beta Was this translation helpful? Give feedback.
-
|
Since you're using Redash 10.x things shouldn't be too far wrong. Are you familiar enough with ssh that you can log into your Redash EC2 vm to check the Docker log files? In theory (!), any error that's being generated by the new data source should be showing up in there. So, if you can get the Docker log files, then it should be possible to figure out what's going wrong. And from there we can probably figure out how to fix it. 😄 |
Beta Was this translation helpful? Give feedback.
-
|
So we found the issue, |
Beta Was this translation helpful? Give feedback.
-
|
You're welcome, glad you got it solved. 😄 |
Beta Was this translation helpful? Give feedback.
So we found the issue,
While adding a new data source we replaced the old data source for a while.
And the Data source table in Redash has its own foreign ID key to queries and dashboard tables.
The foreign key got removed from all tables making the queries and dashboards not visible to any of the users.
We used the: update queries set data_source = where name = ;
Although my understanding of the exact issue might not be accurate but the above fix helped me get our Redash back to the way it was.
Thank you for the help!