SQL Runner Analyst+

The SQL Runner lets you write and execute read-only SELECT queries against any data source in your organization. Use it for ad-hoc analysis that dashboards do not cover.

Writing a Query

  1. Open the Data page and click SQL Runner (or open it from the sidebar).
  2. Write your query in the editor. Only SELECT statements are allowed.
  3. Click Run or press Cmd+Enter.
  4. Results appear in a table below the editor.
SELECT campaign_name, SUM(impressions) as total_impressions
FROM stc_campaign_data
WHERE date >= '2026-01-01'
GROUP BY campaign_name
ORDER BY total_impressions DESC
LIMIT 50
⚠️

Queries are read-only. INSERT, UPDATE, DELETE, and DDL statements are blocked.

Using SQL via AI Chat

You can also run SQL through the AI chat. Ask something like:

“Run SQL: select the top 10 campaigns by revenue this month”

The AI translates your request into SQL, executes it, and shows the results inline.

Tips

  • Reference tables by the names shown in the Data sidebar.
  • Use the Table Preview to check column names and types before writing queries.
  • Results are limited to 10,000 rows. Add a LIMIT clause for faster execution on large tables.

What’s Next