Data Warehouse Security w/ 4 Simple Roles
Get my Modern Data Essentials training (for free) & start building more reliable data architectures
https://www.ModernDataCommunity.com
-----
Although security isn't the most glamorous part of being a data engineer, it's arguably one of the most important.
While each team will have their own unique strategy & naming conventions, this week I want to share what's worked well for me.
It's a simple approach based around 4 high level roles.
It covers each key layer a warehouse pipeline from source data ingestion to end-user reporting.
Enjoy.
PS - Sorry about the weird audio on this one. Didn't notice until after it was recorded but still wanted to get it out to you.
Timestamps:
0:00 - Intro
0:22 - User Overview
1:34 - Analyst Role
2:22 - Developer Role
3:47 - Automation Role
4:45 - Loader Role
5:22 - Example Usage
8:16 - Viewing Grants
8:58 - Sample Scripts
Title & Tags:
Secure Your Data Warehouse With These 4 Roles
#kahandatasolutions #dataengineering #databasesecurity
NOTE: Sorry the audio sounds weird on this one. I didn't realize it until after it was all recorded, but still wanted to get it out.
Watch video Data Warehouse Security w/ 4 Simple Roles online without registration, duration hours minute second in high quality. This video was added by user Kahan Data Solutions 08 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,234 once and liked it 59 people.