Workbench SQL examples

These pages walk through using the Five Safes TES workbench with SQL queries: creating a TES message, validating the message, submitting a task, retrieving the results and aggregating them.

The examples demonstrate using SQL, structured query language, in order to make requests of the databases held in two, separate TREs. SQL can be used to select subsets of the data, and perform basic analysis on the data. These examples demonstrate the use of SQL in this way, but it is extremely flexible, as arbitrary SQL commands can be used to create many different types of analysis.

Use the links in the sidebar for examples on different topics, or start with SQL contingency tables.