[Yandex Cloud documentation](../../index.md) > [Yandex DataLens](../index.md) > [Datasets](index.md) > Source parameterization

# Parameterization of dataset sources in Yandex DataLens

Parameterization of dataset sources allows you to dynamically substitute parameters from a chart into an SQL query or a table or schema name.

To enable source parameterization:

1. Configure a **Raw SQL level** at the connection level. Enable the setting and select the **Allow subqueries in datasets and source parameterization** level.

   {% cut "Connecting with source parameterization" %}

   ![create-connection](../../_assets/datalens/operations/connection/create-sample-connection-parametrization.png)

   {% endcut %}

1. Create a dataset and click **Enable parameterization** in its settings ![image](../../_assets/console-icons/gear.svg).

   {% cut "Enabling parameterization in a dataset" %}

   ![image](../../_assets/datalens/dataset-parametrization/dataset-parametrization-on.png)

   {% endcut %}

1. Follow the [steps](create-dataset.md#add-parameters) to add the parameter and enable the **Allow use in source setting** option in its settings. Available value types: [Integer](data-types.md#integer), [fractional number](data-types.md#float), [string](data-types.md#string), [date](data-types.md#date), and [date and time](data-types.md#datetime).
1. To define a dataset, use the **Insert parameter** button.



For an example of using parameters in a source, see [Source parameterization in DataLens](../tutorials/data-from-ch-dataset-parametrization.md).

   
_ClickHouse® is a registered trademark of [ClickHouse, Inc](https://clickhouse.com)._