Embed analytics experiences in your applications using the Conversational Analytics API

Google Cloud Tech · Intermediate ·📊 Data Analytics & Business Intelligence ·5mo ago

Key Takeaways

The video demonstrates the Conversational Analytics API, a tool in the Gemini stack that enables natural language data exploration in applications, using BigQuery or Looker, and provides a developer interface to embed conversational intelligence.

Full Transcript

Ever wish you could just ask your data questions and get accurate answers right away? No SQL, no dashboard clicks. That's exactly what the conversational analytics API is built for. It's part of the Gemini stack and it lets you [music] embed conversational intelligence right into your applications powered by your own data. So what is the conversational analytics API? The API is a developer interface to the same engine that powers conversational analytics inside Looker. But instead of using it on a web page, you can call the API from anywhere. You create a data agent, an AI agent that understands your schema, business logic, and data connections. Then through [music] the API, you set natural language queries, and the agent translates the queries into SQL or look [music] and returns the structured results. But it's not just a static model that you can't control. The API supports system instructions and authored context so you can define your own instructions and examples to keep your model grounded. For example, you can tell the agent to always filter on specific fields, provide sample natural language questions and their equivalent queries, define a glossery of key terms, and [music] explain how to join tables using schema relations. The API also supports various options for conversation management with stateful sessions and stateless chats. These options let you decide whether to use manage state to an existing agent or conversation object or build an entirely stateless application with dynamically generated inline context. The API also includes AM access controls builtin with predefined rules to grant permissions to create, share, [music] and chat with data agents and to use stateless chats. And since it's just an API, you can combine it with the Mini Live API or other LLM tools for multi-turn multi-source reasoning. For example, you can use the Looker MCP server or agent development kit known as ADK to connect to other agents. In fact, if you've used the ADK's ask data insights tool, you've already seen the conversational analytics API in action. This is the API to use when you want to go beyond static dashboards. You can stop guessing which filters to click and instead ask questions dynamically with the agent inferring how to structure the query. This provides analytics that feels like a conversation but still runs on your covered secure data. Let's see this now in action. You can clone the quickserts repo which has a readyto run examples in Python. Here's a simple Python call to send our chat message and handle the response. The agent interprets the question, runs the right BigQuery query, and gives you the response with both natural language and structured results, so your app can handle the response however [music] you want. So, how do you get started? Check out the links below and try the quick start app and explore the demos and tools repos to see code examples. Then you can start building your data agent using an SDK in a language of your choice. The conversational analytics API turns your data into something more than numbers. It turns it into a dialogue. Thank you for watching and happy building. [music] >> [music]

Original Description

Stop building dashboards and start building dialogues. This video dives into the Conversational Analytics API, a powerful tool in the Gemini stack that lets anyone embed natural language data exploration directly into their own applications. Whether using BigQuery or Looker, the CA API allows anyone to build AI data agents that understands business logic and schema. Resources: Explore the SDKs → https://goo.gle/3NHD8XC Review the Python quick start → https://goo.gle/4qS0JmY Checkout demos and examples → https://goo.gle/4pVlQDF Try out the Looker MCP Server → https://goo.gle/3YVQxxI #GoogleCloud #Gemini Speakers: David Tamaki Szajngarten Products Mentioned: BigQuery, Looker, Gemini, Conversational Analytics API
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from Google Cloud Tech · Google Cloud Tech · 0 of 60

