Hi Meera CONVZ,
Thank you for posting query in Microsoft Q&A Platform.
Azure data factory or Synapse pipelines generally perform task on respective storages. In this case, in SQL DB they execute queries. As we now, in SQL SELECT * is not good for performance and SELECT query with column names will have a little impact in improving performance. Hence, in this case SELECT query with column names will help.
Hope this helps. Please let me know if any further queries.
Please consider hitting Accept Answer
button. Accepted answers help community as well. Thank you.