[Feature] multiple zendesk instances

fivetran / dbt_zendesk

Fivetran's Zendesk Support dbt package

https://fivetran.github.io/dbt_zendesk/#!/overview

Apache License 2.0

25 stars 30 forks source link

[Feature] multiple zendesk instances #124

Open CaseyLeab opened 10 months ago

CaseyLeab commented 10 months ago

Is there an existing feature request for this?

[X] I have searched the existing issues

Describe the Feature

We have multiple zendesk instances in our organization, how would I setup this package so that I can create the models for each of the zendesk instances we have. (They are all in separate schemas; zendesk_concierge, zendesk, zendesk_partner_success, etc....)

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

[ ] Yes.
[X] Yes, but I will need assistance and will schedule time during your office hours for guidance.
[ ] No.

Anything else?

No response

fivetran-jamie commented 10 months ago

hey there! we were actually heavily considering rolling this out in the coming quarter.

i am curious about your use case -- does each zendesk instance belong to a different department or subsidiary in your org?

CaseyLeab commented 10 months ago

hey there! we were actually heavily considering rolling this out in the coming quarter.

i am curious about your use case -- does each zendesk instance belong to a different department or subsidiary in your org?

Yes, we have 5 different zendesk instances and each belongs to a different organization in the building and different metrics, tickets, and tracking associated to it. In zendesk they're separated by different subdomains so there is an individual connector for each in Fivetran.

fivetran-jamie commented 10 months ago

Gotcha! so the solution we were thinking of rolling out would union together these different instances' source data and produce 1 set of output models -- which you could split out into individual ones based on the source_relation column. would that work for your use case?

CaseyLeab commented 10 months ago

I think that would work. Thank you. Please keep me posted when you prioritize and plan to roll this out as our depts are bummed that ticket_metrics is the biggest table they aren't able to see at the moment.

mariahjrogers commented 5 months ago

Hi, I was wondering if you could provide an update on the progress of this issue @fivetran-jamie ? I am eager for this to be released!