Data Query Studio

Use the Data Query Studio when you need to ask a question about past data without building a full dashboard first. It gives you direct, safe access to history, export, and quick analysis.

It sits between raw database access and visual dashboards, so you can explore data without writing complex code.

Why Use Data Query Studio?

• Troubleshooting: Look at the last hour of data for a machine to see what happened before a failure.
• Ad-Hoc Reporting: Build a dataset for a specific time range and export it to Excel for offline analysis.
• Dashboard Prototyping: Try a data view, then turn it into a dashboard when it is useful.

Getting Started

Accessing the Studio

You can access the Data Query Studio directly from any device detail page.

1. Navigate to Devices in the main menu.
2. Select the device you want to inspect.
3. Click the Data Query Studio action (database icon) in the toolbar.

Building Your Query

You do not need to be a database expert. The studio uses a simple parameter-based builder:

1. Define Scope: Choose the Time Unit and Time Value (e.g., "Last 2 Days").
2. Optimize Granularity: Select a Group Unit (e.g., "10 Minutes") if you want to see trends without downloading millions of data points.
3. Generate: Click Generate Query to let the system build the optimal SQL for you.

Analyzing & Exporting Results

Once you run a query, your data appears in a flexible grid view:

• Filter & Sort: Click headers to sort or use the filter row to narrow down results (e.g., find all values > 100).
• Export: Use the export menu to download your findings as CSV or Excel files to share with your team.

Turning Insights into Dashboards

The main value of Query Studio is that a useful analysis can become a dashboard later. If you create a query like "Daily Average OEE for Line 1", you do not need to rebuild it next time.

1. Execute your query and verify the results.
2. Click Create Dashboard.
3. Proxus automatically creates a new Dashboard with your data pre-loaded.
4. Drag-and-drop charts, gauges, and grids to visualize it.

For the full workflow (layouts, widgets, and ClickHouse SQL bindings), see Creating Dashboards.

System Protection (Smart Guard)

Proxus is designed for mission-critical operations. To keep large queries from slowing down the factory network or crashing your browser, the Smart SQL Guard is always active.

• Safe Limits: Queries are limited to 50,000 rows. If you need more data, try increasing the grouping interval.
• Read-Only: The system blocks commands that could modify or delete data.

Ready to explore? Open any device page and launch Data Query Studio when you need to investigate or export data.