Viewing and Setting GUC Parameters

To ensure the optimal performance of DataArts Fabric SQL, you can adjust the GUC parameters in the database based on service requirements.

The database offers numerous operation parameters. Configuring these can impact the behavior of the database system. When modifying these settings, make sure you comprehend their impact on the database to avoid unforeseen results.

Precautions

If the value range of a parameter is a string, the string should follow the OS's rules for path and file name naming conventions.
For parameters with a maximum value of INT_MAX, the maximum value varies depending on the OS.
For parameters with a maximum value of DBL_MAX, the maximum value varies depending on the OS.

Parameter Types and Values

All parameter names are case-insensitive. Parameter values can be integer, float, string, boolean, or enum types.
Boolean values can be (on/off), (true/false), (yes/no) or (1/0), and are not case-sensitive.
For parameters with units, always specify the unit when setting them. Otherwise, default units will apply.
- Memory units include: KB, MB, and GB.
- Time units: ms, s, min, h, and d.

Viewing and Setting GUC Parameters

In DataArts Fabric SQL, you can only set GUC parameters by running the SET command via SQL statements as follows:

    
         SET paramName TO paramValue;

For example, to set the statement_timeout parameter, you can use the REST API to send SET statement_timeout TO 600, thereby setting it to 10 minutes.

To check the current settings of GUC parameters within a session, use the SHOW statement like so: