Back to source plugin
Export from Azure DevOps to BigQuery
CloudQuery is an open-source data integration platform that allows you to export data from any source to any destination.
The CloudQuery Azure DevOps plugin allows you to sync data from Azure DevOps to any destination, including BigQuery. It takes only minutes to get started.
Azure DevOps
v4.4.5
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
v4.4.5
Type
Source
Platforms
Date Published
BigQuery
v4.1.8
Official
BigQuery
The BigQuery plugin syncs data from any CloudQuery source plugin(s) to a BigQuery database running on Google Cloud Platform
Table of Contents
MacOS Setup
Step 1. Install CloudQuery
brew install cloudquery/tap/cloudqueryStep 2. Log in to CloudQuery CLI
cloudquery loginStep 3. Configure Azure DevOps source plugin
You can find more information about the configuration in the plugin documentation
kind: source
# Common source-plugin configuration
spec:
name: azuredevops
path: cloudquery/azuredevops
registry: cloudquery
version: "v4.4.5"
tables: ["*"]
destinations: ["v4.1.8"]
# Azure DevOps specific configuration
spec:
personal_access_token: "${AZURE_DEVOPS_PERSONAL_ACCESS_TOKEN}"
organization_url: "${AZURE_DEVOPS_ORGANIZATION_URL}"
# Optional parameters
# concurrency: 10000Step 4. Configure BigQuery destination plugin
You can find more information about the configuration in the plugin documentation
kind: destination
spec:
name: bigquery
path: cloudquery/bigquery
registry: cloudquery
version: "v4.1.8"
write_mode: "append"
# Learn more about the configuration options at https://cql.ink/bigquery_destination
spec:
project_id: ${PROJECT_ID}
dataset_id: ${DATASET_ID}
# Optional parameters
# dataset_location: ""
# time_partitioning: none # options: "none", "hour", "day"
# service_account_key_json: ""
# endpoint: ""
# batch_size: 10000
# batch_size_bytes: 5242880 # 5 MiB
# batch_timeout: 10sStep 5. Run Sync
cloudquery sync azuredevops.yml bigquery.yml