Do-nothing scripting: the key to gradual automation
When I can (often):<p>1. Write SQL to automate<p>2. Put SQL with output in Metabase<p>3. Have it manually checked alongside day-to-day operation<p>4. Iterate 1-3 (you often will get a lot of feedback)<p>5. Replace the manual work, now that the SQL it checked on a lot of cases in production