question

AmandeepBajaj-2011 avatar image
0 Votes"
AmandeepBajaj-2011 asked RamkumarBalasubramaniam-1544 edited

Data Connector-Shopify is Verfy slow in ADF

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-data-factoryazure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered RamkumarBalasubramaniam-1544 edited

Hi @AmandeepBajaj-2011,


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

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AmandeepBajaj-2011,

Following up to see if you have got a chance to try with Query instead of table name? If so do let us know how it goes.

Thanks

0 Votes 0 ·

Hi @AmandeepBajaj-2011,

Just checking if you have got a chance to try with Query instead of table name? If so do let us know how it goes.

0 Votes 0 ·

Hi @ShaikMaheer-MSFT ,

We'r also facing sort of same issue. We pull data from about 20 Shopify tables. Out of 20, all the time a couple of tables taking ages(approx 2hrs), even if the number of records query returns is in hundreds.

We tried both query and tables. Both gives sort of same performance. All the time same set of tables taking ages.

I hope this helps. Any helps would be really appreciated!

Thanks in advance!

0 Votes 0 ·