Pulling data from Azure Boards into databricks

[Jeade]

Looking for best practises/examples on how to pull data (epics, features, PBIs) from Azure Boards into databricks for analysis.

Any ideas/help appreciated!

[artsheiko]

you can use export to csv (link), push the file to the storage mounted to Databricks or just import the file obtained to dbfs

[Jeade]

yup, .csv export/import is OK for a one-time load, but I was looking for a more automated method - that could be scheduled to sync daily.

[artsheiko · Accepted solution]

in that case you can use Queries and Azure DevOps API :

• Authentication
• Boards - List
• Queries - Get
• Wiql - Get