Great DW tool!
Rating: 10 out of 10
May 27, 2019
EF
Vetted Review
Verified User
1 year of experience
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!
Cons
- 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.