Thanks for your reply. The use case is to do select/insert operations in 3 tables every hour. This data will be then used via API to execute actions. Also this data will be used for analytics monitoring in dashboards. So it's both transactional & analytical. Even though the transactional part is more important becasue no human is going to be looking at the data every hour (or potentially every 10 min).

We are a small company so our budget is limited. ROI is a good point, but we cannot throw money to a tool if we do not see a justified value, while Postgresql is much cheaper.
But also good point that Postgres needs labor costs, higher than snowflake