Select transformation output schema is empty after renaming columns

AdnanT 0 Reputation points
2024-11-20T16:26:53.2266667+00:00

I've followed the example from the link:

https://learn.microsoft.com/en-us/azure/data-factory/tutorial-data-flow-dynamic-columns

It's exactly what I need for my project, but unfortunately, no matter what I do, the output schema of the select transformation remains empty.

User's image

User's image

Data Preview of the select transformation (and all subsequent transformations) shows that columns are, in fact, renamed as expected.

I could map drifted columns, but that transformation maps only renamed columns, and the rest I'd need to manually map which is not ideal when dealing with a lot of non-drifted columns, but ideally, I shouldn't even need to do this.

Is there a reason why this happens, and what would be the solution (preferably not a hack-y one :D)?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,012 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,911 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.