Can we create a button in looker dashboard so that we can click on that and that will do the clear cache and refresh things in backend, I know this can be done by using ctr + shift + enter or by click on three dots and then selecting clear cacnhe and refresh, is there a possibility that can we create button for this functionality
If you are using the Looker UI, I do not think so. Theoretically you could add a button that does an http post to the Looker API which clears the cache for that datagroup or just those query IDs... but that won't also refresh the dashboard. If you were embedding this dashboard in a portal page you could do that as well, using a javascript event to communicate with the iframe.
Hope that helps!