Applies to: check marked yes Databricks SQL

The ENABLE_PHOTON configuration parameter controls usage of the Photon vectorized query engine.

You can set this parameter at the session level using the SET statement.


Two settings are supported:

  • TRUE

    When set to TRUE Databricks SQL will use the Photon vectorized query engine wherever it applies.


    When set to FALSE Databricks SQL does not use Photon.

System default

The system default for this parameter is TRUE.


> SET enable_photon = false;