{"id":"lakehouse-llm","slug":"lakehouse-llm","name":"LLM on existing lakehouse data","shortName":"LLM on existing lakehouse data","problemStatement":"Data already lives in Databricks or Snowflake; want governed inference/RAG without exporting corpora.","whenNotTopPick":"Greenfield agent with no lakehouse — use direct APIs + pgvector/Qdrant.","categoryIds":["cat-inference-apis","cat-train-finetune"],"depotPickProviderId":"databricks-mosaic","depotPickRationale":"Data gravity + privacy/governance beat raw DX.","runnersUpIds":["snowflake-cortex","amazon-bedrock","vertex-ai"],"weights":{"capabilityFit":0.25,"pricePerformance":0.18,"latencyReliability":0.15,"developerDx":0.15,"privacyPosture":0.1,"lockInRisk":0.07,"maturity":0.1},"methodologyNotes":"Data gravity + privacy/governance beat raw DX.","tags":["lakehouse"],"depth":{"whenNotToUse":{"text":"Greenfield agent with no lakehouse — use direct APIs + pgvector/Qdrant.","source":"editorial `whenNotTopPick` (data/jtbds.json)"},"whenNotToUseReason":null,"runnerUp":{"providerId":"snowflake-cortex","name":"Snowflake Cortex","overallForJob":7.1,"pickOverallForJob":7.11,"beatsPickOn":["pricePerformance","developerDx","privacyPosture"],"source":"first resolvable entry of the job's editorially ranked `runnersUpIds`; scores are stored job-weighted scores"},"runnerUpReason":null,"lockIn":{"pickLockInRisk":7.8,"runnerUpLockInRisk":8,"scale":"0–10 stored curated estimate; higher = more lock-in (worse)","pickExitSignals":[],"runnerUpExitSignals":[],"pickNotes":[{"text":"Lock-in to Databricks","field":"weaknesses"}],"selfHostFallback":[],"migration":"The pick has lower stored lock-in risk than runner-up Snowflake Cortex (7.8 vs 8).","migrationReason":null,"derivedFrom":"stored lockInRisk scores, provider tags (oss, self-host, openai-compat, open-models), free rows that list this job, and verbatim provider notes. No migration guide was invented."}},"freshness":{"pick":{"score":{"asOf":"2026-09-14","ageDays":43,"stale":true,"staleAfterDays":30,"reason":null},"lastReviewed":{"asOf":"2026-09-14","ageDays":43,"stale":true,"staleAfterDays":30,"reason":null},"sourceCheck":{"checkedAt":"2026-10-27","sourceUrls":3,"sourcesReachable":3,"pricingRows":0,"pricingRowsReconfirmed":0,"note":"A source re-check confirms the page is reachable and, for pricing rows, that the stored amount and SKU name appear on it. It does not re-derive or change the score.","reason":null}}},"depotPick":{"id":"databricks-mosaic","slug":"databricks-mosaic","name":"Databricks Mosaic AI","tagline":"Pick only when your data/platform already is Databricks. Otherwise Bedrock/Vertex or direct APIs.","overall":7.11},"runnersUp":[{"id":"snowflake-cortex","slug":"snowflake-cortex","name":"Snowflake Cortex","tagline":"Use when Snowflake already holds the data. Don't drag agent backends into Snowflake just for Cortex.","overall":7.1},{"id":"amazon-bedrock","slug":"amazon-bedrock","name":"Amazon Bedrock","tagline":"Enterprise multi-model switchboard. Great when AWS is mandatory; mediocre when you just want the best Claude…","overall":7.75},{"id":"vertex-ai","slug":"vertex-ai","name":"Google Vertex AI","tagline":"Enterprise Gemini path. Use AI Studio for prototypes, Vertex when security review starts asking questions.","overall":7.96}]}