Zur Startseite gehen
0,00 €
Bildergalerie überspringen
Produktbild für Snowflake Data Warehouse Engineering

Snowflake Data Warehouse Engineering

52,99 €

Sofort verfügbar

Format

Snowflake Data Warehouse Engineering, Apress
Architecture, Modeling, ELT Pipelines, and Operations
Von Martin Hander, im heise shop in digitaler Fassung erhältlich

Produktinformationen "Snowflake Data Warehouse Engineering"

Design, build, and operate a production-grade analytics platform on Snowflake. This practical guide shows how Snowflake architecture shapes modeling, ingestion, and transformation choices; how to engineer ELT pipelines for structured and semi-structured data; and how to make performance, workload, security, and cost decisions that stand up in real projects. The approach is engineering-first and scenario-driven, turning concepts into repeatable, auditable solutions teams can use day to day. Beyond feature coverage, the emphasis is operations: CI/CD for SQL and Snowpark code, monitoring and observability, least-privilege governance with roles and policies, cost guardrails, secure sharing and collaboration, and business continuity with Time Travel, cloning, and replication. You will learn Snowflake-specific techniques for pruning, selective clustering, streaming and CDC, and dynamic refresh. What makes this book especially useful is its end-to-end operating playbook: opinionated patterns, checklists, and guardrails that connect architecture, modeling, ingestion and ELT, governance and security, performance and cost, and the everyday practices of releasing and recovering safely. It focuses on concrete decisions and the trade-offs behind them, helping teams avoid legacy anti-patterns while building a reliable, auditable platform that is ready to evolve. What You Will Learn
  • Design Snowflake architectures that align storage, compute, security, and governance into a coherent, scalable platform.
  • Model, load, and transform structured and semi-structured data using streams, tasks, MERGE, and SCD2 patterns.
  • Tune performance and control cost with micro-partition pruning, selective clustering, warehouse sizing, and workload isolation.
  • Implement least-privilege RBAC, masking and row access policies, auditing, and tag-driven governance.
  • Build reliable ELT pipelines and release safely with CI/CD, testing, cloning, and SWAP-based promotion.
  • Operate with observability and SRE practices using Snowflake usage views and SLOs.
  • Share and collaborate securely with Secure Data Sharing and Marketplace, and plan replication and DR for continuity.
Who This Book Is For Data engineers; data warehouse and solution architects; analytics engineers; BI developers; advanced data analysts; DBAs moving from on-prem to cloud (intermediate level with SQL and warehousing basics).  

Artikel-Details

Anbieter:
Apress
Autor:
Martin Hander
Artikelnummer:
9798868826283
Veröffentlicht:
07.07.26

Barrierefreiheit

This PDF has been created in accordance with the PDF/UA-1 standard to enhance accessibility, including screen reader support, described non-text content (images, graphs), bookmarks for easy navigation

  • entspricht den Vorgaben der PDF / UA 1 (05)
  • keine Vorlesefunktionen des Lesesystems deaktiviert (bis auf) (10)
  • navigierbares Inhaltsverzeichnis (11)
  • logische Lesereihenfolge eingehalten (13)
  • kurze Alternativtexte (z.B für Abbildungen) vorhanden (14)
  • Inhalt auch ohne Farbwahrnehmung verständlich dargestellt (25)
  • hoher Kontrast zwischen Text und Hintergrund (26)
  • Navigation über vor-/zurück-Elemente (29)
  • alle zum Verständnis notwendigen Inhalte über Screenreader zugänglich (52)
  • Kontakt zum Herausgeber für weitere Informationen zur Barrierefreiheit (99)