When to use this skill
Use when the user wants to:
- Ask natural language questions over any Data Cloud source
- Create or list data agents (BigQuery)
- Add verified queries to improve agent accuracy
- Set up CA profiles for Looker or database sources
- Understand how CA routes across source types
Prerequisites
- BigQuery:
--project-id (or DCX_PROJECT)
- All other sources:
--profile (YAML file defining source connection)
ca ask uses --location (defaults to US) for chat/queryData endpoints
- Agent management (
create-agent, list-agents, add-verified-query) always uses locations/global — the --location flag is ignored for these commands
- Does not require
--dataset-id
See dcx-bigquery for authentication.
Command routing
| User goal |
Command |
| Ask a natural language question |
dcx ca ask "<question>" [--agent|--tables|--profile] |
| Create a data agent |
dcx ca create-agent --name=NAME --tables=REFS |
| List data agents |
dcx ca list-agents |
| Add a verified query |
dcx ca add-verified-query --agent=NAME --question=Q --query=SQL |
Source routing
The --profile source_type determines which API is called automatically:
| Source |
API Family |
Access method |
| BigQuery |
Chat/DataAgent |
--agent, --tables, or --profile |
| Looker |
Chat/DataAgent |
--profile only |
| Looker Studio |
Chat/DataAgent |
--profile only |
| AlloyDB |
QueryData |
--profile only |
| Spanner |
QueryData |
--profile only |
| Cloud SQL |
QueryData |
--profile only |
Workflows
BigQuery (agents + inline tables)
dcx ca create-agent --name=agent-analytics \
--tables=myproject.analytics.agent_events \
--instructions="You help analyze AI agent performance."
dcx ca ask "What is the error rate for support_bot?" --agent=agent-analytics
Profile-based (Looker, databases)
dcx ca ask --profile sales-looker.yaml "top selling products"
dcx ca ask --profile finance-spanner.yaml "revenue by region"
dcx ca ask --profile ops-alloydb.yaml "show all tables"
dcx ca ask --profile app-cloudsql.yaml "active users today"
Decision rules
- Use
--agent for pre-configured BigQuery data agents
- Use
--tables for ad-hoc BigQuery queries without an agent
- Use
--profile for Looker, AlloyDB, Spanner, Cloud SQL, or BigQuery profiles
--profile cannot be combined with --agent or --tables
--agent and --tables are mutually exclusive
--format text for interactive exploration; --format json for scripts
Constraints
- CA API is currently in preview
- Data agents are project-scoped, BigQuery-only, and live at
locations/global
- Database sources (AlloyDB, Spanner, Cloud SQL) do not support data agents or visualizations
- Looker profiles work with
ca ask but not ca create-agent
References
references/ask.md — ca ask flags, output structure, per-source examples
references/create-agent.md — agent creation, views, verified queries format
references/looker.md — Looker profile setup, OAuth, explore format
references/querydata.md — database CA setup, prerequisites, context sets
1---2name: dcx-ca3description: Conversational Analytics — natural language queries over BigQuery, Looker, AlloyDB, Spanner, and Cloud SQL, plus data agent management and verified queries.4---56## When to use this skill78Use when the user wants to:9- Ask natural language questions over any Data Cloud source10- Create or list data agents (BigQuery)11- Add verified queries to improve agent accuracy12- Set up CA profiles for Looker or database sources13- Understand how CA routes across source types1415## Prerequisites1617- BigQuery: `--project-id` (or `DCX_PROJECT`)18- All other sources: `--profile` (YAML file defining source connection)19- `ca ask` uses `--location` (defaults to `US`) for chat/queryData endpoints20- Agent management (`create-agent`, `list-agents`, `add-verified-query`) always uses `locations/global` — the `--location` flag is ignored for these commands21- Does **not** require `--dataset-id`2223See **dcx-bigquery** for authentication.2425## Command routing2627| User goal | Command |28|-----------|---------|29| Ask a natural language question | `dcx ca ask "<question>" [--agent\|--tables\|--profile]` |30| Create a data agent | `dcx ca create-agent --name=NAME --tables=REFS` |31| List data agents | `dcx ca list-agents` |32| Add a verified query | `dcx ca add-verified-query --agent=NAME --question=Q --query=SQL` |3334## Source routing3536The `--profile` source_type determines which API is called automatically:3738| Source | API Family | Access method |39|--------|-----------|---------------|40| BigQuery | Chat/DataAgent | `--agent`, `--tables`, or `--profile` |41| Looker | Chat/DataAgent | `--profile` only |42| Looker Studio | Chat/DataAgent | `--profile` only |43| AlloyDB | QueryData | `--profile` only |44| Spanner | QueryData | `--profile` only |45| Cloud SQL | QueryData | `--profile` only |4647## Workflows4849### BigQuery (agents + inline tables)5051```bash52dcx ca create-agent --name=agent-analytics \53 --tables=myproject.analytics.agent_events \54 --instructions="You help analyze AI agent performance."5556dcx ca ask "What is the error rate for support_bot?" --agent=agent-analytics57```5859### Profile-based (Looker, databases)6061```bash62dcx ca ask --profile sales-looker.yaml "top selling products"63dcx ca ask --profile finance-spanner.yaml "revenue by region"64dcx ca ask --profile ops-alloydb.yaml "show all tables"65dcx ca ask --profile app-cloudsql.yaml "active users today"66```6768## Decision rules6970- Use `--agent` for pre-configured BigQuery data agents71- Use `--tables` for ad-hoc BigQuery queries without an agent72- Use `--profile` for Looker, AlloyDB, Spanner, Cloud SQL, or BigQuery profiles73- `--profile` cannot be combined with `--agent` or `--tables`74- `--agent` and `--tables` are mutually exclusive75- `--format text` for interactive exploration; `--format json` for scripts7677## Constraints7879- CA API is currently in preview80- Data agents are project-scoped, BigQuery-only, and live at `locations/global`81- Database sources (AlloyDB, Spanner, Cloud SQL) do not support data agents or visualizations82- Looker profiles work with `ca ask` but not `ca create-agent`8384## References8586- `references/ask.md` — ca ask flags, output structure, per-source examples87- `references/create-agent.md` — agent creation, views, verified queries format88- `references/looker.md` — Looker profile setup, OAuth, explore format89- `references/querydata.md` — database CA setup, prerequisites, context sets