profession:cloud engineer
-
Controlling Table Read Access with SELECT Privileges
POST_START Controlling Table Read Access with SELECT Privileges Controlling Table Read Access with SELECT Privileges I started my day by reviewing the access control requirements for the training catalog. The team needed to ensure that analysts could read specific tables, but not access other parts of the catalog. I knew that Databricks Unity Catalog provides…
A1, Access, category:business, category:education, category:software, category:technology, coding, controlling, data engineering, data governance, databricks, education, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, read, select, sql, table, unity catalog -
Granting and Revoking Schema-Level Access
POST_START Granting and Revoking Schema-Level Access Setting Up the Scenario I started my day by reviewing the access control requirements for our data team. We needed to ensure that the analysts had access to the right schemas in the training catalog, but not to everything. The goal was to grant them access to the training…
A1, Access, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, granting, 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, revoking, schema-level, sql, unity catalog -
Granting and Revoking Catalog-Level Access
POST_START Granting and Revoking Catalog-Level Access I’ve been working on setting up a new data pipeline for our analytics team, and one of the key tasks is to ensure that the right people have access to the right data. Today, I need to grant access to the training catalog to a group of analysts. I…
A1, Access, catalog-level, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, granting, 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, revoking, sql, unity catalog -
Creating and Using Reusable SQL Functions
POST_START Creating and Using Reusable SQL Functions in Databricks Unity Catalog I started by opening my Databricks notebook and connecting to the Unity Catalog. I wanted to create a reusable SQL function to calculate tax for sales data, which would help streamline my reporting and analysis. The function needed to take an amount as input…
A1, category:business, category:education, category:software, category:technology, coding, creating, data engineering, data governance, databricks, education, Functions, 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, reusable, sql, 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 -
Dropping Unity Catalog Tables
POST_START <h1>Dropping Unity Catalog Tables</h1> <p>I started my day by reviewing the data pipeline for the customer master table in the training.sales schema. This table had been used for a while, and after a recent data model refresh, it was no longer needed. My task was to safely drop this table from Unity Catalog.</p> <h2>Understanding…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, dropping, 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, sql, tables, unity catalog -
Removing All Rows While Preserving a Table with TRUNCATE
POST_START <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Removing All Rows While Preserving a Table with TRUNCATE</title> </head> <body> <h1>Removing All Rows While Preserving a Table with TRUNCATE</h1> <p>I recently had a need to clear out all the data from a table while keeping the table structure intact. The table in question was <code>training.sales.customer_master</code>, and I…
(all), A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, preserving, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, removing, rows, sql, table, truncate, unity catalog, while -
Renaming Unity Catalog Tables
POST_START <!DOCTYPE html> <html> <head> <title>Renaming Unity Catalog Tables</title> </head> <body> <h1>Renaming Unity Catalog Tables</h1> <p>I recently had a need to rename a table in my Unity Catalog to better align with our data governance standards. The table in question was called <code>training.sales.customers</code>, and I needed to rename it to <code>training.sales.customer_master</code>. This was a straightforward…
A1, category:business, category:education, category:software, category:technology, coding, 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, renaming, sql, tables, unity catalog
