New columns not visible on Inspect Tab | Data Factory Pipeline

Deniz Alkan 101 Reputation points
2022-09-06T10:55:36.237+00:00

Hi everyone,

When I add new columns on Source component, they don't appear in the next component. Lets say there is 10 columns in Source Table and we add 2 new column and now we have 12 columns but in next component there is still 10 column in Inspect tab.

There is no Update or Import Schema options in Inspect tab. So I could not map new column to Sink.

Also I can see new columns in Data Preview tab. I can see data which this columns include but in Inspect tab there is no new columns so I can't use this new columns on Sink component

Is there any solution?

Thanks,
Deniz

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,755 questions
{count} votes

Accepted answer
  1. AnnuKumari-MSFT 31,726 Reputation points Microsoft Employee
    2022-09-07T04:20:19.127+00:00

    Hi @Deniz Alkan ,
    Welcome to Microsoft Q&A platform and thanks for posting your question here.
    As I understand your issue, post the schema change in the source, you are not able to see the new schema in inspect tab of your mapping dataflow . Please let me know if that's not what your concern.

    Kindly import schema in the source dataset or in the projection tab, try to import projection before you check the inspect tab.

    Also, kindly make sure 'Allow schema drift' option is checked in the source transformation.

    238249-image.png

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful