kyle-chalmers

Semantic Layer Demo — Data skill for Claude Code

Data community

Companion repo for KC Labs AI video: Semantic Layers - Bundled vs Standalone.

How to install Semantic Layer Demo

This entry records only its repository, not the path inside it, so there is no exact command to give. Open kyle-chalmers/semantic-layer-demo and copy the folder into ~/.claude/skills/, or the file into ~/.claude/agents/.

What Semantic Layer Demo does

Companion repo for KC Labs AI video: Semantic Layers - Bundled vs Standalone. Demos Snowflake Semantic Views and dbt MetricFlow using TPCH sample data.

Alternatives in Data

  • Private GPT — Complete API layer for private AI applications on local models: RAG, skills, tools, MCP, text-to-sql, and more 57.5k ★
  • A Stock Data — A股全栈数据工具包 · 十一层架构 · 54端点 · 19数据源 · 零鉴权 Full-stack China A-share data toolkit for AI agents — 11 layers, 54 end 9.4k ★
  • HTML Video — Programmatic video for coding agents — HTML to video on your laptop 4.5k ★

README

Semantic Layers: The Skill Data Professionals Need Next

Companion repository for the [KC Labs AI](https://www.youtube.com/@kylechalmersdataai) video ["Semantic Layers: The Skill Data Professionals Need Next"](https://www.youtube.com/watch?v=2hiELj4Yavw). Demonstrates the **bundled vs standalone** approaches using Snowflake's TPCH sample data.

What You'll Learn

  • What a semantic layer is and why AI made it essential
  • The difference between bundled (Snowflake Semantic Views) and standalone (dbt MetricFlow) approaches
  • How to create and query a Snowflake Semantic View
  • How to define metrics with dbt MetricFlow and query them with mf query

Architecture

![Semantic Layer Architecture](./images/diagram.png?v=2)

Prerequisites

Tool Version Purpose
Snowflake Any edition Warehouse + Semantic Views + Cortex Analyst
Snowflake CLI Latest Running SQL from terminal
dbt Core 1.10+ Transformation framework
dbt-snowflake 1.10+ Snowflake adapter for dbt
Python 3.9+ Runtime for dbt and MetricFlow

Snowflake offers a free trial with $400 in credits (no credit card required).

Setup

  1. Clone the repo
 git clone https://github.com/kyle-chalmers/semantic

Related Skills

Agenda Demo — Data skill for Claude Code

Agenda Demo

Render a complete demo agenda from bundled sample data — no accounts, no config

Data community
Run Demo — Data skill for Claude Code

Run Demo

Run a ClawBio skill demo with built-in sample data

Data community
Snowflake Safe Query Skill — Data skill for Claude Code

Snowflake Safe Query Skill

Write and run read-only Snowflake queries against the Gaiia reporting database under a four-layer safety guard

Data community
Memory Architecture — Data skill for Claude Code

Memory Architecture

Configure, maintain, and troubleshoot the Qdrant vector database layer of Memory OS. Covers collection setup,

Data community
Redis Agentcore Settle Agent — Data skill for Claude Code

Redis Agentcore Settle Agent

Debt settlement agent for a fictional bank: Claude on Amazon Bedrock AgentCore Runtime with Redis Cloud as the

Data community
Claude Code Postgres — Data skill for Claude Code

Claude Code Postgres

Query a real PostgreSQL database in plain English from the terminal with Claude Code, safely: read-only role f

Data community

Related Agents

Wp Tailwind — Design agent for Claude Code

Wp Tailwind

CSS-to-Tailwind demo conversion — converts standard HTML/CSS demos into Tailwind-native HTML

Design community
Webship Workspace Demos — Project Management agent for Claude Code

Webship Workspace Demos

Use this agent to build, remove, or maintain demo distribution projects inside ~/workspace/demos/ using its cm

Project Management community
Landscape Bridge — Development agent for Claude Code

Landscape Bridge

Plans a landscape long-form video as a companion to an existing vertical Short (or vice versa). Identifies wha

Development community