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.