Query executor

The Query Executor lets users run SQL queries on data sources connected to the platform.

With this function, you can:

• Choose a database connection
• View and select tables and columns
• Write and validate SQL queries
• Fetch and preview the output columns from your query

This is useful when you filter, join, or extract data using custom SQL directly within your data pipeline.

How to use Query Executor?

Step 1: Open the “Query Executor” component to the workspace.

Step 2: Select the connection name from the drop-down option.

Step 3: Enter the SQL query manually, or use the AI Assistant to assist in writing the query.

Step 4: Upon successfully validating a Select query, the output will be fetched and displayed on the right side of the screen.

Case 2: Query from the last step.

To use the query from the last step, check the box. The user can see the query in the expression box. Now, fetch the columns.

Proceed with “Save.”

For example:

• Selected the connection “pspVert.”
• Entered the required SQL query and validated it. The fetched output is displayed upon successful validation.
• You can also use an AI assistant.

The AI Assistant helps users create, modify, and optimize SQL queries more easily within the Ask Me training interface. Instead of writing complex SQL manually, users can use the AI Assistant to generate or refine queries based on their requirements.

With the AI Assistant, users can:

• Generate SQL queries automatically based on the question or analysis they want to perform.
• Improve or correct existing SQL queries to ensure accurate results.
• Simplify complex query writing, especially for users who may not be familiar with SQL.
• Receive suggestions for filters, aggregations, and calculations based on the dataset structure.

Preview: