Snowflake Data Engineering & Governance Decision Tree
Here is a generalized data engineering & protection/governance decision tree when it comes to current and some private preview features available in Snowflake.
You can access the latest PDF version below
Please keep in mind that, there is not always clear cut numbers to go one way or another when it comes to production loads as type, size, velocity & volume of data may change the decision criteria of how many files vs. how big a table should be before considering some of the options listed on this chart.
I designed this chart to be used as a general guide to see what are the possible options in Snowflake when dealing with data &when best to use them.
Technology Executive | Former VP IT & Head of Architecture | Bridging Fintech, Blockchain & AI
3yAndreas Stålbäck
Chief Creative + Founder at Sentient Imagery
3yMark Neal + Charlie Stanners Yummo!
Head of Region - New Zealand & Pacific
3yExcellent resource, thanks Nick Akincilar.