Skip to main content

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.

ParameterDescriptionExample
use_aggregatesOverride to false to prevent queries in this session from using aggregates.set use_aggregates = false
create_aggregatesOverride to false to prevent queries in this session from generating aggregates.set create_aggregates = false
fake_resultsOverride to true to enable AtScale "training mode" for this session.set fake_results = true
use_local_cacheOverride to false to prevent queries in this session from using the local query.use_local_cache = false