Repository Data Model
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 provider models Azure DevOps entities like documents, folders, and groups as relational 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 provider.
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. Views are statically defined to model Projects, Tasks, Teams, etc. Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
Stored Procedures
Stored Procedures are function-like interfaces to Azure DevOps. Stored procedures allow you to execute operations to Azure DevOps, including downloading documents and moving envelopes.