Description
Book SynopsisThis book is your complete guide to Snowflake security, covering account security, authentication, data access control, logging and monitoring, and more. It will help you make sure that you are using the security controls in a right way, are on top of access control, and making the most of the security features in Snowflake. Snowflake is the fastest growing cloud data warehouse in the world, and having the right methodology to protect the data is important both to data engineers and security teams. It allows for faster data enablement for organizations, as well as reducing security risks, meeting compliance requirements, and solving data privacy challenges. There are currently tens of thousands of people who are either data engineers/data ops in Snowflake-using organizations, or security people in such organizations. This book provides guidance when you want to apply certain capabilities, such as data masking, row-level security, column-level security, tackling rolehierarchy, build
Table of ContentsChapter 1. Introduction to Snowflake
What’s happening to data
Where Snowflake fits in
Building your first Snowflake Data Warehouse
Chapter 2. Account Security
Security Best Practices for Snowflake
Private Link Connection
Chapter 3. Authentication
Authentication in Snowflake overview
Setting Up MFA
Setting Up OAuth
Setting Up SSO
Connecting through a 3rd party SSO
Connecting through a custom OAuth Authentication Service
Network Access Control
Managing Roles Through SCIM
Chapter 4. Data Access Control
Introduction to Data Access Controls
Snowflake Security Model
Designing roles architecture
Custom Data Access Control
Column Based Access Control
Using Abstraction
Using Dynamic Masking
Row Based Access Control
Using Abstraction
Using Row Based Policies
Custom Access Control
Chapter 5. Logging & Monitoring
Introduction
Snowflake Metadata
Account Usage vs Information Schema
Main Views for Security
Limitations
SnowAlert
Building a Custom Security Dashboard
Setting Things Up
Dashboard
Incident Response
Chapter 6. Epilogue
Recap
What’s Coming Up
