Official

Premium

Azure DevOps

The CloudQuery Azure DevOps plugin reads information from your Azure DevOps account and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v5.1.0

Type

Source

Platforms

Date Published

October 30, 2024

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Documentation Tables Changelog Destinations

Overview

Set up process #

brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync azuredevops.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

The CloudQuery Azure DevOps plugin reads information from your Azure DevOps account and loads it into any supported CloudQuery destination (e.g. PostgreSQL, Snowflake, BigQuery, and more).

Authentication #

You will need an API token to access Azure DevOps resources. This can be obtained by creating an API token. It's recommended to allow only read access to the resources you need to sync.

Configuration #

This example syncs from Azure DevOps to a destination. The (top level) source spec section is described in the Source Spec Reference.

kind: source
# Common source-plugin configuration
spec:
  name: azuredevops
  path: cloudquery/azuredevops
  registry: cloudquery
  version: "v5.1.0"
  tables: ["*"]
  destinations: ["postgresql"]

  # Azure DevOps specific configuration
  # Learn more about the configuration options at https://cql.ink/azuredevops_source
  spec:
    personal_access_token: "${AZURE_DEVOPS_PERSONAL_ACCESS_TOKEN}"
    organization_url: "${AZURE_DEVOPS_ORGANIZATION_URL}"
    # Optional parameters
    # concurrency: 10000

This example uses the AZURE_DEVOPS_PERSONAL_ACCESS_TOKEN and AZURE_DEVOPS_ORGANIZATION_URL environment variables. You can also hardcode the values in the configuration file, but this is not advised for production settings.

Azure DevOps Spec #

This is the (nested) spec used by the Azure DevOps source plugin.

personal_access_token (string) (required)
An API token to access Azure DevOps resources. This can be obtained by creating an API token. It's recommended to allow only read access to the resources you need to sync.
organization_url ([]string) (required)
The Azure DevOps organization URL. Should be in the format https://dev.azure.com/{organization}.
concurrency (integer) (optional) (default: 10000)
A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.
scheduler (string) (optional) (default: dfs) The scheduler to use when determining the priority of resources to sync. Supported values are dfs (depth-first search), round-robin, shuffle and shuffle-queue.
For more information about this, see performance tuning.