Defining variables in analyses - 7.3

Suppose that you want to profile a postal_code column and you want to analyze the postal codes that start with 15 in the development environment and with 75 in the production environment. You also want to allow different concurrent connections per analysis in the two environments.

In this example, the first variable is where_clause.

In this example, set the value of the where_clause variable in the Test context to postal_code like '15%', and for the Prod context to postal_code like '75%'. Set the value for the concurrent connections per analysis in the development and production environments to three and five respectively.