Too Long; Didn't Read
Data Warehouse is a place you store and organize your data before analysts use it. BigQuery and Snowflake are quite similar in terms of features and pricing models. StitchData or Fivetran are extracting data from all your business sources and bring them to your Data Warehouse. If your PROD is in No.SQL (such as Mongo), then you’ve got the transformation to do before ingesting the data in your data warehouse. Use DBT to transform data to deliver value to the next paragraph/report.