Snowflake has powerful group roles and policy, which makes it beneficial for enterprise edition and usage. With its cloud architecture and scalability, it addresses our storage, warehouse, and computation problem at the same time. Pros: Snowflake is acting as a company-wide Data Repository. Simple and pleasant User Interface Read More. You only pay for the resources when you are using them Snowflake is well suited for performing data ETL when data is stored in AWS S3 and one needs fine control over instance costs. It is great for analytics as well as simply storing data. It is cloud-based so the it can be scaled to any business need. Overall: Snowflake is great for storing data and using it as an endpoint to query off of. Awesome data warehouse for huge data set. Snowflake also includes caching at various levels to help speed up your queries and minimum costs.Ĭons: Nothing to dislike in Snowflake. Optimized table structures under the hood Reporting queries run in a fraction of the time that they would in our production systems It has great SQL features like LISTAGG or Count Distinct, which go above and beyond Oracle and MS SQL. It addresses the need to combine disparate data sources into one single data source and discover insights into our business that would not be easily possible with lots of disconnected data sources. Pros: Snowflake is being used across our whole organization.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |