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

Community

Other: Ability to ingest only selected columns from a table using workday HCM connector

Planned
Manoj Behera User

Hi Team,

We need the feature to ingest only selected columns from a table using workday HCM connector.

Reference ticket where it was communicated that all columns from a table has to be selected for ingestion. Reference ticket 301654(now closed).

Thanks,

Manoj

Please sign in to leave a comment.

Comments

7 comments

Date Votes
  • Official comment
    Frank Fivetranner
    • Edited

    Hi Manoj, 

    Thanks for explaining this. We are working on a solution to providing the column names for blocking ahead of initiating the sync. I will update this ticket once we have implemented the solution. 

    Frank

  • Frank Fivetranner
    • Edited

    Hi Manoj, 

    I read the ticket, but I might be missing some context on the column issue specifically. Can you help elaborate and/or provide an example of what you mean by "ingesting only selected columns"?

    Thanks, 

    Frank 

  • Manoj Behera User

    Hi Frank, 

    In our project we had a requirement to ingest a few tables from multiple workday domains. 

    However, we didn't need all the columns from the selected few table e.g we wanted to ingest worker but not all the 90+ columns from that table into Snowflake. The reason was the internal workday team wanted to ingest only the required columns and not all. However, when we tried to do that in Fivetran schema, we werent able to that and while contacted the support team advised that its not possible at this moment. Reference ticket is #301654. 

    Hope this helps.

    Thanks,

    Manoj

  • Manoj Behera User

    Thanks Frank, kindly apprise in case you have some updates on this.

    Thanks,

    Manoj

  • Frank Fivetranner

    Hi Manoj, 

    In the short term we have fixed a bug where the schema was being loaded without the columns so columns should be loaded when the schema fetch is complete. We are working on a long term solution to load the schema faster for customers in the future. 

    Thanks, 

    Frank

  • Manoj Behera User

    Dear Frank, Pls do apprise if there is any update on this.

    Thanks,

    Manoj

  • Frank Fivetranner

    Hi Manoj, are you still facing issues with the schema fetch not showing columns? I believe we fixed a bug in the schema fetch that was preventing columns not showing up. 

    Thanks, 

    Frank