Query Builder UI Tutorial

Single Sign-On (SSO) Access with ADWB Workbench

After the Data Access Request (DAR) is approved, the data researcher can use the Query Builder to run remote queries. This means they can securely access and analyze data within the partner organization’s environment without directly downloading or transferring any raw data. All processing takes place remotely, and only the approved results are shared back into the researcher’s protected workspace for further analysis.

Click on Single Sign-on with ADWB Workbench. You will be redirected to complete the SSO login. 

Select and Authenticate Your Provider

Once there, please select the provider and complete the process. After completing your authentication, you will be redirected back to Query Builder.

Choose FDSA Instance in Query Builder

Back in QB, if you have sent request to different FDSA instances, you will have the option to select which FDSA you want to connect to.

Select an Approved Project   

When you select an FDSA instance, you will see a list of all your approved projects. Please select one to proceed.

Query Builder Overview

This is the Overview of the Query Builder, here you can find useful information about the dataset you are going to query. You can also find a list of your active tasks.

 Create a New Remote Query

Click on ‘+ Create Task’ to start running your first task.

Select Tables and Columns

The window below will open, where you must select the tables and columns you want to run the task against. Then click on Next.

Choose or Upload a Model

Here you must select the model you want to run; you could select one from the registry or upload it. Click on Next. 

Manage Models in the Repository

In the Models section, you can see the list of models you have in the repository, and you can also update a new one so next time you want to run a task you can quickly select it from there. 

Add a Model to the Registry

Click on “+ Add model to registry” to upload your model.
This process may take a while, after your model is saved it will be displayed in this section.

Finalize and Submit Your Task

In this last step, a task name and description are required, then confirm and click Done.

Task Approval and Quarantine Status 

Your task will be listed in the Tasks section. As you can see the status is Quarantined, this means that an Administrator must approve this task before you can see the results.