Warehouse data and dashboards
Ask your warehouse a question in the chat
Ask a question in your own words, and Ahamo's AI queries your connected warehouse, works out the figures and shows how each one was checked.
On this page
Ask a question about your company's data in any chat, and Ahamo's AI answers it from your connected warehouse. It writes the query, runs it, works out the figures and shows each one with how it was checked. You don't need an app for this.
Availability. You need a warehouse connection that you own or that is shared with you. This uses the AI capability Using your connected tools, which a workspace admin can turn off under AI capabilities.
Ask
Ask in your own words, and name the warehouse or the tables when you know them.
How did sales per region change month by month this year? Use the sales tables in Snowflake.
Which ten products had the most returns last quarter, and what share of their sales was that?
Ahamo uses a connection you may use. If none exists, it shows a card to connect one. If you have several for the same warehouse, it asks which one.
The answer comes first, as a number, a chart, a map or a short list, with one line on the assumption that matters.
Read-only and approvals
On a connection that can only read, Ahamo runs each query without asking. On a connection that may change data, each query waits in a card until you approve it, because SQL can change or delete data. Ahamo's AI never runs a change you didn't ask for. See Read-only connections.
If your organisation has put datasets on a connection, Ahamo asks only through those datasets, under the rules set for you. Free SQL on that connection is refused, even with approval.
Where the results go
The rows go into the chat's Sandbox as a file, never into Files. Ahamo's AI reads the columns and the row count, and works out the figures in the Sandbox.
The data stays for your next message in the same chat, up to 25 MB, so a follow-up question doesn't fetch it again. It isn't kept after that, and it isn't saved anywhere else.
To keep a result, ask Ahamo to save it. It then saves that file to Files on purpose. A dashboard keeps the data its tiles need by itself.
How figures are checked
Each figure shows how it was checked:
| Mark | What it means |
|---|---|
| Verified | Ahamo worked the figure out, then checked the answer exactly in another way |
| Cross-checked | Ahamo worked the figure out in two different ways and got the same answer |
| Estimate | An estimate Ahamo worked out and checked, so the real figure may differ a little |
| Not verified | No check confirmed it |
A figure that no independent check confirmed isn't shown as a result. Tap a mark to see the calculation and the checks.
Limits
Each query may run for 2 minutes and return 1,000,000 rows or 25 MB. A BigQuery query may bill at most 10 GiB. When rows are left out, Ahamo says so. Queries run in your warehouse and are billed by it.
Every query is in Ahamo's audit log with its SQL and who asked.
Troubleshooting
Ahamo asks which connection to use. You can use several connections for the same warehouse. Name the one you mean.
A card asks you to approve a query. The connection may change data. Approve the query, or connect the warehouse again as Only read.
The answer says rows were left out. The answer was larger than the limit. Ask for fewer columns, a shorter period, or totals instead of rows.
A BigQuery query is refused for its cost. It would bill more than 10 GiB. Ask for fewer columns or a narrower filter.
You can't see a dataset you need. Ask for access. See Ask for access to a dataset.