Great DW tool!
May 27, 2019
Great DW tool!
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Snowflake
We use Snowflake for basic data munging from OLTP databases, APIs, etc. It is only used in our sizable Data department. It solves the problem of spinning up and managing a DW quickly without dedicated DBA support.
- A nice UI with options to see the SQL/Code to automate steps in the UI.
- Has great SQL features like LISTAGG or Count Distinct, which go above and beyond Oracle and MS SQL.
- It's very fast!
- The SQL editor. The worksheets are nice, but code editors today have auto-fill, debug highlighters, etc. They are working on this I'm told.
- Worksheets (where you edit SQL) cannot be exported today.
- Occasionally a bug is introduced during releases. It's no big deal.
- Snowflake allows us to iterate quickly.
- It allows us to start small.
- We can scale quickly.