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 'Project'.

Key Features

• The connector models Azure DevOps entities like builds, environments, and feeds 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 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. Dynamic views beginning with 'Query_' and 'Backlog_' are also supported.