How to scale Gen AI to billions of rows in BigQuery at a fraction of the cost

Google Cloud Tech · Beginner ·🧠 Large Language Models ·2d ago
Documentation for Optimized Mode → https://goo.gle/optimize-ai-functions Generative AI in BigQuery overview → https://goo.gle/bq-genai-overview For many, running generative AI over massive datasets has felt out of reach due to costs and slow processing times. Others settle for traditional ML techniques that require specialized skill sets and often deliver lower-quality results. With optimized mode for BigQuery AI functions, you can now get LLM-quality results at a fraction of the cost and at BigQuery speeds. In this video, we’ll show you how BigQuery uses model distillation and embeddings to process massive datasets, reducing query latency and token consumption. Chapters: 0:00 - Challenge of scaling Gen AI 1:07 - Introducing optimized mode for BigQuery AI 1:22 - How It Works: Model distillation and embeddings 1:57 - Automatic optimization with AI.IF and AI.CLASSIFY 2:16 - Demo: Analyzing images and text with optimized mode 4:23 - Conclusion & next steps 🔔 Subscribe to Google Cloud Tech → https://goo.gle/GoogleCloudTech #BigQuery #GoogleCloud #Gemini #GenAI #SQL #DataAnalytics Speaker: Rushabh Desai Products Mentioned: BigQuery
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related AI Lessons

The Wall Every AI Has Been Hitting And the Startup That Claims to Have Broken Through
Startup SubQ claims to have broken through the context length constraint in AI, solving a decade-long limitation
Medium · LLM
Unsolved AI Mystery Is Solved Along With Lessons Learned On Why ChatGPT Became Oddly Obsessed With Gremlins And Goblins
Discover why ChatGPT became obsessed with gremlins and goblins, and learn vital lessons from this AI mystery
Forbes Innovation
The Human Element in AI-Based Emotion Recognition: When Machines Start to Read Our Faces
Learn how AI-based emotion recognition systems use facial analysis to understand human emotions and the importance of the human element in these systems
Medium · Deep Learning
ChatGPT vs Claude AI: Which AI Tool is Best for Your Business? — Complete Guide by Amigoways
Learn how to choose between ChatGPT and Claude AI for your business needs and understand their differences
Medium · ChatGPT

Chapters (6)

Challenge of scaling Gen AI
1:07 Introducing optimized mode for BigQuery AI
1:22 How It Works: Model distillation and embeddings
1:57 Automatic optimization with AI.IF and AI.CLASSIFY
2:16 Demo: Analyzing images and text with optimized mode
4:23 Conclusion & next steps
Up next
5 Levels of AI Agents - From Simple LLM Calls to Multi-Agent Systems
Dave Ebbelaar (LLM Eng)
Watch →