databricks Platform · Updated Jun 23, 2026

Change Owner of Streaming Tables and Materialized Views

Enhance ownership management for pipeline datasets in Databricks SQL.

What it does

The update allows users to change the owner of streaming tables and materialized views that are backed by standalone pipelines in Databricks SQL using the `ALTER STREAMING TABLE` and `ALTER MATERIALIZED VIEW` commands with `SET OWNER TO`. This functionality is applicable to datasets created with either Databricks SQL or Lakeflow Connect, enabling greater flexibility in dataset management. However, modifications made with `ALTER` statements may be overridden by the pipeline's SQL definition during updates.

Why it matters

This enhancement streamlines the management of data ownership, which is crucial for governance and compliance in data operations. By enabling ownership changes directly through SQL commands, organizations can improve their data stewardship and reduce administrative overhead. This is particularly beneficial for teams managing multiple datasets and needing to reassign ownership as personnel or project responsibilities change.

Key capabilities

Change Owner

Use `SET OWNER TO` in SQL commands to update dataset ownership.

Modify Streaming Tables

Alter properties of streaming tables created with standalone pipelines.

Adjust Materialized Views

Change attributes of materialized views using SQL commands.

Compatibility with SQL Environments

Utilize `ALTER` statements across various Databricks SQL environments.

Prerequisites

User must have appropriate permissions to alter dataset ownership.

Datasets must be created using standalone pipelines in Databricks SQL.

Recommended use cases

Reassign ownership of datasets when team members change.Manage access control for sensitive data effectively.Update dataset ownership as part of compliance audits.

Limitations · remember

!Changes made with `ALTER` statements may be overridden by the pipeline's SQL definition during updates.

!Cannot modify the schedule or trigger of a dataset defined in SDP with an `ALTER` statement.

Architecture

Databricks SQL → Standalone Pipelines → Lakeflow Connect → Streaming Tables → Materialized Views

Get started

Access Databricks SQL

Log into your Databricks SQL environment.

Identify Dataset

Locate the streaming table or materialized view you wish to modify.

Execute ALTER Command

Run the `ALTER STREAMING TABLE` or `ALTER MATERIALIZED VIEW` command with `SET OWNER TO`.

Verify Changes

Check the ownership of the dataset to confirm the update.

Monitor for Conflicts

Be aware of potential overrides from the pipeline's SQL definition on updates.

Key takeaway

The ability to change ownership of streaming tables and materialized views enhances data governance and operational efficiency in Databricks SQL.

2026-06-23-change-the-owner-of-standalone-pipeline-streaming-tables-and-materialized-views Generated by the Databricks Updates Agent · browse all updates