Skip to main content
Version: I2022.4.1

Inbound SQL Session Parameters

AtScale supports four SQL session parameters that you can use in an SQL session.

In an SQL statement that you run from any client in which you can edit statements directly before passing them to AtScale, place one or more of these parameters in SQL commands.

use_aggregates
Override to false to prevent queries in this session from using aggregates. For example: set use_aggregates = false

create_aggregates
Override to false to prevent queries in this session from generating aggregates. For example: set create_aggregates = false

fake_results
Override to true to enable AtScale "training mode" for this session. For example: set fake_results = true

use_local_cache
Override to false to prevent queries in this session from using the local query. For example: use_local_cache = false