We are at the very beginning of our data journey and the pipelines are going to be many, but quite simple for now.
MySQL, Salesforce, other sales/marketing tools ->Redshift via Airbyte
Then dbt tranformation/tests, probably data verification via great expectation or similar and finally Python scripts to reverse ETL back into a data analytics solution (redash), Salesforce etc.