March 18th 2020
With over 18 years of experience, Waypoint is no stranger to the implementation of data and analytics within a rapidly-changing digital landscape. With new technologies popping up all the time and new ways of doing old processes; we are continually striving to learn, grow and enhance our team so that we can continue to provide world-class analytics, award-winning data management solutions, and consulting expertise that are aligned with the times.
With the increased popularity of the Snowflake data platform in late 2019, we jumped at the opportunity to learn more about this emerging technology and eventually partnered with Snowflake to ensure that we continue to bring our clients increased opportunities to save time, money, and resources (without sacrificing performance) with migrations and implementations to this cloud data platform.
As a part of our partnership with Snowflake, we have recently achieved the designation of Snowflake SELECT partner, which designates our continuous leadership and expansion within the industry.
Through our partnership journey with Snowflake, we have grown and evolved to understand the benefits that Snowflake can provide to our clients and have helped to ease the burdens of data warehouse set-up, mitigate the lack of cost transparency, and avoid the potential administrative headaches that come with traditional solutions.
Ease of Set-Up
Time is money, and setting up an on-premise data-warehouse server can take weeks or even months. With Snowflake, it is only a matter of minutes before you and your team can harness the power of the cloud and begin ingesting data from internal and external sources.
Transparency of Cost
Probably the most unique and useful feature of Snowflake is how transparent they make the process of managing and controlling the cost of operating the cloud data warehouse which can be exemplified through three different parts of the Snowflake UI.
- Cost allocation by warehouse
- Cost usage History
- Cost of the Account
Warehouses are established to assign compute processing to various functions; those assignments could be made relative to whether they are more or less memory intensive, or if they are associated with certain areas of the business (Finance can have a warehouse assigned to just their reporting needs for instance).
- By viewing an individual warehouse, an account administrator can see the history of usage for that warehouse for a selected period.
- By viewing History, an account administrator can see a history of all processing in the Snowflake environment for all warehouses.
- By viewing Account, an account administrator can see how many credits are being consumed by day and by how credit usage is allocated among warehouses.
Credit usage can easily be translated into costs, and with this degree of transparency, it becomes very simple to decide how best to allocate processes among warehouses to properly control or allocate the costs of running the Snowflake warehouse.
One of the comments we frequently hear about Snowflake is that it allows data warehouse architects to spend most of their time developing data products for their end-users and minimal time focused on administering the system.
Snowflake is built for the cloud, and that means it is both designed to address all the traditional data management functions while minimizing the time necessary for administering the system.
One of the advantages of Snowflake over other cloud data-warehousing solutions is that it easily ingests data from structured files such as comma-delimited files, as well as, semi-structured data from files such as JSON and Avro. That means you can take advantage of data structured in any useful file format that is available. The process is virtually identical for all of the file types and the two steps are simple:
- Set-up a staging area
- Set-up a pipe
Interested in learning more about Snowflake and how it could potentially improve your business? Book a Snowflake Success Pilot session and In under five days, Waypoint will demonstrate how Snowflake can provide valuable business insights! Our Snowflake Success Pilot engagement offers you the opportunity to realize the benefits of Snowflake in your own personal environment, risk-free with technical guidance, decision support, and expert recommendations.
Written By: Waypoint Contributors