← Previous Next →
1 I’m going for it #GoogleCloudCertified
I’m going for it #GoogleCloudCertified
Google Cloud Tech
2 I had to get #GoogleCloudCertified
I had to get #GoogleCloudCertified
Google Cloud Tech
3 Be better overall at what you do #GoogleCloudCertified
Be better overall at what you do #GoogleCloudCertified
Google Cloud Tech
4 Cloud Monitoring on our radar #Analysis #Uptime
Cloud Monitoring on our radar #Analysis #Uptime
Google Cloud Tech
5 Introduction to Generative AI Studio
Introduction to Generative AI Studio
Google Cloud Tech
6 How to use Github Actions with Google's Workload Identity Federation
How to use Github Actions with Google's Workload Identity Federation
Google Cloud Tech
7 Introduction to Responsible AI
Introduction to Responsible AI
Google Cloud Tech
8 Networking updates and CDMC-certified architecture
Networking updates and CDMC-certified architecture
Google Cloud Tech
9 Create and use a Cloud Storage bucket
Create and use a Cloud Storage bucket
Google Cloud Tech
10 How to digitize text from documents
How to digitize text from documents
Google Cloud Tech
11 Faster analytical queries with AlloyDB
Faster analytical queries with AlloyDB
Google Cloud Tech
12 Next ‘23 sessions and FaaS Wave
Next ‘23 sessions and FaaS Wave
Google Cloud Tech
13 Introduction to Assured Open Source Software
Introduction to Assured Open Source Software
Google Cloud Tech
14 BigQuery Cost Optimization: Storage
BigQuery Cost Optimization: Storage
Google Cloud Tech
15 BigQuery Cost Optimization: Compute
BigQuery Cost Optimization: Compute
Google Cloud Tech
16 BigQuery Cost Optimization: Select Queries
BigQuery Cost Optimization: Select Queries
Google Cloud Tech
17 Remote Field Equipment Management with Manufacturing Data Engine
Remote Field Equipment Management with Manufacturing Data Engine
Google Cloud Tech
18 Supercharging your applications with Cloud SQL Enterprise Plus
Supercharging your applications with Cloud SQL Enterprise Plus
Google Cloud Tech
19 Vector Support on our radar #GenAI
Vector Support on our radar #GenAI
Google Cloud Tech
20 Architecting a blockchain startup with Google Cloud
Architecting a blockchain startup with Google Cloud
Google Cloud Tech
21 Kubernetes and multitasking updates!
Kubernetes and multitasking updates!
Google Cloud Tech
22 GKE: Using Kubernetes Events
GKE: Using Kubernetes Events
Google Cloud Tech
23 How to configure firewall rules for Cloud Composer
How to configure firewall rules for Cloud Composer
Google Cloud Tech
24 Vertex AI Embeddings API + Matching Engine: Grounding LLMs made easy
Vertex AI Embeddings API + Matching Engine: Grounding LLMs made easy
Google Cloud Tech
25 Geospatial analytics on our radar #EarthEngine #BigQuery
Geospatial analytics on our radar #EarthEngine #BigQuery
Google Cloud Tech
26 Ensuring requests are set in Kubernetes
Ensuring requests are set in Kubernetes
Google Cloud Tech
27 Cloud Next 2023, Google research program, and more!
Cloud Next 2023, Google research program, and more!
Google Cloud Tech
28 How to migrate projects between organizations with Resource Manager
How to migrate projects between organizations with Resource Manager
Google Cloud Tech
29 How to run #MySQL in Google Cloud
How to run #MySQL in Google Cloud
Google Cloud Tech
30 #GenerativeAI for enterprises and #Next2023
#GenerativeAI for enterprises and #Next2023
Google Cloud Tech
31 How Google Photos scales to store 4 trillion photos and videos
How Google Photos scales to store 4 trillion photos and videos
Google Cloud Tech
32 Google Cross-Cloud Interconnect (Demo 2)
Google Cross-Cloud Interconnect (Demo 2)
Google Cloud Tech
33 GKE Cost Optimization Golden Signals: Introduction
GKE Cost Optimization Golden Signals: Introduction
Google Cloud Tech
34 GKE Cost Optimization Golden Signals: Workload Rightsizing
GKE Cost Optimization Golden Signals: Workload Rightsizing
Google Cloud Tech
35 GKE Load Balancing: Overview
GKE Load Balancing: Overview
Google Cloud Tech
36 GKE Load Balancing: Best Practices
GKE Load Balancing: Best Practices
Google Cloud Tech
37 Disaster Recovery in GKE
Disaster Recovery in GKE
Google Cloud Tech
38 How to configure IP masquerade agent in GKE Standard clusters
How to configure IP masquerade agent in GKE Standard clusters
Google Cloud Tech
39 Enable and use GKE Control plane logs
Enable and use GKE Control plane logs
Google Cloud Tech
40 Compliance in Australia with Assured Workloads
Compliance in Australia with Assured Workloads
Google Cloud Tech
41 Creating budgets and budget alerts in Google Cloud #FinOps
Creating budgets and budget alerts in Google Cloud #FinOps
Google Cloud Tech
42 Cloud SQL Enterprise Plus on our radar #mySQL
Cloud SQL Enterprise Plus on our radar #mySQL
Google Cloud Tech
43 What's Next for Google Cloud?
What's Next for Google Cloud?
Google Cloud Tech
44 How Loveholidays scaled with Contact Center AI
How Loveholidays scaled with Contact Center AI
Google Cloud Tech
45 What is fleet team management in GKE?
What is fleet team management in GKE?
Google Cloud Tech
46 Troubleshoot VPC Network Peering
Troubleshoot VPC Network Peering
Google Cloud Tech
47 Introduction to DocAI and Contact Center AI
Introduction to DocAI and Contact Center AI
Google Cloud Tech
48 Cloud Run Direct VPC egress explained
Cloud Run Direct VPC egress explained
Google Cloud Tech
49 Database deployment options in GKE
Database deployment options in GKE
Google Cloud Tech
50 Analyze cloud billing data with #BigQuery
Analyze cloud billing data with #BigQuery
Google Cloud Tech
51 Tips to becoming a world-class Prompt Engineer
Tips to becoming a world-class Prompt Engineer
Google Cloud Tech
52 Serverless is simple. Do I need CI/CD?
Serverless is simple. Do I need CI/CD?
Google Cloud Tech
53 Accelerating model deployment with MLOps
Accelerating model deployment with MLOps
Google Cloud Tech
54 How Hawaii's Department of Human Services scaled with CCAI
How Hawaii's Department of Human Services scaled with CCAI
Google Cloud Tech
55 Pricing API on our #Radar
Pricing API on our #Radar
Google Cloud Tech
56 How Recommendations AI for Media can boost customer retention
How Recommendations AI for Media can boost customer retention
Google Cloud Tech
57 Troubleshooting: Node Not Ready Status
Troubleshooting: Node Not Ready Status
Google Cloud Tech
58 One weekend until Cloud Next 2023!
One weekend until Cloud Next 2023!
Google Cloud Tech
59 #GoogleCloudNext starts tomorrow!
#GoogleCloudNext starts tomorrow!
Google Cloud Tech
60 #GoogleCloudNext will be demand!
#GoogleCloudNext will be demand!
Google Cloud Tech

