allow_ctes - Omni Docs

Disabling CTEs is not recommended. Omni’s AI evals are not run in this mode, and CTEs are still governed by your model - they build on top of it, not around it. Turning off CTEs limits what the AI can generate, and Omni will not address reports of the AI failing to produce certain queries as a result.

Properties

ai_settings

object

An object that contains various AI settings. See ai_settings for more information.

Hide ai_settings properties

allow_ctes

string

default:"always"

When the Omni Agent and Workbook Agent can generate CTEs in their queries. Does not apply to hand-written SQL.Must be one of the following:

always - Default. The AI can generate CTEs for all users, regardless of whether their role allows direct SQL access.
never - The AI cannot generate CTEs.
not_for_restricted_queriers - The AI can generate CTEs for all users with querying access except Restricted Queriers.

Examples

ai_settings: allow_ctes: not_for_restricted_queriers

```yaml title="Disable CTEs for all users"
ai_settings:
  allow_ctes: never

ai_settings: allow_custom_fields: not_for_restricted_queriers allow_ctes: not_for_restricted_queriers

See [`allow_custom_fields`](/modeling/models/parameters/ai-settings/allow-custom-fields) for more information.

​Syntax

​Properties

​Examples

Syntax

Properties

Examples