Item: Snowflake
Rating: 8
Author: Verified User

Use Cases and Deployment Scope

Snowflake is currently used as the main data warehouse for the company, by creating a replica of the databases in production and storing them all in one single data warehouse, it gives access to the whole company to data in almost real time, the lag is about 5 to 30 minutes depending on the size of the DB. with this solution all teams have access to data in a single place in order to perform their respective tasks

Pros and Cons

Provide a front to make queries of different DBs in a single place
Cross tables from different schemas
Run complex queries faster than other providers

Graphic outputs
Dashboard creation

Return on Investment

Reduce costs of query running
Improved the efficiency of data scientists and Business analysts when It comes to gathering information from DBs
Improved the efficiency of the engineering team when it comes to development

Support Rating

Haven't had the need to use it actually, thus the qualification I gave

Key Insights

Do you think Snowflake delivers good value for the price?

Yes

Are you happy with Snowflake's feature set?

Yes

Did Snowflake live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Snowflake go as expected?

I wasn't involved with the implementation phase

Would you buy Snowflake again?

Yes

Usability

Even though it is really useful when it comes to running highly elaborated queries that will die in other environments and it also is great for crossing tables of different schemas that are not necessarily related. when it comes to UX/UI it has room for improvement since it requires some level of expertise to go around it without getting lost in the process

Likelihood to Recommend

it is really useful when it comes to running highly elaborated queries that will die in other environments. it also is great for crossing tables of different schemas that are not necessarily related. It doesn't perform well when it comes to dashboard creation/sharing or graphic solutions like drawing pies or bars out of a query

Usability Pros and Cons

Pros	Cons
Like to use Relatively simple Well integrated Consistent Feel confident using	Difficult to use Lots to learn

Easy Tasks

Running queries
downloading query results
graphing simple queries

Difficult Tasks

Complex query graphing
start to write queries without a basic UI explanation

What makes Snowflake amazing

Overall Satisfaction with Snowflake