Hello Team, I am looking for in-built connector for Microsoft Teams folder. An excel file is input for one of the Matillion workflow requires to be picked up from teams folder and load the data into snowflake table

Matillion ETL
1

SharePoint Query does not work as URL is https://ts.companyname.com/sites.... and this component required URL in https://<account>.sharepoint.com format so this particular component does not support.

2

Teams folder is essentially Sharepoint under the hood. You can use Data Transfer component and select "Microsoft Sharepoint" as source type, "Sharepoint Online" as the Edition , and pass the File URL to fetch the data, stage it and then load into your snowflake table.