cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Delta live table : run_as

KevinGagnon
New Contributor

Does Databricks have any plans to decouple the owner from the "run_as" identity in Delta Live Table like it can be done in jobs?

The problem arise specially when using DABs. The service principal used to deploy DLTs shouldn't be the owner AND the runner. It forces us to either give too much rights to the deployment service principals or break the configuration the DAB made to assign a new owner to all DLTs deployed... but are not suitable.

1 REPLY 1

Kaniz_Fatma
Community Manager
Community Manager

Hi @KevinGagnonDatabricks currently does not have plans to decouple the owner from the "run_as" identity in Delta Live Tables, unlike what can be done with jobs. 

The key points are:

  • The Delta Live Table pipeline runs using the credentials of the pipeline owner, which means that the owner is also the identity used to run the pipeline.
  • There is currently no way to change the "run_as" identity to a service principal, separate from the pipeline owner. This can be an issue when the pipeline should not run as a human user, but rather as a service principal.
  • To work around this, the recommended approach is to create a service principal in the Azure Active Directory, add it as a service principal in the Databricks admin settings, and then assign that service principal as the owner of the Delta Live Table pipeline. This allows the pipeline to run using the service principal credentials.
  • However, this still means the service principal has full "IS OWNER" permissions on the pipeline, which may provide more access than is required just for running the pipeline.

In summary, Databricks currently does not offer a way to decouple the pipeline owner from the "run_as" identity in Delta Live Tables, unlike the flexibility available for jobs. Users have to work around this by using a dedicated service principal as the pipeline owner. Databricks may consider adding this capability in the future, but there is no indication of any such plans as of now.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!