Workforce Astra
Snowflake CoCo CLI Hackathon Customer 360 / Employee 360 Track

One workforce.
One governed answer.

HR, Finance, and Engineering ask "how many employees do we have?" and get three different numbers — from the exact same underlying data. Workforce Astra encodes the definition once, as a governed Snowflake Semantic View, so every team gets the identical, SQL-transparent answer.

Try the live conflict below View source
Honest status, 16-Sep-2026: everything on this page runs against the real 150-employee synthetic dataset committed to the repo, computed client-side in your browser using the exact same governance logic defined in the project's Snowflake Semantic View (see sql/02_semantic_view.sql). It is not a live call to Cortex Analyst — the Snowflake trial account is currently blocked by a network policy pending a support ticket. Once that clears, this same logic runs for real inside Snowflake via CoCo CLI.

The cold open: same question, two answers

Ask "how many employees do we have?" two ways. Same 150-row dataset, same moment in time — the numbers genuinely disagree, because one query is governed and one isn't.

Finance asks (ungoverned)
"How many people work here, including contractors?"
VS
HRBP asks (governed)
"How many active employees do we have?"

Ask the governed Semantic View

These are the 6 AI_VERIFIED_QUERIES registered on employee_360. Click one — the answer and the SQL that produced it come from the real dataset, live.

Pick a question above

Flight-risk evidence & the closed-loop action

Comp-ratio below 0.85 and a rating of 4 or above — underpaid high performers, the real retention risk. Click a name for the cited review evidence, then simulate the action a CoCo agent would take via the mock MCP server in this repo.

What's actually running underneath

Governed Semantic View

3 tables, 3 metrics, 6 verified queries. Every question resolves through employee_360, never raw tables.

CoCo CLI skill

Synthetic data generation packaged as $workforce-astra-data-gen — generate, verify, stage, load.

Mock MCP action server

Two tools — Slack manager alert, Workday comp-adjustment draft — protocol-tested with the real MCP client.

Snowflake Semantic Views Cortex Analyst Cortex Search CoCo CLI MCP