snowflake-reliability-patterns

Implement Snowflake reliability patterns: replication, failover, Time Travel recovery, and application-level resilience for Snowflake integrations. Use when building fault-tolerant pipelines, configuring disaster recovery, or adding resilience to production Snowflake services. Trigger with phrases like "snowflake reliability", "snowflake failover", "snowflake replication", "snowflake disaster recovery", "snowflake Time Travel".

Ir para a instalação

Repositório: jeremylongshore/claude-code-plugins-plus-skills
Última atividade na origem: 17 de julho de 2026 às 22:18
Idioma detectado do SKILL.md: inglês
Estrelas: 2.604
Forks: 378

Opções de instalação

Por padrão, está selecionado o prompt que primeiro revisa a origem. Você pode mudar para um comando direto ou baixar uma cópia local.

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Um comando direto ignora o prompt de revisão. Verifique a origem antes de executá-lo.

npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus-skills --skill snowflake-reliability-patterns

O comando permanece em uma só linha. Role horizontalmente para revisá-lo antes de copiar.

Prefere uma cópia local? Baixe os arquivos disponíveis atualmente no SkillsMP.

Revise os arquivos de origem

Leia o SKILL.md e os arquivos complementares exibidos pelo SkillsMP antes de decidir se vai instalar.

SKILL.md

Instruções da origem · Visualização somente leitura

Voltar à pesquisa Voltar à instalação

clerk-core-workflow-a

Implement user sign-up and sign-in flows with Clerk. Use when building authentication UI, customizing sign-in experience, or implementing OAuth social login. Trigger with phrases like "clerk sign-in", "clerk sign-up", "clerk login flow", "clerk OAuth", "clerk social login".

2026-07-23

clerk-core-workflow-b

Implement session management and middleware with Clerk. Use when managing user sessions, configuring route protection, or implementing token refresh and custom JWT templates. Trigger with phrases like "clerk session", "clerk middleware", "clerk route protection", "clerk token", "clerk JWT".

2026-07-23

clerk-enterprise-rbac

Configure enterprise SSO, role-based access control, and organization management. Use when implementing SSO integration, configuring role-based permissions, or setting up organization-level controls. Trigger with phrases like "clerk SSO", "clerk RBAC", "clerk enterprise", "clerk roles", "clerk permissions", "clerk organizations".

2026-07-23

Ver todas deste repositório

name	snowflake-reliability-patterns
description	Implement Snowflake reliability patterns: replication, failover, Time Travel recovery, and application-level resilience for Snowflake integrations. Use when building fault-tolerant pipelines, configuring disaster recovery, or adding resilience to production Snowflake services. Trigger with phrases like "snowflake reliability", "snowflake failover", "snowflake replication", "snowflake disaster recovery", "snowflake Time Travel".
allowed-tools	Read, Write, Edit
version	1.5.0
license	MIT
author	Jeremy Longshore <jeremy@intentsolutions.io>
tags	["saas","data-warehouse","analytics","snowflake"]
compatibility	Designed for Claude Code

Snowflake Reliability Patterns

Overview

Production-grade reliability patterns for Snowflake: database replication, account failover, Time Travel recovery, and application-level circuit breakers.

Instructions

Step 1: Time Travel for Point-in-Time Recovery

-- Query historical data (up to 90 days on Enterprise Edition)
SELECT * FROM orders
AT (TIMESTAMP => '2026-03-21 14:00:00'::TIMESTAMP_NTZ);

-- Restore a table to a previous state
CREATE OR REPLACE TABLE orders
  CLONE orders AT (TIMESTAMP => '2026-03-21 14:00:00'::TIMESTAMP_NTZ);

-- Restore a dropped table
UNDROP TABLE orders;
UNDROP SCHEMA my_schema;
UNDROP DATABASE my_database;

-- Query by offset (5 minutes ago)
SELECT * FROM orders AT (OFFSET => -300);

-- Query by statement ID (before a specific query ran)
SELECT * FROM orders BEFORE (STATEMENT => '<query_id_of_bad_update>');

