Enqurious LogoTM

Use coupon code 'ENQSPARKS25' to get 100 credits for FREE

0
0
Days
0
0
Hours
0
0
Minutes
0
0
Seconds
Go back

Network Policies in Snowflake

16 Inputs
30 Minutes
Beginner
scenario poster
Industry
general
Skills
cloud-management
Tools
snowflake

Learning Objectives

Understand how Network Policies enhance security by filtering access based on IP addresses.
Differentiate between account-level and user-level policies and their use cases.
Learn the roles and privileges required to create and manage Network Policies.

Overview

Vinay, a Data Engineer at GlobalMart, was thrilled to work on a high-profile project with GameForce, a leading mobile gaming company. During a critical meeting, the client mandated strict security requirements: all database access must be restricted to their VPN, ensuring no unauthorized users could connect.

Unsure of how to implement such controls in Snowflake, Vinay approached Rahul, the Senior Architect, for guidance. Through this discussion Vinay, understood about network policies and how they can be used to solve the current problem with GameForce.

Prerequisites

  • Familiarity with Snowflake's architecture
  • Understanding Snowflake roles such as SECURITYADMIN, ACCOUNTADMIN, and how privileges are assigned
  • Ability to write and execute basic SQL commands in Snowflake