Snowpipe Bcdr

---
name: snowpipe-bcdr
title: Snowpipe BCDR on Azure
summary: Snowpipe disaster recovery patterns for Azure ADLS Gen2 with failover, failback, and catchup procedures.
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."
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
---

# 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 |