-- Set retention period per table
ALTER TABLE critical_data SET DATA_RETENTION_TIME_IN_DAYS = 90;
ALTER TABLE temp_staging SET DATA_RETENTION_TIME_IN_DAYS  ;

// src/snowflake/resilient-connection.ts import snowflake from 'snowflake-sdk'; interface FailoverConfig { primary: snowflake.ConnectionOptions; secondary: snowflake.ConnectionOptions; healthCheckIntervalMs: number; } class ResilientSnowflakeConnection { private activeConn: snowflake.Connection | null = null; private isPrimary = true; private config: FailoverConfig; constructor(config: FailoverConfig) { this.config = config; } async connect(): Promise<snowflake.Connection> { try { this.activeConn = await this.tryConnect(this.config.primary); this.isPrimary = true; return this.activeConn; } catch (primaryErr) { console.warn('Primary Snowflake connection failed, trying secondary'); try { this.activeConn = await this.tryConnect(this.config.secondary); this.isPrimary = false; return this.activeConn; } catch (secondaryErr) { throw new Error(`Both Snowflake connections failed. Primary: ${primaryErr.message} Secondary: ${secondaryErr.message}`); } } } private tryConnect(opts: snowflake.ConnectionOptions): Promise<snowflake.Connection> { return new Promise((resolve, reject) => { const conn = snowflake.createConnection(opts); conn.connect((err, conn) => (err ? reject(err) : resolve(conn))); }); } async healthCheck(): Promise<{ connected: boolean; isPrimary: boolean }> { try { await new Promise<void>((resolve, reject) => { this.activeConn!.execute({ sqlText: 'SELECT 1', complete: (err) => (err ? reject(err) : resolve()), }); }); return { connected: true, isPrimary: this.isPrimary }; } catch { return { connected: false, isPrimary: this.isPrimary }; } } } // Usage const resilientConn = new ResilientSnowflakeConnection({ primary: { account: 'myorg-primary', username: process.env.SNOWFLAKE_USER!, password: process.env.SNOWFLAKE_PASSWORD!, warehouse: 'PROD_WH', database: 'PROD_DW', }, secondary: { account: 'myorg-secondary', username: process.env.SNOWFLAKE_USER!, password: process.env.SNOWFLAKE_PASSWORD!, warehouse: 'PROD_WH', database: 'PROD_DW_REPLICA', }, healthCheckIntervalMs: 30000, });

Scenario	Recovery Method	RTO	RPO
Accidental table drop	UNDROP	Instant	Zero
Bad data update	Time Travel CLONE	Minutes	Configurable (up to 90 days)
Regional outage	Failover group	10-30 min	Replication lag
Account compromise	Contact Snowflake support	Hours	Last backup

Issue	Cause	Solution
Time Travel expired	Past retention period	Increase DATA_RETENTION_TIME_IN_DAYS
Replication lag high	Large data changes	Check replication schedule, network
Failover fails	Secondary not synced	Verify failover group status
UNDROP fails	Object recreated with same name	Rename current object first

snowflake-reliability-patterns

Opções de instalação

Revise os arquivos de origem

Snowflake Reliability Patterns

Overview

Instructions

Step 1: Time Travel for Point-in-Time Recovery

Snowflake Reliability Patterns

Overview

Instructions

Step 1: Time Travel for Point-in-Time Recovery

Step 2: Database Replication Across Regions

Step 3: Account Failover Groups

Step 4: Application-Level Connection Failover

Step 5: Pipeline Retry and Idempotency

Step 6: Backup Strategy

Recovery Time Objectives

Error Handling

Resources

Next Steps

snowflake-reliability-patterns

Informações da origem

Opções de instalação

Revise os arquivos de origem

Mais deste repositório

Snowflake Reliability Patterns

Overview

Instructions

Step 1: Time Travel for Point-in-Time Recovery

Mais deste repositório

Snowflake Reliability Patterns

Overview

Instructions

Step 1: Time Travel for Point-in-Time Recovery

Step 2: Database Replication Across Regions

Step 3: Account Failover Groups

Step 4: Application-Level Connection Failover

Step 5: Pipeline Retry and Idempotency

Step 6: Backup Strategy

Recovery Time Objectives

Error Handling

Resources

Next Steps