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.
4,118 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,090 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 23,771 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.