Scheduled Tasks

Scheduled Tasks

Answering the same question every Monday morning shouldn't depend on someone remembering to ask it. With Scheduled Tasks, you save an agent prompt once, pick a cadence — hourly, daily, weekly, monthly, or a custom cron expression — and Cube runs it on schedule: querying your semantic layer, creating and updating reports and dashboards, and emailing results to workspace members.

Every run produces its own thread in Analytics Chat, so you can open any past run and ask follow-up questions in context, and each task's detail page shows its run history at a glance. Tasks run under the security context of the person who created them, so results respect row-level security and access policies. Create one from the new Scheduled section in the sidebar — or simply ask the agent in Analytics Chat to set it up for you.

Other improvements and fixes:

Workbooks

• Added subtotals to pivoted tables: turn on Subtotals in the totals menu and every pivot group gets its own "Total for" column, computed by the database so non-additive measures stay correct
• Fixed the fill in missing rows option resetting the query's sort order

Dashboards

Creators can now edit a published dashboard directly from its chat — ask the agent to add a chart, change filters, or adjust the layout, and it updates the draft; an Open in builder button then carries the conversation into the builder so you can review and publish.

Visualization

• You can now display a numeric column as a sparkline in Table charts, rendering the measure as a mini line, area, or bar chart over time
• Added a freshness indicator to charts in Workbooks and Dashboards: a leaf icon that shows how long ago the served data was refreshed
• Fixed Table charts ignoring date formats set in the Results tab
• Fixed a brief no-data flash while a Table chart loads

Administration

Chat History in the admin console now labels where each conversation originated: Web, Slack, MCP, API, or a scheduled task.

AI

• Added Claude Sonnet 5 support, both as a predefined model and for BYOM
• The Auto agent now uses Claude Opus 4.8 for data modeling
• The Cube MCP server now includes read-only searchDataModel and runQuery tools, so external agents can explore the data model and run governed queries directly
• Analytics Chat can now build map charts
• Custom MCP connectors now support API key, Basic Auth, and custom header authentication

Embed

Deployments can now authenticate Chat and embedding API requests with their own Cube authentication (JWT/JWKS) instead of a separate embed token, via a new deployment setting.

Modeling

• dbt pull can now generate joins between cubes, inferred from dbt relationships tests and foreign-key constraints
• You can now select which branch of your dbt repo to sync, and dbt connection settings moved from environment variables into deployment settings
• View-level default_ui_filters now accept relative date ranges (like "5 weeks ago" to "today") and use the same operator vocabulary as the workbook filter bar

Workspace

You can now rename a workbook from its context menu in the Workspace.