Share via

How to show mapping columns in Select - Data flow

16536432 0 Reputation points
2023-07-11T13:21:08.4433333+00:00

Hello everyone,

I'm having an Issue with the Select tool in Azure Synapse.

When plugging it with my source, it doesn't show the columns to mapp.

Am i supposed to activate/disactivate something ? Is there anyone having the same issue ?

User's image

Thank you.

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,150 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,160 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,196 Reputation points Microsoft Employee
    2023-07-11T18:32:26.8533333+00:00

    Hello 16536432,

    Welcome to Microsoft Q&A

    It looks like the schema is not properly imported (or the schema might have changed)

    on the source dataset, please click on Import schema

    and then on the select transformation, click on "reset". You will see the column mapping after this.

    User's image

    User's image

    I hope this helps.

    Please let me know if you have any further questions.

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.