Not Able to see underline Columns for Joining in Data Flow Activity in ADF

Question

Hi Community,

I am using Data Flow Activity to transfer the data from Azure SQL DB to Azure Synapse (Dedicated Sql Pool) But I am not able to see underline Columns for Joining in Data Flow Activity in ADF.. Pls advise.. When I preview data, I can see underline data.

Answer 1

To resolve the issue of not seeing underlying columns for joining in Azure Data Factory's Data Flow Activity, ensure that you have the correct schema by checking the "Schema" tab in the "Source" transformation and using the "Import projection" option.

Make sure Debug mode is on for better visibility, and verify that data types are compatible for the columns you're joining.

Refresh the schema if necessary, and ensure column names are case-sensitive. If issues persist, review the pipeline run logs for errors or contact Azure Support for further assistance.

https://stackoverflow.com/questions/72141390/not-able-to-transform-and-load-from-adlscsv-to-dedicated-sql-pool-by-using-azu/72167481