Manage Query Parameters

With parameters, you can set the values for a query's filters or calculations each time it runs. Parameters enable you to use a query in multiple contexts and slice-and-dice its data in real time, such as by account, region, or time period.

Create Parameters for a Query

You can create a query's parameters in either the Builder or SQL Editor. When you create a parameter, you can use it with multiple filters and calculations in the query. 

1. From the Parameters panel, click Create Parameter.
   
2. To help identify the parameter, enter a unique name with only alphanumeric characters and no spaces.
3. For Filter type, choose the type of data to filter by, such as Text or Integer.
4. For parameters other than Boolean, to choose from a list of options when you run the query, select Pick List, and enter each option of the list on its own line.

   Note: For a date or timestamp filter, enter each option in the YYYY-MM-dd format.

5. Enter or select the parameter's default value.
6. Click Create.
7. To apply the parameter's value to the query, use it in a filter or calculation:
   • To set a filter's value based on the parameter, select it when you define the filter from the Field Properties right panel.
   • To reference the parameter in a calculation, enter its name after a colon (:) in the SQL statement, such as :ReportingPeriod.

Edit a Query Parameter

To adjust or manage the details of a parameter:

1. From the Parameters right panel, click the parameter to edit.
2. Edit the parameter's name, data type, or values as necessary.
3. Click Apply.

Remove a Query Parameter

If you no longer need a parameter, you can remove it from the query. From the Parameters right panel, click the parameter's Delete , and then click Save .