> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Data Query Templates

> Learn how to efficiently reuse predefined SQL queries using the Templates tab in the Data Query UI, enhancing data analysis tasks.

Learn how to efficiently reuse predefined SQL queries using the Templates tab in the Data Query UI, enhancing data analysis tasks.

The **Templates** tab in the Data Query UI makes it easier for you to reuse predefined SQL queries and improves efficiency in data analysis tasks.

![Data\_Query\_Templates](/_fern-img/38dac2adc959c4d4d3f22fcf1eab9e8015bfead1d355f41737fa520363a3fffa.webp)

## Data Query Template features

Feature highlights include:

* **Templates Tab**: Access a new tab, **Templates**, in Data Query UI.
* **Categories and Accordions**: View predefined data query templates organized into collapsible categories such as booking, billing, cash, revenue, finance, and audit logs.
* **Template Details**: Each template displays a clear name and a detailed description of its purpose.
* **View and Customize**: Click on **View Template** to open the predefined query in the Data Query UI editor. You can customize the query to suit your needs without altering the original template.

This is how templates in Data Query work:

1. Navigate to the **Templates** tab in the Data Query UI.
2. Expand categories to view available templates.
3. Click **View Template** to open the query in the editor.
4. Customize and run the query as needed.