Data Engineering Podcast

SnowflakeDB: The Data Warehouse Built For The Cloud


Listen Later

Summary

Data warehouses have gone through many transformations, from standard relational databases on powerful hardware, to column oriented storage engines, to the current generation of cloud-native analytical engines. SnowflakeDB has been leading the charge to take advantage of cloud services that simplify the separation of compute and storage. In this episode Kent Graziano, chief technical evangelist for SnowflakeDB, explains how it is differentiated from other managed platforms and traditional data warehouse engines, the features that allow you to scale your usage dynamically, and how it allows for a shift in your workflow from ETL to ELT. If you are evaluating your options for building or migrating a data platform, then this is definitely worth a listen.

Announcements
  • Hello and welcome to the Data Engineering Podcast, the show about modern data management
  • When you’re ready to build your next pipeline, or want to test out the projects you hear about on the show, you’ll need somewhere to deploy it, so check out our friends at Linode. With 200Gbit private networking, scalable shared block storage, and a 40Gbit public network, you’ve got everything you need to run a fast, reliable, and bullet-proof data platform. If you need global distribution, they’ve got that covered too with world-wide datacenters including new ones in Toronto and Mumbai. And for your machine learning workloads, they just announced dedicated CPU instances. Go to dataengineeringpodcast.com/linode today to get a $20 credit and launch a new server in under a minute. And don’t forget to thank them for their continued support of this show!
  • You listen to this show to learn and stay up to date with what’s happening in databases, streaming platforms, big data, and everything else you need to know about modern data management. For even more opportunities to meet, listen, and learn from your peers you don’t want to miss out on this year’s conference season. We have partnered with organizations such as O’Reilly Media and the Python Software Foundation. Upcoming events include the Software Architecture Conference in NYC and PyCOn US in Pittsburgh. Go to dataengineeringpodcast.com/conferences to learn more about these and other events, and take advantage of our partner discounts to save money when you register today.
  • Your host is Tobias Macey and today I’m interviewing Kent Graziano about SnowflakeDB, the cloud-native data warehouse
  • Interview
    • Introduction
    • How did you get involved in the area of data management?
    • Can you start by explaining what SnowflakeDB is for anyone who isn’t familiar with it?
      • How does it compare to the other available platforms for data warehousing?
      • How does it differ from traditional data warehouses?
        • How does the performance and flexibility affect the data modeling requirements?
        • Snowflake is one of the data stores that is enabling the shift from an ETL to an ELT workflow. What are the features that allow for that approach and what are some of the challenges that it introduces?
        • Can you describe how the platform is architected and some of the ways that it has evolved as it has grown in popularity?
          • What are some of the current limitations that you are struggling with?
          • For someone getting started with Snowflake what is involved with loading data into the platform?
            • What is their workflow for allocating and scaling compute capacity and running anlyses?
            • One of the interesting features enabled by your architecture is data sharing. What are some of the most interesting or unexpected uses of that capability that you have seen?
            • What are some other features or use cases for Snowflake that are not as well known or publicized which you think users should know about?
            • When is SnowflakeDB the wrong choice?
            • What are some of the plans for the future of SnowflakeDB?
            • Contact Info
              • LinkedIn
              • Website
              • @KentGraziano on Twitter
              • Parting Question
                • From your perspective, what is the biggest gap in the tooling or technology for data management today?
                • Links
                  • SnowflakeDB
                    • Free Trial
                    • Stack Overflow
                    • Data Warehouse
                    • Oracle DB
                    • MPP == Massively Parallel Processing
                    • Shared Nothing Architecture
                    • Multi-Cluster Shared Data Architecture
                    • Google BigQuery
                    • AWS Redshift
                    • AWS Redshift Spectrum
                    • Presto
                      • Podcast Episode
                      • SnowflakeDB Semi-Structured Data Types
                      • Hive
                      • ACID == Atomicity, Consistency, Isolation, Durability
                      • 3rd Normal Form
                      • Data Vault Modeling
                      • Dimensional Modeling
                      • JSON
                      • AVRO
                      • Parquet
                      • SnowflakeDB Virtual Warehouses
                      • CRM == Customer Relationship Management
                      • Master Data Management
                        • Podcast Episode
                        • FoundationDB
                          • Podcast Episode
                          • Apache Spark
                            • Podcast Episode
                            • SSIS == SQL Server Integration Services
                            • Talend
                            • Informatica
                            • Fivetran
                              • Podcast Episode
                              • Matillion
                              • Apache Kafka
                              • Snowpipe
                              • Snowflake Data Exchange
                              • OLTP == Online Transaction Processing
                              • GeoJSON
                              • Snowflake Documentation
                              • SnowAlert
                              • Splunk
                              • Data Catalog
                              • The intro and outro music is from The Hug by The Freak Fandango Orchestra / CC BY-SA

                                Support Data Engineering Podcast

                                ...more
                                View all episodesView all episodes
                                Download on the App Store

                                Data Engineering PodcastBy Tobias Macey

                                • 4.6
                                • 4.6
                                • 4.6
                                • 4.6
                                • 4.6

                                4.6

                                135 ratings


                                More shows like Data Engineering Podcast

                                View all
                                Software Engineering Radio - the podcast for professional software developers by se-radio@computer.org

                                Software Engineering Radio - the podcast for professional software developers

                                272 Listeners

                                The Changelog: Software Development, Open Source by Changelog Media

                                The Changelog: Software Development, Open Source

                                283 Listeners

                                The Cloudcast by Massive Studios

                                The Cloudcast

                                152 Listeners

                                Thoughtworks Technology Podcast by Thoughtworks

                                Thoughtworks Technology Podcast

                                41 Listeners

                                Data Skeptic by Kyle Polich

                                Data Skeptic

                                482 Listeners

                                Talk Python To Me by Michael Kennedy

                                Talk Python To Me

                                592 Listeners

                                Software Engineering Daily by Software Engineering Daily

                                Software Engineering Daily

                                624 Listeners

                                The TWIML AI Podcast (formerly This Week in Machine Learning & Artificial Intelligence) by Sam Charrington

                                The TWIML AI Podcast (formerly This Week in Machine Learning & Artificial Intelligence)

                                443 Listeners

                                Super Data Science: ML & AI Podcast with Jon Krohn by Jon Krohn

                                Super Data Science: ML & AI Podcast with Jon Krohn

                                298 Listeners

                                Python Bytes by Michael Kennedy and Brian Okken

                                Python Bytes

                                213 Listeners

                                DataFramed by DataCamp

                                DataFramed

                                266 Listeners

                                Practical AI by Practical AI LLC

                                Practical AI

                                189 Listeners

                                The Stack Overflow Podcast by The Stack Overflow Podcast

                                The Stack Overflow Podcast

                                64 Listeners

                                The Real Python Podcast by Real Python

                                The Real Python Podcast

                                140 Listeners

                                Latent Space: The AI Engineer Podcast by swyx + Alessio

                                Latent Space: The AI Engineer Podcast

                                77 Listeners