Send data from Wdata back to Snowflake?
Udzielono odpowiedziHey there!
We are looking to send data prepared in Wdesk back to Snowflake using Wdesk. Coming up a bit short on how that's prepared and what the chain should look like so figured I'd ask here to see if anyone else has tried to do this and has done so successfully.
It would basically be a tab in our quarterly spreadsheet that gets picked up by Wdata and sent to Snowflake so our Finance team can use that data to ensure that we are all working from the same data.
-
Hi Brian,
This would be possible in Chains by using the Snowflake JDBC Connector. This Connector allows you to perform SQL operations in Snowflake databases. High level steps in your Chain could be to retrieve data from the Spreadsheet using the Workiva Connector Get Sheet Data Command. Then use the various Snowflake JDBC Commands to write the data to the Snowflake database.
Alternative to the Snowflake JDBC Connector, you may also be able to utilize Snowflake's APIs and the HTTP Request Connector to push data from Workiva to Snowflake via a Chain.
Thanks,
Jeff0Zaloguj się, aby dodać komentarz.
Komentarze
Komentarze: 1