> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/advanced-topics-pentaho-data-integration-overview/pentaho-data-services/optimize-a-pentaho-data-service/apply-a-query-pushdown-optimization/set-up-query-pushdown-parameter-optimization.md).

# Set up query pushdown parameter optimization

To set up this optimization, complete these steps:

1. **Open the Data Service window**, then click the **Query Pushdown** tab.
2. Click the Plus Sign button near the **Parameters** label.
3. In the Create Parameter window add the name of an optimization parameter you created in the input step’s SQL query.
4. Click **OK**.
5. Select the step that contains the parameter from **Step Name**.
6. In the **Definitions** area of the window, enter the **Data Service Field** and the **Step Field** you want to parameterize.
   * The **Data Service Field** contains the transformation's name of the field you want to parameterize. The name should be as it appears in the transformation's output field. For example, you might have renamed the `cty` field from your data source to `country`. You would enter `country` in the **Data Service Field**.
   * The **Step Field** should contain the data source's name of the field you want to parameterize. For example, if you wanted to parameterize the `cty` field in a MySQL database, enter `cty` in the **Step Field**.
7. Optionally, you can click the **Get Optimizations** button to automatically generate input step optimizations based on the output fields for the step on which you have created the data service and input fields.
8. Click the **OK** button to save and close the window.
9. **Test the optimization**.
10. **Publish the Pentaho Data Service**.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/advanced-topics-pentaho-data-integration-overview/pentaho-data-services/optimize-a-pentaho-data-service/apply-a-query-pushdown-optimization/set-up-query-pushdown-parameter-optimization.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.