Account Access and Security

Securing data in Snowflake goes beyond setting passwords. Without understanding authentication methods, access control frameworks, and data masking policies, organizations risk exposing sensitive data, failing compliance audits, and losing customer trust.

Misconfigurations like missing network policies or improper role hierarchies can grant unauthorized users access to production databases. Sensitive information like phone numbers and addresses remain unprotected without column-level security. These gaps create compliance violations and security breaches.

Through interactive scenarios featuring Vinay, a Data Engineer, and Rahul, a Senior Architect, you'll explore real-world security challenges. Each scenario includes hands-on examples, SQL code snippets, and knowledge checks to reinforce learning.

What You'll Learn:

Authentication & Identity Management

• Configure Multi-Factor Authentication (MFA) using Duo Security with bypass and removal options
• Implement Federated Authentication with SSO using Identity Providers like Okta and Microsoft AD FS
• Set up Key Pair Authentication for automated service accounts and pipelines
• Enable OAuth Authentication for third-party tools like Tableau and Looker

Data Protection & Privacy

• Apply Dynamic Data Masking policies to hide sensitive data at query runtime
• Understand External Tokenization for removing sensitive data from Snowflake
• Implement Row Access Policies to control which rows users can see based on roles

Access Control & Role Management

• Understand RBAC and DAC models working together in Snowflake's security framework
• Work with system-defined roles like ACCOUNTADMIN, SECURITYADMIN, and SYSADMIN
• Create custom role hierarchies and manage privileges using GRANT and REVOKE commands

Network Security & Governance

• Create Network Policies with Allowed and Blocked IP lists to restrict database access
• Query Account Usage Schema for historical audit logs and compliance reporting
• Implement object tagging to classify data and automatically apply masking policies

By the end, you'll understand Snowflake's security layers—so you can protect sensitive data with masking policies, control access through role hierarchies, and meet compliance requirements with audit logs. Test your knowledge throughout with scenario-based questions.