Create dbt converter for Airbyte Jira source connector

[marcosmarxm]

The goal of this task is to ensure the Airbyte Jira connector output can be used to run Fivetran's dbt analytical model.

Definition of Done:

• Create a pull request that adds new tables or views, enabling the execution of Fiventran's dbt with Airbyte output data.
• Update the documentation inside the connector folder to explain how to configure the user dbt package to run the analytical model.

Resources:

• Check example of how it was done for Zendesk Support connector

[josix]

I would like to take it, thanks!

[JunqiYangjqy]

Hey @marcosmarxm
Is it possible for multiple people to work on the same issue (also I see this has been assigned already)? @HaozhiTan & I are interested in this as well :)
Thanks

[marcosmarxm]

@JunqiYangjqy could you post in #airbyte-dbt-packages channel? The decision is up to @josix about it

[josix]

That's okay to do so, I'll consolidate some to-do items in the description tomorrow , feel free to take them.

[josix]

Hi @marcosmarxm here is the model mappings I found for step1, could you help review it and create the subtasks in the description so that @JunqiYangjqy and @HaozhiTan could work some of them, thanks a lot!

Fivetran	Airbyte
comment	issue_comments
component	project_components
field	issue_fields
field_option	❌ it doesn't exist
issue	issues
issue_field_history	❌ it doesn't exist
issue_link	issue_remote_links
issue_multiselect_history	❌ it doesn't exist
issue_type	issue_types
priority	issue_priorities
project	projects
resolution	issue_resolutions
sprint	sprints
status	workflow_statuses
status_category	workflow_status_categories
user	users
version	project_versions

Resource:

• https://github.com/fivetran/dbt_jira_source/tree/main/models
• https://github.com/airbytehq/airbyte/tree/master/airbyte-integrations/connectors/source-jira/source_jira/schemas

[marcosmarxm]

@josix can you check if issue_fields doesn't have a option object or array field?
The same for issues table.

[marcosmarxm]

@josix can you check my last message?

[josix]

Sorry that I missed it, I will check it later today.

[josix]

I checked that there are some similar definitions between field_option (Fivetran) and issue_custom_field_options (airbyte) but not sure if they are meaning the same items, as for issues table, I didn't find columns mentioned issue_multiselect_history or issue_field_history
@marcosmarxm could you help check that, thanks

[topefolorunso]

No update on this for a week @josix. Can I take this up? cc: @marcosmarxm

[josix]

No worries, feel free to take it.