Great right up Lee. Pipes are going to be a lot nicer to use when the CDK team bring out higher level CDK constructs that abstract out most of the configuration needed for pipes.
A good topic to discuss as well would be "when to use pipes". I like the functionality of filtering events within a pipe and enriching data before it is sent to a target. The enrichment functionality sometimes makes the use of a pipe erroneous since you have to use a lambda to enrich the data. Because of this, you could just use the DynamoDB stream as the enrichment lambda event source, enrich the received DynamoDB stream record and on success (using Lambda destinations), add the enriched data to the SQS Queue. This would provide us with the same outcome without using the pipe. Would be great to see AWS bring out other means of enriching data in a Pipe, maybe in the same way AppSync allows us to.