I want to integrate Metabase with my SaaS application. In my system, each merchant has a separate database, but all databases follow the same schema.
What I want to achieve is this:
From my SaaS app’s frontend, merchants should be able to create alerts for specific questions or dashboards. They should also be able to set how often they want these alerts (for example, daily, weekly, etc.).
Based on this, I need to send reports to each merchant at their chosen interval. The important requirement is that the data in these reports must be isolated and specific to that particular merchant only.
So my main question is:
What are the different ways I can implement this functionality? i don’t want to handle things manually i want that metabase functionalities should be used most.