I have to run SQL queries on daily basis to extract data and use those results to create a dashboard. I would like to automate this process i.e. dashboard should create automatically (on daily basis) and the result should be sent automatically across the team through email. Can I do this in Metabase? If yes, then how?
Yes, you can use subscriptions on dashboards:
And if you're looking to automate creation of dashboards/etc, then you can use the API:
Thanks, @flamber, this helps me a lot in my work.