Pulling data from microsoft dynamics 365 to snowflake.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Alex98970
5 - Atom
‎01-19-2023
02:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ?
Labels:
- Labels:
- Batch Macro
- Database Connection
0 REPLIES 0
