Azure data factory bulk insert

Meera 0 Reputation points
2023-09-16T05:26:13.0933333+00:00

During bulk insert of sql tables i have used SELECT * FROM [@{item().TABLE_SCHEMA}].[@{item().TABLE_NAME}] in copy activity of source. Using select * will reduce the performance and expensive?usually select *will be avoided in database.

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,316 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,444 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 37,656 Reputation points Microsoft Employee
    2023-09-27T09:31:43.8566667+00:00

    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.