[Qualtrics Pass Through Columns] Please add qualtrics__survey_response_passthrough_columns feature to Qualtrics package

[sharansalemphil]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

Hi, I'm trying to access "TEXT" field on question_response table in Qualtrics.

This field is not available by default inside dbt_packages/qualtrics_source/models/stg_qualtrics__survey_response.sql file.

Could you please enable Pass Through Columns feature on this model as well?
Similar to qualtrics__survey_pass_through_columns, qualtrics__directory_pass_through_columns, etc.

How would you implement this feature?

Please add/replicate {{ fivetran_utils.fill_pass_through_columns('qualtrics__survey_response_passthrough_columns') }} feature inside dbt_packages/qualtrics_source/models/stg_qualtrics__directory_mailing_list.sql file.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• Yes.
• Yes, but I will need assistance.
• No.

Anything else?

No response

[fivetran-joemarkiewicz]

@sharansalemphil thanks for opening this feature request. Ultimately, I believe it would be beneficial for us to add the TEXT field to the base package as opposed to adding a passthrough variable to support this. My team will take this on in our upcoming sprint. However, if you do end up being interested in opening a PR then we would be happy to review the changes sooner to integrate into the upcoming release.

[sharansalemphil]

@fivetran-joemarkiewicz perfect! That makes more sense, and it would be great!
I would love to do it myself and create a PR, but I haven't done that before, especially to an open source project of this scale.

[fivetran-joemarkiewicz]

@sharansalemphil no worries at all. If you want to open a PR I would recommend starting by forking this repo and adding in the field. You can then open a PR to this repo and we can continue collaboration on this effort from there.