Snowflake AI Data Cloud
SnowflakeExternal reviews
676 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Snowflake is an amazing serverless tool for Datalake creation and analytics.
What do you like best about the product?
Snowflake access is an easy process overall. The objects/tables creation DDL is much similar to a SQL server/MySQL syntax. Any number of tables with any number of elements could be created in your snowflake workspace. The analytical queries could be executed on top of the snowflake in a very efficient and smooth fashion with tremendous performance throughput. The flexibility of datatypes and having the string representation of any type of element is the most conducive flexibility of snowflake.
What do you dislike about the product?
Snowflake queries and structure need some training to get acquainted with. The extract process has special syntax that needs separate skill.
Some of the table constructs in snowflake could be complex in nature. Different role exerts different restrictions on the table objects and not every user will have access to all the tables in snowflake.
Some of the table constructs in snowflake could be complex in nature. Different role exerts different restrictions on the table objects and not every user will have access to all the tables in snowflake.
What problems is the product solving and how is that benefiting you?
Snowflake enabled my organization to create several tables under several subject areas. The tables created are interlinked with many common elements and act as a chained data lake. The series of objects on a holistic basis represent the business entities associated with the lake.
Any new and subsequently identified objects are easily appended to the snowflake workspace. The population of these tables could be accomplished easily via multiple data load strategies. Different types of file format like json, csv and many others are supported for data load within snowflake. The file to be loaded could be either uncompressed or compressed.
The schema definition classifies the list of objects in a subject area. Role definition and grants assigned to the role provide the necessary security needed for the table's accesses and unauthorized restrictions. The user needs to necessarily specify the schema along with the table name in order to access and query a table successfully.
Any new and subsequently identified objects are easily appended to the snowflake workspace. The population of these tables could be accomplished easily via multiple data load strategies. Different types of file format like json, csv and many others are supported for data load within snowflake. The file to be loaded could be either uncompressed or compressed.
The schema definition classifies the list of objects in a subject area. Role definition and grants assigned to the role provide the necessary security needed for the table's accesses and unauthorized restrictions. The user needs to necessarily specify the schema along with the table name in order to access and query a table successfully.
Recommendations to others considering the product:
Good serveless datalake tool to consider for your bigdata/DBMS needed.
Super fast and easy
What do you like best about the product?
i like snowflake sql syntaxes (10x better than MYSQL) and the query speed. Storage is also super cheap since they charge by compute usage like a utility bill. Its not laggy and i can share my sql sheets easily with others
What do you dislike about the product?
I do not like the UI experience for users, I end up using pycharm or dbeaver and connect to snowflake to write my sql queries. yes, the new snowsights is better than the classic console, but it also took away some of the things I enjoy about classic console. I like the ability to access the accounts (admin related stuff) / datawarehouses pages on the same sql page
What problems is the product solving and how is that benefiting you?
query speed. customers are happy with the results returned compared to some competitor tools...
Cloud based data warehousing tool with Analytics services
What do you like best about the product?
Performance of the tool, you can perform complex logic calculations on huge volume of data very quickly. At any point of time, you can add/remove servers to increase the performance. Easy to learn and deployment of code.
What do you dislike about the product?
We have not encountered any drawbacks so far with this tool. The only challenge that we see is direct connectivity with the sources. For example, to pull data from SAP, you need to use a replication tool.
What problems is the product solving and how is that benefiting you?
We are building a centralized database in our organization for reporting purposes. As of now, we have multiple systems which are not synched with each other. We are bringing data from all of them in snowflake then transforming data as per business need for reporting.
Great SQL alternative but sometimes not user-friendly
What do you like best about the product?
I like that you only pay for what you use and it makes it easier for people starting their own businesses to have a reliable database without having to buy and pay for a server.
What do you dislike about the product?
Not very user-friendly. It's hard to find table names and key words (like no autocorrect options). I also don't like not being able to use keyboard shortcuts like ctr+e and ctrl+H
What problems is the product solving and how is that benefiting you?
Faster querying and ease to get data since the amount of data increased tremendously in my workplace and using sql server made things simply unmanageable. So a cloud-based solution was a great solution
Good Data warehousing tool and easy to use
What do you like best about the product?
Data pulling and querying is very good and it also can be connected to different other tools like tableau and python for the visualization and the analysis of the data. A very user friendly interface which does not take long to get used to it. I like that it's very fast and efficient.
What do you dislike about the product?
Does not allow the user to use up the whole space for query writing and sql auto formatting is also not available. It would be great if the top menu ribbon can be minimized
What problems is the product solving and how is that benefiting you?
As a data analyst, I use snowflake for pulling the data and analyzing it. Being a cloud managed tool, huge data can be accessed on the go without any need of in house data warehouse
Snowflake review
What do you like best about the product?
The ability to scale warehouses according to business needs.
The ease with which views and connectors can be built.
Great community support.
The ease with which views and connectors can be built.
Great community support.
What do you dislike about the product?
Snowflake doesn't have a native offering with cloud providers like Google, aws or azure.
Bulk loading is a bit difficult.
The next generation of data is going to be unstructured and semi structured. Snowflake must look into this domain as it currently does not offer much in this niche
Bulk loading is a bit difficult.
The next generation of data is going to be unstructured and semi structured. Snowflake must look into this domain as it currently does not offer much in this niche
What problems is the product solving and how is that benefiting you?
Getting husiness insights regarding our product offerings.
I would like give it to 10 but it's only for fully cloud based enterprises. So I give it 8.
What do you like best about the product?
I liked its unique architecture, and also about security.
What do you dislike about the product?
I disliked not supporting hybrid. Because our customer only need hybrid.
What problems is the product solving and how is that benefiting you?
In order to solve big data that RDBMS can't handle properly.
About to use snowflake
What do you like best about the product?
The most exciting part for me is to use this new thing and get more experienced on it
What do you dislike about the product?
For now after reading some articles, there is nothing that i dislike!
But sure I'll share my thoughts with you after getting deeper.
But sure I'll share my thoughts with you after getting deeper.
What problems is the product solving and how is that benefiting you?
Manage the huge amount of data
Data Management and Connection with Power BI
What do you like best about the product?
I usually use Snowflake with SAS and PowerBI,
It is Awesome and very smooth with all microsoft products.
Connectivity and refresh timing with PowerBI is phenomenal.
It is Awesome and very smooth with all microsoft products.
Connectivity and refresh timing with PowerBI is phenomenal.
What do you dislike about the product?
I really dont recall and dislike, but still i would recommend that screen size/Terminal size can be increased for writing SQL queries and result view window also can have some features like traversing to next/previous records, Sorting by variables, choosing top N records etc.
What problems is the product solving and how is that benefiting you?
Yes, Very much, i use mainly as Data warehouse and consume that data using power BI.
It really helps in faster connectivity and good refresh rate to manage data in millions.
It really helps in faster connectivity and good refresh rate to manage data in millions.
I Have Used Snowflake in Data Quality Assurance, Data Migration and ETL Testing
What do you like best about the product?
Using and Working with Snowflake is Like Cake Walk if You have Some Knowledge on Databases and SQL/Oracle. Snowflake Provides an Intensive Set of Connector APIs Such as Spark connector, Python connector, etc., and Javascript Language-Based Stored Procedure Support. Snowflake is a Virtual Data Warehouse So You Don't Need to Worry about Managing things Physically or Hectically. Performance of Query Execution is Incredible even for larger Datasets.
What do you dislike about the product?
The Only Thing I Dislike about Snowflake Data Warehouse is Inability of Inferring Schema of Data Files Reading from Stage Area Such as Reading CSV, Json, Parquet, ORC etc from S3.
What problems is the product solving and how is that benefiting you?
When I Worked On Data Quality Framework, the Client was required to Execute Custom SQL Queries for Creating Aggregated Datasets or Dataframes either for S3 Data Files or Snowflake Tables using Snowflake Compute and Triggering all the System through AWS Step Function and AWS Lambda, By this way we Saved the Cost of AWS EMR and Also Reduced the Time Taken to Access or Operate Large Datasets(Size>4GB).
Recommendations to others considering the product:
If You are in Business or Work of Data Analysis, Data Science, and Data Warehousing, Quickly go for it Don't Even Think Twice.
showing 181 - 190