Connector Improvement: Adding support for JQL in Jira connector to filter issues during data sync process
Not plannedHi Fivetran Team,
We are currently evaluating Fivetran as a tool to support our ELT pipeline for JIRA but we cannot find a way to apply JQL to filter issues that we want to export/import in the context of a given project(s).
- Is it something that can be added to Jira connector configuration?
- Is there a way to apply JQL-based transformation AFTER the data is loaded into destination? (in other words is there a JQL-to-SQL query transformation for Fivetran Jira data model that can be applied on destination)
-
Official comment
Hi,
As of right now we don't support this functionality and you can only filter your data by projects nor do we support any custom transformations after the data is loaded. Is there a particular reason why you cannot use SQL based transformations after the data is loaded into your destination?
Frank
-
Hi Frank,
Our product shall allow our customers to configure ELT pipeline for their Jira instance. One of the options we would like to give to our customers is to specify the filter via JQL, so that only a subset of project data is imported into their destination rather than the data for entire project.
-
Sergii,
Are there specific filters that would be utilized such as creation date that your customers are interested in or are they more complex filters?
Frank
-
Frank,
I would say that we expect our customers to use any filtering that is available when using JQL in Jira Cloud (i.e. filters of any complexity involving multiple fields, various conditions and logical operators).Sergii
-
As of right now we don't support any filtering for JIRA, but will let you know if that changes in the future.
Please sign in to leave a comment.
Comments
5 comments