Cortex
Snowflake LLM
Vector
Semantic Search
DuckDB
Local Migration
LA
Silicon Beach Focus
ML-powered job search engine using Snowflake Cortex for LLM inference and Cortex Search for vector similarity, with a clean DuckDB migration path for local/portable deployment. Demonstrates the full Snowflake ML stack with a real-world dataset of LA AI/ML jobs.
Snowflake Cortex end-to-end — LLM inference, vector search, and ML functions — with a DuckDB fallback for portability.
Tech Stack
Snowflake CortexDuckDBPythonStreamlitSQLVector SearchPandas
Features
Snowflake Cortex
LLM inference and embedding generation natively in Snowflake — no external API calls.
Cortex Search
Vector similarity search over job postings using Snowflake's managed vector store.
DuckDB Migration
Full portability layer — same queries run locally in DuckDB without Snowflake credits.
LA Market Focus
Curated AI/ML job dataset from LA Silicon Beach companies. Real data, real market.
How It Works
01
Ingest
LA AI/ML job dataset → Snowflake staging table
→
02
Embed
Cortex EMBED_TEXT_768 → vector column on each job posting
→
03
Search
User query → Cortex Search → top-k semantic results
→
04
Local
DuckDB migration for zero-cost local development and demos