snowpipe-bcdr

What problem does it solve?

This skill helps data engineers design, implement, and operate Snowpipe disaster recovery on Azure ADLS Gen2, enabling reliable data ingestion across failover scenarios.

Core Features & Use Cases

• **Supports six recovery patterns for Azure Snowpipe, including manual catchup, active-active, RA-GRS, and failover group patterns; helps decide based on RPO, RTO, and cost; provides SQL templates and guidance for storage integrations, pipes, and monitoring.
• Use case: A data platform requires zero data loss and fast failover between primary and DR regions; apply the appropriate pattern to generate the necessary Snowflake objects and runbooks.

Quick Start

Select a BCDR pattern for your Azure ADLS Gen2 Snowpipe deployment and generate the required CREATE STORAGE INTEGRATION, PIPE, and FAILOVER GROUP statements and related steps.