If you're using Snowflake, the excellent Chan-Zuckerberg terraform provider is a good bet.
We use this, paired with Atlantis for managing the pull request workflow (plan, approve,
apply).

Permifros…

tl;dr: I don't think there's a single easy option to cover both pageview / marketing analytics and product analytics, while being simple to set up and scalable (in terms of both cost and tech debt)…

There are a few "free" options that instead cost you in engineering time and infrastructure, such as Meltano (built by the amazing Gitlab data team) and Pipelinewise (by Transferwise). Both of those…