New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Official agent skill

Source Snowflake E2E Tests

by airbytehq in airbytehq/airbyte

Runs the Airbyte protocol sweep for a source-snowflake image against the shared Snowflake integration account, in an isolated per-run schema.

OfficialCustom licenceAuto-check passedTesting & QA

Install Source Snowflake E2E Tests

skills CLI
$ npx skills add airbytehq/airbyte --skill source-snowflake-e2e-tests -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install airbytehq/airbyte source-snowflake-e2e-tests --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/airbytehq/airbyte.git skills-src && mkdir -p .claude/skills && cp -r skills-src/airbyte-integrations/connectors/source-snowflake/.agents/skills/source-snowflake-e2e-tests .claude/skills/source-snowflake-e2e-tests && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
source-snowflake-e2e-tests
GitHub stars
22k
Token cost
~918 tokens
SKILL.md length
362 words
Files
16 (incl. scripts)
Skills in repo
9
Repo updated
First seen
Licence
Custom licence

At a glance

Runs the Airbyte protocol sweep for a source-snowflake image against the shared Snowflake integration account, in an isolated per-run schema.

  • Verifying a source-snowflake connector image against a real Snowflake account
  • SKILL.md covers Prerequisites, Layout, Isolation model and Cursor upper-bound canary, plus 1 more section
  • Runs Shell and Python scripts from its folder
  • Proving a fix by comparing a control and a target connector version

What it does

This is an end-to-end harness for the source-snowflake connector. Every run uses a fresh schema named PROVEFIX_ plus the run id in the shared Snowflake integration account. It needs Docker, uv, jq, a gcloud login that can read the secret holding the Snowflake config (or an existing SNOWFLAKE_CONFIG_FILE) and a clone of the airbyte repository.

Isolation is strict. Each run asserts that its schema is absent before the control and target runs, refuses pre-existing schemas that lack the run's marker, drops the schema in an exit trap, and never touches schemas outside PROVEFIX_. scripts/sweep-orphans.sh lists or drops old PROVEFIX_ schemas, defaulting to four hours. Only sf.py talks to Snowflake, and only configs the scripts fetched are removed at teardown, so a config you supply survives.

The cursor upper-bound canary compares fixed version 1.1.1 with control 1.1.0. After an initial sync on the control image, it inserts a sub-microsecond boundary row and replays the saved state on both versions: 1.1.0 loses the row because it floors the upper bound, while 1.1.1 emits it. Snowflake uppercases identifiers, so cursor and stream names must be given in capitals. The excerpt is cut off where the gotchas begin.

When your agent uses it

  • Verifying a source-snowflake connector image against a real Snowflake account
  • Proving a fix by comparing a control and a target connector version
  • Running the cursor upper-bound canary
  • Cleaning up leftover PROVEFIX schemas from earlier runs

Example prompts

  • “Run the source-snowflake end-to-end sweep for the new connector tag and compare it with the control.”
  • “Run the cursor upper-bound canary and tell me whether the boundary row is emitted.”
  • “List the PROVEFIX schemas older than the default window and drop them.”

Requirements

  • Docker, uv and jq
  • gcloud with read access to the Snowflake config secret, or a SNOWFLAKE_CONFIG_FILE
  • A clone of the airbyte repository

What it can do on your machine

Read from SKILL.md and the folder at commit 8dbd366. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships 9 files in scripts/ (Shell and Python), which the agent can run.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • docs.astral.sh

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Source Snowflake E2E Tests loads about 918 tokens when it runs. Until then it costs about 70 tokens; SKILL.md has 362 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~70
When it runs · the whole SKILL.md, loaded when a task matches
~918

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 362 words (~918 tokens).

“Remote end-to-end harness for source-snowflake. The shared db-harness-lib orchestration runs protocol commands against a per-run schema in the shared Snowflake integration account.”

— opening of SKILL.md by airbytehq, Custom licence
name
source-snowflake-e2e-tests

Read the full SKILL.md on GitHub

Files

