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

Community

Column deleted from Workday's report but still exists in Fivetran connector schema should not send any values to the destination

Answered
Virginia Tam User

Which connector?: Workday Connector 

 

Additional details:

When a Workday customer deletes a column from their report and sends it to Fivetran,  because the column still exists in the connector schema, Fivetran will send that column with all null values to the destination (as documented here: https://fivetran.com/docs/destinations/troubleshooting/column-deleted-from-source-is-in-destination)

As the destination, it's not clear if we need to null out these fields or if the column was simply omitted. A recommendation is to use a clearer value, such as `undefined` so that the destination knows not to action on the value. 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Tom Jose Fivetranner

    Hi Virginia,

    Thanks for sending over the details. We understand the pain point you're highlighting.

    Let me discuss this with the team and see what the best path forward might be. Please give us some time to investigate, and we'll come back with an update as soon as we have more information.

    We'll also keep the community updated on this thread as we make progress.

    Thanks,
    Tom