Forum Discussion

shruti02's avatar
shruti02
Copper Contributor
Jul 11, 2023

how to upload snowflake query results to sharepoint folder?

programmatically i am trying to upload snowflake query results to sharepoint folder

  • Lalit Mohan's avatar
    Lalit Mohan
    Iron Contributor

    shruti02 

     

    To upload Snowflake query results to a SharePoint folder programmatically, follow these simplified steps:

    1. Execute the Snowflake query and fetch the results.
    2. Connect to SharePoint using a suitable API or library.
    3. Prepare the query results for upload by converting them to a compatible format (e.g., CSV, Excel, JSON).
    4. Upload the prepared data to the SharePoint folder using the SharePoint API or library.

    Remember to adjust the code according to your specific requirements and access credentials for Snowflake and SharePoint.