This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
hello,
in the dataflow of data factory, I have the source which gets data from sql server
Then I use select to get the columns I require and rename some of them.
for example: column1, column2, extract_date which I renamed to timestamp
All good so far.
In the alter row I have insert if set to true()
In the sink, I have the dataset pointing to sql server table to insert to.
Question:
In sink preview tab, I only see column1 and column2. Timestamp column is not shown.
Do you know why?
Thank you
An Azure service for ingesting, preparing, and transforming data at scale.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi
arkiboys,
Thanks for posting this question in Microsoft Q&A forum.
As I understand, in Data Flow Sink column is not appearing.
I tried and could see it fine.
Could you please share more details like Sink Settings and Mapping tab details, date format used in Source and Sink:
Thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Hi @arkiboys what about the preview tab in alter row transformation? are all the columns turning up? And is auto mapping enabled in the sink or you are explicitly mapping?
Yes to seeing all three columns in alter raw.Yes it is set to auto mapping
solved as it was a spelling issue. thank you
Hi @arkiboys
If you are able to see all the columns till alter row transformation, you should see it till sink too. Due to some reason it is not showing up. You may try to delete the sink and add it afresh, to let go of any cache issue. Since you have auto mapping enabled, that should be the easiest trial and error method.
Please let us know how it goes.
Thanks
Suba