[Feature] Add picklist_poll_response to increase poll response coverage #36
Description
Is there an existing feature request for this?
- I have searched the existing issues
Describe the Feature
Currently, there is the below in the poll_response field for the poll_event source, noting that there is no way of obtaining the picklist response value:
There is now a new table available from Pendo called picklist_poll_response which contains a response_id. This can be joined with poll_event via poll_response to provide the picklist value. And while this table isn't used very much downstream, it would be great to at least have all responses covered in the staging model.
Describe alternatives you've considered
No response
Are you interested in contributing this feature?
- Yes.
- Yes, but I will need assistance and will schedule time during your office hours for guidance.
- No.
Anything else?
Here is an example query that's worked for us:
with
poll_events as (
select * from raw.fivetran_pendo.poll_event
),
picklist_responses as (
select * from raw.fivetran_pendo.picklist_poll_response
),
joined as (
select
poll_events.*,
picklist_responses.response_text as picklist_response_text
from poll_events
inner join picklist_responses
on poll_events.poll_response = picklist_responses.response_id
)
select
poll_id,
poll_response,
picklist_response_text
from joined;