Query Policy

This page explains query controls for each data source in Skoot.

Connection Query Controls

• Configure Query Timeout (ms) in the connection settings for each data source:
  • It is the maximum time Skoot allows a query to run before stopping it.
  • Skoot applies this timeout whenever it runs SQL, including the agent-driven query executions and verified query previews.
  • Defaults for new and existing connections is 30000
  • Example: for a cost-sensitive production warehouse, set Query Timeout (ms) to 15000 to stop long-running scans earlier.

Validation rules:

• The timeout value must be an integer.
• The timeout value must be at least 1000 ms.
• Skoot does not impose an application-level maximum.

Notes

• Use dedicated read-only credentials for each data source as your primary write-protection control.
• Some data sources may still enforce engine-side limits (for example, warehouse/session settings).
• If engine-side limits are lower than your Skoot setting, engine behavior takes precedence.

Related Pages

• Data Sources Overview
• Query Audit Trail