We're exploring Snowflake and it looks like it doesn't provide for workflow/automation capabilities. Not knowing too much about Snowflake, I don't see any special integration between TDP and Snowflake other than at the data source level: Snowflake creates the data sources and brings in the data while TDP creates the automation workflows and gets the data it needs from the Snowflake data sources (not really an integration if you were to ask me!).
Just for the sake of integration, one could probably try to create a workflow in TDP which will call out (maybe using the "Run Program" activity) to Snowflake tasks just to say that TDP talks to Snowflake directly. Even if possible, and I doubt it, I wouldn't be a fan of this given the tight coupling between TDP and Snowflake tasks and the nightmare of readjusting if one of the tools gets replaced by another tool.
Anyway, are there any architecture or design patterns for TDP-Snowflake integration? I'd appreciate any input on this. Thanks!