Determines whether prepared statements are allowed when executing queries in Snowflake.

Data Type

bool

Default Value

false

Remarks

A prepared statement is a SQL query that is precompiled and can be executed multiple times with different parameters.

The default value for this property is 'false', meaning that statements are parsed each time they are executed. Leave the default setting if you are executing many different queries only once, or if you have complex queries.

If you are executing the same query repeatedly, you will generally see better performance by setting this property to 'true'. Preparing the query avoids recompiling the same query over and over. However, prepared statements also require the connector to keep the connection active and open while the statement is prepared.