We are requesting the addition of a feature to the Fivetran GitHub connector that allows us to retrieve "Parent Issue" information, which represents the hierarchical relationship between issues.

Currently, the Fivetran GitHub connector (https://fivetran.com/connector-erd/github) does not have a field in the Issue table that indicates the parent issue. Therefore, analyzing the dependencies and hierarchical structure between issues requires complex processing such as parsing issue bodies and comments.

The GitHub GraphQL API allows you to retrieve parent-child relationships between issues using the parent field of an issue. By having the Fivetran connector utilize this GraphQL API and adding a field such as parent_issue_number to the Issue table, the following benefits can be expected:

• Improved efficiency in analyzing issue dependencies: You will be able to directly retrieve parent issue information, eliminating the need for complex SQL queries and data transformation processes.
• Enhanced visibility of issue management: It will be easier to create issue management dashboards and reports that consider parent-child relationships.
• Increased accuracy of data analysis: You can obtain more reliable analysis results by accurately understanding the relationships between issues.

Specific Requests:

• Add a parent_issue_number (INTEGER type) field to the Issue table to store the issue number of the parent issue.
• Utilize the GitHub GraphQL API to retrieve parent issue information from the parent field and store it in the parent_issue_number field.
• Store a NULL value in the parent_issue_number field if the parent issue does not exist.

We believe that adding this feature will enable Fivetran users to leverage GitHub issue data more effectively. Thank you for your consideration.