Looking for data load solution to Snowflake db

I've multiple sources like SharePoint, OnPremise db, and Azure blob. Need solution to automate this data load. And also, need to implement role based security. Looking for someone who has done it already.
I would need proper design document, implementation not required.