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 name and Schema is set to a repository name.

Key Features

• The server 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.
• Live connectivity to these objects means any changes to your Azure DevOps account are immediately reflected when using the server.

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.