Can we use single snowpipe to load data from multiple source to multiple destination

Question

Can we use a single snowpipe to load data from multiple sources to multiple destinations?

Answer 1

If has a single Copy into command which go from one place to one table.

Aka No

https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#create-pipe

I cannot think why you might want a single pipe. Given you billed for work done and if using auto ingestion the files queued.