Data Access Architecture

Data Connectors, Data Agents & MCP Servers

When connecting Gemini Enterprise to Hollywood Park databases, Google Workspace, SaaS trackers, and internal APIs, we use three distinct mechanisms depending on whether you need broad search, curated analytics, or custom tool integration:

1. Data Connectors🔗
Pre-Built Bridges (8)

Turnkey integrations linking Gemini Enterprise to Google Workspace (Drive, Gmail, Calendar, Chat, Meet) and SaaS apps (Wrike, Jira Cloud).

Best used when: You want broad, low-friction search and lookups across company documents, emails, and project trackers while honoring user ACLs.

2. Data Agents📊
Curated Analytics Experts (3)

Specialized Conversational Analytics agents built in BigQuery and published into Gemini Enterprise (Ticketing, ParkHub, Iterable).

Best used when: Accuracy is critical (e.g., revenue, attendance, parking volume) and answers must follow verified “golden SQL” logic with Python charting.

3. MCP Servers🛠️
Universal Tool Protocol (3)

Servers built on the open Model Context Protocol (MCP) standard that expose live data queries and write actions as tools.

Best used when: You need live actions across Workspace/SaaS or need to connect proprietary Hollywood Park APIs on Cloud Run via Agent Gateway.

How They Relate to One Another: Google's first-party Data Cloud connectors actually use Google-managed MCP servers behind the scenes to run live federated queries while respecting each user's OAuth/IAM permissions.
🔒 Strict Per-User ACL Enforcement
Layer 1 • Broad Search & Lookups

Enterprise Data Connectors (8)

Live synced from prj-hwp-its-gemini-ent-prod (hwp-app-ge-org-prod). Multi-table connectors like Jira Cloud (10 entity stores) and Wrike are automatically grouped for clarity.

📁
Google DriveFederated & ACL-Enforced

Google Drive, Docs, Sheets & Slides

Search and ground answers across your personal and shared Google Drives—including strategy docs, financial sheets, slide decks, and PDFs—strictly honoring your @hollywoodparkca.com file permissions.

Try Asking
“Find our latest Q4 operational readiness deck in Google Drive and summarize the key milestones.”
✉️
GmailFederated & ACL-Enforced

Gmail Messages & Threads

Locate commitments, vendor quotes, leadership approvals, and action items across your Gmail inbox without leaving Gemini Enterprise.

Try Asking
“Summarize the most recent email threads in my Gmail about vendor onboarding and list any open questions.”
📅
Google CalendarFederated & ACL-Enforced

Google Calendar

Check your daily schedule, prepare 1:1 meeting briefings, audit calendar conflicts, and coordinate team availability.

Try Asking
“What meetings are on my Google Calendar today, and what documents should I review to prepare for them?”
💬
Google ChatFederated & ACL-Enforced

Google Chat Spaces & DMs

Catch up on busy team spaces, surface urgent escalations, and turn Chat discussions into tracked Wrike or Jira tasks.

Try Asking
“Check my recent Google Chat threads for any unresolved action items or blockers mentioned today.”
🎥
Google MeetFederated & ACL-Enforced

Google Meet Transcripts & Notes

Search across recorded meeting transcripts and notes to extract decisions, owners, and post-meeting follow-ups.

Try Asking
“Pull the key decisions and action items from my most recent Google Meet transcript.”
📌
WrikeIndexed & Live Action Connector

Wrike Project Management

Search Wrike spaces, project folders, milestones, and active deliverables across departments—and delegate new tasks directly from chat.

Try Asking
“Search Wrike for active tasks due this week and highlight any overdue milestones.”
🧩
Jira CloudIndexed & Live Action Connector

Jira Cloud (Projects, Epics, Issues & Boards)

Unified connector across 10 Jira Cloud entities: Projects, Boards, Epics, Stories, Tasks, Bugs, Issues, Comments, Attachments, and Worklogs for IT and engineering tracking.

Try Asking
“Check Jira for all open bugs or blocked stories in our current sprint and group them by assignee.”
🏛️
Cloud Storage Document StoreIndexed Semantic Search

Hollywood Park Org Documents Store

Curated district-wide reference documents, policies, standard operating procedures, and reference guides indexed in Google Cloud Storage for fast semantic retrieval.

Try Asking
“Search our Hollywood Park Org Documents store for official district policies and standard operating procedures.”
Layer 2 • Verified SQL & Conversational Analytics

Curated Data Agents (3)

Scoped strictly to curated BigQuery tables, business definitions, and verified queries—with built-in Python execution for generating charts and executive metrics.

🎟️
BigQuery Data AgentVerified SQL + Python Charting

Ticketing & Event-Performance Data Agent

Scoped to the unified event-performance warehouse table (mart_poc_event_data). Answers high-precision questions on ticket inventory, sold/comp tickets, holds, revenue, attendance, sell-through, and no-shows using verified SQL.

Try Asking
“Show me a breakdown of sold vs. comp tickets, total revenue, and attendance rate by event from mart_poc_event_data.”
🅿️
BigQuery Data AgentVerified SQL + Python Charting

ParkHub Parking Operations Data Agent

Scoped to stg_parkhub events, reporting, and transaction tables. Delivers verified metrics on parking pass sales, lot transaction volumes, ingress activity, and event-level parking revenue.

Try Asking
“Analyze parking transaction volumes and gross parking revenue across lots for the last three major events.”
📈
Marketing Analytics Data AgentVerified Analytics & Metrics

Iterable Venue Marketing Data Agent

Curated analytics specialist for venue email campaigns in Iterable. Evaluates audience reach, open/click conversion funnels, and presale campaign effectiveness.

Try Asking
“Compare email open rates, click-to-open rates, and conversions across recent YouTube Theater and SoFi Stadium campaigns.”
Layer 3 • Universal Tool Protocol

MCP Servers & Tool Gateways (3)

First-party Google-managed MCP servers and custom remote Streamable HTTP MCP servers hosted on Cloud Run.

⚡
First-Party Managed MCPPer-User OAuth / IAM Federated MCP

Google-Managed Workspace & SaaS MCP Server

Powers live federated lookups and write actions (creating Google Docs, updating Sheets, logging Jira issues, and delegating Wrike tasks) while strictly enforcing per-user OAuth permissions.

Try Asking
“Draft a meeting summary in a new Google Doc and create follow-up tasks in Wrike using our connected Workspace & Wrike tools.”
🌐
Custom Cloud Run MCP / ADK ToolsetStreamable HTTP (Cloud Run)

Hollywood Park Innovation Hub Tool Server

Exposes live publishing tools (`publish_page`, `update_page`, `list_pages`, `set_privacy`) so Gemini can deploy HTML dashboards and prototypes directly to innovation.hollywoodparkca.com.

Try Asking
“Publish this HTML prototype to the Hollywood Park Innovation Hub and return the shareable URL.”
🛠️
Custom Remote MCP (FastMCP / Cloud Run)Agent Gateway + Secret Manager

Custom Cloud Run MCP Gateway

Connect proprietary Hollywood Park APIs, internal microservices, or legacy databases that don't have an off-the-shelf connector by deploying a remote FastMCP server to Cloud Run (guided by the @mcp-builder skill).

Try Asking
“Use @mcp-builder to scaffold a production Python FastMCP server on Cloud Run that wraps our internal API.”