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

Community

Connector Improvement: Remove events associated with deleted profiles from dbt_klaviyo flow

Completed
Robert Spragg User

Currently, some of the dbt unit tests built into the `dbt_klaviyo` package fail when one has deleted Klaviyo profiles that are associated with Klaviyo events. 

Tests that fail: 

select person_id from ANALYTICS.analytics_klaviyo.klaviyo__person_campaign_flow where person_id is null
select person_id from ANALYTICS.analytics_int_klaviyo.int_klaviyo__person_metrics where person_id is null

I reached out to Klaviyo a few months ago, and they confirmed that their events API was returning events associated with deleted events, causing these failures. 

Klaviyo has recently deployed a fix for this issue (screenshot attached) where one can now specify `filter=has(profile)` to the events API call.

 

My hope is that this filter can be added to the query of events table which is utilized in the `dbt_klaviyo` flow.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Robert, Luke from the Product team here!

    Thanks for submitting this feature request. We recently added a toggle to our connector setup form that allows customers to filter out events where the associated profile is deleted using filter=has(profile). You can view the changelog here.

    If you go to the setup form for your connector and turn this on, this should resolve this issue. I'll also pass this along to our data models team in charge of the dbt_klaviyo package.

    Thanks,
    Luke