Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Pulling data from microsoft dynamics 365 to snowflake.

Alex98970
5 - Atom

Hi everyone,

I am trying to pull data from tables from dynamic 365 and dumping it in snowflake.

 

There is one of the table which is having 3 mil records in it.

 

Going through the official document (Dynamics CRM Input tool) is deprecated and it is suggested to use Dataverse tools.

(The Dynamics CRM tools are deprecated. Install the Dataverse tools which provide updated features.)

 

I am using Dataverse input tool to pull data from 365. 

Choose Provide authentication information -> ClientID, CLientSecret, Tenant ID, Instance URL to establish connection with 365.

 

When I am pulling data and storing in snowflake it took around 3+ hrs to finish the load in snowflake. 

 

How can I performance tune this. Or is there a better way to do this ?

0 REPLIES 0
Labels
Top Solution Authors