Building Scalable Data Warehouses
Chapter 1: MPP Architecture and Storage Internals
Massively Parallel Processing Fundamentals
Decoupling Compute and Storage
Columnar Storage Formats and Compression
Micro-partitioning and Metadata Management
Hands-on practice: Inspecting Storage Profiles
Chapter 2: Advanced Data Modeling at Scale
Dimensional Modeling Constraints in Big Data
Data Vault 2.0 Implementation Patterns
Handling Semi-Structured Data
Schema Evolution and Versioning
Hands-on practice: Designing a Data Vault
Chapter 3: High-Throughput Ingestion Pipelines
Change Data Capture Architectures
Idempotency in Data Pipelines
Micro-batch vs Streaming Ingestion
Handling Late Arriving Data
Hands-on practice: Building a CDC Pipeline
Chapter 4: Query Optimization and Performance Tuning
Analyzing Query Execution Plans
Partition Pruning and Clustering Keys
Join Strategies: Broadcast vs Shuffle
Materialized Views and Caching Layers
Hands-on practice: Tuning High-Latency Queries
Chapter 5: Governance, Security, and Observability
Role-Based Access Control Hierarchies
Dynamic Data Masking and Tokenization
Row-Level Security Implementation
Resource Monitoring and Cost Control
Hands-on practice: Configuring Security Policies
Row-Level Security Implementation
Was this section helpful?
- Row Access Policies, Snowflake, 2024 (Snowflake) - Official documentation detailing the implementation, syntax, and operational considerations for Row Access Policies in Snowflake, a prominent MPP data warehouse.
- Efficient Fine-Grained Access Control for Data-Intensive Applications, Kevin Nitsche, Wolfgang Lehner, 2018 Proceedings of the 2018 ACM SIGMOD International Conference on Management of Data (ACM) DOI: 10.1145/3183713.3190669 - A research paper discussing techniques for efficient fine-grained access control in data-intensive applications, relevant to the performance implications of Row-Level Security in scalable data warehouses.
- Data Governance: The Definitive Guide, Evren Eryurek, Uri Gilad, Valliappa Lakshmanan, Anita Kibunguchy-Grant, Jessi Ashdown, 2021 (O'Reilly Media) - Provides context on data governance strategies and practices, with sections relevant to implementing security controls like Row-Level Security within a comprehensive data governance framework.
© 2025 ApX Machine LearningEngineered with