temporary
-
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 -
Removing Temporary Elevated Production Privileges
POST_START Removing Temporary Elevated Production Privileges I recently had to address a security concern where a group of incident responders had been granted temporary MODIFY privileges on the production.sales.orders table. These privileges were initially issued to allow them to investigate a data integrity issue, but the incident had been resolved, and the elevated access was…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, elevated, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, removing, sql, temporary, unity catalog -
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
