Query Configuration

Tursio allows users to configure which parts of the database are enabled for querying. Tables or views can be added as Query Tables and referenced during query processing. This section describes how to manage Query Tables.

Add Query Table

The screenshot below shows the Add Query Table dialog.

To add tables to the query scope:

1. Click Add Query Table in the Query Tables section.
2. Select the database from the dropdown (only databases you have already connected will appear).
3. Choose the tables or views you want to include from the selected database.
4. Click Save.

Adding Microsoft Excel

Users can create a database with Microsoft Excel as the dialect and then add Query Tables as follows:

1. Enter a table name.
2. Select the report type (e.g., Forecast report).
3. Upload a valid Excel file in the predefined format.
4. Once uploaded, click Save.
5. If the Excel file contains errors, a downloadable Error Log link will be provided.

The screenshot below shows the Add Query Table dialog for Microsoft Excel.

Note

Share a sample Excel file with the Tursio team for training. Once trained, that format will be available as a report type for uploading future Excel files.

Save Query Table

Once a Query Table is added, the engine classifies its columns into the following categories:

• Dimensions — Used for grouping and filtering (e.g., category, date).
• Measures — Numeric or aggregated values (e.g., sales, count).
  • Can also be added as dimensions for filtering.
• PII Columns — Sensitive data (e.g., SSN, email, phone).
  • Cannot be used as either dimensions or measures.

The screenshot below shows columns categorized for different Query Tables.

Training Required

Adding Query Tables takes effect only after re-training. Re-train your database to apply updates and refresh the page afterward. Once training is complete, the trained dataset will appear in the Select Dataset dropdown.

Edit Query Table

A Query Table can be edited to configure additional details and refine the query scope:

• Alias Name: An alias for the table, used for easier referencing.
• Dimension Values: Columns that should be treated as dimensions (categorical fields used for grouping or filtering).
• Measure Values: Numeric columns to be treated as measures (used for aggregations such as sum, average, etc.).
• PII Values: Columns containing Personally Identifiable Information (PII), marked to ensure proper handling and compliance.

The screenshot below shows the Edit dialog for modifying column categories.

Editing a Query Table with the Microsoft Excel dialect allows users to:

1. Re-upload Excel files in the predefined format.
2. Download the parser error log if any errors are detected when the Excel file is saved.

The Edit Query Table dialog is the same as the one used when uploading a new Query Table.

Delete Query Table

To remove a table from the query scope entirely:

1. Select the Query Table.
2. Click Delete next to the table entry.
3. Confirm the deletion.

The removed table will no longer be used for querying.

Tip

With Query Tables configured, the system will only query from the approved scope, ensuring accuracy and security.

Note

Changes to Query Tables take effect only after re-training. Re-train your database to apply updates and refresh the page afterward. Once training is complete, the trained dataset will be available in the Select Dataset dropdown.