What is Teamdrive?
Google Teamdrive is a shared folder for your team. It functions as any other normal folder inside drive and as such can con contain spreadsheets that you want to connect to.
Connect to spreadsheets in Teamdrive
You can add your Teamdrive spreadsheet as sources when editing or creating a new connection. When choosing the data source, the teamdrive folders should be shown right at the top.