Snowflake - IT Press Your June 2018

Transcript

1. The beginnings of Snowflake THIERRY CRUANES, FOUNDER BENOIT DAGEVILLE, FOUNDER SNOWFLAKE COMPUTING
2. © 2017 Snowflake Computing Inc. All Rights Reserved. Our story Over 1000 customers today Over $400M in venture funding from ICONIQ Capital, Sequoia Capital, Sutter Hill, Redpoint Ventures, Wing Venture Capital, Altimeter Capital, and Capital One. First customers 2014, general availability 2015 Founded 2012
3. The Data Warehouse Built for the Cloud BOB MUGLIA, CEO SNOWFLAKE COMPUTING
4. © 2018 Snowflake Computing Inc. All Rights Reserved. My Snowflake Story Joined in 2014 What attracted me to the company: •  The team •  The idea •  The opportunity
5. © 2018 Snowflake Computing Inc. All Rights Reserved. Enable Every Organization to be Data-Driven OUR MISSION:
6. © 2018 Snowflake Computing Inc. All Rights Reserved. 73% of respondents say their organization has invested or is planning to invest in big data... Only 15% of respondents report their organization has deployed their big data project to production. Gartner, “Survey Analysis: Big Data Investments Begin Tapering in 2016”, October 2016
7. © 2018 Snowflake Computing Inc. All Rights Reserved. Silos & Islands Delays Cost Complexity
8. © 2018 Snowflake Computing Inc. All Rights Reserved. Snowflake built a better way
9. © 2018 Snowflake Computing Inc. All Rights Reserved. What is Snowflake? •  A complete analytic relational database built for the cloud •  SQL compatible with Oracle, Teradata, Netezza, SQL Server, Vertica •  Completely self managing – eliminates all database operational expense •  Provides essentially unlimited data sizes •  Provides essentially unlimited concurrency •  Supports both structured and machine generated, semi-structured data •  Much lower cost then traditional SQL data warehouses
10. © 2018 Snowflake Computing Inc. All Rights Reserved. Over 1000 Customers
11. © 2018 Snowflake Computing Inc. All Rights Reserved. What Customers are doing with Snowflake Share live data with clients BI, ANALYTICS & APPLICATIONS DATA SOURCES DATA MARTS & EXTRACTS STAGING DATA LAKE DATA WAREHOUSE
12. © 2018 Snowflake Computing Inc. All Rights Reserved. What Customers are doing with Snowflake Consolidate data silos to reduce cost & complexity Replace noSQL data lakes for simpler, faster data exploration Modernize data warehouse to deliver fast, scalable BI and analytics Share live data with clients BI, ANALYTICS & APPLICATIONS DATA SOURCES
13. © 2018 Snowflake Computing Inc. All Rights Reserved. Fully managed with a pay-as-you-go model. Works on any data Multiple groups access data simultaneously with no performance degradation Multi petabyte-scale, up to 200x faster performance and 1/10th the cost 200x The Snowflake difference Concurrency Simplicity Performance
14. © 2018 Snowflake Computing Inc. All Rights Reserved. Complete SQL Database Zero Management All of Your Data All of Your Users Data warehouse built for the cloud Pay Only for What You Use Live Data Sharing
15. © 2018 Snowflake Computing Inc. All Rights Reserved. How is this possible? A Brand New Architecture Centralized storage Instant, automatic scalability & elasticity Service Compute Storage
16. © 2018 Snowflake Computing Inc. All Rights Reserved. Secure by design Authentication Embedded multi-factor authentication Federated authentication available Access control Role-based access control model Granular privileges on all objects & actions Data encryption All data encrypted, always, end-to-end Encryption keys managed automatically External validation Certified against enterprise- class requirements
17. © 2018 Snowflake Computing Inc. All Rights Reserved. Our partners: A full ecosytem
18. © 2018 Snowflake Computing Inc. All Rights Reserved. YOUR DATA, NO LIMITS Thank you
19. A Close Look at the Data Warehouse Built for the Cloud CHRISTIAN KLEINERMAN, VP OF PRODUCT MANAGEMENT ARTIN AVANES, DIRECTOR OF PRODUCT MANAGEMENT SNOWFLAKE COMPUTING © 2018 Snowflake Computing Inc. All Rights Reserved.
20. © 2018 Snowflake Computing Inc. All Rights Reserved. Complete SQL Database Zero Management All of Your Data All of Your Users How we deliver the data warehouse built for the cloud Pay Only for What You Use Live Data Sharing
21. © 2018 Snowflake Computing Inc. All Rights Reserved. Complete SQL database z Query Data definition Role based security Updates and deletes Multi-statement transactions Complete database Support for the SQL that business users already know Broad ecosystem of technology partners
22. © 2018 Snowflake Computing Inc. All Rights Reserved. Zero management Load data and run queries, we do all the rest Zero infrastructure and admin costs Secure & highly available Fully managed with no knobs or tuning required No indexes, distribution keys, partitioning or vacuuming
23. © 2018 Snowflake Computing Inc. All Rights Reserved. All of your data IoT Enterprise apps Mobile 3rd party apps Corporate Web Structured and semi-structured data (JSON, XML, Avro) Centralized storage of data, accessible by any user & application Multi-petabyte scale Query petabytes of data in as little as a few seconds Load data continuously with Snowpipe
24. © 2018 Snowflake Computing Inc. All Rights Reserved. All of your users Up to 200x faster than solutions not built for the cloud Maintains a consistent SLA–resources grow and shrink automatically Loading data does not impact query performance Multiple groups access data at the same time with no performance degradation Supports an unlimited number of simultaneous users Data exploration BI/ Reporting Data science Data-driven applications Diverse applications
25. © 2018 Snowflake Computing Inc. All Rights Reserved. Pay only for what you use Scale compute up and down, transparently and automatically Data storage is columnar compressed Comparably priced to AWS S3
26. © 2018 Snowflake Computing Inc. All Rights Reserved. Instant, secure, easy sharing of live data Share data without moving or copying In a secure, governed, resilient environment No complex data pipelines With full data warehouse capabilities Available to all Snowflake customers at no additional cost
27. © 2018 Snowflake Computing Inc. All Rights Reserved. YOUR DATA, NO LIMITS Demo
28. Snowflake Data Sharing MATT GLICKMAN, VP CUSTOMER SNOWFLAKE COMPUTING
29. 29 © 2017 Snowflake Computing Inc. All Rights Reserved. © 2018 Snowflake Computing Inc. All Rights Reserved. Collaborate on shared data with partners Why share data? CRM POS ERP Enrich your analytics with external data APPLICATIONS RESEARCH WEATHER IOT WEB MOBILE HR Break down internal data silos
30. 30 © 2017 Snowflake Computing Inc. All Rights Reserved. © 2018 Snowflake Computing Inc. All Rights Reserved. Traditional Data Transfers: Painful and Inefficient Data providers •  Complex process to prepare data for sharing •  Poor ability to govern published data •  Security headaches •  Inefficiency Data consumers •  Need to build infrastructure to collect and house data •  Complex process to reconstruct data •  Fragile pipeline •  Difficult to keep data up to date Data Consumer Data Provider Data Repository Data & Metadata Staging Data Transfer Data Staging Data Reconstruction
31. 31 © 2017 Snowflake Computing Inc. All Rights Reserved. © 2018 Snowflake Computing Inc. All Rights Reserved. Snowflake Data Sharing radically improves data access and collaboration.
32. © 2018 Snowflake Computing Inc. All Rights Reserved. How is this possible? A Brand New Architecture Centralized storage Instant, automatic scalability & elasticity Service Compute Storage
33. 33 © 2017 Snowflake Computing Inc. All Rights Reserved. © 2018 Snowflake Computing Inc. All Rights Reserved. Cloud Services Snowflake Data Sharing 33 Management Optimization Security Availability Transactions Metadata Data Provider Snowflake Account Consumer 2 Snowflake Account SQL Analysts WH Multi-Tenant Snowflake Deployment Data Science WH Consumer 1 Snowflake Account Data to Share Secure Data Share Wants provider data for data scientists Wants provider data for SQL analysts Share Live Data Instantly Grant Secure Row Level Access Use One Share for Many NO FTP or EDI NO Duplicate Files or Storage NO Additional Charge
34. 34 © 2017 Snowflake Computing Inc. All Rights Reserved. © 2018 Snowflake Computing Inc. All Rights Reserved. Data Share Object s1 Schema List View List Account List Shared Database Data provider Data Consumer Joining between Private and Shared Data Private Database select * from private_data.table1 pd join shared_database.shared_data sd on pd.id = sd.id
35. 35 © 2017 Snowflake Computing Inc. All Rights Reserved. © 2018 Snowflake Computing Inc. All Rights Reserved. Data Sharing The Impact of Snowflake Data Sharing Instant, secure, easy, powerful way to share live data Share data without moving or copying Without complex reconstruction In a secure, governed, resilient environment With full data warehouse capabilities Available to all Snowflake customers at no additional cost
36. 36 © 2017 Snowflake Computing Inc. All Rights Reserved. © 2018 Snowflake Computing Inc. All Rights Reserved. Use Case – Ad Data 36
37. 37 © 2017 Snowflake Computing Inc. All Rights Reserved. © 2018 Snowflake Computing Inc. All Rights Reserved. Use Case – Data Supply Chain 37
38. 38 © 2017 Snowflake Computing Inc. All Rights Reserved. © 2018 Snowflake Computing Inc. All Rights Reserved. Use Case – Advanced analytics on mobile data 38
39. © 2018 Snowflake Computing Inc. All Rights Reserved. YOUR DATA, NO LIMITS Thank you!