SET EXTERNAL_FEDERATION#
Controls whether the default (external) federation push-down step runs while a query is prepared.
When ON (the default), Querona may apply its default federation engine to statements that combine
data from more than one source. When OFF, that step is skipped.
Tip
This is an advanced query-planning option, on by default. It affects only how a federated query is planned and executed, not its results — change it for diagnostics or to work around a specific federation issue.
Syntax#
SET EXTERNAL_FEDERATION { ON | OFF } [;]
Remarks#
Federation is how Querona answers a single query whose data lives in several sources. This option
gates the final default-federator push-down stage of query preprocessing. The default is ON.
See SET IN_MEMORY_FEDERATION and SET SINGLE_SOURCE_FEDERATION for the other federation controls.
Permissions#
Requires membership in the public role.
Examples#
SET EXTERNAL_FEDERATION OFF;