Views
-
Creating Identity-Aware Views for Conditional Data Access
POST_START Creating Identity-Aware Views for Conditional Data Access I recently had the task of implementing a secure data access pattern for customer information in our sales database. The goal was to create a view that would expose customer data conditionally based on the user’s identity. This way, only users who are part of the ‘pii_readers’…
A1, Access, category:business, category:education, category:software, category:technology, coding, Conditional, creating, data, data engineering, data governance, databricks, education, identity-aware, 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, sql, unity catalog, Views -
Creating and Managing Permanent Unity Catalog Views
POST_START Creating and Managing Permanent Unity Catalog Views I recently needed to create a permanent view in Unity Catalog to simplify access to customer data for my team. I decided to use the CREATE OR REPLACE VIEW command to define a view that selects specific columns from the customers table in the training.sales namespace. CREATE…
A1, category:business, category:education, category:software, category:technology, coding, creating, data engineering, data governance, databricks, education, Lakehouse, Managing, paragraph ordering, paragraph structure, paragraphorder, permanent, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, sql, unity catalog, Views -
Creating and Using Session-Scoped Temporary Views
POST_START Creating and Using Session-Scoped Temporary Views I recently needed to analyze a subset of customer data for a reporting task. The dataset was large, and I wanted to filter for active customers in Germany first. I decided to create a temporary view to simplify my analysis and keep the data isolated for the session.…
A1, category:business, category:education, category:software, category:technology, coding, creating, data engineering, data governance, databricks, education, 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, session-scoped, sql, temporary, unity catalog, Views -
Controlling Who Can Create Governed Views in Production Unity Catalog Schemas
POST_START Controlling Who Can Create Governed Views in Production Unity Catalog Schemas I recently had the responsibility of ensuring that only specific team members could create governed views in our production Unity Catalog schemas. The goal was to maintain data governance and prevent unauthorized access or modifications to sensitive data. I started by understanding the…
A1, Can, category:business, category:education, category:software, category:technology, coding, controlling, Create, data engineering, data governance, databricks, education, governed, 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, schemas, sql, unity catalog, Views, Who -
Creating and Using Session-Scoped Temporary Views
POST_START <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Creating and Using Session-Scoped Temporary Views</title> </head> <body> <h1>Creating and Using Session-Scoped Temporary Views</h1> <p> I started my day by reviewing the latest customer data that needed to be analyzed for a targeted marketing campaign. The dataset was stored in the training.sales.customers table, and I needed to focus…
A1, category:business, category:education, category:software, category:technology, coding, creating, data engineering, data governance, databricks, education, 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, session-scoped, sql, temporary, unity catalog, Views
