snowpipe-bcdr

name	snowpipe-bcdr
description	Use when designing or operating Snowpipe disaster recovery on Azure ADLS Gen2 — choosing between dual-pipe, RA-GRS, active-active, or Failover Group patterns, and running failover/failback/catchup. Triggers: snowpipe BCDR, snowpipe disaster recovery, snowpipe failover, dual pipe, active-active pipe, RA-GRS snowpipe, GZRS snowpipe, snowpipe catchup, pipe failback, snowpipe high availability, failover group snowpipe, snowpipe RPO RTO.
metadata	{"upstream":{"title":"Snowpipe BCDR on Azure","summary":"Snowpipe disaster recovery patterns for Azure ADLS Gen2 with failover, failback, and catchup procedures.","tools":["snowflake_sql_execute","Read","Write"],"prompt":"Help me design and implement a Snowpipe BCDR pattern on Azure ADLS Gen2 with failover and catchup.","language":"en","status":"Published","author":"Snowflake Solutions Team","type":"snowflake"},"category":"data","source":{"repository":"https://github.com/Snowflake-Labs/coco-skills","path":"skills/snowpipe-bcdr","license_path":"skills/snowpipe-bcdr/LICENSE","commit":"d62f6ff052b7efca106432727f493a7ae62b8cf3"}}

Snowpipe BCDR on Azure

Overview

This skill helps developers and data engineers design, implement, and operate Snowpipe business continuity / disaster recovery on Azure ADLS Gen2. Six patterns are supported — pick one based on your RPO, RTO, edition, and cost tolerance.

#	Pattern	RPO	RTO	Cost	Complexity
1	Manual Catchup (single pipe)	Min–hrs	30–90 min	Lowest	Low
2	Active-Active + Dedup