Snowflake's ability to eliminate data silos and run workloads from a single platform creates opportunities to democratize data analytics, allowing users at all levels within an organization to make data-driven decisions. This clear, comprehensive guide will show you how to build integrated data applications and develop new revenue streams based on data. The author deftly unravels complex topics, provides hands-on SQL examples, and reveals how you can use the Snowflake Data Cloud to avoid replatforming or migrating data unnecessarily.

You'll learn how to:

  • Efficiently capture, store, and process large amounts of data at an amazing speed
  • Rapidly ingest and transform real-time data feeds in both structured and semistructured format and deliver meaningful data insights within minutes
  • Use Time Travel and Zero-Copy cloning to produce a sensible data recovery strategy that balances the need for system resilience with ongoing storage cost
  • Securely share data and reduce or eliminate data integration costs by accessing fresh, ready-to-query data sets available within the Snowflake Data Marketplace

Table of Contents

  1. 1. Creating and Managing Snowflake Architecture
    1. Snowflake Architecture
    2. Shared-Disk (Scalable) Data Warehouse Architecture
    3. Shared-Nothing (Scalable) Data Warehouse Architecture
    4. NoSQL Alternatives
    5. Snowflake’s Hybrid Columnar Architecutre
    6. Managing the Cloud Services Layer
    7. Billing for the Cloud Services Layer
    8. Query Processing (Virtual Warehouse) Compute Layer
    9. Warehouse Size
    10. Scaling Up a Virtual Warehouse to Process Large Data Volumes and Complex Queries
    11. Scaling Out with Multi-Cluster Warehouses to Maximize Concurrency
    12. Creating and Using Virtual Warehouses
    13. Separation of Workloads and Workload Management
    14. Billing for Virtual Warehouse Layer
    15. Centralized (Hybrid-Columnar) Database Storage Layer
    16. Introduction to Zero Copy Cloning
    17. Introduction to Time Travel
    18. Billing for Storage Layer
    19. Snowflake Caching
    20. Query Results Cache
    21. Metadata Cache
    22. Virtual Warehouse Local Disk Cache
    23. Get Ready for Hands-On Learning
    24. Exercises to Test Your Knowledge
  2. 2. Creating and Managing Snowflake Architecture Objects
    1. Creating and Managing Snowflake Databases
    2. Creating and Managing Snowflake Schemas
    3. INFORMATION_SCHEMA and Account Usage
    4. Introduction to Snowflake Tables
    5. Creating and Managing Views
    6. Introduction to Snowflake Stages – File Format Included
    7. Extending SQL with Stored Procedures and UDFs
    8. User Defined Function (UDF) – Task Included
    9. Secure SQL UDF That Returns Tabular Value (Market Basket Analysis Example)
    10. Stored Procedures
    11. Other
    12. Code Cleanup
    13. Exercises to Test Your Knowledge