Data Warehouse Security w/ 4 Simple Roles

Опубликовано: 11 Октябрь 2024
на канале: Kahan Data Solutions
1,234
59

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.