I've been trying it out, and yes, I can access "tables" like "Documents" or "Shared Documents" (names of SharePoint document libraries).
This allows me to extract the *list* of documents in the library, and their attributes. Like the name, file type, file size, last modified date, path, et cetera. Which could be handy.
But I was wondering if I could use the SharePoint Query component to extract the *contents* of a particular CSV or Excel file that resides in SharePoint. From what I can tell, the answer is "no."
Instead, I have seen this more recent post... https://redshiftsupport.matillion.com/customer/portal/questions/17539392-sharepoint-download-excel-file ...Which describes using the "Data Transfer" component with Source Type = 'Microsoft SharePoint" to copy a file from SharePoint to S3. Then, of course, Matillion has other components for extracting the contents of CSVs, Excel files, et cetera -- if those files are in S3. So I suppose this is the solution (rather than using the SharePoint Query component) for extracting the *contents* of files that reside in SharePoint.