category:business
-
Managing Schema-Level SELECT Access Across Tables
POST_START Managing Schema-Level SELECT Access Across Tables I recently had to set up access controls for a team of analysts who needed to query a set of tables in the training.sales schema. Since the analysts would be working with multiple tables within this schema, I decided to grant them schema-level SELECT access rather than individual…
A1, Access, Across, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, Managing, 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, schema-level, select, sql, tables, unity catalog -
Controlling Table Data Changes with MODIFY Privileges
POST_START Controlling Table Data Changes with MODIFY Privileges I recently had the task of ensuring that only specific data engineers could modify the customer data in our training database. The goal was to prevent accidental or unauthorized changes to the training.sales.customers table while still allowing the team to perform necessary updates. I decided to use…
A1, category:business, category:education, category:software, category:technology, changes, coding, controlling, data, data engineering, data governance, databricks, education, Lakehouse, modify, 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, sql, table, unity catalog -
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
