https://community.databricks.com/t5/data-engineering/access-from-dbt-job-to-azure-devops-repository-using-service/m-p/55492#M30348 <P>Hi,</P><P>We are using Databricks bundles to deploy our DBT project. Everything is set up to deploy and run as a Service Principal.</P><P>The DBT job is connected to an Azure DevOps repository. The problem is that we cannot find a way to properly authenticate the SP and the repository. The only way we found is to use the Databricks cli / api to create a git connection, however you can only add a PAT. As far as I know you are not able to generate a PAT for a service principal in Azure DevOps. If the PAT needs to be generated by a user anyway, this defeats the whole purpose of using a SP.</P><P>What is the best way to set this all up without using user accounts?</P><P>Thanks!</P> Tue, 19 Dec 2023 09:51:45 GMT Jules 2023-12-19T09:51:45Z https://community.databricks.com/t5/data-engineering/access-from-dbt-job-to-azure-devops-repository-using-service/m-p/55492#M30348 <P>Hi,</P><P>We are using Databricks bundles to deploy our DBT project. Everything is set up to deploy and run as a Service Principal.</P><P>The DBT job is connected to an Azure DevOps repository. The problem is that we cannot find a way to properly authenticate the SP and the repository. The only way we found is to use the Databricks cli / api to create a git connection, however you can only add a PAT. As far as I know you are not able to generate a PAT for a service principal in Azure DevOps. If the PAT needs to be generated by a user anyway, this defeats the whole purpose of using a SP.</P><P>What is the best way to set this all up without using user accounts?</P><P>Thanks!</P> Tue, 19 Dec 2023 09:51:45 GMT https://community.databricks.com/t5/data-engineering/access-from-dbt-job-to-azure-devops-repository-using-service/m-p/55492#M30348 Jules 2023-12-19T09:51:45Z