SKILL.md and 15 other files (scripts) in airbyte-integrations/connectors/source-snowflake/.agents/skills/source-snowflake-e2e-tests of airbytehq/airbyte.

  • SKILL.md
  • cases/cursor-upper-bound.sh
  • fixtures/configs/base.template.json
  • fixtures/configs/utc-session.template.json
  • fixtures/sql/.gitignore
  • fixtures/sql/00-cursor-canary-base.sql
  • fixtures/sql/01-cursor-canary-boundary-row.sql
  • scripts/apply-sql.sh
  • scripts/fetch-config.sh
  • scripts/render-config.sh
  • scripts/reset-databases.sh
  • scripts/run.sh
  • scripts/sf.py
  • scripts/start-backend.sh
  • scripts/stop-backend.sh
  • scripts/sweep-orphans.sh

Open the folder on GitHubat commit 8dbd366

Compare with similar skills

Source Snowflake E2E Tests next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Source Snowflake E2E Tests compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Source Snowflake E2E Tests this skillairbytehq/airbyte22k—~918Automated safety check: PassCustom licence
Local Platform E2Ecomputesdk/benchmarks126—~3kAutomated safety check: NotesMIT
Rocky New Adapterrocky-data/rocky304—~2kAutomated safety check: PassApache-2.0
Optimizing Query By IdAltimateAI/data-engineering-skills128—~919Automated safety check: PassMIT
Snowflake Developmentsickn33/agentic-awesome-skills47k2 repos~2.1kAutomated safety check: PassMIT
Snowflake Developmentalirezarezvani/claude-skills28k—~3.2kAutomated safety check: PassMIT

Similar skills

  • Local Platform E2E

    computesdk/benchmarks

    Stand up benchmarks-platform locally (Postgres + MinIO + ClickHouse in docker) and run a real @benchsdk/runner benchmark against it, with no cloud or provider credentials.

    126 GitHub stars~3k tokensUpdated today
    DatabasesAuto-check: notes

  • Rocky New Adapter

    rocky-data/rocky

    Adding a new warehouse or source adapter crate to the Rocky engine.

    304 GitHub stars~2k tokensUpdated today
    DatabasesAuto-check passed

  • Optimizing Query By Id

    AltimateAI/data-engineering-skills

    Optimizes Snowflake query performance using query ID from history.

    128 GitHub stars~919 tokensUpdated 6 days ago
    DatabasesAuto-check passed

  • Snowflake Development

    sickn33/agentic-awesome-skills

    Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt…

    47k GitHub starsUsed in 2 repos~2.1k tokens
    DatabasesAuto-check passed

  • Snowflake Development

    alirezarezvani/claude-skills

    A skill your agent uses when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex Agents, writing Snowpark Python…

    28k GitHub stars~3.2k tokensUpdated 1 mo ago
    DatabasesAuto-check passed

  • Data Warehouse Experimentation

    rampstackco/claude-skills

    Running experiments out of the data warehouse instead of via dedicated experiment platforms.

    940 GitHub stars~7.3k tokensUpdated yesterday
    DatabasesAuto-check passed

More from airbytehq/airbyte

All 9 skills in this repo

  • MongoDB Source Connector E2E Harness

    airbytehq/airbyte

    Official

    Starts a throwaway MongoDB 7.0 replica set and runs the Airbyte spec, check, discover and read commands against source-mongodb-v2 images for local end-to-end testing.

    22k GitHub stars~1.9k tokensUpdated today
    Auto-check passed

  • source-mssql E2E Test Harness

    airbytehq/airbyte

    Official

    Stands up a throwaway local SQL Server 2022 backend, applies SQL fixtures and runs Airbyte spec, check, discover and read against source-mssql images.

    22k GitHub stars~4.4k tokensUpdated today
    Auto-check passed

  • Airbyte source-mysql E2E Tests

    airbytehq/airbyte

    Official

    Stands up a throwaway local MySQL 8.0 backend, applies SQL fixtures and sweeps the Airbyte spec, check, discover and read commands against a source-mysql image.

    22k GitHub stars~2.6k tokensUpdated today
    Auto-check passed

  • Airbyte Postgres Source E2E Tests

    airbytehq/airbyte

    Official

    Starts a local PostgreSQL 16 container, loads SQL fixtures and runs the Airbyte spec, check, discover and read commands against a chosen source-postgres image.

    22k GitHub stars~2.5k tokensUpdated today
    Auto-check passed

  • MSSQL CDC Bug Reproduction Harness

    airbytehq/airbyte

    Official

    Reproduces change-data-capture bugs in the source-mssql Airbyte connector by enabling CDC on a local SQL Server backend and replaying per-bug SQL fixtures.

    22k GitHub stars~3.3k tokensUpdated today
    Auto-check passed

  • Source MySQL CDC Test Harness

    airbytehq/airbyte

    Official

    Reproduces MySQL binlog change-data-capture behavior for the Airbyte source-mysql connector on a local MySQL backend, with fixtures, a catalog and smoke cases.

    22k GitHub stars~1.8k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Source Snowflake E2E Tests

What does Source Snowflake E2E Tests do?

Runs the Airbyte protocol sweep for a source-snowflake image against the shared Snowflake integration account, in an isolated per-run schema. This is an end-to-end harness for the source-snowflake connector. Every run uses a fresh schema named PROVEFIX_ plus the run id in the shared Snowflake integration account.

When should I use Source Snowflake E2E Tests?

Source Snowflake E2E Tests fits situations like: verifying a source-snowflake connector image against a real Snowflake account; proving a fix by comparing a control and a target connector version; running the cursor upper-bound canary; cleaning up leftover PROVEFIX schemas from earlier runs.

How do I install Source Snowflake E2E Tests in Claude Code?

Run `npx skills add airbytehq/airbyte --skill source-snowflake-e2e-tests -a claude-code`. Or copy the skill folder (airbyte-integrations/connectors/source-snowflake/.agents/skills/source-snowflake-e2e-tests in airbytehq/airbyte) into .claude/skills/source-snowflake-e2e-tests in your project. Claude Code loads it when a task matches its description.

How do I install Source Snowflake E2E Tests in Codex?

Run `npx skills add airbytehq/airbyte --skill source-snowflake-e2e-tests -a codex`. Or copy the skill folder (airbyte-integrations/connectors/source-snowflake/.agents/skills/source-snowflake-e2e-tests in airbytehq/airbyte) into .agents/skills/source-snowflake-e2e-tests in your project. Codex loads it when a task matches its description.

Can I use Source Snowflake E2E Tests in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add airbytehq/airbyte --skill source-snowflake-e2e-tests -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/source-snowflake-e2e-tests, .gemini/skills/source-snowflake-e2e-tests, .github/skills/source-snowflake-e2e-tests and .opencode/skills/source-snowflake-e2e-tests in your project.

What does Source Snowflake E2E Tests need to run?

Going by SKILL.md and its folder, Source Snowflake E2E Tests needs a shell and Python for the scripts in its folder. Our summary lists: Docker, uv and jq; gcloud with read access to the Snowflake config secret, or a SNOWFLAKE_CONFIG_FILE; A clone of the airbyte repository.

Does Source Snowflake E2E Tests access the network?

SKILL.md names 1 domain. As links in the text: docs.astral.sh. This is read from the text; nothing was executed.

Is Source Snowflake E2E Tests safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Source Snowflake E2E Tests use?

Source Snowflake E2E Tests has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does Source Snowflake E2E Tests use?

About 918 tokens (SKILL.md is roughly 3.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Source Snowflake E2E Tests?

Skills that share tags, products or a category with Source Snowflake E2E Tests: Local Platform E2E (computesdk/benchmarks, 126 stars), Rocky New Adapter (rocky-data/rocky, 304 stars), Optimizing Query By Id (AltimateAI/data-engineering-skills, 128 stars) and Snowflake Development (sickn33/agentic-awesome-skills, 47k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Source Snowflake E2E Tests?

airbytehq (a GitHub organization, an official publisher) maintains it in airbytehq/airbyte, which has 22,188 GitHub stars. The repository holds 9 skills in this directory. The repository was last updated on October 8, 2026.

Source: airbytehq/airbyte on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.