Home

Query Cost Control

1. Overview

The Query Cost Control feature helps you manage and optimize query expenses across your data environments. By setting limits, you can prevent runaway queries, avoid unexpected charges and ensure predictable usage of your connected data sources.

Instead of relying on manual monitoring, Connecty AI enforces cost limits automatically. This gives teams both flexibility and protection, ensuring that data exploration stays within defined budget boundaries.

2. Where to Find

You can configure Query Cost Control directly in the Connection Settings of any Data Environment.

Steps:

  1. In the left navigation bar, click the Manage icon ⚙️.

  2. Select Data Environments.

  1. Choose the environment where you want to set a cost limit (e.g., Snowflake).

  1. In the Connections section, click the specific connection you want to edit.

  1. Scroll down to the Synchronization or Execution Configuration area.

  2. Locate the Query Cost field.

  3. Enable and set the Limit query cost value.

  1. Click Save Changes to apply.

3. How it Works

The Query Cost Control feature lets you define limits on the cost of queries executed in Connecty AI. These limits ensure that your environments stay within budget and prevent runaway queries from consuming excessive resources.

Synchronization Cost Limit

  • Applied when Connecty AI synchronizes metadata (schemas, objects, and statistics) from your data source.

  • Prevents excessive sampling or scanning costs during background sync operations.

Example: If you set a limit of $50, synchronization tasks will stop once this cost threshold is reached.

Execution Cost Limit

  • Applied when running user queries (the SQL generated to answer questions).

  • Ensures interactive analysis does not exceed your budget.

Example: If you set a limit of $200, queries will be blocked once the accumulated execution cost reaches this value.

Automatic Enforcement

If a query would exceed the defined limit, Connecty AI blocks the request and notifies you. This applies both to synchronization and user queries, depending on where the limit is set.

Limits can be changed in Connection Settings at any time.

Last updated