Using the Query Tool

The Query Tool is an interactive UI within the Platform, which you can use to build, test and run queries.

The Query Tool helps you explore the datasets you can reference, and to build a query using InfoSum's query language, IQL. If you want to, you can then take the finished query and run it using the Platform API.

As discussed in the IQL reference documentation, InfoSum Platform supports two types of queries: insight queries and activation queries. Unless previously agreed otherwise, activation queries are disabled by default as it's important to consider legal and regulatory requirements. If required, please get in touch with your InfoSum contact to discuss enabling this feature.

Alongside the slight difference in syntax, the use case and output greatly differ between insight and activation queries. Insight queries return aggregated, statistical results whereas activation queries return a list of identifiers that relate to specific individuals. In order to submit an activation query, you must have selected an output column during the data normalisation phase.

When you use the Query Tool, the first thing to select is the query type. then start writing the query. You can click the Copy to console icon in the left pane to copy the name of a dataset, category or category and property to the query text. 

To copy a previous query, click the Copy to console icon to reproduce the whole query in the query text.

The Platform automatically works out the best key for matching based on the highest fill rate. Using Advanced Settings you can override the InfoSum Platform automatic key choice based on highest fill rate, as shown in the example below. 

When you're ready, select SUBMIT and then you will see the anonymised statistics in interactive histograms, joyplots and pie graphs. You can also review the query quality and view the query in json format. If your query contains any errors, a warning message appears under the query.

If you've built an activation query, name the campaign and select Create campaign. You will then be taken to the Activation tab, where you can view the size of the resulting dataset and choose to push the results to an external destination, such as an SFTP server.