Data Connector-Shopify is Verfy slow in ADF

Amandeep Bajaj 26 Reputation points
2021-09-01T11:06:59.523+00:00

Shopify Data connector which is preview is very slow and the output for certain tables drops to bytes/sec , how can we optimize this connector?

Do we write the query instead?

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

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,432 Reputation points Microsoft Employee
    2021-09-02T07:37:39.137+00:00

    Hi @Amandeep Bajaj ,

    Thanks for using Microsoft Q&A forum and posting your query.

    Just wanted to check if your connector slow performance is consistent or random? I would also recommend you to please give a try with query instead of table name and see the difference in performance behavior.

    And as this connector is in preview, this could be also due to some underlying issues. Hence we recommend you to file a support ticket if this continues so that a support engineer can take a deeper look and if needed they can involve the relevant driver team to further investigate as needed and improve the connector performance.

    Hope this info helps. Do let us know how it goes with Query. Also if you have filed a support ticket, please do share the SR# with us here for tracking it internally.

    Thank you