Snowflake Data Warehouse Engineering
Martin Hander
Sold by Wegmann1855, Zwiesel, Germany
AbeBooks Seller since 2 June 2022
New - Soft cover
Condition: New
Ships from Germany to U.S.A.
Quantity: 1 available
Add to basketSold by Wegmann1855, Zwiesel, Germany
AbeBooks Seller since 2 June 2022
Condition: New
Quantity: 1 available
Add to basketNeuware -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 ForData 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).
Seller Inventory # 9798868826276
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
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).
Martin Hander, Ph.D. (LIGS University, USA), is a technology professional with a strong focus on data warehousing and cloud analytics. Over his career he has worked extensively with relational databases and modern cloud platforms, designing and operating data solutions that support reporting and advanced analytics. In combining his academic background with years of practical project work, he bridges theory and implementation. This blend of experience makes him a trusted guide for readers who want to understand Snowflake and modern data warehouse engineering in a clear, hands-on, and practice-oriented way.
"About this title" may belong to another edition of this title.
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to Wegmann1855, Zwiesel, Germany, +49 22609490, without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
| Order quantity | 9 to 30 business days | 8 to 14 business days |
|---|---|---|
| First item | £ 22.27 | £ 28.28 |
Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.