designing
-
Designing Department-Based Row-Level Security for Enterprise Tables
POST_START Designing Department-Based Row-Level Security for Enterprise Tables Setting Up the Security Function I started by thinking about how to secure our enterprise tables based on department access. I needed a way to filter rows so that users could only see data relevant to their department. The solution was to create a security function that…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, department-based, designing, education, Enterprise, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, row-level, security, sql, tables, unity catalog -
Designing Region-Based Row-Level Security for Shared Production Data
POST_START Designing Region-Based Row-Level Security for Shared Production Data I recently took on the responsibility of securing access to a shared production dataset in Databricks. The dataset, production.sales.regional_orders, contains sensitive customer information, and I needed to ensure that users only saw data relevant to their region. The goal was to implement region-based row-level security using…
A1, category:business, category:education, category:software, category:technology, coding, data, data engineering, data governance, databricks, designing, education, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, region-based, row-level, security, shared, sql, unity catalog -
Designing Service Principal Access for Production Data Pipelines
POST_START Designing Service Principal Access for Production Data Pipelines I recently took on the task of securing access for our ETL pipelines to a production data catalog in Databricks. The goal was to ensure that the service principals used by our data pipelines had the right level of access without exposing sensitive data unnecessarily. I…
A1, Access, category:business, category:education, category:software, category:technology, coding, data, data engineering, data governance, databricks, designing, education, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, Pipelines., principal, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, service, sql, unity catalog -
Designing Least-Privilege Unity Catalog Read Access for Production Analytics Users
POST_START Designing Least-Privilege Unity Catalog Read Access for Production Analytics Users Designing Least-Privilege Unity Catalog Read Access for Production Analytics Users I started my day by reviewing the access requirements for the production analytics users. We needed to ensure that these users could read data from specific tables in the production catalog, but with the…
A1, Access, Analytics,, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, designing, education, Lakehouse, least-privilege, paragraph ordering, paragraph structure, paragraphorder, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, read, sql, unity catalog, users