The Conversational Analytics API allows developers to embed natural language data exploration into their applications, providing a more intuitive and interactive way to explore data. The API supports various features such as stateful sessions, stateless chats, and access controls, making it a powerful tool for building conversational analytics experiences.

Key Takeaways
  1. Create a data agent using the Conversational Analytics API
  2. Set natural language queries and translate them into SQL or LookML
  3. Define system instructions and authored context to control the model
  4. Use stateful sessions or stateless chats for conversation management
  5. Integrate the API with other LLM tools for multi-turn multi-source reasoning
💡 The Conversational Analytics API provides a developer interface to embed conversational intelligence into applications, allowing for more intuitive and interactive data exploration.

Related Reads

📰
The Presence Premium: Office Mandates Need a 10% Productivity Miracle to Break Even.
Office mandates come with significant costs, requiring a 10% productivity boost to break even, highlighting the need for data-driven decision making in return-to-office strategies
Medium · Data Science
📰
From Python Basics to Data Analysis: My 4-Week Internship Journey at Sparks To Ideas
Learn how a B.Tech student applied Python basics to data analysis in a 4-week internship, gaining practical experience and skills in data science
Medium · Data Science
📰
From Python Basics to Data Analysis: My 4-Week Internship Journey at Sparks To Ideas
Learn how a student applied Python basics to data analysis in a 4-week internship, gaining hands-on experience and skills in a real-world setting
Medium · Python
📰
How I’m Making Sure My Analytics Career Doesn’t Get Eaten by AI
Learn how to future-proof your analytics career in an AI-driven world
Towards Data Science
Up next
How to Scrape Facebook Ad Library Data + Analyse on n8n 🔥
DroidCrunch
Watch →