Create views in Azure Databricks Unity catalog using service principal

Ashwini Gaikwad 130 Reputation points
2024-11-13T16:51:42.7266667+00:00

Hello Team,

Is there a possibility to Create views in Azure databricks Unity Catalog using service principal.

and if there is how to update views based on tables added or deleted in schema. For e.g. I would like to create each views per tables in the schema using service principal , so how can I manage it if a new table is added or existing table is updated or deleted?

are there any reference article for it?

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,262 questions
{count} votes

1 answer

Sort by: Most helpful
  1. phemanth 11,980 Reputation points Microsoft Vendor
    2024-11-25T11:46:26.65+00:00

    @Ashwini Gaikwad

    I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

    Ask:

    Is there a possibility to Create views in Azure databricks Unity Catalog using service principal.

    and if there is how to update views based on tables added or deleted in schema. For e.g. I would like to create each views per tables in the schema using service principal , so how can I manage it if a new table is added or existing table is updated or deleted?

    are there any reference article for it?

    Solution:

    But I managed to create the views using SPN as per my below code. Thank you for your time and assistance.

    User's image User's image

    If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

    If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.