Query Tool overview
The Query Tool is an interactive UI within Dataset Manager, 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 identity queries. Unless previously agreed otherwise, identity 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 identity queries. Insight queries return aggregated, statistical results whereas identity queries return a list of identifiers that relate to specific individuals. In order to submit an identity query, you must have a selected an output column during the data mapping 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.
Once you're ready, if you've built an insight query 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, if you like, view the query in json format.
If you've built an identity 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.