Snowflake to Sharepoint by COZYROC

This gem involves extracting data from Snowflake, converting it to CSV files, and uploading them to SharePoint. This ensures that data is readily accessible at the chosen SharePoint location for collaboration and reporting. Automation and monitoring ensure data accuracy and timely updates.

Setup Guide

This gem will establish a connection between Snowflake and the Sharepoint location of your choosing. Once the connection is established, the gem will pull the data from each Snowflake table specified in the List Table parameter. The gem will then generate a CSV file for each table data and upload all files to Sharepoint leveraging Microsoft Graph API. The uploaded files will be named Table_currentdate.

To run this integration and connect Snowflake to Sharepoint, you need to specify the parameters below

Snowflake

• Server Host Required. Specify the correct [account identifier] in the server host URL.
• Token File Required. Select the Rest Token file from the drop-down list. Review the KB Article mentioned here on how to generate the token file.
• Warehouse Required. Specify the Snowflake warehouse name.
• Database Required. Specify the Snowflake database name.
• Schema Required. Specify the Snowflake schema name.
• List Table Required. This parameter accepts comma-separated values if you want to pull data from multiple Snowflake tables.
• Timeout Required. Specify the timeout. The default is set to 60.
• Where Optional. Specify to filter the data.
• Batch Size Required. The default is set to 200.
• Compression Optional. The default is set to false.

Microsoft Graph

• Server Host Required. The default is set to https://graph.microsoft.com/v1.0/sites/root when connecting to the default SharePoint instance. Set to https://graph.microsoft.com/v1.0/sites/<site-id> when connecting to a specific SharePoint instance.
• Token File Required. Select the Rest Token file from the drop-down list. Review the documentation mentioned here regarding how to generate the token file.
• Destination Folder Required. Specify the path to the destination folder ending with the trailing slash.