[pinkbeanz]

It starts there, but then once you get into complex workflows that merge data across your product and CRMs it all moves to the warehouse first. Typical flow is a Fivetran or Stitch into the warehouse, lots of dbt models, then business models fit for consumption down stream.

Once in the warehouse, it needs to get back into those operational systems again, which is the tricky part.

I’ve done these one off integrations from the warehouse into Salesforce (creating leads, converting them, moving stages all based off product usage), and into marketing tools (customer segmentation built using SQL in the warehouse, then sent to marketing automation tools).

Being able to feed tools directly off the warehouse instead of writing one off integrations is the real value.