you can try to copy data from a SharePoint Online using Azure Data Factory and the Copy activity in an Azure Synapse pipeline, and then use the Snowflake connector in Azure Data Factory to load the data into a Snowflake table. You need to configure a connection to your Snowflake account and specify a target table.