Azure Data Factory - Jira Connector : Query tuning for Agile_Board_Issue_Fields_Issue_Links table
Hi,
I have managed to create and access Jira table data using the Jira Linked Service connector in Azure Data Factory. I'm able to significantly reduce the query time for the Agile_Board_Issue table by using a filter on the Issues_fields_project_id field (reduced to around 1min), however I can't find a way to reduce the time for the Agile_Board_Issue_Fields_Issue_Links table. I've tried a full table load (~13min), filtering on Issues_Key like '<>%', and also by joining back to the Agile_Board_Issue on Issues_Key and then filtering on the project ID.
I've also tried Board_ID (set as part of PK but still slow when filtering on that).
Is there any better way to speed up querying that table?
cheers
Henry
