Fine Tuning Data Access

You can use the following properties to gain more control over the data returned from Azure DevOps:

• Catalog: Specifies the catalog to be used.
  • If you want to query data for a specific project, set Catalog to the project name. For example, to query data in a project named dev, you should set Catalog to dev. To get a list of project names, execute a SELECT query against the Projects table.
  • If you want to query information that is independent of a specific project, set Catalog to CData.
• Schema: Specifies the schema to be used.
  • If Catalog is set to CData, the only schema available is Information.
  • If Catalog is set to a project catalog, you can set Schema to either Analytics, Project, or one of the Repository schemas. If you want to query data for a specific repository, set Schema to the repository name. For example, to query data in a repository named drivers, you should set Schema to drivers. To get a list of repository names, set Schema to Project and execute a SELECT query against the Repositories table.