Thanks @anagilla , this was really helpful to point me in the right direction. One edit, while you're right on the SharePoint connector that is available/supported by databricks being serverless only at this time (not sure if in the future this will be expanded to run with job compute and/or all-purpose compute), it is actually possible to create your own "Community Connector" that runs either with Serverless toggled on (by default) or off. However, if Serverless is toggled off, this comes with some additional Pipeline environment Dependency configurations which both of these posts dive into:

• Solved: Re: Issue: Lakeflow Connect Microsoft Teams Commun... - Databricks Community - 163789
• Solved: Re: Lakeflow Community Connector Issue - ModuleNot... - Databricks Community - 163634