Your data team will love Snowflake, just be sure to manage cost
Rating: 9 out of 10
January 13, 2025
DW
Vetted Review
Verified User
2 years of experience
- Security
- Scaling
- Support
- Separating compute from storage
- Flexible disparate compute models
- Detailed history of all your queries and activity, for analysis/review/troubleshooting
- Cloning, undeletion, sharing - all tied to how Snowflake stores data
Cons
- There is no support for triggers
- Materialised views are limited to only one table
- You can't create dynamic SQL in functions