Skip to main content

Query Mode

We designed a rich query editor with advanced query features like (Sample query, Parameters, and so on). With Query editor, you can write, edit and run queries against your integration.

Learn How to use Query Mode​

Query Mode​

First, click the Query Mode switch toggle to open the Query editor.

query mode

Write your Query​

The Query Editor is where you create and edit queries to get insight from your data. You can also add multiple queries in the SQL editor by using a semicolon to parse the queries.

write your query

Use Advanced Query

The advanced query will have access to schema, table, and columns that help you to write queries more accurately.

  • Click the Arrow button that will open the Advanced Query Editor

You can use the Advanced Query editor for the following purposes-

advanced query

  • In the left side of pane, you will see a Data Structure where you can search for the schema and tables

  • In the query editor box, you can write, copy, format the query, and view the sample query

  • You can pass parameter using {{}} in an advanced query editor or click the Add Parameter button

  • To execute the query, click the Test button

Add Parameter​

You pass parameters to the query using {{}} syntax in a query editor to change the query statement or the query data

Naming Dataset​

Give a meaningful name to the dataset and then click the Continue button for further transformation

Test & Save​

Click the Test & Save to save the dataset

Any Question? 🤓​

We are always an email away to help you resolve your queries. If you need any help, write to us at - 📧 support@boltic.io