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 a selected an output column during the data normalisation phase.

When you use the Query Tool, the first thing to select is the query type. While writing the query, the explain button can be used to help you debug and fine-tune your query, potentially improving the quality of the result. 

 

The Platform will automatically work out which key produces the highest match to connect the datasets. If you want to, you can use the Advanced Settings to specify which key will be used, as shown in the example below. 

 

When you're ready, select Submit and then you will see the anonymised statistics in interactive histograms, joy plots and pie graphs. You can also review the query quality and view the query in json format. 

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 resulting dataset and choose to push the results to an external destination, such as an SFTP server.