Administration & observability · Reliability and controls
Which BI tools let you cap AI spending?
6 of 15 tools do, according to their public docs, and 3 partly.
Yes: Databricks, Snowflake, Omni, Hex, BigQuery, Metabase. Partly: Sigma, MotherDuck, Redshift.
The question we asked: Can you cap what the built-in AI spends?
Grading standard
A limit that actually blocks the built-in AI's usage once it is reached. Reporting on spend without blocking anything does not count.
Databricks
Yes
Quoted from Databricks’s docsChecking Block usage blocks Genie usage for the user when the budget threshold is met.
Source: docs.databricks.com/aws/en/genie/budgets · checked Oct 26, 2026 · quoted by Claude
Snowflake
Yes
Quoted from Snowflake’s docsThese limits help organizations control CoCo consumption by blocking access when a user’s estimated credit usage in a rolling 24-hour window exceeds the configured threshold.
Source: docs.snowflake.com/en/user-guide/cortex-code/credit-usage-limit · checked Oct 26, 2026 · quoted by Claude
Omni
Yes
Quoted from Omni’s docsDisables AI features when the specified credit threshold is reached.
Source: docs.omni.co/ai/settings/usage · checked Oct 26, 2026 · quoted by Claude
Hex
Yes
Quoted from Hex’s docsAdmins can control how many add-on credits each user is allowed by applying a credit limit to a User, Group, or Workspace.
Source: learn.hex.tech/docs/administration/credits · checked Oct 26, 2026 · quoted by Claude
Sigma
Partlypreview
Quoted from Sigma’s docsAdmins can configure monthly token usage limits for their organization to limit AI column usage costs.
Source: help.sigmacomputing.com/docs/configure-ai-column-token-limit · checked Oct 26, 2026 · quoted by Claude
BigQuery
Yes
Quoted from BigQuery’s docsIf the estimated bytes to be scanned exceed the big_query_max_billed_bytes value, the query fails without incurring a charge, and the agent returns an error message.
Source: docs.cloud.google.com/gemini/data-agents/conversational-analytics-api/manage-costs · checked Oct 26, 2026 · quoted by Claude
Metabase
Yes
Quoted from Metabase’s docsOnce this limit is hit, Metabot stops responding to requests until the next reset.
Source: www.metabase.com/docs/latest/ai/usage-controls · checked Oct 26, 2026 · quoted by Claude
MotherDuck
Partly
Quoted from MotherDuck’s docsThe AI session cap safeguards your spend; it is not a throughput limit.
Source: motherduck.com/docs/sql-reference/motherduck-sql-reference/ai-functions/prompt · checked Oct 26, 2026 · quoted by Gemini
Redshift
Partly
Quoted from Redshift’s docsWhen using Amazon Q Developer Free tier, the total number of prompts of all users of an AWS account is limited to 1,000 in a month.
Source: docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-generative-ai-settings.html · checked Oct 26, 2026 · quoted by Claude
Looker
Tableau
Power BI
Alteryx
Mode
Streamlit