Hi,
We have an existing dashboard that many users have bookmarked. We created a new version of this dashboard that is more optimized for performance. What is the best way to switch the contents of the first dashboard without changing the url?
I know there is an update_dashboard() endpoint using the API, but I haven’t successfully been able to update any dashboards when testing that endpoint. Is there any other way to do this? Does anyone have any tips or suggestions?
Thanks in advance!
+1
Updating dashboards via the API is hard. That’s one of the problems that Gazer helps with, but I don’t think gazer really lets you “swap” dashboards.
I haven’t tried to just update_dashboard() via the API but I’d imagine you could get_dashboard() and copy/paste that into update_dashboard() removing things like slug + dashboard ID… If that’s not working, I can give it a try myself.
What you might be able to do that could be easier, if you can’t figure out the fields to include/exclude in the update_dashboard() call— Get dashboard lookml on the new dashboard & create a LookML dashboard for it, add a lookml_link_id to the dashboard pointing to the new lookml dashboard, and then sync_lookml_dashboard to update the UDD. There’s instructions on the use of sync_lookml_dashboard here:
https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/dashboard#sync_lookml_dashboard
I think that’d work!
We swap dashboards using gazer, they are an update from a dev version which is promoted, we didn’t want to spoil people’s bookmarks and schedules when updating them so we force overwrite which retains the db id.
We also use Gazer to “swap” dashboards and it works for us.
Thanks all. I’ll give these solutions a try.
What commands do you use in gazer to do the swap?
Cat dashboard to file and then import it with force on (has to have the same title or name, can’t remember which)
gzr space export space_id --host=host.eu.looker.com --client-id=**** --client-secret=*** --tgz exported_space.tar.tgz
gzr dashboard import Dashboard_XYZ.json space_id --host=host.eu.looker.com --client-id=**** --client-secret=**** --force
I hope it helps
Hello,
I have essentially the same need as is mentioned in this thread: I want to swap out the underlying lookml of a user dashboard without changing the URL. I wanted to check: is using Gazer still the best approach or is there another way recommended to do this? I also looked through the sync_lookml_dashboard api docs and it wasn’t clear to me how that works. Does that allow you to point an existing UDD to a new lookml file?
Thanks!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
