I’m wondering if there’s a way to leverage Power Automate to automatically update data tables within Snowflake every time a sharepoint list is updated?
Best answer by Ethem Q
View originalI’m wondering if there’s a way to leverage Power Automate to automatically update data tables within Snowflake every time a sharepoint list is updated?
Best answer by Ethem Q
View originalFrom your inquiry it looks like you want to automate a process so that every time your Sharepoint Lists get updated the changed data will be transferred in a destination Snowflake database is that right?
While we do have solutions that allow you to connect to both Sharepoint and Snowflake in Power Automate, I am not immediately sure if you can accomplish what you are looking for. My understanding is that, your flow would consist in 2 parts, one part would be responsible for triggering the flow when a column or item is modified in Sharepoint whereas the other part would require to get those changes and push them to Snowflake. Based on some research it seems you can achieve the first part within PowerAutomate itself:
https://powerautomate.microsoft.com/it-it/blog/run-a-flow-when-a-sharepoint-column-is-modified/
As for the second part you can make use of our Connect Cloud solution in order to create a connection to Snowflake and connect to Power Automate as displayed here: https://www.cdata.com/kb/tech/snowflake-cloud-power-automate.rst
My assumption would be that you should be able to push the changes into Snowflake by making use of the above however we don't have much expertise with Power Automate and have not tested a similar use case before, so you will need to explore this option on your own if Power Automate is a critical component for you. We would be happy to assist you with making a connection to Snowflake in Connect Cloud however. You can sign up for a trial here:
Returning to your end goal, if Power Automate is not critical for you we do have several alternative solutions you might want to explore:
If you have any further questions regarding our offerings please submit a ticket here or reach out to the support team at support@cdata.com and we would be happy to assist you.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.