Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Add Linear Issue Relations to Fivetran

Answered
Tripp Smith User
Connector name: Linear

Table name: ISSUE_RELATION


Additional details: The Linear connector syncs `ISSUE` and related tables into Snowflake, but does not sync peer issue relationships (`related`, `blocks`, `duplicate`, `similar`). These are distinct from sub-issue hierarchy (`ISSUE.PARENT_ID`). We need an `ISSUE_RELATION` table with `id`, `issue_id`, `related_issue_id`, `type`, `created_at`, `updated_at`, `archived_at`, and standard Fivetran metadata columns to analyze cross-team linked issues (e.g. Product ↔ Implementation dependencies). Airbyte's Linear source already syncs an `issue_relations` stream.
https://docs.airbyte.com/integrations/sources/linear
https://linear.app/docs/airbyte

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Syead Mujtaba Imam Rizwi Fivetranner

    Hi Tripp, thank you for the request.

    Adding support for peer issue relationships is a valuable idea for analyzing cross-team dependencies, and we have added it to our feature improvements backlog. We have confirmed that the relevant relationship data is available in Linear's API. Could you share more about how you plan to use the relationship types, for example, whether blocks and duplicates are equally important to your analysis? We will keep you updated on this thread as we make progress.

    Best,
    Syead Mujtaba Imam Rizwi

  • Tripp Smith User
    Yes, we are interested in “related”, “blocks”, “duplicate”, etc., equivalent to the API. Duplicate is the least important, but “blocks” and “related” are equally important. This is how you know that an issue in one project is stopping another from progressing for example. We are also interested in tracking history for this entity, although the API only provides current state.
  • Erica Fagin User

    +1, my team needs this as well for `blocks`, `duplicate`, and `related`. We have Linear data currently ingested in Y42 for a productivity analytics pipeline, and we'd like to replace the ingestion with Fivetran, but we're currently blocked on the `IssueRelation` field not being available. We'll likely move forward with a custom connector in Fivetran using the SDK for just this field, but it's not a super elegant solution.