Hi all.. is it possible to have one source that write to two destinations in parallel? Let say, I have data I am pulling via an API, which is my source. Then I would like to have the same data on both dev and production instance of Snowflake which is my destination. How can I achieve this? I don’t want to set up two different connections since my API have rate limits and I want to avoid that. If this is implemented, please point me to the write section in the documentation. Regards.

Hello @Espoir Murhabazi today this is not possible. A connection is exclusive between one source and destination.

Thank you Marcos.

@Espoir Murhabazi For your dev instance, have you looked at snowflake's zero copy clone feature? This would allow you to create a clone after each load and have it refreshed. Another option to get more to a CICD workflow, is that you create clones for each branch as they are needed.

Thanks you @Jaye Howell, that is what I ended up implementing.

Great to hear you figured it out, Espoir!