Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# CURRENT\$1SETTING
<a name="r_CURRENT_SETTING"></a>

 CURRENT\$1SETTING returns the current value of the specified configuration parameter.

This function is equivalent to the [SHOW](r_SHOW.md) command.

## Syntax
<a name="r_CURRENT_SETTING-synopsis"></a>

```
current_setting('parameter')
```

The following statement returns the current value of the specified session context variable.

```
current_setting('variable_name')
current_setting('variable_name'[, error_if_undefined])
```

## Arguments
<a name="r_CURRENT_SETTING-argument"></a>

 *parameter*   
Parameter value to display. For a list of configuration parameters, see [Configuration reference](cm_chap_ConfigurationRef.md)

 *variable\$1name *   
The name of the variable to display. This must be a string constant for session context variables.

 *error\$1if\$1undefined*   
(Optional) A boolean value that specifies the behavior if the variable name doesn't exist. When error\$1if\$1undefined is set to `TRUE`, which is the default, Amazon Redshift throws an error. When error\$1if\$1undefined is set to `FALSE`, Amazon Redshift returns `NULL`. Amazon Redshift supports the *error\$1if\$1undefined* parameter only for session context variables. This can't be used when the input is a configuration parameter.

## Return type
<a name="r_CURRENT_SETTING-return-type"></a>

Returns a `CHAR` or `VARCHAR` string.

## Examples
<a name="r_CURRENT_SETTING-example"></a>

To return the current setting for the `query_group` parameter, use the following example.

```
SELECT CURRENT_SETTING('query_group');

+-----------------+
| current_setting |
+-----------------+
| unset           |
+-----------------+
```

To return the current setting for the variable `app_context.user_id`, use the following example.

```
SELECT CURRENT_SETTING('app_context.user_id', FALSE);
```