data-warehouse-experimentation SKILL.md skillA

data-warehouse-experimentation from rampstackco/claude-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add rampstackco/claude-skills/data-warehouse-experimentation@git:20260810.e5bc675

Pins git:20260810.e5bc675 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
rampstackco/claude-skills
Path
skills/data-warehouse-experimentation/SKILL.md
Versions recorded
3
Latest version
git:20260810.e5bc675, committed Aug 10, 2026
First version recorded
May 5, 2026
Size
29,023 bytes
Repository stars
1,037
License
MIT

Running experiments out of the data warehouse instead of via dedicated experiment platforms. SQL-based assignment, exposure logging discipline, metric definitions in dbt models, statistical analysis in SQL or Python, variance reduction with CUPED, sequential testing, and the operational tradeoffs vs platforms like Statsig and Optimizely. Triggers on warehouse-native experimentation, run experiments in BigQuery, run experiments in Snowflake, dbt experiments, SQL t-test, CUPED variance…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Data Warehouse Experimentation

A senior data scientist's playbook for running experiments natively out of BigQuery, Snowflake, or any modern data warehouse, with metric definitions in dbt and statistical analysis in SQL or Python.

Most companies that run experiments at scale use a dedicated platform. Statsig, Optimizely, LaunchDarkly with experimentation, PostHog, Amplitude Experiment. The platforms are good. They handle assignment, instrumentation, and analysis in one product, and the SQL-savvy data team does not have to reinvent the variance reduction wheel.

There is a different operational model that mature data teams increasingly choose: warehouse-native experimentation. Assignment happens in code or via feature flags. Exposure events fire to the warehouse like any other event. Metrics are defined as dbt models. Statistical analysis runs as SQL or in a Python notebook against warehouse data. The "experiment platform" is just your existing data stack.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add rampstackco/claude-skills/data-warehouse-experimentation@sha256:e3aa63517c3495fb

The line at the top of this page pins the label git:20260810.e5bc675, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_6rt5n7bbn5jpfj5a.svg)](https://markdownregistry.com/a/art_6rt5n7bbn5jpfj5a)

4 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 3 versions of this file, between May 5, 2026 and Aug 10, 2026, about one every 48 days.

versioncommittedcommitsizeaudit
git:20260810.e5bc675 latest2026-08-10 e5bc675 29,023 BA view · diff
git:20260507.ac2b0782026-05-07 ac2b078 28,400 BA view · diff
git:20260505.f3368be2026-05-05 f3368be 27,943 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (29023 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

rampstackco/claude-skills · 1,037 stars · license MIT · pushed 2026-10-27 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_6rt5n7bbn5jpfj5a
GET https://markdownregistry.com/api/v1/resolve?ref=rampstackco/claude-skills/data-warehouse-experimentation
GET https://markdownregistry.com/api/v1/blob/e3aa63517c3495fb8039a498927b3045ddcc23bc9dc0af5ee96d489e6f525ff0

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from rampstackco/claude-skills

accessibility-audit SKILL.md skill
rampstackco/claude-skills · skills/accessibility-audit/SKILL.md · Run a comprehensive WCAG accessibility audit covering perceivable, operable, understandable, and robust principles. Use…
git:20260810.e5bc675 · audit A · 1,037 stars
ads-creative-development SKILL.md skill
rampstackco/claude-skills · skills/ads-creative-development/SKILL.md · How to produce ad creative that converts at performance scale. Hook patterns, format selection, video pacing, variation…
git:20260810.63d8377 · audit A · 1,037 stars
ads-performance-analytics SKILL.md skill
rampstackco/claude-skills · skills/ads-performance-analytics/SKILL.md · How to read paid media dashboards without fooling yourself. Attribution models, platform reporting quirks…
git:20260810.e5bc675 · audit A · 1,037 stars
after-action-report SKILL.md skill
rampstackco/claude-skills · skills/after-action-report/SKILL.md · Run a structured after-action review (postmortem, retrospective) on a launch, incident, or completed project to capture…
git:20260810.e5bc675 · audit A · 1,037 stars
ai-content-collaboration SKILL.md skill
rampstackco/claude-skills · skills/ai-content-collaboration/SKILL.md · How humans and AI compose in content workflows. Where AI legitimately participates, where humans must own, hybrid…
git:20260507.ac2b078 · audit A · 1,037 stars
analytics-strategy SKILL.md skill
rampstackco/claude-skills · skills/analytics-strategy/SKILL.md · Design measurement frameworks including event taxonomy, KPI hierarchy, dashboard architecture, attribution models, and…
git:20260507.ac2b078 · audit A · 1,037 stars
art-direction SKILL.md skill
rampstackco/claude-skills · skills/art-direction/SKILL.md · Direct visual and creative work for campaigns, photography, illustration, video, and branded experiences. Use this…
git:20260810.1d637e9 · audit A · 1,037 stars
backup-and-disaster-recovery SKILL.md skill
rampstackco/claude-skills · skills/backup-and-disaster-recovery/SKILL.md · Plan and run backups, set recovery objectives, and run disaster recovery drills. Use this skill when defining RPO/RTO…
git:20260507.ac2b078 · audit A · 1,037 stars
beta-program-management SKILL.md skill
rampstackco/claude-skills · skills/beta-program-management/SKILL.md · Running closed and open betas that produce real signal. Beta participant selection, structured feedback collection…
git:20260810.e5bc675 · audit A · 1,037 stars
brand-archetype-system SKILL.md skill
rampstackco/claude-skills · skills/brand-archetype-system/SKILL.md · Apply pre-composed aesthetic archetype defaults to jumpstart brand design work covering color, typography, layout…
git:20260510.f1aa1d7 · audit A · 1,037 stars
brand-discovery SKILL.md skill
rampstackco/claude-skills · skills/brand-discovery/SKILL.md · Run upstream brand discovery covering audience research, competitive landscape, category dynamics, problem space, and…
git:20260810.e5bc675 · audit A · 1,037 stars
brand-ideation SKILL.md skill
rampstackco/claude-skills · skills/brand-ideation/SKILL.md · Generate, evaluate, and narrow brand concepts during early ideation including positioning territories, naming…
git:20260810.e5bc675 · audit A · 1,037 stars

Every file in rampstackco/claude-skills

Browse by kind, by grade A, or by owner.