I have been trying to figure out what is the best approach to connect Metabase to the Database. I have the following thoughts/questions. Would like to have some feedback from the community
1. Connecting Metabase to Live Database: This is in case of smaller deployments where I want to connect to a Database and draw Visualisations in Metabase. I was thinking of connecting it directly to the live database (database of live application). My only concern/question here is, while performing the light sync (hourly) or detailed ones at night, will Metabase ever write to the source Database? [Please provide your views on this concern]
2. Connecting Metabase to Replica Database: In case of larger database and larger user base, it makes more sense to setup a replica database of the source DB and then connect Metabase to this replica DB.
Appreciate the help.