Snowflake Access Control: Mastering the Features for Data Privacy and Regulatory Compliance by Larson 9781484280386 1484280385

Snowflake Access Control: Mastering the Features for Data Privacy and Regulatory Compliance Larson – Ebook Instant Download/Delivery ISBN(s): 9781484280379, 1484280377, 9781484280386, 1484280385

Product details:

• ISBN 10: 1484280385
• ISBN 13: 9781484280386
• Author: Jessica Megan Larson

Understand the different access control paradigms available in the Snowflake Data Cloud and learn how to implement access control in support of data privacy and compliance with regulations such as GDPR, APPI, CCPA, and SOX. The information in this book will help you and your organization adhere to privacy requirements that are important to consumers and becoming codified in the law. You will learn to protect your valuable data from those who should not see it while making it accessible to the analysts whom you trust to mine the data and create business value for your organization. Snowflake is increasingly the choice for companies looking to move to a data warehousing solution, and security is an increasing concern due to recent high-profile attacks. This book shows how to use Snowflake’s wide range of features that support access control, making it easier to protect data access from the data origination point all the way to the presentation and visualization layer.Reading this book helps you embrace the benefits of securing data and provide valuable support for data analysis while also protecting the rights and privacy of the consumers and customers with whom you do business. What You Will Learn Identify data that is sensitive and should be restricted Implement access control in the Snowflake Data Cloud Choose the right access control paradigm for your organization Comply with CCPA, GDPR, SOX, APPI, and similar privacy regulations Take advantage of recognized best practices for role-based access control Prevent upstream and downstream services from subverting your access control Benefit from access control features unique to the Snowflake Data Cloud Who This Book Is For Data engineers, database administrators, and engineering managers who wantto improve their access control model; those whose access control model is not meeting privacy and regulatory requirements; those new to Snowflake who want to benefit from access control features that are unique to the platform; technology leaders in organizations that have just gone public and are now required to conform to SOX reporting requirements

Table contents:

Part I. Background
1. What Is Access Control?
2. Data Types Requiring Access Control
3. Data Privacy Laws and Regulatory Drivers
4. Permission Types
Part II. Creating Roles
5. Functional Roles: What a Person Does
6. Team Roles: Who a Person Is
7. Assuming a Primary Role
8. Secondary Roles
Part III. Granting Permissions to Roles
9. Role Inheritance
10. Account- and Database-Level Privileges
11. Schema-Level Privileges
12. Table- and View-Level Privileges
13. Row-Level Permissioning and Fine-Grained Access Control
14. Column-Level Permissioning and Data Masking
Part IV. Operationally Managing Access Control
15. Secure Data Sharing
16. Separating Production from Development
17. Upstream and Downstream Services
18. Managing Access Requests

People also search:

snowflake access control considerations

snowflake sql access control error

row based access control snowflake

snowflake attribute based access control

snowflake tag based access control