Writing SQL to get data onto a dashboard shouldn't require being a SQL expert. SmartAssist is an AI assistant built directly into SquaredUp's tile editor that helps you build queries faster, without needing to know the syntax or even the language. It can be used in two distinct areas:
- The parameters step of a query language e.g. JQL, KQL or MSSQL
- For combining data streams or advanced grouping when you turn on SQL Analytics
How to use it
- Open the tile editor and select the an appropriate data stream e.g. Log Analytics KQL
- Select objects, as normal
- Navigate to the Parameterstab
- Click the SmartAssist AIicon in the top-right corner of the query editor to open the chat panel.
- Describe what you want in plain language — for example, "Show me the top 10 issues by comment count from the last 30 days".
- SmartAssist generates the query for you. Click Previewto review the suggested changes.
- A side-by-side comparison shows your original query next to the new version so you can see exactly what's changed.
- Happy with it? Click Applyand Execute the SQL when ready, that's it 🎉