Advanced Configuration

Advanced Configuration settings help optimize user experience and ensure responses are formatted correctly for analysis.

Query Execution & Display Settings #

Fine-tune how queries are processed, executed, and displayed in the application.

Show Generated Query #

Enable this option to display the SQL query generated for retrieving responses during conversations. This helps users understand how data is being queried.

Output Formats #

Choose how responses should be displayed:

• Grids – Tabular format for structured data representation.

• Graphs – Visual representation for better insights.

Max Rows in Data Grid #

Define the maximum number of rows to display when responses are shown in a data grid.

Query Execution Timeout (seconds) #

Set the maximum time (in seconds) the system should wait for a query to execute before timing out. Adjust this based on query complexity and data source performance.

Scope of the Application #

Specify the boundaries of the application, ensuring it only processes relevant queries while classifying unrelated ones as out of scope.

For example, the scope of an application for analyzing employee performance can be defined as:

This application is designed to analyze employee compensation and performance data. Any questions related to current affairs, global events, or topics beyond the scope of data analysis should be explicitly considered out of scope.

Advanced Settings for SQL Generation #

Provide additional instructions in natural language to guide SQL generation for better accuracy. These instructions would apply to all selected tables in the dataset.

Examples:

• States are stored as two-letter abbreviations (CA, NV).

• When querying for the highest salary, disregard any null values in the salary column.

Advanced Settings for Graph Generation #

Define preferences for how the application should generate graphs based on query results.

Examples:

• Prefer Vertical Bar chart over Line graph.

• Use Line chart for Growth trends over time.

Additional Configurations #

Add Configuration: Provide additional key-value pair settings for customization.

Save & Sync Changes #

• Save – Saves all changes made to the application.

• Sync – Synchronizes metadata and examples with the vector database.

• Save & Sync – Saves changes and syncs metadata & examples in one step.

Once saved and synced, you will be redirected to the listing page, where you can start querying your data and performing further actions.