Overview

This section shows the available API objects and provides more information on executing SQL to Azure DevOps APIs. Note that this schema can only be accessed when Catalog is set to a project and Schema is set to a repository.

Key Features

• The connector models Azure DevOps entities like Git branches, pull requests, and pushes as tables and views, allowing you to write SQL to query Azure DevOps data.
• Stored procedures allow you to execute operations to Azure DevOps
• Live connectivity to these objects means any changes to your Azure DevOps account are immediately reflected when using the connector.

Tables

Tables describes the available tables. The provider models the data in Azure DevOps into a list of tables that can be queried using standard SQL statements.

Views

Views describes the available views. Unlike tables, views are read-only.

Stored Procedures

Stored Procedures are SQL scripts that extend beyond standard CRUD operations. They allow you to execute operations to Azure DevOps, such as creating a pull request.